FREE TOOL
Pipeline coverage calculator
Coverage is the ratio of open pipeline to the number you have to hit. It is the most quoted number in revenue operations and the most easily gamed, because both halves of the ratio can be wrong at once.
Only deals with a close date inside the period you are measuring. Including deals that close later is the single most common way this number is inflated.
The number the team has to close in the same period. Use bookings or ARR consistently with how the pipeline above is valued.
Closed-won ÷ (closed-won + closed-lost) over a period long enough to be stable. This is what makes coverage interpretable rather than decorative.
PIPELINE COVERAGE
3.00×
COVERAGE YOUR WIN RATE REQUIRES
4.00×
You are 25% short of break-even at this win rate. Closing the gap needs pipeline generation, a better win rate, or a smaller number — not deal inspection.
Roughly break-even at a 25% win rate
This is the range where coverage starts to mean something. Check the age and close-date distribution before trusting it — coverage says nothing about whether the pipeline is real.
The formula
Pipeline coverage = open pipeline ÷ quota for the period
Published because a calculator that hides its arithmetic is asking to be trusted rather than checked. Every input above is defined precisely in the note under its field — most disagreements about these numbers turn out to be disagreements about what went into them.
WHERE THIS FAILS
Coverage is a ratio of two numbers that can each be wrong. A pipeline full of deals with close dates in the past produces a healthy ratio and an unmakeable quarter.
It treats every dollar of pipeline as equivalent. A single deal at 40% of the total is a very different risk profile from forty deals at 1% each, and this number cannot tell them apart.
It says nothing about stage. Pipeline concentrated in the first stage converts at a fraction of the rate of pipeline in late stages, at the same coverage ratio.
Win rate is historical. If your mix, segment or pricing has changed, the rate you are dividing by describes a business you no longer run.
DEFINITIONS USED HERE
OTHER CALCULATORS
- Payback periodCAC payback (months) = CAC ÷ (monthly ARPA × gross margin)
- Net revenue retentionNRR = (starting ARR + expansion − contraction − churn) ÷ starting ARR
- LTV:CAC ratioLTV = (monthly ARPA × gross margin) ÷ monthly churn rate · Ratio = LTV ÷ CAC
- Ramp-adjusted capacityCapacity = (ramped reps × quota × period/12) + (ramping reps × quota × productive months/12), where a linearly ramping rep averages half productivity during ramp
- Rule of 40 scoreRule of 40 = revenue growth rate (%) + profit margin (%)
- Forecast accuracyAccuracy = 1 − |actual − forecast| ÷ actual · Bias = (forecast − actual) ÷ actual
- Magic numberMagic number = (current quarter ARR − prior quarter ARR) × 4 ÷ prior quarter S&M spend
Run the whole audit, not one number
These calculators each answer one question. The courses here build the full picture — inventory, process, measurement — with interactive tools that keep your data and export it as a workbook.
COMMON QUESTIONS
- What is a good pipeline coverage ratio?
- It depends entirely on your win rate, which is why this calculator asks for it. The arithmetic is simple: to expect to hit quota you need coverage of at least 1 ÷ win rate. At a 25% win rate that is 4×; at a 33% win rate it is about 3×; at 20% it is 5×. The commonly quoted '3× is healthy' is only true at a 33% win rate and is misleading everywhere else.
- Should pipeline coverage include deals closing after the period?
- No, and including them is the most common way this number gets inflated. Coverage measures whether you can make a specific number in a specific period, so the pipeline in the numerator must have close dates inside that period. If you want a forward view, calculate coverage separately for the next period rather than blending them.
- Why is my coverage high but my forecast still missing?
- Almost always pipeline hygiene. Deals that should have been closed out as lost keep inflating the numerator, and close dates that have been pushed three times are counted as though they are real. Check the age distribution and the number of close-date changes per deal — if a meaningful share of your pipeline has been pushed more than once, your coverage is measuring an archive rather than a pipeline.
- Is coverage measured on bookings or ARR?
- Either, as long as both halves of the ratio use the same basis. Mixing them — ARR pipeline against a bookings quota that includes services and multi-year totals — produces a ratio with no meaning. Write down which basis you use and put it in the report definition so it cannot drift.