How should a CRO build a renewal forecast model that actually predicts pipeline?
The Three-Layer Forecast Stack
Renewal forecasting fails when built on gut. OpenView's ops model uses three overlapping layers, each with different confidence levels:
Layer 1: Health-Based Forecast (Months 0-4)
What it is: Probabilistic model using account health score
- Health score = (40% usage) + (30% expansion) + (20% NPS) + (10% support sentiment)
- Health 85+ = 95% renewal confidence
- Health 70-84 = 78% renewal confidence
- Health 55-69 = 42% renewal confidence (at-risk)
- Health <55 = 18% renewal confidence (critical)
Accuracy window: Best 120+ days out; loses accuracy as contract approaches
Formula: Forecast = (ARR pool) × (weighted health avg) - (AE override adjustments)
Layer 2: Engagement-Based Forecast (Months 5-9)
What it is: Binary funnel based on renewal conversation stage
| Stage | Probability | Velocity |
|---|---|---|
| Renewal discussion scheduled | 72% | 30 days |
| Business case shared | 68% | 35 days |
| Negotiation active | 61% | 40 days |
| Discount approved | 84% | 15 days |
| Contract sent | 91% | 7 days |
| Signed | 100% | 0 days |
Pipeline math: Each account moves through 1 stage per 30-35 days. Accounts stalled > 45 days in a stage = 60-day escalation flag.
Layer 3: Cohort-Based Forecast (Months 8-12)
What it is: Historical churn rates by cohort + vintage + segment
- Cohort example: SMB customers signed Jan 2024 show 84% renewal rate (historical)
- Segment example: Hospitality vertical shows 72% renewal vs. 88% for fintech
- Vintage risk: Customers in years 2-3 churn 4.2 points higher than year 1
Formula: Expected renewals = (Cohort size) × (Historical churn %) - (At-risk list adjustments)
Building the Master Forecast
Month 4 forecast (best accuracy):
- Pull all accounts in renewal 90-120 days out
- Layer 1: Apply health score probabilities
- Layer 2: Override with actual engagement stage (if > 45 days stalled, downgrade 15%)
- Layer 3: Apply cohort/segment adjustment factor
- Result: Conservative forecast with ±3-5% margin of error
Bridge Group benchmark: Most companies have ±12-18% forecast error (too wide). Those using three-layer model achieve ±4-6% error.
Dashboard Metrics
| Metric | Target | Red Flag |
|---|---|---|
| Health score avg | 72+ | <65 (signals decay) |
| Avg days in negotiation | 35 | >50 (deal friction) |
| ARR at risk (health <70) | <12% of pool | >18% |
| Churn vs. forecast | ±5% | >10% deviation |
Critical discipline: Reforecast monthly, not quarterly. Renewal forecasts decay 4% accuracy per month without fresh health data.
TAGS: renewal-forecasting,pipeline-prediction,health-scoring,cohort-analysis,ops-forecasting