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.
Download it
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
5 sections, each listed with its own size. The first is previewed below; the remaining 4 come with the download, with blank rows ready to fill in.
| Section | Size | Previewed |
|---|---|---|
| Back-solve from bookings target | 4 columns, 5 worked example rows | Below |
| Back-solve by channel | 9 columns, 3 worked example rows | In the download |
| Formulas | Guidance notes | In the download |
| Timing | 6 fields to complete | In the download |
| Conversion rate hygiene | 8-point checklist | In the download |
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 |
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 as well as 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.