Weighted Pipeline

Weighted pipeline is the value of open sales opportunities adjusted by their probability of closing, so each deal contributes its expected value rather than its full value. A $100,000 deal at 30% probability counts as $30,000 of weighted pipeline. It gives a more realistic picture of likely revenue than raw pipeline value.

Raw pipeline totals overstate what will actually close, because not every open deal wins. Weighting each opportunity by its likelihood turns an optimistic list into a sober estimate, which is why weighted pipeline is a staple of forecasting and pipeline review.

What weighted pipeline measures

Weighted pipeline is the sum of each open deal's value multiplied by its probability of closing. It answers "how much revenue can we realistically expect from the current pipeline?", a question raw pipeline value cannot answer honestly. The probabilities usually come from the deal's stage (later stages have higher probability) or from a data-driven model.

How weighted pipeline is calculated

For each deal: weighted value = deal value × probability of closing. Sum across all open deals for the weighted pipeline.

The probabilities are the crux. Stage-based weighting assigns a fixed probability to each pipeline stage (e.g., proposal = 50%, negotiation = 75%); model-based weighting uses historical data or AI to estimate each deal's odds. Either way, the weighting is only as good as the probabilities behind it, which must reflect real historical win rates, not optimism.

Raw vs weighted pipeline

Why weighted pipeline matters

• Realistic forecasting. It estimates likely revenue far better than raw pipeline totals.
• Coverage assessment. Weighted against target, it shows whether you truly have enough to hit the number, refining pipeline coverage.
• Prioritization. Seeing expected value focuses attention on the deals that move the forecast most.
• Honest reviews. It counters the optimism baked into raw pipeline figures.

Limitations of weighted pipeline

Weighted pipeline is an estimate, not a guarantee. Stage-based probabilities are averages, so an individual deal does not close "30%", it either wins or loses; the weighting only makes sense in aggregate across many deals. Probabilities also go stale if win rates change, and they can be gamed if reps misstate stages. It works best as one input alongside forecasting judgment and a commit view, not as the single source of truth.

A worked example

Take a small team with five open deals and stage probabilities calibrated from its own history. The figures below are illustrative, chosen to show the arithmetic.

Raw pipeline says $170,000. Weighted pipeline says the team should expect roughly $72,000, less than half. If the quarterly target is $100,000, the raw figure suggests comfort and the weighted figure says the team needs new pipeline now. That gap between the two numbers is the whole reason the metric exists.

Notice also where the value sits. Deal C contributes a third of the weighted total from a single proposal, so the forecast is exposed to one outcome. Weighted pipeline read deal by deal shows concentration risk that a total cannot.

How to set the probabilities

The weights should come from history, not from a template. For each stage, count how many deals that reached it went on to close. If 40 of the last 100 deals that reached Proposal were eventually won, Proposal is worth 40%. Recalculate every quarter, and segment when deal types behave differently: an enterprise deal at Proposal and a small-business deal at Proposal rarely share the same odds.

Weighting by stage is simple, but it ignores everything that happens inside a stage. A deal that has sat in Negotiation for three months is not as likely to close as one that arrived last week. More mature teams adjust for age and activity, or replace stage weights with deal-level scores built from engagement, stakeholder coverage and deal health. The test is calibration: across all the deals you called 70%, about 70% should close. The Brier score is a standard way to measure how well a set of probability forecasts matched what actually happened.

Two habits keep the number honest. First, close out dead deals instead of leaving them in the pipeline at a low weight, because many small probabilities on stale deals quietly inflate the total. Second, compare the weighted forecast with actual results each quarter and track the gap as forecast accuracy. Clean stages depend on pipeline hygiene and a CRM that records every stage change as it happens, see sales pipeline stages for how to define them.

Weighted pipeline in the forecast call

In a forecast review, weighted pipeline works best as a cross-check against the reps' commit. If the commit is well above the weighted figure, either the team knows something about specific deals that the stage probabilities miss, or optimism is creeping in. Ask which deals explain the difference. If the commit sits well below the weighted figure, the probabilities may be too generous or the pipeline full of stale deals. Either way, the conversation moves from a single number to the handful of deals that decide the quarter, which is where pipeline management earns its keep.

Common weighted pipeline mistakes

• Wrong probabilities. Stage weightings that do not match real win rates produce a misleading forecast.
• Treating it as exact. Weighted value is meaningful in aggregate, not for predicting a single deal.
• Stale weightings. Probabilities that are never recalibrated drift away from reality.
• Stage gaming. Reps advancing deals to inflate weighted value corrupts the metric.

Weighted pipeline turns an optimistic list of open deals into a realistic estimate of expected revenue by adjusting for the odds of each closing. Built on probabilities that reflect real win rates and read in aggregate, it is one of the most useful tools for honest forecasting and pipeline review.