How to build a weighted pipeline
Raw pipeline overstates what will close because it treats a brand-new deal the same as a signed-tomorrow one. Weighting corrects that by discounting each deal by its odds.
The build is mechanical once your stage probabilities are honest. Getting those probabilities from real conversion data, not gut feel, is what makes the weighted number trustworthy.
Short answer
Build a weighted pipeline by giving each stage a default win probability grounded in your historical stage-to-close conversion, multiplying every open deal's amount by its probability, and summing the results. A 50,000 dollar deal at 40 percent contributes 20,000. The total is a risk-adjusted estimate that is more realistic than raw pipeline for forecasting a period.
Step by step
Calibrate stage probabilities from history
For each stage, calculate what share of deals that reached it eventually closed won. Those historical rates, not optimistic guesses, become your stage probabilities.
Multiply every deal by its probability
Take each open deal's amount and multiply by the probability of its current stage. A 100,000 deal in a 30 percent stage contributes 30,000 to the weighted total.
Sum for the weighted pipeline
Add the weighted values across all open deals. The result sits between raw pipeline and zero and is a far more realistic read on likely bookings.
- Weighted total is your risk-adjusted number
- Compare it against quota for coverage
- It is one input to the forecast, not the whole thing
Refine with per-deal overrides
Let reps adjust a specific deal's probability when real signals differ from the stage default, such as a stalled late-stage deal that deserves a haircut.
Reconcile against rep commits
Compare the weighted number to the rep-commit roll-up. Where they diverge, inspect the deals; the gap is your risk, not something to average away.
Weighted pipeline is not a forecast
The weighted number is one input, not the answer. Good forecasts also use rep commit judgment, historical accuracy, and category roll-ups. Treating weighted pipeline as the forecast ignores the human signal that timing and risk carry.
Weighting is only as honest as your stage discipline. If reps park deals in advanced stages prematurely, the weighted number inflates. Clean stages first, then weight.
How Ardovo helps
Ardovo weights pipeline by stage probability automatically and lets you override per deal, and Rook refines the weighting with real signals like engagement and buying-committee coverage rather than just the stage a rep parked the deal in.
Frequently asked questions
How do I weight a sales pipeline?
Assign each stage a win probability from your historical stage-to-close conversion, multiply every open deal's amount by its stage probability, and sum the results. A 50,000 dollar deal at 40 percent contributes 20,000 to the weighted total.
Where do the stage probabilities come from?
From your own history: the share of deals reaching each stage that eventually closed won. Borrowed or guessed probabilities produce a weighted number you cannot trust. Calibrate from real conversion and revisit it as your data grows.
Is weighted pipeline the same as a forecast?
No. It is one input. A complete forecast also uses rep commit judgment, historical accuracy, and category roll-ups. Weighted pipeline captures probability but not the timing and risk signals a rep's commit call adds.