Deals per Rep

Goal of the analysis:

Measure how many deals each quota-carrying rep closes (typically Closed-Won) in a defined period, normalize for ramp and mix, and link deal counts to revenue productivity, win rate, and average deal size (ADS). Executives use Deals per Rep to validate quota math (deals needed to hit target), assess territory equity, identify execution gaps (low win rate vs. low volume), and plan capacity. A disciplined view—segmented by motion (new vs. expansion), segment, and tenure—prevents “activity theater” and ensures growth is driven by repeatable, winnable deals.

Data required:

• CRM bookings and opportunity data:
  • Closed-Won opportunities: Opportunity ID, close date, amount (ARR/ACV and/or TCV), currency, product/solution, term.
  • Opportunity type: new logo, expansion/upsell, renewal (include/exclude per policy).
  • Owner at close, created-by owner, split credits (percentages), partner attribution.
  • Stage history (for cycle time), lost reasons (for context), forecast category at close.
• Sales roster and HR data:
  • Rep ID, role (AE/AM with quota), start date in role, ramp schedule, FTE%, status (active/leave/terminated).
  • Team/manager, region/territory, segment (SMB/MM/Enterprise), route-to-market (direct/partner).
  • Quota assignments for capacity checks.
• Policy/crediting rules:
  • Revenue definition (ARR vs. TCV), credit timing (close date basis), split/overlay rules, inclusion of renewals vs. only new + expansion.
  • Consolidation rules for multi-quote events; duplicate prevention.
• Optional diagnostics:
  • Pipeline per rep, opportunities created per rep, win rate, average deal size, sales cycle length.
  • Marketing/SDR attribution (inbound/outbound/partner) to contextualize input mix.

Detailed step-by-step instruction on how to conduct the analysis:

1. Define scope and “deal” for counting.
   • Primary: count Closed-Won opportunities as “deals.” Separate new logo and expansion; report renewals separately if included.
   • Set the time basis: close date within the reporting period (monthly/quarterly).
   • Clarify credit: primary owner at close; apply split credits if policy requires (count fractional deals) and provide a primary-owner view for simplicity.
2. Build the rep denominator.
   • From the roster, identify all quota-carrying reps active in the period; capture tenure and ramp months.
   • Compute Ramp-Adjusted Rep Months (RARM): sum(active month × FTE% × ramp factor, e.g., 0.5/0.75/1.0 for months 1/2/3+).
   • Define a fully ramped cohort (tenure ≥ ramp months) for peer comparisons.
3. Extract, clean, and normalize CRM data.
   • Pull Closed-Won opportunities with required fields; convert currency to base FX as of close date.
   • Consolidate multi-quote buying events if policy mandates; exclude internal/test deals.
   • Validate ownership at close; ensure accurate opportunity type and product taxonomy.
4. Compute core metrics.
   • Deals per Rep (period) = count of Closed-Won per rep.
   • Deals per Ramped Rep Month = total deals ÷ RARM (normalizes for ramp/partial months).
   • Breakouts: new vs. expansion; direct vs. partner-assisted; by product/solution.
   • Quality overlays: ADS (ARR) for the rep; win rate = wins ÷ (wins + losses) in period; cycle time (median days).
   • Efficiency overlays: opportunities per deal (inverse of win rate proxy) and meetings per deal.
5. Segment, compare, and control for mix.
   • By segment (SMB/MM/Enterprise), region, product family, motion (inbound/outbound/partner), and tenure bands.
   • Provide both count-based and value-weighted views (e.g., deals per rep alongside revenue per rep) to avoid “small-deal bias.”
6. Trend and distribution analysis.
   • Time series for last 6–8 quarters: average/median deals per rep and per RARM; overlay ADS and win rate.
   • Distribution (box/violin) to identify inequality and outliers; compute P25/P50/P75 and top decile.
7. Capacity back-solve and quota math.
   • Deals needed per rep = quota (ARR) ÷ expected ADS (ARR).
   • Compare deals needed vs. actual deals per rep; quantify gap by segment and tenure.
   • Cross-check feasibility with win rate and cycle time (if deals needed require impractical volume, revisit ADS or win rate targets).
8. Integrity checks and anti-gaming.
   • Deal splitting: multiple small opps closing from one negotiation—consolidate per policy.
   • Backdating: close dates edited post-period—compare audit logs.
   • Renewals mis-tagged as new; expansion uplift vs. total contract value consistency.
9. Synthesize implications.
   • Diagnose whether low deals per rep stem from demand (few opportunities), conversion (low win rate), or mix (larger, longer deals).
   • Translate to actions: demand build, enablement to lift win rate, pricing/packaging to raise ADS, or territory redesign.

Format of the output of analysis:

• Executive summary table: deals per rep and per RARM; new vs. expansion mix; ADS; win rate; by segment/region/product.
• Leaderboards: rep/team deals per RARM with ADS and win rate overlays; tenure context included.
• Distribution charts: box/violin of deals per rep by segment/tenure; highlight top/bottom quartiles.
• Trend lines: quarterly deals per rep and per RARM with ADS and win rate overlays.
• Capacity view: deals needed vs. actual; gap by segment; scenario sliders for ADS/win rate.
• Quality panel: share of deals with Contact Roles, median cycle time, expansion uplift consistency.

How to interpret results:

• High deals per rep with healthy ADS and win rate: Strong, scalable execution; validate territory equity and ensure demand can sustain volume.
• High deals per rep with low ADS: Downmarket skew or discount pressure; consider a barbell mix (some larger deals) and tighten discount guardrails.
• Low deals per rep with high ADS: Upmarket focus; acceptable if revenue per rep and win rates are strong, but watch cycle time and coverage.
• Low deals per rep with low win rate: Execution issue—prioritize enablement, deal coaching, and ICP alignment.
• Large variance across reps/regions: Signals territory inequity or input disparity (SALs, partner coverage); rebalance and standardize routing.
• Tenure effects: Expect lower deal counts pre-ramp; judge fully ramped cohorts separately.

Steps a company can take to improve on this measure:

• Demand and territory design:
  • Increase high-intent inbound and partner-sourced pipeline where deals per rep lag; set SQO targets aligned to deals-needed math.
  • Rebalance territories by ICP/TAM; cap account loads; ensure equitable SAL routing and partner coverage.
• Conversion and enablement:
  • Deploy stage-specific playbooks and deal coaching to lift win rates; enforce exit criteria and mutual action plans.
  • Stand up a responsive deal desk and CLM to reduce late-stage friction and cycle time.
• Pricing, packaging, and mix:
  • Introduce good/better/best bundles and give-get pricing guardrails to protect ADS while maintaining velocity.
  • Set portfolio mix targets (e.g., 60% mid-market, 40% enterprise) to balance count and value.
• Operational rigor and governance:
  • Publish deals-per-RARM scorecards with ADS and win rate; inspect outliers monthly.
  • Harden crediting and close-date integrity; consolidate duplicate opps; enforce Contact Roles.
  • Tie rep goals to balanced outcomes (deals, revenue, quality), not counts alone.
• Scenario guidance:
  • If deals per rep are high but revenue per rep lags, raise ADS via packaging and discount discipline.
  • If deals per rep are low despite adequate opportunities, focus on enablement and late-stage acceleration.
  • If enterprise teams appear unproductive on deal count, evaluate revenue per rep and pipeline quality before changing targets.

Benchmark comparisons:

General benchmarks (directional, fully ramped AEs):

• SMB/velocity: 8–20 deals per month; ADS (ARR) $5k–$20k; median cycle 15–45 days.
• Mid-market: 3–8 deals per month; ADS $20k–$80k; cycle 30–90 days.
• Enterprise/complex: 1–4 deals per quarter; ADS $80k–$250k+; cycle 60–180+ days.
• Expansion (uplift basis): Higher deal counts with smaller ADS; judge on revenue per rep and net retention impact.

Internal benchmark construction:

• Build 4–8 quarter baselines by segment/region/product and tenure. Use fully ramped cohorts’ median and top quartile deals per RARM as operating targets.
• Always pair deals per rep with ADS, win rate, and revenue per rep to avoid optimizing for count at the expense of value and profitability.