Pipeline Coverage Ratio: Work Out Your Own Multiple Instead of Copying One

Coverage is open pipeline for a period divided by the target for that period. If you need one crore of revenue this quarter and have three crore of open deals with close dates in the quarter, coverage is three times. That is the whole calculation. What makes it useful or useless is entirely in the definitions: which deals count, which close dates you believe, and what the multiple should be for your business.

It is not a forecast. It does not tell you what will close. It tells you whether there is enough in play for the target to be arithmetically plausible given how your team historically converts. Treating it as a forecast is the source of most disappointment with the metric.

Assume, illustratively, that your team wins 22 per cent of deals that reach the qualified stage. The inverse is roughly 4.5, meaning you need about four and a half rupees of qualified pipeline for every rupee of target. Now allow for timing. Look back at the last two quarters and calculate what share of deals open at the start of the quarter actually closed within it, won or lost. Suppose that is 70 per cent. Divide 4.5 by 0.7 and you get approximately 6.4.

So this illustrative team needs a little over six times coverage at the start of the quarter, not three. If they had used the common rule of thumb they would have entered every quarter roughly half covered and been mystified by the results. Run the same two step calculation with your own numbers. It takes twenty minutes and it is the single most valuable thing in this article.

The last row deserves a comment. When the required multiple climbs above eight or nine, the sensible response is usually not to generate that much more pipeline. It is to look hard at qualification, because a win rate that low often means deals are entering the pipeline that were never real, and the cheapest fix is at the entry gate rather than the top of the funnel.

Close dates that mean nothing

If reps set close dates by dragging them forward to the end of the current quarter, coverage becomes a measure of wishful date entry. Audit this directly: count how many deals in the current period have a close date that was previously in an earlier period. If it is a large share, your coverage number is describing the calendar rather than the pipeline.

One deal dominating

Always look at coverage excluding your single largest open deal. If the ratio collapses when you remove it, you do not have coverage, you have a bet, and the review conversation should be about that bet rather than about the aggregate.

Stale pipeline propping up the number

Deals that have not moved in sixty days convert at a fraction of the rate of active ones. Split coverage into active and stale, using a movement rule rather than a feeling, and watch the active figure as the real number. The stale figure is a to do list for the close out conversation nobody enjoys.

When coverage falls short with time left, the fastest levers in order are usually these. Revisit closed lost deals from the previous two quarters, because those buyers had a need and a process and some of them have changed circumstances. Increase deal size on live opportunities through packaging rather than discounting. Then push top of funnel, accepting that anything created now will mostly land in the following period. And say something early to whoever owns the number, because the cost of a surprise in the last fortnight is not just the miss, it is the credibility.

Coverage becomes a live number rather than a monthly slide once your pipeline data is trustworthy. HelloGrowthCRM shows open pipeline by close date and by rep with stage entry rules you define, which mainly matters because the ratio is only useful when everyone agrees what a qualified deal is.

More on forecasting and pipeline discipline: sales automation, lead management software, CRM fundamentals, CRM versus spreadsheets, features, and use cases.