ThinkWork
Interactive Team/Manager Free · no sign-up

Pipeline Coverage & Gap Calculator

Coverage ratio targets (3x, 4x, whatever your model uses) are only useful if they're checked against two things: what you actually have, and what your own win rate says is the mathematical floor. This calculator does both — it sizes the gap between your current pipeline and what's required, then translates that gap into deals and a weekly sourcing rate given how long your sales cycle actually takes.

Your numbers

Quota for the period (e.g. this quarter)
Total open opportunity value right now
Of qualified opportunities, closed-won
£ of pipeline you want per £1 of target
Typical closed-won deal value
First contact/qualification to close
Days remaining until the quarter/period ends

Method & assumptions

  • Required pipeline = revenue target × your target coverage ratio. The 'win-rate implied minimum' is a separate, independently-derived floor (1 ÷ win rate) — the coverage you'd need even before adding any buffer for slippage.
  • Deals/week assumes new pipeline must be created before (days left − average sales cycle) elapses to still close within the period. If the cycle is longer than the time left, no amount of new sourcing closes the gap in time — that scenario is flagged separately rather than silently averaged away.
  • This sizes the gap arithmetically; it does not weight pipeline by stage or probability. Use it alongside a weighted forecast, not instead of one.
  • 3–4x coverage is a common B2B/SaaS rule of thumb, but it's a heuristic — your own win-rate-implied minimum is the harder floor to respect, and the tool tells you if your chosen ratio falls short of it.

How to use it

Enter your revenue target for the period and your current open pipeline value, then your historical win rate and the coverage ratio your team plans against (commonly 3–4x). Add your average deal size and sales cycle length, plus how many days are left in the period. The tool shows the required pipeline, the gap in £ and deals, and how many new deals per week you'd need to source to close that gap in the time you have left — while also flagging if your target ratio itself is thinner than what your win rate mathematically requires.

For managers

A checklist shows the surface. A standard shows the layer underneath.

If team performance keeps coming up in your 1:1s, the gap is usually structural, not effort. The Mastery Diagnostic measures your team against a written 27-framework standard in two weeks, and tells you exactly where the layer breaks.

See the Mastery Diagnostic Book a discovery call