Optimized Sales Optimized Marketing Target Accounts For CROs For CFOs For CMOs Blog News Glossary Compare Tools About Schedule a Demo
Pipeline Analytics

Weighted Pipeline: How to Calculate It, and Why It Still Understates Your Risk

Pete Furseth 6 min read
weighted pipelinepipeline coveragesales forecastingRevOpspipeline analytics
Weighted Pipeline: How to Calculate It, and Why It Still Understates Your Risk
Home/ Blog/ Weighted Pipeline: How to Calculate It, and Why It Still Understates Your Risk

What Is Weighted Pipeline?

Weighted pipeline is the sum of every open deal's value multiplied by the probability assigned to its current stage. Instead of counting all open opportunities at full value, you discount each one by how likely it is to close from where it sits today. A $100,000 deal in an early stage rated at 20% contributes $20,000. The same deal in a late stage rated at 80% contributes $80,000. Add those weighted amounts across the pipeline and you get a single number that is supposed to approximate the revenue you will book.

Weighted pipeline is a real step up from the cruder number most teams start with. It is also where a lot of them stop, and that is the problem. Weighted pipeline is a better input than raw coverage. It is still not a forecast.

Put this to work on your numbers
Run your own numbers with the free Forecast Accuracy Scorecard, then see how ORM builds it into a custom model.

How Do You Calculate Weighted Pipeline?

Multiply each open opportunity's CRM value by the probability tied to its stage, then sum the results across every open deal. The stage probabilities usually live in your CRM as a fixed percentage per stage, set once and rarely revisited. Here is the arithmetic on three illustrative deals.

DealCRM valueStage probabilityWeighted value
Deal A (Discovery)$100,00020%$20,000
Deal B (Proposal)$100,00050%$50,000
Deal C (Commit)$100,00080%$80,000
Total$300,000$150,000
The full pipeline is worth $300,000 at face value. Weighted, it is worth $150,000. That $150,000 is the number a lot of teams carry into the forecast meeting. The method is sound as far as it goes. The trouble is what it quietly assumes.

Why Is Weighted Pipeline Better Than Raw Pipeline Coverage?

Weighted pipeline is better than raw coverage because it accounts for stage, and raw coverage accounts for nothing. Pipeline coverage is total open pipeline divided by the goal, the familiar 3x to 5x rule. Across our customers the standard sits around 3.5x, with a range from about 1.4x to 5x. The ratio feels like control. It is not.

Coverage treats a dollar in discovery the same as a dollar in commit, and it says nothing about timing. On the first day of a quarter, only about 20% of the pipeline dated to close that quarter actually closes in it. Roughly 80% of the in-quarter value does not land in the quarter. A team can hold 4x coverage and still miss badly, which is why the 3x pipeline coverage rule hides the composition of the quarter. Weighting by stage at least admits that a late deal and an early deal are not worth the same. That is the improvement, and it is a narrow one.

Where Does Stage-Weighted Pipeline Still Break?

Stage-weighted pipeline breaks because it assumes two things that are usually false: that the stage probability is right, and that the CRM deal value is right. Both inputs come from the same CRM that sellers manage under quota pressure, and both drift from reality in predictable directions.

Start with the deal value. Pipeline routinely carries an average deal size well above what actually closes. I see pipelines with an $80,000 average deal size while closed-won deals average $40,000. Deals close for less than the CRM says, so every weighted amount built on the CRM value is inflated before you apply a single probability. The $150,000 in the example above is optimistic even if every probability is perfect.

Now the stage probability. A fixed percentage per stage is a static number attached to a moving deal. It does not know that the close rate shifts when a competitor enters and pressures pricing, or when a rep pushes the close date for the third time. The single best signal that a deal is slipping is a rep moving the close date, and a static stage weight cannot see that at all. More than 10% of pipeline in a typical account is stale, untouched for twelve months, and it still sits there carrying its old stage probability as if nothing has changed. Weighted pipeline counts that ghost at full weight, so deal slippage and aged opportunities are exactly what the method is blind to.

Stage-weighted pipeline understates risk twice. The value is too high, and the probability is too confident about deals that have stopped moving.

Is Weighted Pipeline the Same as a Forecast?

No. Weighted pipeline is an input to a forecast, and treating it as the forecast is the most expensive mistake I see. A sales forecast has to explain how the quarter will happen, and the visible pipeline is only one of its sources. The revenue you book this quarter comes from three places: carry-over deals already in the pipeline on day one that close this quarter, in-quarter deals that do not exist yet but get created and closed inside the period, and pull-forward deals dragged in early from future quarters, often with a discount. Weighted pipeline only touches the first of those, and it overstates even that, because only about 20% of the in-quarter pipeline closes in the quarter it is dated for. A weighted sum tells you something about the deals you can see. It says nothing about the revenue motion you cannot see yet, which is where a large share of the quarter actually comes from.

Raw Coverage vs Weighted Pipeline vs Grouped Close Curves: What Breaks Where?

Each method makes a different assumption, and each one fails in a different place. The table lays out where.

ApproachWhat it assumesWhere it breaks
Raw pipeline coverage (the 3x to 5x rule)A fixed multiple of open pipeline converts to the goalOn day one, only about 20% of the in-quarter pipeline closes in the quarter, so roughly 80% of that value is not realized. It ignores stage, age, and deal quality.
Stage-weighted pipelineThe stage probability is correct and the CRM deal value is correctPipeline can average $80,000 per deal while closed-won averages $40,000. A static stage percentage ignores stale deals and slipping close dates.
ORM grouped close curvesSimilar opportunities close on similar timing, learned from your own historyNeeds 4 to 6 weeks to train on your historical performance and a meaningful-activity signal (a change in stage, close date, or amount) to keep each curve current.

How Does ORM Model Pipeline Instead?

At ORM we replace the fixed stage percentage with a close curve learned per group of deals. Instead of tagging every opportunity in Proposal with the same 50%, a machine learning model groups each opportunity with similar deals and predicts a curve for how long that group takes to close. The curves run from 1 to 80 weeks, with most of the expectation landing before week 12 and very few groups extending past 52 weeks. A deal is not worth a flat percentage. It is worth a probability that changes with each week it stays open.

That design fixes what weighted pipeline misses. Timing is built in, because the curve describes when a group closes, not only whether. Staleness is penalized, because we treat meaningful activity as a change in stage, close date, or amount, and a deal with none of those signals decays instead of holding its weight. The model trains on your own historical performance in 4 to 6 weeks, so the probabilities reflect how your deals behave rather than a percentage someone typed into the CRM years ago.

None of this makes coverage or weighted pipeline worthless. Both are useful inputs. The mistake is treating either one as the conclusion. Pipeline coverage is not the forecast, and neither is a weighted sum built on CRM values that close low and stage weights that never move. The forecast is a claim about how the quarter will actually happen, and you reach it by modeling the timing and the real close value of every deal, not the version of it that lives in the pipeline report. That is the number worth building your quarter on.

Frequently Asked Questions

What is weighted pipeline?

Weighted pipeline is the sum of every open deal's value multiplied by the probability assigned to its current sales stage. A $100,000 opportunity in a stage rated at 20% counts as $20,000 of weighted pipeline. It discounts open opportunities by how likely they are to close, which makes it a better input than raw pipeline coverage.

How do you calculate weighted pipeline?

Multiply each open opportunity's CRM value by the probability tied to its stage, then add the weighted amounts across every open deal. Most CRMs store a fixed probability per stage, so the math is quick. The output approximates bookings, but only if the stage probabilities and the deal values are accurate.

Is weighted pipeline the same as a sales forecast?

No. Weighted pipeline is an input to a forecast, not the forecast itself. On the first day of a quarter, only about 20% of the pipeline dated to close that quarter actually closes in it, so roughly 80% of the in-quarter value is not realized in the quarter. A forecast also has to account for deals that will be created and closed inside the quarter, which weighted pipeline never sees.

Why does weighted pipeline understate risk?

It assumes the CRM deal value and the stage probability are both correct, and they usually are not. Pipeline commonly carries an average deal size of $80,000 while closed-won deals average $40,000, so deals routinely close for less than the CRM says. Static stage percentages also ignore stale opportunities and slipping close dates, so the weighted number stays confident about deals that have stopped moving.

What is a standard pipeline coverage ratio?

The standard is 3x to 5x pipeline to goal. Across our customers most run around 3.5x, with a range from about 1.4x to 5x. Coverage is a useful input, but the ratio alone does not predict attainment, because it says nothing about stage, deal quality, or close timing.

How is ORM's approach different from weighted pipeline?

Instead of a fixed percentage per stage, ORM groups each opportunity with a machine learning model and predicts a close curve for that group. The curves run from 1 to 80 weeks, with most of the expectation before week 12. The model trains on your historical performance in 4 to 6 weeks and treats a change in stage, close date, or amount as meaningful activity, so a deal that stops moving decays instead of holding its weight.

PF
Pete Furseth
ORM Technologies
Pete has built custom revenue forecast models for B2B SaaS companies for over a decade.

See how ORM turns these insights into action

ORM builds custom revenue forecast models for B2B SaaS companies. Not dashboards. Prescriptive analytics that tell you what to do next.

Schedule a Demo