Marketing Funnel Calculator | Conversion Rates, CPL by Stage & Revenue Projection
Map your complete marketing funnel from website visitors through leads, MQLs, SQLs, opportunities, and closed-won revenue. Calculate cost per lead at each stage, identify the highest-impact conversion leaks, and model the revenue impact of improving any stage.
Global Settings
Funnel Stages
Funnel Visualization
Stage-by-Stage Metrics
Worst leverage point: Leads (15.00% conversion — improve this first)
| Stage | Count | Stage Conv. | Cum. Spend | Cost Per | Monthly Spend |
|---|---|---|---|---|---|
| Visitors | 10,000 | — | $5,000 | $1 | $5,000 |
| Leads ⚠ | 1,500 | 15.00% | $7,000 | $5 | $2,000 |
| MQLs | 400 | 26.67% | $8,500 | $21 | $1,500 |
| SQLs | 120 | 30.00% | $9,500 | $79 | $1,000 |
| Opportunities | 50 | 41.67% | $10,000 | $200 | $500 |
| Customers | 15 | 30.00% | $10,300 | $687 | $300 |
What-If Optimizer: +5% Improvement Per Stage
Revenue impact if you improve each stage's conversion rate by 5 percentage points
What Is the Marketing Funnel Calculator | Conversion Rates, CPL by Stage & Revenue Projection?
A marketing funnel models how prospects move from first awareness through to paying customers. Each stage transition has a conversion rate — the fraction of people from the prior stage who advance. By quantifying these rates, marketers can identify where the most volume is lost and focus optimization effort where it has the highest leverage. The 6-stage model (Visitors → Leads → MQLs → SQLs → Opportunities → Customers) maps the full B2B revenue journey from anonymous traffic to closed revenue.
Formula
How to Use
- 1
Enter stage counts from your CRM: total visitors from analytics, leads from your form submissions, MQLs from lead scoring, SQLs from sales-accepted leads, opportunities from active deals, and customers from closed-won.
- 2
Enter monthly spend per stage: ad budget goes against Visitors, content/nurture costs go against Leads, SDR costs against MQLs, AE time against SQLs/Opportunities.
- 3
Set average deal value — for SaaS this is typically Annual Contract Value (ACV). For e-commerce, use average order value.
- 4
Set sales cycle length. A 3-month cycle means your pipeline today converts to revenue in 3 months — important for forecasting.
- 5
Look at the funnel visualization. The narrowest stages (biggest absolute drop in bar width) represent the largest volume losses.
- 6
The highlighted red stage is the worst conversion bottleneck. Focus here first — a 5% improvement at the weakest point yields more revenue than the same improvement at a strong stage.
- 7
Use the What-If table to quantify the revenue impact of improving each stage by 5 percentage points.
- 8
Rerun the model monthly as you test conversion improvements to track funnel health over time.
- Enter actual counts for each funnel stage using your CRM and analytics data.
- Enter the monthly spend at each stage — include ad spend, tool costs, and headcount costs for that function.
- Set your average deal value (ACV for annual contracts, or MRR for subscriptions).
- Set the sales cycle length in months — used for pipeline velocity calculations.
- Review the funnel visualization: stages highlighted in red have the lowest conversion rates and need the most attention.
- Check the Stage Metrics table for cost-per-stage to understand where acquisition costs concentrate.
- Use the What-If Optimizer to see which stage improvement generates the most incremental monthly revenue.
Example Calculation
A B2B SaaS company with 10,000 monthly visitors converts at these rates: Visitors→Leads 15% (1,500 leads), Leads→MQLs 27% (400 MQLs), MQLs→SQLs 30% (120 SQLs), SQLs→Opportunities 42% (50 opps), Opportunities→Customers 30% (15 customers). With a $5,000 ACV, monthly revenue is $75,000 ($900K ARR). The SQL→Opportunity stage at 42% is above average, but MQL→SQL at 30% is the bottleneck — improving it to 35% would cascade to ~17.5 customers/month, adding $12,500 MRR. The What-If optimizer calculates this automatically.
Understanding Marketing Funnel | Conversion Rates, CPL by Stage & Revenue Projection
Industry Funnel Conversion Benchmarks
| Stage | B2B SaaS | B2B Services | E-Commerce | Enterprise |
|---|---|---|---|---|
| Visitor → Lead | 2–5% | 1–3% | 2–4% | 0.5–2% |
| Lead → MQL | 20–35% | 15–30% | N/A | 10–25% |
| MQL → SQL | 25–40% | 30–50% | N/A | 20–35% |
| SQL → Opportunity | 40–60% | 45–65% | N/A | 30–55% |
| Opportunity → Customer | 25–45% | 30–55% | 1–5% | 15–30% |
| Overall (Visitor → Customer) | 0.1–0.5% | 0.1–0.3% | 1–3% | 0.05–0.2% |
Funnel Optimization Strategies by Stage
| Stage | Common Leaks | Optimization Tactics | Key Metric |
|---|---|---|---|
| Visitors → Leads | Poor targeting, weak CTA, slow page speed | SEO, landing page A/B tests, exit intent offers | Lead conversion rate % |
| Leads → MQLs | Low-quality traffic, weak nurture sequences | Lead scoring, intent signals, segmented email nurture | MQL rate % |
| MQLs → SQLs | Poor sales-marketing alignment, slow response time | SLA agreements, lead routing automation, SDR training | SQL acceptance rate % |
| SQLs → Opportunities | Weak discovery calls, poor qualification | BANT/MEDDIC training, demo quality, discovery scripts | Opp creation rate % |
| Opps → Customers | Long cycles, multi-stakeholder complexity, competition | ROI calculators, executive sponsors, competitive battlecards | Win rate % |
Funnel Velocity and Pipeline Forecasting
Funnel velocity combines conversion rates with deal value and cycle time: Velocity = (Opportunities × Win Rate × ACV) ÷ Sales Cycle Length. A company with 50 opportunities per month, 30% win rate, $60,000 ACV, and 3-month cycle has monthly revenue velocity of $300,000. Improving any one variable by 10% improves revenue by 10%. But improving two variables — say win rate from 30% to 33% and ACV from $60K to $66K — compounds to a 21% revenue increase. This multiplicative nature of funnel optimization is why small, consistent improvements across stages compound into large revenue gains.
Frequently Asked Questions
What is a good visitor-to-customer conversion rate?
For B2B SaaS, 0.1–0.3% overall visitor-to-customer is typical. Enterprise-focused companies with high ACV often run lower volume but higher rates at later stages. E-commerce typically sees 1–3%. The more important metric is the conversion rate at each individual stage transition.
What is the difference between MQL and SQL?
A Marketing Qualified Lead (MQL) meets demographic and behavioral criteria suggesting sales-readiness — job title, company size, and engagement signals like downloading a white paper or attending a webinar. A Sales Qualified Lead (SQL) has been reviewed and accepted by a sales rep who confirms the prospect has budget, authority, need, and timeline (BANT). The MQL→SQL handoff is often where the most friction occurs in B2B funnels.
How do I calculate cost per acquisition (CAC)?
Total CAC = Total Sales & Marketing Spend ÷ New Customers. But the funnel model lets you compute cost-per-stage: Cost per Lead = all marketing spend ÷ total leads; Cost per MQL = all marketing spend ÷ MQLs; Cost per Customer = total S&M spend ÷ customers. Comparing these to LTV (Customer Lifetime Value) tells you whether your funnel is economically viable. A healthy SaaS company aims for LTV:CAC ≥ 3.
What does the What-If optimizer show?
The What-If optimizer calculates the incremental monthly revenue you would generate if one specific stage conversion rate improved by 5 percentage points. It works by multiplying the improved stage count through all downstream stages at their current conversion ratios, then computing the resulting increase in customers and therefore revenue. This identifies which funnel lever has the most revenue impact.
How often should I update funnel data?
Monthly is the minimum cadence for SaaS funnels. High-volume funnels (e-commerce, PLG) benefit from weekly updates. The most valuable analysis is tracking conversion rate trends over time — a declining Visitor→Lead rate might indicate worsening ad targeting, while improving SQL→Opportunity rates could signal better sales qualification training.
You Might Also Like
Explore 360+ Free Calculators
From math and science to finance and everyday life — all free, no account needed.