Weighted vs Unweighted Pipeline

What is the difference between weighted and unweighted pipeline?

Unweighted pipeline adds up every open deal at its full amount. Weighted pipeline multiplies each deal by a probability of closing before it adds them up. One tells you how much total opportunity is on the table. The other tries to estimate how much of it turns into revenue. They answer different questions, and reporting one when a decision needs the other is where teams get into trouble.

The gap between the two numbers is large. A pipeline that reads $4M unweighted might read $1.2M weighted once you apply stage probabilities. Neither number is wrong. They measure different things, and each is right for a specific job.

What is unweighted pipeline?

Unweighted pipeline is the total dollar value of every open opportunity, counted at full amount regardless of how likely each one is to close. If you have twenty open deals worth $50,000 each, your unweighted pipeline is $1,000,000. A deal in first-meeting stage counts exactly the same as a deal in final contract review.

That flatness is the point. Unweighted pipeline measures the size of the opportunity in front of the team, not the odds attached to it. It is the number behind pipeline coverage, the ratio of open pipeline to quota that most teams hold somewhere between 3x and 5x. Because it ignores probability, unweighted pipeline is stable. It moves when deals are created, closed, or resized, and not when a rep nudges a probability field.

What is weighted pipeline?

Weighted pipeline is the sum of every open deal multiplied by its probability of closing. That probability usually comes from the deal's stage or forecast category. A $50,000 deal at a stage mapped to 60 percent contributes $30,000 to weighted pipeline. The same deal at 20 percent contributes $10,000.

The goal is a single directional estimate of what the current pipeline is worth in expected revenue. Weighted pipeline leans on the idea that a deal's stage is a decent proxy for its odds, so a later-stage deal should count for more than an early one. The quality of the number rises and falls with the quality of that stage-to-probability mapping. If your Proposal stage historically closes 55 percent of the time and you have it mapped to 55 percent, the math holds. If you mapped it to 80 percent because that is what optimism wanted, weighted pipeline just inherits the error.

How do weighted and unweighted pipeline compare side by side?

The short version: unweighted measures capacity while weighted estimates revenue, and each carries a failure mode you have to respect.

Read the table as a division of labor. When the question is whether you have enough at-bats, unweighted is the right tool. When the question is what the pipeline is probably worth, weighted gets you closer. Problems start when the two get swapped.

When should you use unweighted pipeline?

Use unweighted pipeline whenever the question is about capacity rather than expected revenue. Coverage planning is the clearest case. The coverage ratio divides unweighted pipeline by the goal, and applying probabilities there would double-count the risk the ratio already builds in, which is why the 3x coverage rule targets 3x to 5x instead of 1x.

Unweighted is also the right number for pipeline-generation targets and rep workload, and for any early-stage conversation where probabilities are mostly noise. A stage-one deal's 10 percent is a placeholder, not a measurement, and weighting a top-of-funnel pipeline by those placeholders manufactures false precision. When you want a number that does not flinch every time someone edits a field, use unweighted.

When should you use weighted pipeline?

Use weighted pipeline when you need one directional revenue estimate and your stage probabilities are calibrated to reality. It is the better tool for comparing pipeline value across reps or segments that carry different stage mixes, because it corrects for the fact that one rep's pipeline might be mostly early and another's mostly late. A raw unweighted comparison flatters whoever has more open deals, quality aside.

Weighted also earns its place in an executive summary that needs a single expected-value figure next to the goal. Tie the probabilities to historical win rates by stage rather than to hope. The habit that keeps weighted pipeline honest is unglamorous. Every quarter or two, check whether each stage actually closes at the rate you have it mapped to, and re-map it when it has drifted.

Why does neither number equal a forecast?

Because both are static snapshots of the pipeline you can see today, and a real forecast has to account for the pipeline you cannot see yet. Unweighted overstates by ignoring the odds. Weighted corrects for the odds, but only through fixed stage averages that fit almost no individual deal. A 60 percent Proposal probability is an average across hundreds of deals, while the specific deal in front of you is closer to 90 percent or 15 percent.

There is a larger gap underneath that one. Both metrics only count deals already sitting in the CRM. Neither models the revenue that gets created and closed inside the quarter, or the deals pulled forward from a future period to rescue a number. In ORM's data, of the deals whose close date lands inside the current quarter, only about 20 percent of that value actually closes in the quarter it was dated for. A weighted-pipeline number built on those close dates carries the slippage straight into the estimate. The mistake I see most often is a team treating that estimate as the forecast itself.

So use both as inputs, not answers. Unweighted tells you whether there are enough at-bats. Weighted gives you a first-pass read on revenue. A real sales forecast breaks the quarter into what will close from existing pipeline, what still has to be created and closed in-quarter, and what might be pulled forward, then attaches the risk to each path. Weighted and unweighted pipeline are two useful gauges. They were never the whole instrument panel.