Sales funnel conversion calculator
Funnel targets usually get set forward: marketing plans leads, and everyone hopes they add up to the number. Working backward from bookings is the only way to know whether the plan is even possible. This calculator back-solves each stage from the bookings target using your own conversion rates, by channel, because inbound and outbound convert so differently that a blended funnel sets the wrong targets for both.
- Category:
- RevOps Metrics & Reporting
- Formats:
- CSV + web view
- Sections:
- 5
- Updated:
What you get
- A back-solve from bookings target to deals, opportunities, meetings, MQLs, and leads
- A channel split showing how inbound and outbound need different volumes
- Formulas for every stage in plain arithmetic
- Timing inputs so each stage target lands early enough to close in the period
- A checklist for measuring conversion rates you can trust
Who it's for
- RevOps teams setting pipeline and marketing targets
- Marketing ops leads translating bookings into lead volume
- Sales leaders testing whether a plan is achievable
What's inside
- 1
Back-solve from bookings target
4 columns, 5 worked example rows
- 2
Back-solve by channel
9 columns, 3 worked example rows
- 3
Formulas
Guidance notes
- 4
Timing
6 fields to complete
- 5
Conversion rate hygiene
8-point checklist
Preview of section 1
Back-solve from bookings target
Worked example: 3,000,000 new bookings target, 30,000 average deal size. Conversion rates are illustrative; replace them with your own cohort rates.
| Stage | Conversion to next stage | Required volume | Formula |
|---|---|---|---|
| Closed won deals | 100 | 3,000,000 / 30,000 = 100 | |
| Opportunities | 25% (win rate) | 400 | 100 / 0.25 = 400 |
The preview shows part of section 1. The full template has all 5 sections (4 not previewed here), with blank rows ready to fill in. Download the full template
How to use it
- 1
Start from bookings, not leads
Enter the new bookings target and your average deal size for new business. Every other number is derived from these two and your conversion rates.
- 2
Use cohort conversion rates
Measure each conversion by following a cohort forward (of MQLs created in Q1, how many became meetings), not by dividing this quarter's meetings by this quarter's MQLs. Period ratios mix cohorts and mislead when volume changes.
- 3
Split by channel before summing
Inbound and outbound have different deal sizes and win rates. Back-solve each separately, then add the results. The totals will differ from a blended funnel, and the channel view is the one to plan against.
- 4
Shift targets earlier by the stage lag
Opportunities needed for Q4 bookings must be created a sales cycle before Q4 ends. Use the timing section to set when each stage target is due, not just how big it is.
Frequently asked questions
How do you calculate a sales funnel backward from revenue?
Divide the bookings target by average deal size to get deals, then divide by each conversion rate in turn. With 3,000,000 at 30,000 per deal and a 25% win rate, you need 100 deals and 400 opportunities.
What conversion rates do I need for a funnel calculator?
Lead to MQL, MQL to meeting, meeting to opportunity, and opportunity to closed won (win rate), measured on cohorts from your own history and split by channel.
Why calculate the funnel by channel?
Channels differ in deal size, win rate, and conversion. A blended funnel sets one target for everyone, which overstates what low-converting channels will produce and hides the true volume they need.
How many leads do I need to hit my sales target?
Required leads = Deals needed / (Win rate x Meeting-to-opportunity rate x MQL-to-meeting rate x Lead-to-MQL rate). In the example, 100 / (0.25 x 0.50 x 0.20 x 0.25) = 16,000 leads.
Related templates
All sales ops templatesPipeline generation plan
Pipeline & Forecasting
A pipeline generation plan that back-solves pipeline by source from the bookings target, win rate, and cycle length, with owners. Free PDF and CSV.
Lead lifecycle stage definitions
CRM & Data Hygiene
Lead lifecycle stages defined: MQL, SAL, SQL, and recycle rules with entry and exit criteria, SLAs, and the timestamps to capture at each step. Free PDF.
Sales velocity calculator
RevOps Metrics & Reporting
A sales velocity calculator using opportunities, win rate, deal size, and cycle length, with lever sensitivity and a by-segment view. Free PDF and CSV.