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.
- Category:
- Pipeline & Forecasting
- Formats:
- PDF + CSV + web view
- Sections:
- 5
- Updated:
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
- 1
Coverage calculator by segment
10 columns, 4 worked example rows
- 2
Formulas
3 columns, 5 worked example rows
- 3
Closing the gap
5 fields to complete
- 4
What counts as in-period pipeline
7-point checklist
- 5
Why the blended number misleads
Guidance notes
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) |
The preview shows part of section 1. The full template has all 5 sections (4 not previewed here), with blank rows ready to fill in. Download the full template
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 rather than 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.
Related templates
All sales ops templatesPipeline generation plan
Pipeline & Forecasting
A pipeline generation plan that back-solves pipeline by source from the bookings target, win rate, and cycle length, with owners. Free PDF and CSV.
Sales funnel conversion calculator
RevOps Metrics & Reporting
A sales funnel calculator that back-solves required leads, MQLs, meetings, and opportunities from a bookings target, by channel. Free CSV.
Sales forecast template
Pipeline & Forecasting
A sales forecast template that rolls rep calls into a team number with floor, ceiling, manager calls, and a stage-weighted cross-check. Free PDF and CSV.