How to calculate weighted pipeline
Weighted pipeline corrects the biggest flaw in raw pipeline: it treats a brand-new deal and a deal in final negotiation as equally likely to close. Weighting by probability produces a far more realistic number.
Probabilities usually come from the deal's stage, though scoring models refine them with real signals. Either way, the goal is a single risk-adjusted figure leaders can compare against quota.
- Sum of value x probability The formula
- Stage-based odds Where probabilities come from
- Forecast-friendly More realistic than raw
Short answer
Weighted pipeline multiplies each open deal's value by its probability of closing, then sums the results. A 50,000 dollar deal at 40 percent contributes 20,000 dollars. It produces a risk-adjusted revenue estimate that sits between raw pipeline and zero, making it a more realistic forecast input than total open pipeline value.
Step by step
List open deals with value and stage
Take all open deals expected to close in the period, each with its amount and current stage.
Assign a win probability
Apply each deal's win probability, usually the default for its stage, or a model-based score for more accuracy.
Multiply and sum
Multiply each deal's value by its probability, then add the results. The total is your weighted pipeline.
Use it in the forecast
Compare weighted pipeline to quota as one forecast input. It is more conservative than raw pipeline and pairs well with rep commit judgment.
Worked example
Three deals: 100,000 dollars at 20 percent, 60,000 dollars at 50 percent, and 40,000 dollars at 80 percent. Weighted contributions are 20,000, 30,000, and 32,000 dollars.
Weighted pipeline = 20,000 + 30,000 + 32,000 = 82,000 dollars, versus 200,000 dollars of raw pipeline. The weighted figure is a far more realistic estimate of what these deals will actually contribute this period.
How Ardovo handles it
Ardovo weights pipeline by stage probability automatically and lets you override per deal. Rook refines the weighting with real signals like engagement and buying-committee coverage, not just the stage a rep parked the deal in.
Frequently asked questions
What is the weighted pipeline formula?
The sum of each open deal's value multiplied by its win probability. A 50,000 dollar deal at 40 percent contributes 20,000 dollars. The total is a risk-adjusted estimate between raw pipeline and zero.
Where do the win probabilities come from?
Most teams assign a default probability to each pipeline stage. More advanced setups use a model that scores each deal on engagement, fit, and history, producing more accurate weights than stage alone.
Is weighted pipeline the same as a forecast?
No, it is one input to a forecast, not the whole thing. Good forecasts also use rep commit judgment, historical accuracy, and category roll-ups alongside the weighted number rather than relying on it alone.