Weighted Pipeline = Sum of (Opportunity Value × Stage Win Probability)
Weighted pipeline converts raw pipeline into an expected-value figure by discounting each deal according to how likely it is to close from its current stage. A pipeline of $5 million that is mostly early-stage discovery is not the same coverage as $5 million concentrated in late-stage deals. Weighting separates those two situations.The formula applied to each opportunity:
> Weighted Value = Opportunity Amount × Stage Win Probability
Sum across all open opportunities to get total weighted pipeline.
Static Weights vs. AI-Derived Weights
| Approach | How It Works | Tradeoffs |
|---|---|---|
| Static stage weights | Fixed percentages assigned by stage, reviewed quarterly | Simple to explain, easy to audit, slow to adapt |
| Rep-adjusted weights | Managers override probabilities deal-by-deal | Adds judgment but introduces bias and inconsistency |
| Historical cohort weights | Probabilities derived from your own close-rate data by stage | More accurate than guesses, requires clean CRM history |
| AI-derived weights | Model scores each deal on engagement, activity, and firmographic signals | Most accurate on sufficient data, hardest to explain to reps |
Why Coverage Calculations Should Use Weighted Pipeline
Pipeline coverage is typically expressed as pipeline divided by quota. Using total (unweighted) pipeline in the numerator inflates coverage and creates false confidence. A team with $10 million in pipeline against a $3 million quota looks like it has more than 3x coverage, but if most of that pipeline is in the first two stages, weighted pipeline might only be $2 million, signaling a coverage problem rather than safety.
Using weighted pipeline as the denominator in your coverage ratio ties the calculation to expected revenue, not nominal deal value.
Building and Maintaining the Weights
Win probabilities should be reviewed at least quarterly by pulling historical stage-to-close rates from your CRM. Segment by deal size band, sales motion, and segment if you have enough volume. Weights that were accurate when the company sold primarily to mid-market SMBs will mislead you after moving upmarket into enterprise deals with longer cycles and more buying committee complexity.
For more on how weighted pipeline feeds coverage analysis, see Weighted Pipeline and Weighted Pipeline Coverage.
Frequently Asked Questions
What is the weighted pipeline formula?
Weighted Pipeline = Sum of (Opportunity Value × Stage Win Probability) across all open opportunities. If you have a $200,000 deal at 50% probability and a $100,000 deal at 25% probability, your weighted pipeline is $125,000.
What win probabilities should I assign to each stage?
Static probabilities are typically set by analyzing historical close rates at each stage. A common starting point is 10% at discovery, 25% at demo, 50% at proposal, 75% at negotiation, and 90% at verbal commit, but these should be calibrated to your actual data, not borrowed from a template.
When should I use weighted pipeline instead of total pipeline in coverage calculations?
Almost always. Total pipeline overstates expected revenue because it treats a deal at discovery the same as a deal in negotiation. Weighted pipeline gives you a realistic view of what the pipeline is actually worth, which produces a more accurate coverage ratio against quota.
Put these metrics to work
ORM builds custom revenue forecast models that turn concepts like weighted pipeline formula into prescriptive action for your team.
Schedule a Demo