← Community / Sales Tools
Pipeline#forecast

Weighted Pipeline Builder

Stop looking at raw pipeline. Apply stage-level close probabilities to see what your pipeline is actually worth — and build a defensible quarterly forecast.

Pipeline Stages
StagePipeline Amount ($)Close Probability (%)Weighted Value
$
%
$120K
$
%
$360K
$
%
$475K
$
%
$420K
$
%
$272K
TOTAL$3.9M42.6% avg$1.6M
Pipeline Summary
Total Raw Pipeline
$3.9M
unweighted
Weighted Pipeline
$1.6M
probability-adjusted
Weighting Ratio
42.6%
weighted / raw
Quarterly Forecast
$544K
≈1/3 of weighted
Scenario View
Best Case
$920K
Stages at ≥70% probability
Committed
$320K
Stages at ≥85% probability

Why Your CRM Pipeline Number Is a Lie

Most CRM systems report pipeline at full face value — every deal in "Proposal" is counted at 100% of its dollar amount, regardless of whether it's actually likely to close. This creates a systematically inflated number that gives false confidence and leads to poor resource allocation decisions. Weighted pipeline applies a probability multiplier to each deal based on its stage, producing a more realistic view of expected revenue. A $500K deal in Discovery at 20% probability contributes $100K to weighted pipeline — not $500K. This is closer to what actually closes.

THE FORMULA
Weighted Value = Deal Amount × Stage Probability  |  Weighting Ratio = Total Weighted ÷ Total Raw

CRM systems assign generic probabilities by stage (often 25%, 50%, 75%) — but your team's actual win rates by stage may look nothing like the defaults. Calibrate by pulling your closed-won and closed-lost data for the last 12 months and calculating actual close rates at each stage. Use those as your weighting factors, and recalibrate every two quarters as your team, product, and market evolve. Weighted pipeline is not your forecast — it's a sanity check on your forecast. If a rep has $2M of weighted pipeline and commits $900K, that's defensible. If they commit $1.8M from the same weighted pipeline, that's optimism the weighted math doesn't support. Top-performing teams have weighted-to-raw pipeline ratios of 25–40%. If your weighting ratio is 60%+, your stage probabilities are too generous.

Frequently Asked Questions

What is weighted pipeline in sales?

Weighted pipeline multiplies each deal's value by its probability of closing (usually based on stage) to produce a more realistic revenue projection. A $200K deal at 50% probability contributes $100K to weighted pipeline. It gives a more conservative and accurate view of expected revenue than raw pipeline totals.

How do you calculate pipeline probability by stage?

Pull your historical data: of all deals that reached each stage, what percentage eventually closed as won? That close rate by stage is your probability weighting. For example, if 40% of deals that reach the Proposal stage close, weight Proposal-stage deals at 40%. Recalibrate every quarter.

What is a good weighted pipeline coverage ratio?

Target 2.5x–3x weighted pipeline coverage relative to your quota. Because weighted pipeline already accounts for probability, you need less raw coverage than with unweighted pipeline. If your weighted coverage is below 1.5x quota, you're at serious risk of missing the number.

How is weighted pipeline different from forecast?

Weighted pipeline is a mathematical average across all open deals. Forecast (specifically 'commit') reflects a rep's judgment about which specific deals will close, factoring in nuance that a formula can't capture. Use weighted pipeline as a sanity check on the forecast — if a rep's commit is significantly higher than their weighted pipeline, investigate why.

Discuss this in #forecast with 194+ revenue operators in the community.

← All ToolsJoin Community →