Sales Funnel Calculator — Conversion Rate at Each Stage

Total Leads

All inbound and outbound leads entering the funnel

Marketing Qualified Leads (MQLs)

Leads that meet your marketing qualification criteria

Sales Qualified Leads (SQLs)

Leads accepted by sales as ready for active pursuit

Opportunities Created

SQLs that became active sales opportunities / demos

Closed Won Deals

Opportunities that converted to paying customers

Lead-to-Close Rate

1.5%

15 customers from 1,000 leads

Funnel Stage Conversion Rates

Leads → MQLs30%

1,000 → 300

MQLs → SQLs40%

300 → 120

SQLs → Opportunities41.67%

120 → 50

Opportunities → Closed Won30%

50 → 15

1,000

Leads

100%

120

SQLs

12%

15

Won

How was this calculated?

Lead → MQL

300 MQLs ÷ 1,000 leads = 30%

MQL → SQL

120 SQLs ÷ 300 MQLs = 40%

SQL → Opportunity

50 opps ÷ 120 SQLs = 41.67%

Opportunity → Close

15 won ÷ 50 opps = 30%

Overall Lead-to-Close Rate

15 won ÷ 1,000 leads = 1.5%

What is a Sales Funnel?

A Sales Funnel Calculator computes the conversion rate at each stage of the sales pipeline — from raw leads through marketing qualification (MQL), sales acceptance (SQL), active opportunities, and final close. It answers the most strategically important question in revenue operations: at which stage are we losing the most leads, and by how much?

Every B2B company has a sales funnel, but most track stages in isolation. This calculator shows all stages simultaneously, with the conversion rate at each transition side by side. A 35% Lead→MQL rate, 45% MQL→SQL rate, 50% SQL→Opportunity rate, and 30% Opportunity→Close rate multiplies to a 2.4% overall lead-to-close rate. Each stage's conversion rate is a lever — the biggest multiplier improvement comes from fixing the stage with the lowest conversion rate.

The visual funnel breakdown is the calculator's primary value: it makes the bottleneck immediately visible. A company with a 12% SQL→Opportunity rate while all other stages are above 40% has a clear diagnosis — the sales team is qualifying leads (good SQL rate) but struggling to convert those qualified leads into active deals (bad SQL-to-opp rate). That points to proposal quality, demo effectiveness, or initial discovery call issues as the fix target.

The overall lead-to-close rate is the headline metric — shown prominently as the product of all four stage conversion rates. For Indian B2B SaaS and service companies, this number typically falls between 1–5%, with inbound-sourced leads generally converting 2–3× better than outbound-sourced leads.

For a simpler two-stage version of the same calculation, the Lead-to-Customer Rate Calculator takes just total leads and customers acquired as inputs. For downstream ROI analysis, the CAC Calculator uses similar funnel data to compute customer acquisition cost.

How to use this Sales Funnel calculator

Enter Total Leads — all leads entering the funnel in the measurement period, regardless of source or quality.
Enter MQLs — leads that passed marketing qualification criteria. If you do not have formal MQL tracking, use leads that requested a demo or expressed explicit purchase intent.
Enter SQLs — MQLs that the sales team accepted for active pursuit. If you do not have formal SQL tracking, use leads that completed a discovery call.
Enter Opportunities Created — active deals in the pipeline (post-demo or post-proposal stage, where genuine purchase intent is confirmed).
Enter Closed Won Deals — customers acquired from this lead cohort.
Read your results — Overall Lead-to-Close Rate, and all four stage conversion rates with visual bars for instant bottleneck identification.

Formula & Methodology

Lead→MQL Rate (%) = MQLs ÷ Leads × 100

MQL→SQL Rate (%) = SQLs ÷ MQLs × 100

SQL→Opportunity Rate (%) = Opportunities ÷ SQLs × 100

Opportunity→Close Rate (%) = Closed Won ÷ Opportunities × 100

Overall Lead-to-Close Rate = Lead→MQL × MQL→SQL × SQL→Opp × Opp→Close

Worked example using realistic values:

An Indian B2B SaaS company in a quarter:
- Total Leads: 1,000
- MQLs: 280 (28% Lead→MQL)
- SQLs: 112 (40% MQL→SQL)
- Opportunities: 61 (54% SQL→Opportunity)
- Closed Won: 18 (30% Opportunity→Close)

Overall Lead-to-Close Rate = 18 ÷ 1,000 = 1.8%

Check via stage multiplication: 28% × 40% × 54% × 30% = 1.81% ✓

The Opportunity→Close rate at 30% is the primary bottleneck (all other stages are above 40%) — improving win rate to 40% would increase closed deals from 18 to 24, a 33% revenue increase with the same lead volume.

Assumptions:

- Stage counts should represent the same lead cohort (leads entered in the same period that progressed through each stage). Mixing monthly lead intake with all-time pipeline stages creates misleading rates.
- If you do not track all four stages, use the stages you do track and leave others at 100% (full pass-through). The overall rate will still reflect the stages you can measure.
- Average sales cycle length affects which quarter's closed deals correspond to which quarter's leads — adjust the measurement window to match your typical cycle length.

Frequently Asked Questions

What is a sales funnel calculator?

A sales funnel calculator computes the conversion rate at each stage of your sales process — from leads to marketing qualified leads (MQLs), MQLs to sales qualified leads (SQLs), SQLs to opportunities, and opportunities to closed deals. It identifies where the largest percentage of leads is being lost, so sales and marketing teams can focus improvement efforts on the highest-impact funnel stage. The final output is the overall lead-to-close rate — the percentage of leads that ultimately become customers.

What are MQLs and SQLs in a sales funnel?

MQLs (Marketing Qualified Leads) are leads that marketing has determined meet certain criteria suggesting they are likely to become customers — based on demographic fit, behaviour (content downloads, webinar attendance), or lead scoring. SQLs (Sales Qualified Leads) are MQLs that the sales team has reviewed and accepted as ready for active sales pursuit, typically after a qualification call. The MQL → SQL conversion rate measures how well marketing's lead quality meets sales' acceptance criteria.

What conversion rates should I expect at each funnel stage?

Industry benchmark ranges for B2B SaaS vary, but typical ranges are: Lead → MQL: 20–40% (marketing qualification rate); MQL → SQL: 30–50% (sales acceptance rate); SQL → Opportunity: 30–60% (discovery to active opportunity); Opportunity → Close: 20–40% (win rate). Overall lead-to-close rates for B2B SaaS typically range from 1–5%. Indian B2B companies often have similar funnel rates but longer sales cycles, especially for enterprise deals.

What is overall lead-to-close rate?

Overall lead-to-close rate (also called lead-to-customer rate) is the percentage of all leads that ultimately become paying customers, calculated by dividing closed won deals by total leads. It is the product of all individual stage conversion rates: Lead→MQL × MQL→SQL × SQL→Opp × Opp→Close. An overall rate of 1.5% means 15 out of every 1,000 leads become customers. Use the [Lead-to-Customer Rate Calculator](/lead-to-customer-rate-calculator/) for a simpler two-input version of this calculation.

What is win rate and how is it different from lead-to-close rate?

Win rate is the percentage of opportunities (active sales deals) that close as won deals: Closed Won ÷ Total Opportunities × 100. Lead-to-close rate measures the full funnel from initial lead to customer. Win rate focuses only on the final stage — deals that were already in the pipeline. Win rate of 25% means the sales team wins one in four opportunities it actively works. This is a sales execution metric; lead-to-close rate is an overall marketing + sales funnel health metric.

How do I identify the biggest drop-off in my sales funnel?

The biggest drop-off is the stage with the lowest conversion rate. If your Lead→MQL rate is 35%, MQL→SQL is 40%, SQL→Opportunity is 55%, and Opportunity→Close is 25%, your largest drop-off is Opportunity→Close (win rate). This means the issue is not lead volume or qualification but the sales team's ability to close deals — pointing to pricing, competitive differentiation, or sales negotiation skills as focus areas. This calculator shows all stage rates simultaneously to make the comparison immediate.

What is the difference between inbound and outbound funnel rates?

Inbound leads (from content, SEO, referrals, social media) typically have higher lead-to-MQL conversion rates (35–50%) because they showed active intent. Outbound leads (cold email, cold calls, paid acquisition) typically have lower lead-to-MQL rates (10–25%) because they may not have expressed explicit interest. However, outbound SQLs — once qualified — often have comparable win rates to inbound SQLs. For accurate funnel analysis, track inbound and outbound pipelines separately.

How do I improve MQL-to-SQL conversion rate?

Low MQL-to-SQL conversion means marketing is passing leads that sales does not accept. The root cause is almost always a misaligned definition of 'qualified' between the two teams. Fix it by establishing a shared lead scoring definition — which company size, industry, job title, and behavioural signals constitute an MQL that sales will accept. Hold weekly reviews where sales gives feedback on MQL quality. The standard target is 40–50% MQL-to-SQL rate; anything below 30% indicates systematic misalignment.

Can I use this sales funnel calculator for e-commerce?

Yes, with adapted stage definitions. For e-commerce, a common funnel is: Website Visitors → Product Page Views → Add to Cart → Checkout Started → Purchases. Each transition is a conversion rate. You would enter visitors as 'Leads', product page viewers as 'MQLs', add-to-carts as 'SQLs', checkouts started as 'Opportunities', and purchases as 'Closed Won'. The overall lead-to-close rate becomes your site-wide conversion rate from visitor to buyer. Use the [Conversion Rate Calculator](/conversion-rate-calculator/) for a simpler two-stage e-commerce conversion analysis.

What is a healthy lead-to-close rate for Indian B2B SaaS?

Indian B2B SaaS companies targeting SME markets typically see lead-to-close rates of 2–5% for inbound-led models with shorter sales cycles (self-serve or inside sales), and 1–3% for outbound-heavy models. Enterprise-focused Indian SaaS with longer deal cycles (3–12 months) commonly see 0.5–2% lead-to-close rates, with higher average contract values compensating for lower conversion rates. These benchmarks are broadly similar to global SaaS benchmarks, as the fundamentals of B2B buying behaviour are similar across markets.

How do I use the sales funnel calculator for revenue forecasting?

Revenue forecasting from funnel data: if you know your lead volume, stage conversion rates, average deal value, and average sales cycle length, you can project future closed revenue. If you add 1,000 leads this month, with 35% MQL rate, 45% SQL rate, 50% opportunity rate, and 30% win rate, you can expect approximately 24 closed deals (1,000 × 35% × 45% × 50% × 30%). At an average deal value of ₹2 lakh, that is ₹48 lakh in expected revenue from this month's leads — typically closing 2–4 months out depending on sales cycle length.

What is the ideal ratio of leads to closed deals?

There is no universal ideal — it depends entirely on lead quality, product price, and go-to-market strategy. High-volume, low-touch SaaS with a self-serve motion may accept 1% lead-to-close rates at low average contract values. Enterprise SaaS with dedicated sales teams may invest heavily in lead quality to achieve 5–10% lead-to-close rates at high average contract values. The right ratio is one where the cost of generating leads (CPA at the top of the funnel) combined with the cost of sales (salary, commissions, tools) is less than the lifetime value of closed customers.