GM! This week… forecasts…
The Forecast Problem
A VP of Sales I worked with had the same problem every quarter.
Weeks 1–10 looked healthy.
Then Week 11 arrived.
Forecast dropped 30%.
Leadership panicked.
Discounting started.
Reps scrambled.
The quarter limped across the line at 95% of quota.
“Why does this happen every time?” he asked.
“Because you do not see the problem until it is too late,” I said.
He was managing trailing indicators.
Quota attainment. Closed revenue. End-of-month results.
Those metrics tell you what already happened.
They do not tell you what is about to break.
So we looked at three quarters of historical data.
What predicted quota miss 6 weeks early?
Not quota attainment.
These:
pipeline coverage ratio
new deal creation rate
deal velocity
forecast accuracy
bottleneck stage age
By Week 4, the outcome of the quarter was already visible.
So we built a dashboard.
Five metrics.
Reviewed weekly.
No more surprise quarters.
Here is the framework.
The Leading Indicators Framework
Quota is a trailing indicator.
Leading indicators predict revenue problems early enough to intervene.
That distinction changes how strong operators manage pipeline.
1. Pipeline Coverage Ratio
Definition:
Total open pipeline value ÷ quarterly quota
Target:
3.0x minimum
4.0x healthy
below 2.8x = warning
Why It Matters
If quota is $1M and open pipeline is only $2.5M, the math is already working against you.
Weak coverage usually means:
not enough new deals
pipeline attrition
stalled movement
overqualified “hope deals”
Example
Open pipeline = $2.8M
Quarterly quota = $1M
Coverage ratio = 2.8x
At 2.8x in Week 4, the risk is already visible.
Action
If coverage drops below 3.0x early in the quarter:
inspect deal creation
inspect prospecting activity
inspect pipeline hygiene
The issue is usually upstream.
2. New Deal Creation Rate
Definition:
New opportunities created per week
(Discovery-stage deals less than 7 days old)
Why It Matters
Pipeline creation is delayed revenue.
If new deal creation drops in Week 2, closes usually fall 8–12 weeks later.
That lag catches most leadership teams off guard.
Example
Required pace = 15 new deals/week
Current 4-week average = 7.5/week
You are operating at 50% of required pipeline generation.
The quarter just has not felt the impact yet.
Action
If creation rate drops >20% below baseline:
prospecting discipline is slipping
ORreps are trapped managing old deals
Either way, future revenue is now at risk.
3. Deal Velocity
Definition:
Average days from Discovery to Close
Why It Matters
Velocity measures flow.
When velocity expands:
deals stall
close dates drift
forecasts compress
month-end risk increases
Example
Historical average = 30 days
Current average = 37 days
That is a 23% slowdown.
Something inside the system is blocking movement.
Action
Do not treat velocity as a generic problem.
Diagnose the stage.
Usually the issue lives inside:
Proposal
stakeholder alignment
procurement
commercial friction
Week 16’s bottleneck framework applies directly here.
4. Forecast Accuracy
Definition:
Percentage of forecasted deals that actually close on time
Why It Matters
If forecast accuracy collapses, leadership loses visibility.
Everything downstream breaks:
hiring plans
capacity planning
board reporting
cash expectations
Example
Forecasted closes = 12 deals
Actual closes = 8 deals
Accuracy = 67%
That gap compounds quickly across a quarter.
Action
If accuracy drops below 70% consistently:
close dates are unrealistic
pipeline is inflated
reps are guessing
ORcompensation structure rewards optimism
This is usually a management-system issue before it becomes a rep issue.
5. Bottleneck Stage Age
Definition:
Average days spent inside your bottleneck stage
(Identified in Week 16)
Why It Matters
This metric tells you where the system is slowing down.
If Proposal historically averages 22 days and suddenly jumps to 35:
deals are not progressing
pipeline is compressing
forecast timing is drifting
Example
Historical Proposal average = 22 days
Current Proposal average = 35 days
Increase = +59%
That is no longer random variance.
That is operational blockage.
Action
If bottleneck stage age spikes:
diagnose immediately
identify blockers
assign ownership
accelerate or remove stalled deals
Delay compounds quietly.
Then suddenly.
The Weekly 30-Minute Review
Every Friday, review:
1. Pipeline Coverage
Above 3.0x?
If not:
pipeline generation issue
qualification issue
stalled movement issue
2. New Deal Creation
Holding baseline pace?
If not:
prospecting discipline broke
ORreps are buried in pipeline management
3. Deal Velocity
Any stage slowing >20%?
If yes:
identify the bottleneck
diagnose the blocker
assign action
4. Forecast Accuracy
Above 75%?
If not:
forecast discipline is weak
close dates are unreliable
5. Bottleneck Stage Age
Above historical average by >30%?
If yes:
the system is clogging
flow is deteriorating
This review tells you:
whether pipeline is healthy
whether flow is healthy
whether forecasting is trustworthy
whether quota risk is increasing
Long before the quarter breaks.
The Real Shift
Most sales teams manage outcomes.
Strong RevOps teams manage predictors.
That is the difference.
By the time quota miss becomes visible in closed revenue, intervention options are already limited.
But if:
deal creation drops in Week 2
velocity spikes in Week 3
forecast accuracy weakens in Week 4
You still have time to respond.
That is what operational visibility actually means.
Your Move
This week:
Pick one leading metric
Define the baseline
Review it weekly for 30 days
Compare it against forecast movement
You will start seeing the pattern quickly.
Revenue problems almost always appear in the indicators before they appear in quota.
Most teams simply are not looking early enough.
— Pipeline Playbook