Sales Pipeline Metrics: Coverage, Velocity and Weighted Forecasting
Table of Contents
Four calculations turn a pipeline view into a forecast: coverage ratio, velocity, stage conversion rates and weighted value. Most pipeline guides describe the stages and stop before any of them.
This covers all four, with the formulas, one quarter of data carried through every calculation, and the reporting errors that make a healthy-looking pipeline miss.
What a sales pipeline actually measures
A sales pipeline is the set of open opportunities, positioned by how far through the sales process each one has moved.
As a visualization it shows where deals are. As a measurement instrument it answers three questions: is there enough in there to hit the number, how fast is it moving, and how much of it will actually close. Those require arithmetic, not a board view.
Pipeline vs sales funnel
The two get used interchangeably and measure different things.
A sales funnel tracks leads through a buying process — how many people entered at the top, how many survived each stage. It is a volume and conversion instrument, and it belongs to marketing more often than sales.
A sales pipeline tracks deals through a selling process — specific opportunities with values and close dates attached. It is a revenue forecasting instrument.
The practical difference: a funnel tells you whether you are generating enough interest, a pipeline tells you whether you will hit the quarter. A business can have a healthy funnel and a failing pipeline when leads arrive but do not qualify — which is usually a targeting problem at the top, not a selling problem at the bottom. We have covered building the top of that system in how to build a SaaS demand generation strategy.
Pipeline coverage ratio
Coverage answers whether there is enough open pipeline to hit the target.
Pipeline coverage = Open pipeline value ÷ Revenue target for the period
A team with $4.2M open against a $1.4M quarterly target has 3.0x coverage.
The convention is that 3x is adequate, which is really a restatement of a 33% win rate — if you close a third of what you open, you need three times the target in play. That makes the useful version of the rule specific to your business:
Required coverage = 1 ÷ Historical win rate
A team closing 25% needs 4x. A team closing 50% needs 2x, and holding 4x would mean it is over-generating pipeline that will age out.
Two ways coverage misleads. It treats a $500K deal at the proposal stage as equivalent to a $500K deal at first call, which is why weighted value exists. And it goes stale — pipeline opened eleven months ago in a three-month sales cycle is not coverage, it is clutter.
Pipeline velocity
Velocity measures how much revenue the pipeline produces per day.
Pipeline velocity = (Opportunities × Win rate × Average deal value) ÷ Sales cycle length in days
Four inputs, and only one of them is usually worked on.
Continuing the example: 140 open opportunities, 28% win rate, $38,000 average deal value, 74-day average cycle.
(140 × 0.28 × 38,000) ÷ 74 = 1,489,600 ÷ 74 = $20,130 per day
At roughly $20K a day, a 90-day quarter produces about $1.81M — comfortably above the $1.4M target, which tells you more than the coverage ratio did.
The reason velocity is worth calculating is that it shows which input actually moves revenue. From the numbers above:
ImprovementNew velocityChangeBaseline$20,130/day—+10% opportunities$22,143/day+10%+10% win rate (28% → 30.8%)$22,143/day+10%+10% deal value$22,143/day+10%−10% cycle length (74 → 66.6 days)$22,366/day+11.1%
All four levers are roughly equivalent at the margin — which is the point. Most teams reflexively pull the first one, generating more opportunities, when shortening the cycle by a week does slightly more and usually costs less. This is the same pattern we described in the SaaS metrics that predict growth: the input everyone watches is rarely the one that moves the outcome.
Weighted forecasting, and where it goes wrong
Weighted pipeline applies a probability to each stage and sums the result.
StageOpen valueProbabilityWeightedDiscovery$1,450,00010%$145,000Qualified$1,100,00025%$275,000Proposal$890,00050%$445,000Negotiation$520,00080%$416,000Verbal$240,00090%$216,000Total$4,200,000—$1,497,000
Weighted value of $1.497M against a $1.4M target. Tighter than raw coverage suggested, and a more honest read.
Three failure modes.
The probabilities are assumed, not measured. Those percentages should come from your own historical conversion by stage. Using a CRM's defaults means forecasting off someone else's business.
Averaging a bimodal pipeline. If half your deals close at 90% and half die at discovery, the arithmetic mean describes neither. A weighted forecast on a bimodal distribution will be reliably wrong in both directions.
Stage inflation. Reps move deals forward to look productive. Every deal parked at "proposal" that has not had a proposal sent adds phantom weighted revenue. This is the most common cause of a forecast that looks fine until the last week of the quarter.
Stage conversion rates
Conversion by stage is what makes every other calculation trustworthy.
Stage conversion = Opportunities advancing to next stage ÷ Opportunities entering stageStageEnteredAdvancedConversionDiscovery34019056%Qualified19010455%Proposal1047168%Negotiation715882%Verbal → Closed585290%
End-to-end: 52 ÷ 340 = 15.3% from discovery to closed won.
Read the shape, not just the numbers. Conversion generally rises through the stages, because the weak deals have already been filtered out. A stage where conversion drops relative to the one before it is where the process is broken. And the largest absolute loss here is discovery to qualified, which loses 150 opportunities — more than every later stage combined. That is where an improvement is worth most.
Worked example: one quarter, all four metrics
Same quarter, every number in one place.
MetricValueReadingRevenue target$1,400,000Open pipeline$4,200,000Coverage ratio3.0xAdequate, but only against a 33% win rateRequired coverage at 28% win rate3.6xActually short — needs $5.0M openPipeline velocity$20,130/day$1.81M over 90 daysWeighted pipeline$1,497,000Just above targetEnd-to-end conversion15.3%
Three instruments, three different answers: short on coverage, comfortable on velocity, marginal on weighted value. That disagreement is the useful output. It says the pipeline is adequate only if the deals currently in it convert at better than historical rates — which is exactly the assumption worth stress-testing before committing to the forecast.
Common pipeline reporting mistakes
Stale deals counted as coverage. Anything older than 1.5 times your average cycle should be reviewed or closed. It inflates every metric on this page.
Renewals in new-business pipeline. They convert at radically higher rates and destroy the win-rate figure that three of these calculations depend on.
Forecasting off unweighted totals. The raw $4.2M is not a forecast. It is the ceiling.
One pipeline across two motions. Self-serve and enterprise deals have different cycles, values and win rates. Averaged together, every metric here describes a business that does not exist.
Close dates that move. A deal whose close date has been pushed three times is not a Q3 deal. Track push count; it predicts loss better than stage does.
What to do with the numbers
Calculate required coverage from your own win rate rather than accepting 3x. Measure stage conversion from your own history and replace the CRM defaults. Then run coverage, velocity and weighted value together — when they disagree, that disagreement is the most useful signal the pipeline produces.
If the constraint turns out to be pipeline volume rather than conversion, the question becomes what each channel costs to feed it — our SEO ROI calculator models that for organic.
FAQs
What is a good pipeline coverage ratio?
Three times the target is the common rule of thumb, but the accurate version is 1 divided by your historical win rate. A team closing 25% of opportunities needs 4x coverage; a team closing 50% needs only 2x. Using the generic 3x when your win rate is 28% leaves you roughly 20% short without the dashboard showing it.
How do you calculate pipeline velocity?
Multiply the number of open opportunities by the win rate and the average deal value, then divide by the average sales cycle length in days. The result is revenue per day. It is useful because it exposes all four inputs — most teams try to add opportunities when shortening the cycle produces an equal or larger gain.
What is the difference between a sales pipeline and a sales funnel?
A funnel tracks leads through a buying process and measures volume and conversion. A pipeline tracks specific deals through a selling process and measures forecastable revenue. A business can have a healthy funnel and a weak pipeline when leads arrive in quantity but do not qualify.
What are the stages of a sales pipeline?
Most B2B pipelines use five or six: discovery, qualified, proposal, negotiation, verbal commitment, closed. The names matter less than having exit criteria for each — an observable event that must happen before a deal advances. Without them, stage data is opinion and every weighted forecast built on it is unreliable.
How do you forecast revenue from a sales pipeline?
Apply your own historically measured conversion rate for each stage to the open value in that stage, then sum. Do not use your CRM's default probabilities, which describe an average business rather than yours. Cross-check the result against pipeline velocity; when the two disagree, the assumptions behind one of them are wrong.