Calculator Input
Use this career-planning view to evaluate prospecting performance, coaching needs, quota readiness, and promotion-facing sales discipline.
Example Data Table
This sample shows how the funnel moves from prospect traffic to won deals.
| Stage | Count | Stage Conversion | Drop-off Rate |
|---|---|---|---|
| Visitors | 2,500 | - | - |
| Leads | 300 | 12.00% | 88.00% |
| MQLs | 180 | 60.00% | 40.00% |
| SQLs | 90 | 50.00% | 50.00% |
| Opportunities | 40 | 44.44% | 55.56% |
| Won Deals | 12 | 30.00% | 70.00% |
Formula Used
- Stage Conversion (%): (Next Stage ÷ Current Stage) × 100
- Drop-off Rate (%): ((Current Stage - Next Stage) ÷ Current Stage) × 100
- Overall Conversion (%): (Won Deals ÷ Visitors) × 100
- Lead-to-Customer Conversion (%): (Won Deals ÷ Leads) × 100
- Win Rate (%): (Won Deals ÷ Opportunities) × 100
- Pipeline Velocity: Opportunities × Win Rate × Average Deal Value ÷ Sales Cycle Days
- Cost Per Lead: Funnel Cost ÷ Leads
- Customer Acquisition Cost: Funnel Cost ÷ Won Deals
- Efficiency Score: 0.30×Conversion Score + 0.20×Speed Score + 0.20×Goal Score + 0.15×Lead Quality Score + 0.15×Win Score
- Conversion Score: (Lead-to-Customer % ÷ Benchmark Lead-to-Customer %) × 100, capped at 150
- Speed Score: (Benchmark Cycle Days ÷ Actual Cycle Days) × 100, capped at 150
- Goal Score: (Won Deals ÷ Target Deals) × 100, capped at 150
- Lead Quality Score: (SQLs as % of Leads ÷ 25%) × 100, capped at 150
- Win Score: (Win Rate ÷ 30%) × 100, capped at 150
How to Use This Calculator
- Enter a period label so your export files stay organized.
- Type your funnel counts in stage order from visitors to won deals.
- Add deal value, funnel cost, cycle days, and target deals.
- Enter a realistic benchmark conversion rate and benchmark cycle length.
- Press Calculate Efficiency to show the result above the form.
- Review the score, weakest stage, conversion gaps, and cost metrics.
- Use the Plotly graph to see where volume drops fastest.
- Export the summary with the CSV or PDF buttons.
FAQs
1) What does this calculator measure?
It measures stage conversion, drop-off, lead quality, win rate, pipeline velocity, acquisition cost, and a combined efficiency score. The goal is to show where your funnel performs well and where it wastes effort.
2) Why is this useful for career planning?
Sales professionals can use it to prove performance discipline, identify coaching goals, and set improvement plans before interviews, reviews, territory changes, or promotion discussions.
3) What is a good efficiency score?
A score near 100 means you are roughly meeting your chosen benchmarks. Above 120 is strong. Below 80 usually signals clear friction in conversion, speed, goal attainment, or close quality.
4) Why compare against a benchmark conversion rate?
Benchmarks turn raw results into context. A 4% lead-to-customer result may be excellent in one model and weak in another. Benchmarking helps you judge performance more fairly.
5) Can I use this for recruiting or job-search funnels?
Yes. Replace visitors with outreach contacts, leads with replies, and deals with offers accepted. The same stage-efficiency logic still reveals weak transitions and wasted effort.
6) Why does pipeline velocity matter?
Velocity estimates how much value moves through the funnel each day. Faster movement often means better qualification, cleaner handoffs, and less revenue getting stuck late in the process.
7) What if later-stage counts are larger than earlier ones?
That usually means the stage definitions or the time window are inconsistent. Later stages should not exceed earlier ones in the same funnel period, so the calculator flags that issue.
8) How often should I review funnel efficiency?
Monthly reviews work well for most teams. Weekly reviews help when volume is high, performance is changing quickly, or you are actively coaching prospecting, discovery, and closing habits.