Rev Ops Pipeline Coverage Calculator
Calculate pipeline coverage ratio — total pipeline value ÷ quarterly quota. Target: 3-5x for predictable quota attainment. Adjusts by win rate, deal stage distribution, and average sales cycle. Identifies the coverage gap by stage and the action plan to close it.
Pipeline Coverage Math
Coverage ratio = Total pipeline value (weighted or unweighted) ÷ Quarterly quota. Unweighted coverage: simpler, sum of all open opps × ACV. Weighted coverage: each opp × historical close rate by stage. Most teams target 3-5x unweighted, 1.2-1.8x weighted. Below 2.5x unweighted at start of quarter = quota attainment <70%. Above 5x = likely sandbagging or inflated opps.
Stage-Weighted Coverage
Different stages have different historical close rates: Discovery 5-15%, Demo 15-25%, Proposal 30-45%, Verbal 60-80%, Closed-Won 100%. Multiply pipeline value × stage close rate to get weighted pipeline. Compare weighted pipeline to quota — should be 1.2-1.8x. If you're 3x unweighted but 0.8x weighted, your top-of-funnel is fine but you have a closing problem.
Sales Cycle and Pipeline Aging
Average sales cycle determines how far in advance you need coverage. 90-day cycle: need full quarter's coverage 90 days ahead. 30-day cycle: build pipeline same quarter. Pipeline aging report — count opps stuck >2x normal stage length. Stuck opps usually never close — they should be either advanced or removed. Aggressive pipeline hygiene improves win rate and forecast accuracy.
Common Pipeline Hygiene Failures
(1) Aging opps not removed — bloats coverage, hurts forecast. (2) Opps stuck in early stages (Discovery 90+ days) — usually not real. (3) ACV inflation — sales rep enters max-aspirational deal size instead of realistic. (4) No 'commit' / 'best case' / 'pipeline' segmentation in forecast. (5) Marketing pipeline counted at SAL stage before sales accepts. Quarterly pipeline cleanup is essential — remove 10-25% of opps and you usually get more accurate forecast, not less.
Sources: Salesforce State of Sales 2024, Pavilion CRO Survey 2024, RevOps Co-op Benchmarks. Last updated: May 2026. Not financial advice.
Frequently Asked Questions
What is a good pipeline coverage ratio?
Unweighted: 3-5x quarterly quota at start of quarter. Weighted (× historical stage win rates): 1.2-1.8x. Below 2.5x unweighted = quota attainment risk. Above 5x unweighted = possibly inflated/stuck opps.
What is the difference between weighted and unweighted pipeline?
Unweighted = sum of all open opp ACV. Weighted = each opp × its stage's historical close rate. Weighted is more accurate but requires reliable historical win-rate data. Most CFOs and boards look at both.
How do I improve pipeline coverage?
(1) Top-of-funnel: more MQLs / ABM accounts. (2) Mid-funnel: improve discovery → demo conversion via better qualification. (3) Pipeline hygiene: remove stuck/aging opps to clean data. (4) Acceleration: shorten sales cycle via better proof, references, deal-desk speed. (5) Cross-sell: expand existing accounts to grow pipeline coverage from base.
How often should sales review pipeline coverage?
Weekly: rep-level review (committed deals, slip risk). Monthly: team-level (coverage gap, conversion trends). Quarterly: company-level (segment performance, ICP refinement). Pipeline meetings should focus on action items, not status updates.
What's a healthy stage distribution?
Typical pyramid: 50% in early-stage discovery/demo, 30% mid-stage proposal, 20% late-stage verbal/commit. Heavy late-stage = good for current quarter but signals future-quarter risk (no new pipeline). Heavy early-stage = healthy top-of-funnel but conversion risk.