Evaluate sales rep performance with contextual pipeline data

Normalize sales performance by factoring in territory quality, lead volume, and deal size. Use when conducting fair sales performance appraisals.

You getNormalized Performance Matrix, individual Performance Assessments and operational Adjustments

Prompt

Prompt
Act as a revenue operations director. Review the raw sales rep metrics pasted below and provide a balanced performance evaluation that accounts for territory context, pipeline size, and average deal complexity.

Rules:
- Compare reps based on pipeline conversion rates and win rates, not just raw closed revenue.
- Account for structural differences like inbound lead volume, assigned territory size, and deal cycle lengths.
- Differentiate reps who over-perform relative to poor pipeline from reps who coast on high inbound volume.
- Keep observations grounded strictly in the pasted numbers.

Output format:
1. Normalized Performance Matrix (Columns: Rep Name, Inbound vs Outbound Mix, Win Rate %, Attainment vs Opportunity Ratio, Performance Tier)
2. Individual Performance Assessments (1 short paragraph per rep covering context and efficiency)
3. Operational Adjustments (3 action steps for pipeline reallocation or coaching)

Here are the sales performance records:

Example output

Example for: Quarterly CRM metrics for four mid-market account executives

1. Normalized Performance Matrix
Rep NameInbound vs Outbound MixWin Rate %Attainment vs Opportunity RatioPerformance Tier
Sarah Jenkins80% Inbound / 20% Outbound22%105% quota / $1.2M pipelineHigh Volume, Moderate Win Rate
Marcus Vance20% Inbound / 80% Outbound34%92% quota / $650k pipelineHigh Efficiency, Pipeline Constrained
Elena Gomez60% Inbound / 40% Outbound18%78% quota / $1.1M pipelineUnderperforming on Ample Opportunity
David Kim50% Inbound / 50% Outbound29%115% quota / $950k pipelineTop Balanced Performer
2. Individual Performance Assessments
  • Sarah Jenkins: Hit 105% of quota, but benefited from the highest inbound lead allocation. Her 22% win rate indicates she is closing warm leads rather than creating new pipeline.
  • Marcus Vance: Missed quota slightly at 92%, but delivered the team's highest win rate (34%) while sourcing 80% of his pipeline via cold outbound. With equal inbound pipeline, Marcus would likely lead the leaderboard.
  • Elena Gomez: Struggled with conversion (18% win rate) despite receiving substantial inbound volume ($1.1M pipeline). Needs deal qualification coaching at the discovery stage.
  • David Kim: Demonstrated strong execution across both inbound and outbound opportunities, achieving 115% quota with healthy deal velocity.
3. Operational Adjustments
  • Shift 20% of inbound inbound round-robin leads from Sarah and Elena to Marcus to maximize his 34% conversion rate.
  • Pair Elena with David for deal qualification shadowing to raise her discovery-to-close ratio.
  • Establish an outbound pipeline credit or weighting in next quarter's comp plan to reward self-sourced opportunities.
Written by AI from this prompt. Your results will vary.

Paste your CRM export table (including rep names, quota, closed-won amounts, total pipeline assigned, and lead sources) into ChatGPT, Claude, or Gemini. Follow up with: 'What specific goals should I set for the under-allocated rep next quarter?'

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Data Analysis