A weighted pipeline is a forecasting method that multiplies each deal's value by its probability of closing based on its current stage. Instead of saying "we have INR 5 crore in pipeline," a weighted pipeline says "we expect to close INR 1.2 crore based on stage-adjusted probabilities." This gives sales leaders a realistic revenue expectation rather than an aspirational one.
The formula for each deal is: Weighted Value = Deal Value x Stage Probability. The total weighted pipeline is the sum of all weighted values. For Indian B2B sales teams, weighted pipeline is the foundation of accurate forecasting and resource planning.
How Weighted Pipeline Works
Each pipeline stage carries a probability reflecting historical close rates at that stage.
| Pipeline Stage | Typical Probability | Example Deal (INR 50L) | Weighted Value |
|---|---|---|---|
| Qualification | 10% | 50,00,000 | 5,00,000 |
| Discovery | 20% | 50,00,000 | 10,00,000 |
| Proposal | 40% | 50,00,000 | 20,00,000 |
| Negotiation | 60% | 50,00,000 | 30,00,000 |
| Verbal Commit | 80% | 50,00,000 | 40,00,000 |
| Closed Won | 100% | 50,00,000 | 50,00,000 |
Why Raw Pipeline Value Is Misleading
A team with INR 10 crore in raw pipeline might feel confident about hitting a INR 2 crore quarterly target. But if 60% of that pipeline is in qualification stage at 10% probability, the weighted value is only INR 1.6 crore, and they are likely to miss.
Consider two teams: - Team A: INR 10 crore raw pipeline, 70% in early stages. Weighted: INR 1.8 crore - Team B: INR 6 crore raw pipeline, 50% in late stages. Weighted: INR 2.4 crore
Team B has less total pipeline but a stronger weighted position. Raw pipeline obscures this difference. Weighted pipeline reveals it.
Setting the Right Stage Probabilities
The biggest mistake in weighted pipeline is using default probabilities instead of your actual historical close rates.
How to Calculate Your Stage Probabilities
- Export all deals closed in the last 12 months (both won and lost)
- For each stage, calculate: (Deals that eventually closed-won from this stage) / (Total deals that reached this stage)
- This gives you your actual conversion rate per stage
For example, if 100 deals reached your Proposal stage in the last year and 35 eventually closed-won, your Proposal stage probability is 35%, not the 40% default.
Indian B2B benchmarks for stage probabilities tend to be 5-10% lower than global averages in early stages due to longer evaluation cycles and broader exploratory behaviour from buyers.
| Stage | Global Average | Indian B2B Average |
|---|---|---|
| Qualification | 10-15% | 8-12% |
| Discovery | 20-25% | 15-20% |
| Proposal | 35-45% | 30-40% |
| Negotiation | 55-65% | 50-60% |
| Verbal Commit | 75-85% | 70-80% |
Beyond Stage-Based Weighting
Stage-based weighting is a good starting point, but it treats all deals in the same stage equally. Advanced weighting incorporates additional factors.
Multi-Factor Weighted Pipeline
Adjust the probability based on deal characteristics:
- Multi-threaded deals (3+ contacts): Add 10-15% to probability
- Single-threaded deals (1 contact): Subtract 10-15%
- Stale deals (no activity 10+ days): Subtract 15-20%
- Competitor present: Subtract 10%
- Executive engagement: Add 10%
Mevak calculates multi-factor weighted pipeline automatically by combining stage probabilities with engagement signals, conversation intelligence, and deal health indicators. This produces a more nuanced and accurate forecast than stage-only weighting.
Using Weighted Pipeline for Planning
Weighted pipeline serves three planning functions:
Coverage Ratio
Pipeline coverage ratio = Weighted Pipeline / Revenue Target. A healthy ratio is 1.5-2x for weighted pipeline (compared to 3-4x for raw pipeline). If your coverage is below 1.2x, you need more pipeline or faster deal progression.
Gap Analysis
Compare weighted pipeline to target by expected close date: - This month: Weighted pipeline should be 1.2x target minimum - Next month: 1.5x target (accounting for slippage) - Two months out: 2x target (accounting for more uncertainty)
Resource Allocation
Higher-weighted deals deserve more resources. A INR 50 lakh deal at 60% probability (weighted INR 30 lakh) should get more attention than a INR 80 lakh deal at 10% probability (weighted INR 8 lakh), even though the raw value is lower.
Common Weighted Pipeline Mistakes
- Using industry-default probabilities - Calculate from your own data. Defaults are always wrong for your specific business.
- Not recalibrating quarterly - Close rates change. Recalculate probabilities every quarter.
- Ignoring deal age - A deal in Proposal stage for 60 days should not have the same probability as one that reached Proposal yesterday. Factor in time decay.
- Weighting by rep confidence - Some CRMs let reps override stage probability with personal confidence. This reintroduces subjectivity and defeats the purpose.
Quick Reference
Weighted pipeline replaces the false precision of total pipeline value with a realistic revenue expectation. Calculate it from your historical stage conversion rates, adjust for deal-specific factors, and use it for coverage planning and resource allocation. A well-calibrated weighted pipeline should predict actual close revenue within 15-20% variance month over month.