What Is Factored Pipeline? Formula, Example, and How to Use It
Factored pipeline (also called weighted pipeline) is the total value of your open deals after each one is multiplied by its probability of closing. Instead of treating a $100K deal in discovery the same as a $100K deal in contract review, factored pipeline counts the first at maybe $10K and the second at $80K. The result is a more realistic estimate of the revenue your pipeline is likely to produce.
The factored pipeline formula
Factored pipeline = Σ (Deal amount × Close probability)
Add up every open opportunity's amount multiplied by its probability. The probability usually comes from the deal's stage, though more mature teams adjust it using deal age, source, or rep-level history.
A worked example
Say your team has five open deals this quarter:
| Deal | Stage | Amount | Stage probability | Factored value |
|---|---|---|---|---|
| Acme | Discovery | $60,000 | 10% | $6,000 |
| Northwind | Demo completed | $40,000 | 25% | $10,000 |
| Globex | Proposal sent | $80,000 | 50% | $40,000 |
| Initech | Negotiation | $50,000 | 70% | $35,000 |
| Umbrella | Contract out | $30,000 | 90% | $27,000 |
| Total | $260,000 | $118,000 |
Your raw pipeline is $260,000. Your factored pipeline is $118,000. If your quota is $150,000, the factored number tells you something the raw number hides: you're about $32,000 short unless you create or accelerate more deals.
Factored pipeline vs. other forecast views
| View | What it counts | Best for |
|---|---|---|
| Raw (total) pipeline | Every open deal at full value | Measuring pipeline generation and coverage |
| Factored / weighted pipeline | Each deal × its close probability | Projecting likely revenue across many deals |
| Commit | Only deals reps are confident will close this period | Short-term, call-the-number forecasting |
| Best case | Commit plus deals that could realistically close | Upside planning |
Factored pipeline is most reliable when you have many deals of similar size. Probabilities average out across volume. With a handful of large deals, a single win or loss swings the outcome far more than the weighted number suggests, so pair it with a rep-level commit forecast.
How to set stage probabilities (without guessing)
Most CRMs ship with default probabilities (10%, 20%, 50%…). Those defaults aren't based on your data. Replace them with historical conversion rates:
- Pull all opportunities closed (won or lost) in the last 2-4 quarters.
- For each stage, count how many deals that reached the stage eventually closed-won.
- Divide closed-won by total deals that reached that stage. That's your stage probability.
- Revisit quarterly, and segment if your motions differ (e.g., SMB vs. mid-market, inbound vs. outbound).
Example: 200 deals reached "Proposal sent" last year and 84 closed-won, so your proposal-stage probability is 42%, not the default 50%.
How to see factored pipeline in your CRM
Salesforce: Each opportunity stage maps to a default Probability (%), and the standard Expected Revenue field calculates Amount × Probability. Update stage probabilities in Setup under the Opportunity Stage picklist, then build a report summing Expected Revenue by close date or owner.
HubSpot: Each deal stage has a deal probability set in your pipeline settings. HubSpot calculates a weighted amount for each deal, which you can sum in reports and the forecast tool.
In both, the factored number is only as good as two things: accurate stage probabilities and clean stage hygiene (deals actually sitting in the stage they're in, with realistic close dates).
Common mistakes
- Using default probabilities forever. They rarely match your real conversion rates.
- Stale deals inflating the number. A deal stuck in "Negotiation" for 120 days isn't 70% likely to close. Add aging rules or auto-flag deals past your average sales cycle.
- Ignoring close dates. Factored pipeline for this quarter should only include deals with close dates in this quarter.
- Treating it as the forecast. It's an input. Combine it with commit calls and historical run-rate for the number you report.
Want a forecast you actually trust? Pilot Revenue builds revenue intelligence and forecasting systems on top of your CRM, with clean stage definitions, data-driven probabilities and live dashboards. See our forecasting service →
FAQ
Is factored pipeline the same as weighted pipeline?
Yes. The terms are used interchangeably. Both multiply each deal's value by its probability of closing.
What's a good pipeline coverage ratio?
Many B2B SaaS teams aim for 3-4× raw pipeline coverage against quota. Factored pipeline coverage of 1-1.3× quota usually signals a healthy quarter, but your benchmark depends on your historical win rates.
How often should stage probabilities be updated?
Quarterly is a good default, or any time you change your sales process, stages, or target segment.
Can AI improve factored pipeline accuracy?
Yes. Instead of one probability per stage, a model can score each deal using activity, engagement, deal age, and historical patterns, then roll those scores up into a deal-level weighted forecast.