Sales Rep Effectiveness
Petavue, for all SDRs’ opportunities created in the last 6 months:
1. Key Metrics per SDR:
- Total Opportunities Created
- Win Rate (% Closed-Won)
- Average Closed-Won ACV ($)
2. Composite Performance Score:
- Calculate a score = (Win Rate × 0.4) + (Normalized Avg ACV × 0.4) + (Normalized Opps Created × 0.2), scaled to 0–100.
3. Leaderboard:
- Rank SDRs by their composite score
- Highlight any rep scoring below 50
Please return the leaderboard table with these details.
- List SDRs scoring below 50 with their individual win rate, average ACV and opportunity volume.
- Show the top 10 SDRs by composite score and highlight their underlying metric breakdown.
- Compare each SDR’s composite score this period versus the previous six months to spot performance trends.
- Identify which metric (win rate, ACV or volume) contributes most to each SDR’s composite score.
- Recommend tailored coaching actions for SDRs falling in the bottom quartile of composite scores.
What This Prompt Does
This prompt gathers all opportunities created by SDRs over the past six months and calculates three key metrics for each rep—total opportunities created, win rate percentage and average Closed‑Won ACV. It normalizes each metric on a 0–100 scale, applies weights (40 percent win rate, 40 percent average ACV, 20 percent volume) to compute a composite score, then returns a leaderboard sorted by score and highlights any reps scoring below 50.
Strategic Impact
Aligning SDR performance metrics with revenue‑quality signals drives more effective pipeline generation and ensures coaching is focused where it matters most.
Business outcomes:
→ Incentivizes behaviors that produce higher‑value pipeline instead of sheer volume
→ Boosts forecast confidence by centering on reps who deliver wins
→ Identifies underperforming SDRs early for targeted coaching