Prospect Pipeline Conversion & Leak Analyzer
Analyze sales pipeline conversion rates, identify biggest leaks, and calculate revenue impact of stage optimization
Worked Examples
Example 1: B2B SaaS Pipeline Leak Analysis
Problem: 1,000 leads/month, 30% become MQL, 50% MQL→SQL, 60% SQL→Opportunity, 25% Opportunity→Closed Won. $50K avg deal. Identify biggest leak and improvement opportunity.
Solution: Current Funnel:\n- Leads: 1,000\n- MQLs: 1,000 × 30% = 300\n- SQLs: 300 × 50% = 150\n- Opportunities: 150 × 60% = 90\n- Closed Won: 90 × 25% = 22.5 deals\n\nOverall Conversion: 22.5 / 1,000 = 2.25%\n\nLeak Analysis:\n- Lead → MQL: 700 lost (70%)\n- MQL → SQL: 150 lost (50%)\n- SQL → Opp: 60 lost (40%)\n- Opp → Won: 67.5 lost (75%) ← Biggest leak\n\nRevenue:\n- Deals: 22.5/month\n- Deal size: $50K\n- Monthly revenue: $1.125M\n- Annual: $13.5M\n\nImprovement Scenarios:\n\nOption 1: Improve Opp → Won (25% → 35%)\n- Closed Won: 90 × 35% = 31.5 deals (+9)\n- Additional revenue: 9 × $50K = $450K/month\n- Annual impact: $5.4M (+40%)\n\nOption 2: Improve Lead → MQL (30% → 40%)\n- MQLs: 400 (instead of 300)\n- Cascades: 400 × 50% × 60% × 25% = 30 deals (+7.5)\n- Additional revenue: $375K/month\n- A
Result: 2.25% overall conversion | Biggest leak: Opp→Won (75% lost) | Improve close rate 25%→35% = $5.4M annual gain
Frequently Asked Questions
What is a sales pipeline funnel?
Pipeline funnel tracks prospects from initial contact to closed deal through stages: Leads (suspects) → MQLs (marketing qualified) → SQLs (sales qualified) → Opportunities (in negotiation) → Closed Won (customer). Each stage has conversion rate (% advancing to next). Multiplication reveals overall conversion: 30% × 50% × 60% × 25% = 2.25% lead-to-customer. Typical B2B funnel has 1-5% overall conversion depending on industry, price point, and sales complexity.
What is pipeline conversion leak?
Leak is dropoff between stages. Example: 1,000 leads → 300 MQLs (70% leak). Analyzing leaks identifies bottlenecks: (1) Lead → MQL leak (poor lead quality or qualification criteria), (2) MQL → SQL (interest but not ready to buy), (3) SQL → Opportunity (can't find budget or decision-maker), (4) Opportunity → Closed Won (lose to competition, pricing, or no-decision). Fix biggest leak first for maximum impact.
How do I improve MQL to SQL conversion?
MQL → SQL conversion issues: (1) MQLs aren't actually qualified (scoring too lenient), (2) No nurturing (passing cold MQLs to sales), (3) Timing mismatch (MQL now, ready to buy in 6 months). Fixes: Tighten MQL criteria (raise score threshold), nurture campaigns (email drips, retargeting), sales enablement (better discovery calls to assess readiness), feedback loop (sales tells marketing what good MQLs look like). Target: 40-60% MQL→SQL for B2B.
How do I calculate sales pipeline coverage?
Pipeline coverage = Pipeline value / Quota. Example: $10M quota, 25% win rate. Need $40M pipeline ($10M / 0.25) to hit quota. If current pipeline is $30M, coverage is 0.75× (25% short). Healthy coverage: 3-4× quota (accounts for losses and slippage). Too low (<2×): Will miss quota. Too high (>5×): Reps cherry-picking or poor qualification. Balance quality (realistic opportunities) with quantity (enough to hit target).
What is pipeline velocity?
Pipeline velocity = (# Opportunities × Avg Deal Size × Win Rate) / Avg Sales Cycle Days. Measures revenue flow rate. Example: 20 opportunities, $50K avg, 25% win rate, 90-day cycle. Velocity = (20 × $50K × 0.25) / 90 = $2,778/day = $83K/month. Improve by: (1) More opportunities (+volume), (2) Higher deal size (+value), (3) Better win rate (+efficiency), (4) Faster cycle (-time). Increasing any factor increases revenue throughput.
How do I prevent pipeline decay?
Pipeline decay = opportunities aging without progressing (stale pipeline). Causes: No next steps, champion left, budget frozen, competitor chosen but not formalized. Prevention: (1) Activity requirements (must have call/meeting every 14 days or disqualify), (2) Close date discipline (if pushed >2×, mark lost), (3) Quarterly pipeline review (purge stale opps), (4) Re-engagement campaigns (dormant opps get outreach; unresponsive = disqualified). Healthy pipeline: <20% opportunities older than avg cycle time.