Rev Ops Pipeline Coverage Calculator

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.