Pipeline coverage calculator
The 3x coverage rule gets repeated so often that teams treat it as a law. It is only right if your win rate on in-period pipeline happens to be about 33%. This calculator derives required coverage from your own win rate, computes it against remaining target rather than full quota, and does it by segment, because a healthy blended number routinely hides a segment that is short.
Download it
What you get
- A coverage calculator by segment using remaining target and your own win rates
- Required pipeline and pipeline gap per segment, with every formula written out
- A worked example showing a blended number that looks fine while two segments are short
- A pipeline qualification checklist so only in-period, real pipeline is counted
- A pipeline creation back-calculation for closing the gap
Who it's for
- RevOps leads reporting pipeline health to the executive team
- VPs of Sales deciding where to push pipeline generation
- Sales managers with segmented teams and different win rates
What's inside
5 sections, each listed with its own size. The first is previewed below; the remaining 4 come with the download, with blank rows ready to fill in.
| Section | Size | Previewed |
|---|---|---|
| Coverage calculator by segment | 10 columns, 4 worked example rows | Below |
| Formulas | 3 columns, 5 worked example rows | In the download |
| Closing the gap | 5 fields to complete | In the download |
| What counts as in-period pipeline | 7-point checklist | In the download |
| Why the blended number misleads | Guidance notes | In the download |
Preview of section 1
Coverage calculator by segment
Worked example at week 5 of a 13-week quarter. Win rates are illustrative; replace them with your own by-value win rates.
| Segment | Quarter target | Closed won to date | Remaining target | Win rate (by value) | Required pipeline | Open in-period pipeline | Current coverage | Required coverage | Pipeline gap |
|---|---|---|---|---|---|---|---|---|---|
| Enterprise | 1,200,000 | 300,000 | 900,000 | 25% | 3,600,000 | 2,800,000 | 3.1x | 4.0x | 800,000 |
| Mid-market | 800,000 | 240,000 | 560,000 | 30% | 1,866,667 | 2,100,000 | 3.8x | 3.3x | -233,333 (surplus) |
How to use it
1. Use remaining target, not full quota
Coverage against full quota flatters you as the quarter progresses because closed deals leave the pipeline. Compute it against what is still to be closed: Remaining target = Quarter target - Closed won to date.
2. Compute win rate on the same pipeline definition
If you only count deals past qualification with a close date this quarter, your win rate must be measured on that same population, by value, over at least four quarters. Mixing definitions makes the ratio meaningless.
3. Calculate by segment before looking at the total
Enterprise and SMB have different win rates and cycle lengths. Blending them lets a surplus in one hide a shortfall in the other. Fix gaps segment by segment.
4. Convert the gap into a creation target
A gap only matters if you can still close it this quarter. Check the gap against your cycle length; if the average cycle is longer than the weeks remaining, new pipeline will not help this quarter and the gap is a forecast risk, not a pipeline task.
Frequently asked questions
How do you calculate pipeline coverage?
Pipeline coverage = Open in-period pipeline / Remaining target. Required coverage = 1 / Win rate. If your win rate on in-period pipeline is 25%, you need 4x coverage of what remains to be closed.
Is 3x pipeline coverage enough?
Only if your win rate on the same pipeline definition is about 33%. At a 25% win rate you need 4x; at 40% you need 2.5x. Use your own by-value win rate from the last four quarters, not a rule of thumb.
Should pipeline coverage be measured against quota or remaining quota?
Remaining quota. Once deals close they leave the pipeline, so coverage against full quota makes the pipeline look thinner than it is early in the quarter and hides nothing useful late in it.
What win rate should I use for pipeline coverage?
Win rate by value, measured on the same pipeline definition you use for coverage (usually qualified deals with a close date in the period), over at least four quarters, calculated separately for each segment.