What pipeline coverage measures and why the ratio exists
Pipeline coverage is the value of your open opportunities divided by the quota you still have to land. A coverage ratio of 3× means you are carrying three dollars of open pipeline for every dollar you still need to book.
The ratio exists because a pipeline is a probability distribution, not a queue. Most opportunities will not close: they stall, lose to a competitor, lose to no decision, or slip past the period. So the pipeline has to be larger than the gap by whatever factor compensates for the losses. Coverage is a quick way to ask whether you are carrying enough to survive normal attrition.
The trouble is that the industry answers the question with a number — "you need 3× coverage" — which is only correct for a team that wins one opportunity in three. If your win rate is 20%, 3× coverage is a forecast miss you can already see: you expect to close 0.2 × 3 = 0.6 of the gap. If your win rate is 40%, 3× is 20% more pipeline than you need, and the rep is being asked to prospect for volume they will never work.
This calculator refuses to guess. It takes your own win rate and derives the coverage you need from it, then compares that against what you actually hold. It also tells you what win rate your team's coverage policy silently assumes, which is usually the fastest way to end an argument about pipeline targets.
The formula: expected value, rearranged
Start with the only line of math that matters. The value you expect to close from an open pipeline is the pipeline value times the win rate:
expected bookings = pipeline × win rate
You want expected bookings to equal your remaining gap. Set them equal and solve for pipeline, and you get pipeline = gap ÷ win rate. Divide both sides by the gap and the coverage ratio falls out on its own: required coverage = 1 ÷ win rate. That is the whole derivation, and it explains every coverage multiple anyone has ever quoted. A 33% win rate gives 3×. A 25% win rate gives 4×. A 20% win rate gives 5×. Nobody was wrong about 3×; they were describing their own win rate and forgetting to say so.
Three definitions decide whether your inputs are honest. Win rate must be won opportunities divided by opportunities that reached a decision — won plus lost — measured over enough history to be stable, which for most B2B teams means at least four quarters. Dividing wins by all opportunities ever created inflates the denominator with deals still open and understates your win rate. Open pipeline must exclude opportunities whose close date falls outside the period; a pipeline padded with next-year deals produces comforting coverage and no bookings. Average deal size should be the mean of won deals over the same window as the win rate, and you should use the median instead when a handful of large deals dominate the mean.
The count version follows from the same algebra. Wins needed is the gap divided by average deal size. Opportunities needed is that figure divided by the win rate again — gap ÷ (deal size × win rate). If you want to work further back up the funnel to the leads and traffic those opportunities require, the sales funnel conversion calculator chains the stage rates together.
Worked example: a $1.5M quarter, 22% win rate, 45 days left
A team carries a $1,500,000 quarterly quota. Six weeks from the end of the quarter they have booked $450,000, hold $3,200,000 of open pipeline dated inside the quarter, win 22% of the opportunities that reach a decision, and average $60,000 per won deal. Their average sales cycle is 75 days.
- Remaining gap. $1,500,000 − $450,000 = $1,050,000.
- Coverage the win rate requires. 1 ÷ 0.22 = 4.55×.
- Pipeline required. $1,050,000 ÷ 0.22 = $4,772,727.
- Coverage held. $3,200,000 ÷ $1,050,000 = 3.05×.
- Shortfall. $3,200,000 − $4,772,727 = −$1,572,727 of pipeline.
- Wins needed. $1,050,000 ÷ $60,000 = 17.5, so 18 deals.
- Opportunities needed. $1,050,000 ÷ ($60,000 × 0.22) = $1,050,000 ÷ $13,200 = 79.5, so 80 opportunities must be worked to produce those 18 wins.
- Weighted forecast. $450,000 + ($3,200,000 × 0.22) = $450,000 + $704,000 = $1,154,000, which is $346,000 short of quota.
Two things fall out of those numbers. First, the team passes the traditional 3× test and is still going to miss by about a quarter of the quota — which is exactly the failure mode a fixed coverage policy produces. Second, the 75-day sales cycle is longer than the 45 days left, so an opportunity created today will not close in time. The $1,572,727 of missing pipeline cannot be prospected into existence this quarter; it can only be found among deals that already exist, pulled forward, or accepted as a miss and replaced with a plan for next quarter.
How to read the result, and what to do about a shortfall
Compare two numbers: coverage held against coverage required. Above the requirement, your expected bookings clear the gap and the remaining risk is timing and concentration. Below it, you have a forecast problem that arithmetic has already decided, and the only question is which lever you pull.
There are four, and only four. You can add pipeline, which works only if your sales cycle fits inside the days remaining — the calculator checks that for you. You can raise the win rate, which in-period usually means better qualification and tighter deal support rather than a training programme. You can raise deal size through packaging or multi-year terms. Or you can change the number and re-forecast honestly. Everything else is hope.
Read the weighted forecast next to the coverage figure, but know that on these inputs the two are the same test wearing different clothes. Coverage clears the requirement exactly when the weighted forecast clears quota: coverage above 1 ÷ win rate means pipeline × win rate exceeds the gap, and adding closed-won to both sides turns that straight into a forecast above quota. So the forecast never disagrees with the ratio here — it just restates it in dollars, which is the more useful unit when you have to tell somebody the number. A genuine disagreement only appears once the two are fed different assumptions: a CRM forecast built from per-stage probabilities, or a pipeline total that includes out-of-period close dates in one calculation and not the other.
Watch concentration too, because a ratio cannot see it. Coverage of 5× where one deal is 60% of the pipeline is far riskier than 3.5× spread over forty opportunities — the ratio treats a coin flip and a diversified portfolio identically. And beware stage-weighted forecasts that use per-stage probabilities: they are useful, but the probabilities are usually assumptions rather than measurements. If your CRM says a stage-three deal closes 50% of the time, verify that against history before you forecast on it. Rising coverage with a falling win rate is not progress; the two multiply, and the product is what pays.
Finally, tie the pipeline back to capacity. Eighty worked opportunities is a workload, not just a number. Take your own working limit — the live deal count your reps carried in quarters they actually hit — and divide: at a limit of twenty-five, 80 ÷ 25 = 3.2, so that gap needs more than three reps' full attention for the quarter. The billable utilization calculator makes the same capacity argument for delivery teams, and the sales commission calculator shows what the attainment implied by this gap pays out.
Pipeline required for a $1,050,000 gap, by win rate
| Win rate | Required coverage | Pipeline required |
|---|---|---|
| 10% | 10.00× | $10,500,000 |
| 15% | 6.67× | $7,000,000 |
| 20% | 5.00× | $5,250,000 |
| 22% | 4.55× | $4,772,727 |
| 25% | 4.00× | $4,200,000 |
| 30% | 3.33× | $3,500,000 |
| 33.3% | 3.00× | $3,150,000 |
| 40% | 2.50× | $2,625,000 |
| 50% | 2.00× | $2,100,000 |
The 3× rule of thumb is exactly right at a 33.3% win rate and wrong everywhere else. Find your own row before you set a coverage target.
Deals and opportunities needed for the same gap at a 22% win rate
| Average deal size | Wins needed | Opportunities needed |
|---|---|---|
| $25,000 | 42 | 191 |
| $50,000 | 21 | 96 |
| $60,000 | 18 | 80 |
| $100,000 | 11 | 48 |
| $250,000 | 5 | 20 |
Deal size does not change the pipeline dollars required — only the number of opportunities that has to be sourced and worked to produce them. That is a headcount question, not a marketing question.
Mistakes that make a coverage number useless
- Using a borrowed coverage target. A multiple copied from another company encodes that company's win rate. Derive yours from 1 ÷ win rate.
- Counting pipeline that cannot close in the period. Opportunities with close dates beyond the quarter inflate coverage without changing what you will book.
- Computing win rate over open opportunities. Divide wins by decided opportunities — won plus lost. Including still-open deals in the denominator understates the rate.
- Ignoring the sales cycle against days remaining. If the cycle is longer than the time left, new pipeline cannot rescue this period no matter how much you add.
- Treating the coverage ratio as a risk measure. One deal at 60% of pipeline is a coin flip. The ratio cannot see concentration, so look at the deal list too.
- Forecasting on unmeasured stage probabilities. CRM stage weights are often defaults nobody validated. Check them against your own closed history before you rely on them.
- Comparing coverage across periods without adjusting the gap. Early in a quarter the gap is nearly the whole quota, so coverage looks low; late in the quarter a small gap makes coverage look enormous.
What this model assumes, and what it cannot see
The model applies one win rate to the whole open pipeline. That is a deliberate simplification and a real limitation: in practice win rates differ by segment, by product, by lead source, and by stage. A pipeline that is mostly stage-one has a lower true win rate than your historical blend, and this calculator will flatter it. If your stages have measured conversion rates, run the segments separately and add the results.
It assumes deals close inside the period at the historical rate and that your average deal size is representative. It does not model slippage explicitly, seasonality, discounting pressure at quarter end, ramping reps who cannot yet carry a full number, churn or contraction inside a renewal-heavy quota, or multi-year contract value versus first-year bookings. It also treats the win rate as independent of pipeline volume, which stops being true when reps are stretched: coverage bought by loading up thin opportunities usually lowers the win rate that the whole calculation depends on.
Treat the required-pipeline figure as a planning floor rather than a forecast. Expected value is an average, and you land a single outcome, not an average. Carrying coverage a little above the arithmetic requirement is how teams absorb the variance — and how much extra depends on how concentrated your deal list is. If you want the customer-economics side of the same plan, the customer acquisition cost calculator prices the acquisition effort, and the LTV to CAC ratio calculator tells you whether the deals are worth winning at that cost.
How coverage relates to the other ways of forecasting a quarter
Coverage is a capacity test, not a forecast. It belongs alongside three other methods, each answering a different question.
A weighted forecast multiplies each opportunity by a stage probability and sums the result. It is more granular than coverage and more sensitive to the accuracy of the probabilities. This calculator produces the single-rate version of it. A commit-and-upside forecast abandons probability entirely and asks reps to categorise each deal as commit, most-likely or upside; it is judgement-based, works well with disciplined teams, and is unauditable without history. A run-rate forecast extrapolates the bookings pace so far, which is the right instrument for high-volume, short-cycle business and useless for a business closing eighteen deals a quarter.
The strongest practice is to compute all of them and interrogate the disagreement. Note that coverage cannot disagree with the single-rate forecast on this page — they are algebraically the same test — so the comparison worth making is against your CRM's stage-weighted forecast. When coverage says the pipeline is sufficient and the stage-weighted forecast says you miss, your pipeline is skewed to stages that convert below your blended rate, and that is a qualification finding you can act on today. When coverage says you are short but the run rate says you will land, you are probably closing deals faster than the recorded cycle implies — worth confirming, because it means the cycle input needs updating. The conversion rate calculator and the average order value calculator handle the same arithmetic for high-volume, short-cycle revenue where the run-rate method wins.
Key terms
- Coverage ratio
- Open pipeline value divided by the quota still to be booked. Expressed as a multiple, such as 3×.
- Win rate
- Won opportunities as a share of opportunities that reached a decision — won plus lost. Open deals belong in neither.
- Quota gap
- Quota for the period minus closed-won to date. The number coverage is measured against.
- Weighted forecast
- Closed-won plus open pipeline multiplied by a probability. Here the probability is your single historical win rate.
- Sales cycle
- Median days from opportunity creation to closed-won. Determines whether new pipeline can land inside the period.
- Slippage
- An opportunity whose close date moves into a later period. Slippage lowers realised bookings without changing the pipeline total.