Pipeline Coverage: A Math-First Framework
Pipeline coverage ratios are usually theater. Replace them with a math-first model that accounts for stage conversion, deal size, and time-to-close.
The phrase "we have three-times pipeline coverage" is one of the most reassuring and least useful statements I encounter in sales operations. It is reassuring because it sounds like a buffer. It is useless because the multiplier almost never reflects the math underneath.
What "coverage" actually needs to account for
A coverage ratio that means anything has to account for four variables: stage-weighted conversion, deal size distribution, time-to-close, and seller capacity. A pipeline that looks like three times coverage on paper might be ninety percent stage-two opportunities with a sixteen-week average close cycle. That is not coverage. That is hope.
The math-first version asks a different question. Of the pipeline currently in the system, what fraction will close within the period being forecast, weighted by historical stage conversion and adjusted for deal-size variability?
The five-input model
Whenever I rebuild a pipeline coverage model, I build it from five inputs, not one ratio:
- Stage distribution: how much pipeline sits in each stage, by dollar value
- Stage conversion: what fraction historically advances from each stage to closed-won
- Time-to-close by stage: how long deals at each stage take to reach close
- Deal size distribution: median and standard deviation, not just the average
- Seller capacity constraint: even if the math says enough, can the team actually work it?
Multiplied through, these produce a credible coverage number. It is usually significantly less than the simple ratio suggests.
What to do with the answer
Once the math-first coverage number exists, leadership can see three things the simple ratio hides: which stages are over-represented in the pipeline, which deals are stuck rather than progressing, and where seller capacity is the binding constraint instead of pipeline volume.
The first response to weak coverage is usually "build more pipeline." The math-first version often suggests a different answer. Improve stage conversion, accelerate stuck deals, or rebalance seller capacity. All three are typically faster and cheaper than building more top-of-funnel.
The right pipeline question is rarely "how much do we have." It is "how much will actually close."
Written by Ramy Stephanos. SF Advisor | Consulting.