Performance Analytics
4 terms in Sales insights
Trend Analysis
#A systematic examination of historical sales performance data across multiple periods to identify patterns, seasonal cycles, growth trajectories, and anomalies that inform future compensation plan design and quota setting. Trend analysis in the SPM context goes beyond simple revenue trending — it examines attainment distributions (what percentage of reps hit quota over time), payout curves (how total variable compensation tracks against revenue growth), rate effectiveness (whether accelerators are actually motivating above-target performance), and turnover correlation (whether comp plan changes correlate with rep attrition). Effective trend analysis requires at least 8-12 quarters of data to distinguish signal from noise and to account for seasonal variation. The output directly informs plan design decisions: if trend analysis shows that 80% of reps consistently miss quota, the problem is likely quota-setting methodology, not rep performance.
A Sales Ops team analyzes 3 years of quarterly attainment data and discovers: (1) Q1 attainment averages 65% across the team due to seasonal slowdown — suggesting quotas should be seasonally weighted, (2) reps in the 90-110% attainment band have 15% lower attrition than those consistently below 80%, and (3) the accelerator kicker above 120% is rarely triggered (only 5% of reps) — indicating either quotas are too high or the kicker threshold needs lowering to motivate stretch performance.
Section 1.3 — Plan Design Methodology Compensation plan parameters including quota levels, threshold percentages, accelerator rates, and kicker thresholds are established annually based on trend analysis of at least the prior 8 quarters of performance data. The analysis shall include attainment distribution curves, payout-to-revenue ratios, and rep retention correlation. Plan design recommendations are presented to the Governance Committee with supporting trend data.
Performance Trend Dashboard showing: Quarterly attainment distribution (histogram), median attainment trend line over 12 quarters, payout-to-revenue ratio trend, accelerator trigger rate by quarter, rep attrition rate overlaid with plan change events. Drill-down capability by region, role, and tenure band.
Variance Analysis
#Variance Analysis in SPM systematically compares actual sales performance against targets, budgets, or prior-period results to identify and explain deviations. It goes beyond noting 85% attainment — it decomposes variance into actionable categories: volume variance (fewer deals), price variance (lower ASP), mix variance (unfavorable product/segment mix), and timing variance (deals slipping between periods). In compensation contexts, it also examines payout variances: is total expense above budget due to higher attainment (positive) or an overly aggressive rate table (design issue)? Effective variance analysis requires a well-defined baseline and feeds directly into mid-year plan adjustments, quota relief decisions, and territory rebalancing.
Q2 Southeast: actual $4.2M vs. plan $4.8M (-$600K). Volume variance -$400K (15 fewer deals, healthcare budget freezes), Price variance -$280K (discount 22% vs. planned 15%), Mix variance +$80K (favorable analytics product shift). Comp variance: actual $520K vs. budget $580K — $60K favorable.
Section 14.2 — Variance Review. The Compensation Committee shall review variance analysis comparing actual to budgeted plan costs quarterly, decomposing into volume, price, mix, and design components. Variances exceeding 10% of budget shall include root cause analysis and corrective recommendations per Section 14.3.
Variance Analysis Dashboard: waterfall chart (volume, price, mix, timing components), comparison table with plan vs. actual, drill-down by region and product, comp cost variance with cost-of-sale ratio. Filterable by region, product, and variance category.
Cohort Analysis
#Cohort Analysis in SPM examines performance patterns of defined groups sharing common characteristics — hire date, role, territory type, training program, or plan design. By tracking cohorts over time, organizations isolate variable impacts on performance. For example, comparing reps who received new onboarding versus traditional reveals program effectiveness. It is particularly valuable for evaluating ramp-up curves: how quickly do new hires reach productivity, and does that vary by experience, territory, or manager? In plan design, it answers whether changes improved performance via before/after cohorts or simultaneous A/B comparisons. Common failure modes include confusing correlation with causation and failing to control for external variables like market conditions.
FY25 new hires (24 reps) vs. FY24 (18 reps) at 12 months: FY25 average attainment 78% vs. FY24 71%. Median ramp to 80%: 7 months vs. 9 months. Key difference: FY25 received structured 90-day onboarding with mentor pairing. Retention at 12 months: FY25 83% vs. FY24 72%.
Section 14.4 — Plan Effectiveness Analysis. The Compensation Design team shall conduct cohort-based analysis annually, comparing performance across groups segmented by tenure, role, region, and plan version. Findings shall inform the annual plan design review per Section 14.5 and be presented to the Compensation Committee.
Cohort Analysis Report: cohort selector (hire quarter, role, plan version), metrics by cohort (attainment, retention), ramp curve chart, side-by-side distributions, statistical significance indicators. Filterable by dimension, time horizon, and metric.
Forecast vs. Actual
#Forecast vs. Actual analysis compares projected sales performance against realized results to measure forecasting accuracy and improve future predictions. In SPM, it evaluates forecast reliability (which feeds financial planning and compensation accruals) and identifies systematic biases: sandbagging (forecasting low for easy beats), optimism bias (deals that slip or never close), and timing errors. Key metrics are MAPE (Mean Absolute Percentage Error) and bias direction. Analysis should run at multiple levels — rep, team, region, company — because aggregation masks individual inaccuracy. Forecast accuracy is increasingly tied to compensation: some plans include a modifier that adjusts payout based on prediction quality.
Q3 Mid-Market: Manager forecast $2.8M, actual $2.45M (87.5% accuracy, over-forecast bias). Rep A: $600K/$580K (96.7% accurate). Rep B: $500K/$310K (62% — 3 deals totaling $190K slipped to Q4). Team MAPE: 14.2%, up from 11.8% prior quarter.
Section 7.3 — Forecast Accuracy. Management participants may be evaluated on forecast accuracy per Exhibit B. Accuracy is the absolute deviation between forecast and actual results. Modifier: MAPE below 10% = 1.1x, 10-20% = 1.0x, above 20% = 0.9x applied to management incentive.
Forecast vs. Actual Dashboard: comparison bars by period, accuracy trend, MAPE gauge, bias indicator. Table: Rep, Forecast, Actual, Variance, Accuracy %. Heat map over trailing 4 quarters. Filterable by team and region.
Test Your Knowledge
0 of 4 correctWhich term does this describe?
______ in SPM systematically compares actual sales performance against targets, budgets, or prior-period results to identify and explain deviations. It goes beyond noting 85% attainment — it decompose…