How do you forecast a fast-growing rep who has no historical attainment baseline to model against?
Use 3-quarter rolling cohort benchmarks, not the individual rep's history. Bucket by ramp stage, product mix, and territory vintage, then apply Pavilion/SalesLoft velocity curves as ceiling.
When a rep is brand-new, fast-growing, or moved territories, their own past attainment is noise. Instead:
1. Cohort Benchmarking (Primary Method)
- Pull all reps hired in the same quarter + cohort (e.g., "Q3 2024 enterprise AE hires").
- Calculate median attainment at months 3, 6, 9, 12, 18, 24.
- That cohort median becomes your rep's forecast floor for quarters matching their tenure.
- Example: New AE hired Apr 2026, now in month 3 (Jul 2026). Q3 median for month-3 cohorts is 45% quota. Your rep's Q3 forecast = 45% (or adjusted for their early signals).
2. Adjust for Territory & Product Mix (Seconds Pass)
| Factor | Impact | Adjustment |
|---|---|---|
| Territory vintage | New vs. mature territory | −10% to +15% vs. cohort |
| Product mix | High-touch vs. self-serve | −20% vs. +25% |
| Manager quality | New vs. tenured manager | −8% vs. +12% |
| Sales enablement | Weak vs. strong onboarding | −15% vs. +20% |
3. Velocity Curves (Ceiling Check)
Pavilion data shows enterprise AE month-3 attainment peaks at ~50%, month-6 at ~65%, month-12 at ~95%. If your rep is hitting 70% at month 3, they're running hot; forecast 110%+ by month 12 (if holdover).
Forecasting Formula:
`` Forecast = (Cohort_Median × Territory_Multiplier × Enablement_Multiplier) + Early_Signal_Uplift ``
Early Signals (Real-time Tilt):
- First 90 days: activity metrics (calls, meetings, demos). Rep hitting 150% of activity target = +5–8% forecast bump.
- Months 4–6: deal progression (pipeline velocity, win rate on early deals). First deal close → +10–15%.
- Months 7–12: quarter-over-quarter momentum. Attainment trending up month-on-month → keep pace with cohort ceiling.
Red Flags (Downgrade):
- Activity flatlining by month 2 → Forecast 60% of cohort.
- Pipeline quality weak (avg deal size 40% below territory target) → Discount 15–20%.
- Manager feedback on call quality poor → Discount 10%.
Practical Example:
Q3 2026, new enterprise AE (month 3). Cohort median month-3 attainment = 45%. Territory is new (−8%). Enablement strong (+12%). Early activity signal hot (+5%). Forecast = (45% × 0.92 × 1.12) + 5% = 50% quota.
Do not use: individual rep historical close rate, company-wide average, gut feel, or their interview impression. Cohort + early signals wins every time.
TAGS: forecasting,ramp,cohort,quota,sales-ops,early-signals