Pipeline Conversion Rate Calculator

• Stage conversion rate (%): (Downstage ÷ Upstage) × 100
• Overall lead→won (%): (Closed Won ÷ Leads) × 100
• Win rate (%): (Closed Won ÷ Opportunities) × 100
• Value conversion (%): (Won Revenue ÷ Pipeline Value) × 100
• Expected wins: Opportunities × (Win Rate ÷ 100)

These metrics help you find “leaks” (big drops) and “friction” (low stage rates), so you can prioritize fixes that lift revenue predictability.

1. Pick a single reporting window (week, month, or quarter).
2. Enter counts for each stage using your standard definitions.
3. Enter pipeline value and won revenue for the same window.
4. Click Calculate to view results above the form.
5. Download CSV or PDF to share the snapshot with stakeholders.
6. Improve the weakest stage first, then re‑measure next cycle.

Pipeline conversion benchmarks by stage

Evaluate conversion stage by stage. In the example, Lead→MQL is 35%, MQL→SQL is 50%, SQL→Opportunity is 50%, Opportunity→Proposal is 57.14%, and Proposal→Won is 30%. Track each rate by period and compare to your recent baseline, because seasonality can shift performance. Also monitor overall Lead→Won: 18 wins from 1,200 leads equals 1.50%. Set a target (for example 2.00%) to guide focus and report progress. Use the same definitions across every team quarterly.

Finding leaks with volume drops

Stage counts show where prospects fall out. A big drop, such as 1,200 leads down to 420 MQLs, can signal lead quality, scoring rules, list hygiene, or slow response. Low rates with smaller drops suggest friction, like unclear qualification or weak handoffs. Use the “largest volume drop” output to pick the stage with the biggest recoverable volume. Align definitions if counts increase downstream. Track this alongside response time and touch counts to connect process to outcomes.

Connecting pipeline value to revenue outcomes

Pair counts with money metrics to strengthen forecasts. Value conversion is Won Revenue ÷ Pipeline Value. With $72,000 won from $250,000 pipeline, value conversion is 28.80%. Win rate is Won ÷ Opportunities: 18 wins from 105 opportunities equals 17.14%. Average revenue per won deal is $72,000 ÷ 18 = $4,000. Expected wins uses Opportunities × Win Rate; with 105 opportunities, that is about 18 wins.

Segmenting results for clearer decisions

Averages can hide differences. Recalculate by source, product line, region, or ICP tier. Paid search may deliver stronger Lead→MQL but weaker Proposal→Won, while referrals may show the opposite. Segmenting helps you invest in what improves win rate and revenue per deal, not just volume. Consider separate views for new business vs expansion to avoid mixing motions.

Improvement experiments and reporting cadence

Use the “weakest stage rate” to prioritize work. Common experiments include tighter scoring, faster follow‑up SLAs, better qualification questions, proposal template updates, and rep enablement. Recalculate after each cycle and keep change notes. Confirm that downstream stages and won revenue rise too, so you avoid optimizing a single rate in isolation.

What is the pipeline conversion rate?

It is the percentage of records that move from one stage to the next. This tool also reports overall Lead→Won conversion, showing how efficiently top‑of‑funnel volume becomes closed revenue.

Which stages should I enter?

Use the stages your team consistently tracks for the same period. If your CRM uses different names, map them to Leads, MQLs, SQLs, Opportunities, Proposals, and Closed Won, then keep that mapping stable.

Why is Lead→Won different from win rate?

Lead→Won uses leads as the starting point and reflects the entire funnel. Win rate uses opportunities as the starting point and focuses on late‑stage sales effectiveness. Both are useful for different decisions.

How should I read value conversion?

Value conversion compares won revenue to total pipeline value. A low value conversion can indicate over‑inflated pipeline, heavy discounting, or deals slipping. Compare it over time and by segment to find root causes.

What if my stage counts increase later in the funnel?

That usually means stages are defined differently across systems or time windows. Align the reporting period, deduplicate records, and confirm each record is counted once. After cleanup, stage counts should generally decrease.

How often should I calculate and export reports?

Monthly works for most teams, while high‑volume funnels benefit from weekly checks. Export the report after major process changes, campaigns, or pricing updates so stakeholders can see the impact quickly.