What is weighted pipeline and how do you calculate it?
TL;DR
Weighted pipeline is every open deal's value times its odds of closing: the sum of (deal value × stage probability). It's a fine baseline — if your probabilities come from real win rates and every stage has exit criteria. Skip those and you've built a spreadsheet that lies to you with decimal places.
What weighted pipeline is, why it exists, and what it buys you
Weighted pipeline is one formula: the sum of every open deal's value times its probability of closing — deal value × stage probability, added up. That's the whole thing.
It exists to kill a specific lie. An unweighted pipeline adds every deal at face value, so a lead you got yesterday counts the same as a contract signing tomorrow. That's how a team stares at a $4M pipeline, closes $600k, and calls it a bad quarter instead of bad math.
Done right, weighting gives you a defensible baseline in about an hour, straight from the CRM. Done wrong, it gives you false precision — more dangerous than a guess, because you'll believe it.
The data, explained
The definition isn't controversial; every CRM and glossary agrees on the formula. The argument is about the probabilities. Clari's work on pipeline coverage makes the case that weighted coverage beats raw coverage, because a late-stage deal really is worth more than an early one and your number should say so.
Here's the part teams skip. Default stage probabilities are round numbers someone picked at setup — 20%, 40%, 60%. Your actual win rate by stage, pulled from your own closed deals, is the only input that makes weighting mean anything. Everything else is decoration with a decimal point.
What that produces: a baseline, not a verdict
Treat weighted pipeline as the floor you build on, never the answer you ship. Left alone it misleads in three predictable ways:
- It flattens deals inside a stage. Two deals in "Negotiation" can have very different odds; the formula pretends they don't.
- It's only as honest as your stage hygiene. Garbage stages, garbage weights.
- It assumes the market holds still. When conditions shift, your historical probabilities quietly stop being true.
So triangulate. Weighted pipeline is the math floor, the rep commit is judgment, and a historical sanity check catches when either one is lying. The full playbook covers the judgment pass.
How to model it (and where it breaks)
| Assumption baked in | Why it breaks | What to do |
|---|---|---|
| Every deal in a stage is equal | Odds vary wildly within a stage | Add exit criteria so a stage means one thing |
| Stage probabilities are accurate | Defaults are guesses | Recalculate from your real win rate each quarter |
| The market is stable | Probabilities drift with conditions | Revisit weights after any shift or launch |
Frequently asked questions
What's the weighted pipeline formula?
The sum, across open deals, of each deal's value multiplied by its stage probability of closing.
Is weighted pipeline the same as a forecast?
No. It's one input — a math baseline. A real forecast triangulates it with rep judgment and a historical check.
What probability should each stage get?
Your actual historical win rate from that stage, not the CRM default. Recalculate it on a cadence.
Where we come in
We calibrate weighted pipeline against your real win rates and write the stage exit criteria that make it honest. Book a call →
Related reading
- Clari. “Pipeline Coverage: Best Practices for Sales Leaders.” Clari Blog. clari.com. Accessed July 16, 2026.
