How do we measure and improve forecast accuracy beyond activity metrics?
Forecast accuracy = deal age + rep history + pipeline composition. Track 3 tiers: rep forecast vs actual (65%+ target), deal velocity (days-to-close), stage conversion rates. Red-line reps missing 75% attainment for 2 quarters—they're guessing.
Operator Approach
Activity metrics (dials, meetings, proposals) are vanity unless tied to revenue outcome. Real forecast accuracy requires deal-level intelligence.
Tier 1: Individual Rep Forecast Accuracy Measure: rep forecast in CRM vs actual close per quarter
- Target: 65–75% (overforecasting is more common than underforecasting)
- Red flag: > 20% miss indicates guessing or bad data
- Ramp consideration: ramping reps typically forecast ± 30%; mature reps ± 15%
Action: Reps missing forecast by > 25% for 2 consecutive quarters → coaching or termination discussion
Tier 2: Deal Velocity & Stage Progression Measure by segment (enterprise, mid-market, SMB):
| Deal Stage | Enterprise (Days) | Mid-Market (Days) | SMB (Days) | Conversion Rate |
|---|---|---|---|---|
| Discovery | 14–21 | 7–14 | 3–7 | 40–50% |
| Demo | 21–35 | 10–21 | 5–10 | 35–45% |
| Proposal | 35–60 | 14–28 | 7–14 | 25–35% |
| Negotiation | 21–45 | 7–14 | 3–7 | 60–80% |
Red flags:
- Deals stuck in demo for > 6 weeks (losing momentum)
- Proposal acceptance < 20% (pricing/product mismatch)
- Negotiation taking > 6 weeks (deal fragility)
Tier 3: Pipeline Composition Quality Score pipeline by risk:
- Committed: reps report 95%+ confidence, deal < 14 days out = 100% weight
- Probable: reps report 75–95% confidence, 15–60 days out = 50% weight
- Possible: reps report 40–75% confidence, > 60 days out = 10% weight
- Pipeline: reps report < 40% confidence = 0% weight
Forecast = (Committed × 1.0) + (Probable × 0.5) + (Possible × 0.1)
Forecast accuracy diagnosis tree:
| Symptom | Root Cause | Fix |
|---|---|---|
| Large misses (±25%+) per rep | Rep guessing or data stale | Deal review coaching, daily updates |
| Aggregate forecast wrong by 5–10% | Bad stage distribution | Validate stage rules, clean CRM |
| Deals slipping between quarters | Velocity trending slower | Pipeline health review, resource gaps |
| High closing rates but late discovery | Reps under-capturing early-stage | Sales process audit, activity enforcement |
Mermaid: Forecast Accuracy Diagnostic Loop
Sources: Pavilion Forecast Accuracy Benchmarks, Bridge Group Pipeline Health Study, SaaStr Sales Operations Best Practices
TAGS: forecast-accuracy,pipeline-quality,deal-velocity,rep-coaching,stage-conversion,pipeline-composition,deal-intelligence
FAQ
What's a realistic individual rep forecast accuracy target? Aim for 65–75% of rep forecast in CRM matching actual close per quarter, since overforecasting is more common than underforecasting. A miss greater than 20% signals guessing or stale data. Ramping reps typically forecast within ±30%, while mature reps land closer to ±15%.
When should a rep's forecast misses trigger a coaching or termination discussion? When a rep misses forecast by more than 25% for two consecutive quarters. That pattern indicates they are guessing or working off bad data rather than reading their pipeline. Pair it with daily deal updates and a 1-on-1 deal review before escalating.
How does the pipeline composition weighting work? Committed deals (95%+ confidence, under 14 days out) carry 100% weight, probable deals (75–95% confidence, 15–60 days) carry 50%, and possible deals (40–75% confidence, over 60 days) carry 10%. Anything under 40% confidence gets 0% weight.
The forecast equals (Committed × 1.0) + (Probable × 0.5) + (Possible × 0.1).
What are the red flags for deal velocity by stage? Deals stuck in the demo stage for more than 6 weeks signal lost momentum, proposal acceptance under 20% points to a pricing or product mismatch, and negotiation dragging past 6 weeks indicates deal fragility. These thresholds vary by segment, with enterprise deals naturally running longer than SMB.
If the aggregate forecast is off by only 5–10%, what's the likely cause? That size of aggregate miss usually points to a bad stage distribution rather than individual rep guessing. The fix is to validate the stage rules and clean the CRM data so deals are sitting in the correct stages.
Large per-rep misses of ±25% or more are a separate problem solved through deal review coaching.