Weighted Pipeline
Definition
Weighted Pipeline
A weighted pipeline multiplies every open opportunity by the win probability attached to its stage, then adds the results into one number. It is a statistical view, never a commitment, and it is only as honest as the percentages behind it.
The arithmetic is trivial. A $100,000 deal sitting at a stage that historically converts 40% of the time contributes $40,000 to the weighted total.
What makes it useful is coverage. Across fifty opportunities the individual errors cancel out, which a single rep’s gut feel never does.
What makes it dangerous is that the output looks precise. A weighted total carried to the nearest dollar invites a confidence the underlying percentages cannot support.
Key takeaways
- A weighted pipeline is the sum of each open deal’s value multiplied by its stage win probability.
- Stage probabilities should come from historical conversion, not from how a rep feels about the deal.
- Weighted pipeline answers “roughly how much”, while a commit forecast answers “what will definitely land”.
- Stale stages and optimistic probabilities are the two failure modes that quietly inflate the number.
How it works
Weighted pipeline works in three steps. Assign a win probability to each sales stage, multiply every open opportunity by the probability of the stage it sits in, then total the results for the period you are forecasting.
A worked example makes the shape obvious.
| Stage | Stage probability | Open value | Weighted value |
|---|---|---|---|
| Qualified | 20% | $500,000 | $100,000 |
| Discovery complete | 40% | $300,000 | $120,000 |
| Proposal sent | 60% | $250,000 | $150,000 |
| Verbal agreement | 85% | $150,000 | $127,500 |
| Total | n/a | $1,200,000 | $497,500 |
The $1.2m of open pipeline is the headline number a rep quotes. The $497,500 is the number a finance team can plan against.
Calibration is the real work. Stage probabilities must be derived from what actually happened to past deals at that stage, not set once in a sales forecasting model and left alone.
The test is simple. Of the last hundred deals that reached your 60% stage, did roughly sixty close? If the answer is thirty, the stage is mislabelled and every forecast built on it is wrong.
A stage probability is really just a close rate measured from one point in the pipeline — so the same data discipline applies to both numbers.
Professional forecasters work in probabilities for the same reason. The Philadelphia Fed runs the oldest quarterly survey of macroeconomic forecasts in the United States, and it has collected probability estimates rather than single point numbers since 1968.
Coverage ratio sits alongside the weighted total. Most teams want three to four times their target in open pipeline, and the ratio flags a gap earlier than the weighted number does.
Then there are the known weaknesses, and none of them are subtle.
Stale stages come first. An opportunity parked at “proposal sent” for five months still contributes its full weighted value, which is why pipeline hygiene reviews exist.
Optimism is the second. Harvard Business Review’s 2019 review of sales forecasting concluded that most inaccuracy comes from human behaviour, not algorithms — the model is rarely the problem.
The third is category confusion. A weighted pipeline is a distribution flattened into one figure, so treating it as a commit number guarantees a miss in both directions.
Used properly it answers one question — roughly how much revenue is in play — and leaves the question of which named deals will sign to a separate review.
Mature teams report both side by side and treat the gap between them as the agenda item. A narrowing gap late in the quarter is usually the most useful signal either number produces.
Examples
Weighted pipeline turns up anywhere a team forecasts from a staged pipeline. Software sales, professional services, outsourcing providers and agency new-business teams all run the same calculation, and all of them argue about the percentages.
A software team’s quarter. The board sees three numbers each month: total open pipeline, weighted pipeline and the sales leader’s commit, with the gap between the last two treated as the discussion.
An outsourcing provider’s new-logo pipeline. Deals move slowly and carry long procurement stages, so the provider weights by stage and by age, discounting anything that has not moved in sixty days.
A services firm with lumpy deals. With only twelve open opportunities, the averaging effect barely works, so the team reports a weighted figure alongside a deal-by-deal review.
A recalibration exercise. A revenue operations team recuts stage probabilities from two years of closed deals, finds the proposal stage converts at 38% rather than the assumed 60%, and resets the forecast overnight.
The last case is the common one. Most weighted pipelines are wrong because nobody has checked the percentages since the CRM was configured.
Related terms
Weighted pipeline sits among the measures teams use to judge whether a quarter is on track. The entries below cover the pipeline discipline around it, the ratios read beside it, and the forecasting methods it feeds.
- Sales Pipeline Coverage: the ratio of open pipeline to the revenue target for a period.
- Pipeline Velocity: the speed at which value moves through the stages toward a close.
- Pipeline Management: the ongoing discipline of keeping stages, values and dates accurate.
- Opportunity Qualification Framework: the criteria deciding whether a deal belongs in the pipeline at all.
- Rolling Forecast: the continuously updated projection that replaces a fixed annual plan.
FAQ
How do you calculate a weighted pipeline?
Multiply each open opportunity’s value by the win probability of its current stage, then add every result together for the forecast period.
Where do stage probabilities come from?
From historical conversion data: of all deals that reached a given stage, the share that eventually closed. Default CRM percentages are a starting point, not an answer.
Is weighted pipeline the same as a forecast?
No. A weighted pipeline is a probability-adjusted estimate across every open deal, while a commit forecast is a named list of deals the team expects to sign.
Why does weighted pipeline overstate revenue?
Usually because stages are stale, probabilities were never recalibrated, or dead deals are still sitting open with a full value attached.
How often should stage probabilities be recalibrated?
At least annually, and sooner after any change to the sales process, the product mix or the buyer profile.
Explore more sales and outsourcing definitions across Outsource Accelerator.
Independent
