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

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.