Quota Distribution Shape

Goal of the analysis:

Understand how quotas are distributed across sellers and whether that shape is fair, explainable, and aligned to opportunity and plan targets. “Quota Distribution Shape” examines the statistical distribution of assigned quotas (and normalized quotas vs. potential/history) across peer groups (role/segment/region) and links that shape to attainment, cost of sales, and morale. Executives use it to validate quota methodology, detect inequities or hidden role mixes (bimodality), calibrate over-assignment, set glide paths for new hires, and ensure territory potential and capacity are reflected in quotas—supporting sustainable, predictable performance.

Data required:

• Quotas and plan configuration:
  • Rep-level quotas by period (monthly/quarterly/annual), currency, effective dates, updates, proration rules (ramp, partial-period, leave).
  • Plan mechanics: measure used (bookings/ARR/revenue/margin), crediting/split rules, thresholds/accelerators, SPIFFs, caps (if any).
• Territory and role context:
  • Role (Inside/Field AE, AM), segment (SMB/MM/ENT), region, manager, territory mapping and plan version effective dates.
  • Territory potential (ICP account universe × propensity × expected ACV), white space, active account counts by tier.
• Historical performance and pipeline:
  • Trailing 4–8 quarter bookings/ARR by rep/territory; pipeline coverage at start of period; inbound intensity (MQLs/AE).
• People and capacity:
  • Rep roster, tenure, ramp status, active AE months/FTE %, vacancies/backfills.
• Reference and normalization:
  • FX at quota basis, fiscal calendar, product taxonomy (if quotas by product), account hierarchy, attribution policy (co-sell/overlays).

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

1. Lock scope, peer groups, and normalization rules.
   • Analyze quotas within homogeneous peer groups (e.g., Inside SMB AEs in NA; Field ENT AEs in EMEA) to avoid role-mix distortion.
   • Standardize to the same period and currency; apply proration for ramps/partial periods; compute Quota per AE-month for comparability.
   • Create normalized metrics:
     • Quota-to-Potential Ratio (QPR) = Quota ÷ Territory Potential.
     • Quota-to-History (QTH) = Quota ÷ Trailing-12-month bookings.
2. Assemble, reconcile, and segment the dataset.
   • Join quotas (by effective date) with roster, territory, potential, and TTM bookings; ensure owner/territory as-of dates match the plan period.
   • Exclude reps with <30 active days from distribution summaries or report separately.
3. Profile the distribution shape (by peer group).
   • Compute summary stats for raw quotas, Quota per AE-month, QPR, and QTH: mean, median, P10/P25/P75/P90, standard deviation, coefficient of variation (CV), skewness, kurtosis.
   • Build histograms/density and violin/box plots for each metric; plot Lorenz curves and compute Gini coefficients (inequality) for quotas and QPR.
   • Detect multimodality (e.g., via Hartigan’s dip test or clustering) indicating mixed roles/segments in one pool.
4. Link distribution shape to plan health and outcomes.
   • Over-assignment ratio = Σ quotas ÷ top-down bookings plan; compute by peer group and org-wide.
   • Overlay prior-period attainment distribution vs current quota distribution shape to test realism (e.g., extreme right tail in quotas correlating with low attainment).
   • Correlate QPR/QTH with attainment and turnover; flag outlier reps with high QPR and chronic under-attainment.
5. Equity and fairness diagnostics.
   • Scatter: Quota vs Territory Potential (and vs TTM bookings); fit line and R²; inspect residuals for systematic bias by manager/region.
   • Workload overlays: accounts per AE, inbound per AE; ensure high-quota reps are not under-resourced.
6. Scenario and sensitivity analyses.
   • Simulate re-centering quotas to target QPR (e.g., median QPR by peer group) while preserving Σ quotas (or desired over-assignment); estimate % reps within ±10% band of target.
   • Model alternative over-assignment ratios (e.g., 1.10 → 1.20) and predict %≥100% attainment using historical conversion of pipeline to bookings.
   • Design ramp glide paths (50%→75%→100%) and quantify impact on distribution CV and %≥100% among new hires.
7. Integrity checks.
   • Verify proration and FX conversions; confirm territory potential calculations and plan versions; reconcile Σ credited historical bookings with finance actuals.
   • Ensure overlays/split-credit do not double-count potential or history in QPR/QTH denominators.
8. Synthesize implications.
   • Highlight peer groups with excessive variance (CV, Gini), bimodality, or misalignment to potential; quantify efficiency loss and morale risk.
   • Translate into quota policy, territory redesign, ramping, or capacity moves; estimate change in %≥100% and cost-of-sales impact.

Format of the output of analysis:

• Distribution visuals: histograms/density and violin/box plots for Quota, Quota per AE-month, QPR, and QTH by peer group.
• Lorenz/Gini panel: inequality of quotas and QPR with targets/thresholds.
• Scatter/fit charts: Quota vs Territory Potential and vs TTM bookings with residual heatmaps by manager/region.
• Executive table: mean/median/P25/P75, CV, skewness/kurtosis for each metric; over-assignment ratio; share of reps within ±10% of peer-group median QPR.
• Scenario worksheet: before/after distribution stats for proposed recalibration (QPR targets, ramp glide paths) and projected %≥100% attainment.
• Fairness dashboard: workload and inbound overlays vs quotas; outlier list with rationale and recommended actions.

How to interpret results:

• High variance within a homogeneous peer group (CV > 0.30) or high Gini: Quotas are uneven; expect morale issues and volatile attainment. Rebase to tighter bands or re-segment roles.
• Right-skewed quotas with a long tail: A few very high quotas (often ENT/strategic) mixed into the pool; separate tiers or apply distinct quota methodology and accelerators.
• Bimodal distributions: Mixed roles or territory quality inside one peer group; split the cohort (e.g., “core” vs “strategic”) or normalize by potential and redesign quotas.
• Wide QPR/QTH spread: Quotas not calibrated to opportunity or history; high-QPR reps likely under-attain. Target narrower QPR IQR (e.g., ≤0.20 width) within peer group.
• Over-assignment too high (>1.25) with low %≥100%: Plan stretch exceeds capacity/potential; consider lowering over-assignment, adding capacity, or boosting pipeline coverage.
• Over-assignment too low (<1.05) with bunching at 100%: Quotas soft; tighten targets and adjust accelerators to reward >110–120% without excess COS.

Steps a company can take to improve on this measure:

• Quota methodology and guardrails:
  • Adopt bottom-up quotas: sum account-level propensity × expected ACV; blend with top-down growth targets.
  • Set peer-group targets for QPR/QTH and CV (e.g., QPR median 1.2–1.6 with IQR ≤0.20; CV ≤0.25) and enforce during quota councils.
  • Define over-assignment policy (e.g., 1.10–1.20) by segment based on win rates, pipeline coverage, and ramp mix.
• Role segmentation and design:
  • Split mixed cohorts into clear tiers (core/strategic; velocity/enterprise) with distinct quota bands and accelerator curves.
  • Introduce ramped glide paths (e.g., Q1 50%, Q2 75%, Q3+ 100%) and role transitions with documented triggers.
• Territory and capacity alignment:
  • Rebalance accounts using potential and workload; cap accounts per AE; add SDR/partner overlays where inbound or potential is high.
  • Adjust quotas for material mid-year territory changes via prorated restatements tied to potential deltas.
• Governance and process:
  • Run cross-functional quota councils (Sales/Finance/RevOps) to review distribution stats, QPR/QTH, and over-assignment before finalizing.
  • Lock plan versions; document exceptions; publish fairness dashboards to managers with outlier flags and action prompts.
• Enablement and plan mechanics:
  • Align accelerators to encourage performance beyond 110–120% without forcing discounts; consider margin- or strategic-mix multipliers.
  • Support high-QPR reps with pipeline programs, ABM, and partner overlays; revisit quotas if support cannot be delivered.
• Scenario guidance:
  • If SMB Inside cohort shows bimodal quotas, separate velocity and strategic pods; rebase quotas to target QPR bands; expect tighter attainment dispersion.
  • If ENT field cohort CV = 0.38 and Gini high, normalize via enterprise potential model and apply strategic-account tiering; set differentiated accelerators.
  • If over-assignment 1.28 drives <40%≥100%, reduce to ~1.15 and increase SDR capacity; project +10–15 pts in %≥100%.

Benchmark comparisons:

General benchmarks (directional):

• Coefficient of variation (CV) of quotas within homogeneous peer groups: Target ≤0.25; >0.30 indicates likely miscalibration or mixed cohorts.
• Gini for quotas or QPR within peer group: ≤0.20–0.25 is typical in well-designed plans; higher suggests inequity.
• Over-assignment ratio (Σ quotas ÷ plan): 1.05–1.25 common; segment-specific tuning recommended (lower in ENT, higher in SMB/velocity).
• QPR (quota ÷ potential) median: Often 1.2–1.6 depending on growth mandate and win rates; aim for narrow IQR (≤0.20) within peer groups.
• QTH (quota ÷ TTM bookings) median: 1.1–1.5 typical; above ~1.6 frequently depresses %≥100% unless pipeline expands materially.

Constructing internal benchmarks:

• Build 4–8 quarter peer-group cohorts; track CV, Gini, QPR/QTH medians and IQRs, over-assignment, and %≥100% attainment.
• Use top-quartile peer groups (lowest CV/Gini with healthy %≥100%) as design references; set target bands accordingly.
• Refresh semiannually as territory potential models improve and role mixes evolve; document changes across plan versions for transparency.