How do you forecast a fast-growing rep who has no historical attainment baseline to model against?
SUBAGENT_VERIFIED. Forecast a no-history rep with a Bayesian blend of cohort prior + early-signal likelihood, prove it with quarterly out-of-sample backtests, and operationalize it inside Salesforce/Clari/Gong with a documented audit trail. This is the operator runbook: framework + stack + governance.
Forecasting fails at the seam between model and tooling. The math below is solved; the discipline is in wiring it into the systems where reps live.
1. Cohort Prior (Build Once Per Quarter)
Pull every rep hired into the same fiscal quarter, segment, and motion via Salesforce User + Hire Date + Role + Segment fields. Compute attainment medians and 25th/50th/75th/90th percentiles at months 3, 6, 9, 12, 18, 24. Per Bridge Group's 2024 SaaS AE Compensation and Performance report, enterprise AE month-12 median attainment was 72% in 2024 (down from 81% in 2022).
Mid-market: 78%. SMB: 85%. ICONIQ Growth's 2024 Topline Growth report corroborates 65-75% attainment medians across $50M-$500M ARR.
McKinsey's 2024 B2B Sales Pulse flags 67% of new hybrid-selling AEs miss month-12 quota by >20%.
2. Early-Signal Likelihood (Refresh Weekly)
Per Gartner's 2024 CSO Forecast Accuracy benchmark, forecast accuracy for reps in months 0-6 averages just 47% with rep-submitted commits; activity-based signals beat that by 18 points. Track from Gong/Outreach/Salesloft (activity), Salesforce Opportunity (pipeline), Gainsight PX (training):
- Days 1-30: training-completion velocity, role-play scores, manager 1:1 quality.
- Days 31-60: outbound throughput.
- Days 61-90: pipeline generation rate, first qualified opp, multi-thread depth.
- Days 91-180: pipeline velocity, win rate on first 3-5 deals, ACV vs. territory target.
3. Posterior Forecast (Refresh Monthly in Clari)
`` Forecast_t = w_t × Cohort_Median + (1 - w_t) × Rep_Signal_Forecast w_3 = 0.70, w_6 = 0.55, w_9 = 0.40, w_12 = 0.30 (n>=12) w = 0.85 throughout if cohort n<12 ``
Wire as a Clari custom forecast type "Ramp_Bayes_v2" so it shows alongside Commit/Best Case/Worst Case.
4. Velocity Ceiling Check
RepVue 2024: top-quartile enterprise AEs at 95-110% by month 12; bottom-quartile at 35-50%. Pavilion 2024 Pulse: month-6 median 55-65% for series-B+. Forrester 2024 Sales Intelligence wave: reps exceeding 80% by month 6 have a 78% probability of hitting 100%+ in year 1.
HBR 2024 inside-sales ramp study: month-3 activity throughput correlates 0.62 with month-12 attainment.
5. Audit and Backtest (Quarterly, Mandatory)
Run retrospectively against prior 4-8 cohorts. Compute MAE of forecasted vs. actual month-12 attainment. Threshold: MAE <= 12pp.
If MAE > 15pp, recalibrate weights. Compute calibration via reliability diagram. Per Korn Ferry/Miller Heiman 2024 Sales Performance Study, best-in-class MAE is 9-11pp; median 18pp.
Document drift: 3 consecutive quarters of rising MAE = rebuild cohort.
6. Reverse Test (Out-of-Sample)
Hold out most recent quarter's hires. Forecast their month-3/6/9 attainment from prior cohorts only. Compare to actuals. Reverse-test MAE diverging from in-sample by >5pp = overfit; widen window or simplify multipliers.
7. Operator Decision Tree (5-Question Heuristic)
- Is cohort n>=12? If no, lean prior at w=0.85 throughout.
- Did the comp plan reset mid-cohort? If yes, re-benchmark post-reset only.
- Did the rep inherit pipeline? If yes, strip months 1-6 inherited deals.
- Did the rep's manager change mid-ramp? If yes, discount 12-18pp at month 12.
- Did the cohort hit a regime change (ZIRP-end, product launch)? If yes, exclude or use 8-quarter window.
8. Tooling Map
| Step | System | Object/Field |
|---|---|---|
| Cohort build | Salesforce | User.HireDate, Role, Segment |
| Activity signals | Gong/Outreach | Calls, Emails, Meetings |
| Pipeline signals | Salesforce | Opportunity.Stage, Amount, CreatedDate |
| Training velocity | Gainsight PX | CourseCompletion% |
| Forecast publish | Clari | Custom forecast type Ramp_Bayes_v2 |
| Backtest dashboard | Tableau/Looker | Quarterly MAE + reliability diagram |
9. Manager Override
+/-10% with documented rationale; beyond requires VP sign-off. Per Salesforce State of Sales 2024, unjustified overrides degrade forecast accuracy by 22%.
10. Compliance and Audit Trail
Retain forecast snapshots for 7 quarters minimum (SOX-friendly). Log every override with rationale, manager ID, timestamp. Surface in quarterly RevOps governance review. Per SEC SOX Section 404 guidance, forecast inputs to public financial guidance require auditable provenance.
Cross-References
/knowledge/q187 ramp-acceleration signals, /knowledge/q142 cohort segmentation, /knowledge/q201 activity-to-revenue ratios, /knowledge/q156 ramp coaching cadence, /knowledge/q88 pipeline-velocity formula, /knowledge/q263 territory carving impact, /knowledge/q119 quota-setting math, /knowledge/q05 forecast governance, /knowledge/q331 backtesting cadence, /knowledge/q44 Clari custom forecast types, /knowledge/q278 SOX RevOps controls.
Bear Case: Eight Failure Modes (Severity HML)
- (H) Cohort n<6. Variance swamps signal. Roll up to parent segment.
- (H) Regime-change cohort. Q1 2023 ZIRP-end hires median understated 25-30%. Use 8-quarter window or exclude.
- (H) Comp-plan reset mid-cohort. Re-benchmark post-change cohorts only.
- (M) Inherited pipeline. Top-rep carve-outs inflate months 1-6 by 15-30%. Strip inherited deals.
- (M) Ramp quota mismatch. Normalize to full-quota basis.
- (M) Manager turnover during ramp. -12 to -18pp at month 12. Flag and discount.
- (L) Seasonality skew. Q4-hire cohorts show inflated month-3 from year-end flush; deflate by 8%.
- (L) Product-launch tailwind. Cohort hired into new release shows +10-15% inflated; isolate launch-quarter contribution.
Practical Example
Q3 2026, new enterprise AE, month 3. Cohort n=14, median month-3 = 45%. Rep signal forecast = 55%. w_3 = 0.70.
Forecast = (0.70 × 45%) + (0.30 × 55%) = 48% quota. Published as Ramp_Bayes_v2 in Clari. Month 6 recompute: cohort median 60%, signal 70%, w_6 = 0.55. Forecast = 64.5%. Quarterly backtest: MAE on prior 4 cohorts = 10pp.
Within 12pp threshold. Ship and snapshot for SOX retention.
Never use: individual historical close rate, company-wide average, gut feel, interview impression, unweighted manager judgment, or any forecast that has not survived a backtest and an audit log.
TAGS: forecasting,ramp,cohort,quota,sales-ops,early-signals
Recently Added — Related
- [How do you design a sales contest that doesn't tank pipeline quality after it ends?](/knowledge/q251)