How is weighted pipeline calculated?

Each opportunity's value multiplied by a probability — usually from its stage — and summed. The result is an expected value across the portfolio, not a prediction about any individual deal.

Are stage probabilities accurate?

Usually not, because they are set once from a default and never re-fitted against observed conversion. Comparing assigned probability to actual historical conversion per stage is the correction, and it is arithmetic on data you already hold.

Why does weighted pipeline not match the forecast?

They are different instruments. Weighted pipeline is a mechanical expected value; a forecast is a judgement. Divergence between them is informative and should be examined rather than reconciled away.

When is weighted pipeline misleading?

With few large deals. Expected value assumes enough opportunities for probabilities to average out — with ten deals, no outcome will resemble the weighted figure.

Weighted Pipeline

Pipeline value multiplied by a probability assigned to each stage, producing an expected value rather than a gross total.

What the number is

An expected value across a portfolio of opportunities. It is a statement about the aggregate, and it says nothing meaningful about any individual deal — a £100,000 opportunity at 40% will close for £100,000 or for nothing, never for £40,000.

It requires volume

Expected value relies on the law of large numbers. With a few large opportunities, the weighted figure describes an outcome that cannot occur, and using it to plan is how a quarter is missed by a wide margin while the dashboard looked fine.

Fixing the probabilities

The weights are the whole model, and in most systems they are vendor defaults that nobody has revisited.

For each stage, compute the observed historical conversion of opportunities that entered it, over at least four completed periods.
Compare against the assigned probability. Divergence is systematic and invisible at the deal level.
Replace the assigned values with the observed ones, and re-fit on a schedule — the mix shifts and so do the rates.
Fit separately by segment where motions differ. One probability set across enterprise and self-serve is wrong for both.

Using it alongside a judgement forecast

The most useful application is as an independent second estimate. Produce the weighted figure mechanically alongside the judgmental roll-up and examine where they disagree rather than reconciling them. Combining independent forecasts is among the most consistently supported recommendations in forecasting research, and this is the cheapest available version of it.

Where it misleads

Probabilities derived from stage assume stage is the only information, ignoring deal age, segment and source, which often predict better.
It rewards creating opportunities, since every new record adds weighted value regardless of quality.
Ageing opportunities keep their stage probability indefinitely, so stalled deals contribute expected value they no longer deserve.

RELATED TERMS

Forecast Accuracy

How closely forecasts match actual results, measured consistently over time. The metric that separates disciplined forecasting from lucky forecasting.

Pipeline Coverage

The ratio of open pipeline value to the target for a period. Answers whether there is enough in play to hit the number at historical conversion rates.

Win Rate

The proportion of opportunities that close won, measured against a defined denominator — which is where most of the disagreement lives.

COMMON QUESTIONS

How is weighted pipeline calculated?: Each opportunity's value multiplied by a probability — usually from its stage — and summed. The result is an expected value across the portfolio, not a prediction about any individual deal.
Are stage probabilities accurate?: Usually not, because they are set once from a default and never re-fitted against observed conversion. Comparing assigned probability to actual historical conversion per stage is the correction, and it is arithmetic on data you already hold.
Why does weighted pipeline not match the forecast?: They are different instruments. Weighted pipeline is a mechanical expected value; a forecast is a judgement. Divergence between them is informative and should be examined rather than reconciled away.
When is weighted pipeline misleading?: With few large deals. Expected value assumes enough opportunities for probabilities to average out — with ten deals, no outcome will resemble the weighted figure.