Weighted Pipeline

Weighted pipeline discounts every open deal by the historical win rate of the stage it sits in, then sums what's left. A $100k opportunity in a stage that closes 30% of the time counts as $30k. The raw number — total open pipeline — flatters everyone. The weighted number is supposed to tell you what's actually going to land, and it's the figure RevOps quietly trusts more than the rep's gut.

How Weighted Pipeline Is Calculated

Each open opportunity gets multiplied by a probability tied to its opportunity stage, and the products are summed:

Weighted Pipeline = Σ (Deal Amount × Stage Win Probability)

The probabilities come from one of two places. The honest version pulls them from your own stage conversion rate history — what fraction of deals that reached "Proposal" actually closed over the last four quarters. The lazy version uses whatever defaults the CRM admin typed in during setup in 2019. Those two numbers are rarely the same, and the gap between them is where forecasts go to die.

Weighted Pipeline Worked Example

A rep has three open deals heading into quarter-end:

The rep walks into forecast review talking about $400k of pipeline. The weighted view says $190k. Finance plans headcount, spend, and the board deck off the $190k, because in aggregate the discounted number tracks reality better than the sum of optimistic close dates.

When Sales Teams Use Weighted Pipeline

RevOps leans on it to sanity-check the rep-submitted commit against something math-based. A VP of Sales uses it to spot reps whose raw pipeline is enormous but whose weighted number is thin — a sign of deals parked in early stages going nowhere. Finance uses weighted pipeline for cash and hiring models because it smooths out individual-deal noise across a large enough book. It pairs naturally with pipeline coverage ratio: coverage tells you if there's enough volume, weighting tells you how much of that volume is real.

Common Weighted Pipeline Gaming Patterns

The metric breaks the moment stage probabilities stop reflecting actual conversion. The most common exploit is stage inflation — a rep nudges a stalled deal from "Discovery" to "Proposal" not because the buyer advanced but because the higher stage weight makes their forecast look healthier. Nothing changed except a picklist value, and $120k of dead air now counts as $48k of "real" pipeline.

The second exploit runs the other direction. A rep on track to crush quota leaves closeable deals languishing in low-probability stages so the weighted number stays modest, banks the upside, and beats the forecast next quarter — textbook sandbagging. Weighted pipeline can't see intent; it only sees the stage field.

And the math has a structural blind spot: weighting assumes deals are independent and that your historical win rates still hold. They don't during a pricing change, a competitive shift, or a quarter where one logo represents 60% of the number. A single $2M deal weighted at 70% contributes $1.4M to the forecast, but it either closes or it doesn't — there is no $1.4M outcome. Weighted pipeline is a portfolio tool that quietly lies to you whenever the portfolio is small or lumpy. Use it across a full team and a full quarter; distrust it on any single deal.