Demand generation calculator: Reverse funnel math from a revenue target to visitors, leads, MQLs, SQLs and opportuniti

A demand generation calculator works a revenue target backward: divide marketing's share by average deal size to get customers, then divide by each stage's conversion rate up to opportunities, sales qualified leads (SQLs), marketing qualified leads (MQLs), leads and visitors. At a $3,000,000 target and $30,000 average deal, illustrative rates call for 100 won deals, 455 opportunities, 2,366 MQLs and 525,800 visitors. Round up at every stage.

How many leads do I need to hit a revenue target

Start with the new-business revenue marketing owns. Divide it by average deal size to get the number of customers. Then divide back up the funnel, one stage at a time, by each stage's conversion rate. Each result becomes the target for the stage above it.

The formula chain looks like this:

• Customers = new-business target ÷ average deal size
• Opportunities = customers ÷ win rate
• SQLs = opportunities ÷ SQL-to-opportunity rate
• MQLs = SQLs ÷ MQL-to-SQL rate
• Leads = MQLs ÷ lead-to-MQL rate
• Visitors = leads ÷ visitor-to-lead rate

Round up at every step. A fraction of a customer is still a customer you have to find.

A worked example

A published funnel model starts from a new revenue target of $10 million. Sales covers half, so marketing needs to generate $5 million, at a fixed price of $100,000 per deal. The model treats opportunities and sales qualified leads (SQLs) as one stage and starts at inquiries, not website visits.

Each row comes from the model's own math: 50 closed opportunities, 150 SQLs, 200 MQLs, 400 inquiries and 20,000 names.

What the calculator asks for and returns

The calculator takes seven inputs. You enter the new-business revenue target and the average deal size. Then you enter five stage rates: opportunity win rate, SQL to opportunity, marketing qualified lead (MQL) to SQL, lead to MQL, and visitor to lead.

It returns six counts: customers, opportunities, SQLs, MQLs, leads and visitors. Splitting SQLs from opportunities adds one division compared with the model above. If your team counts them as the same stage, set that rate to 100 percent.

Three checks before you trust the output

1. Use only the revenue marketing owns. With a direct sales force, sales management typically will assume responsibility for generating 15 to 50 percent of the pipeline. Take that share out of the target before you divide.
2. Use the price customers actually pay. Deal size should be the average sales price, reflecting typical discounts, not your suggested list price.
3. Lean low on rates. The same model advises: When in doubt, be conservative by picking lower conversion rates. Compare your inputs with our funnel conversion benchmarks. Then test the opportunity count against your pipeline coverage target.

The reverse funnel formula, with every input defined

Each stage of the reverse funnel is one division. You start at revenue, divide by the next conversion rate up, and carry the result into the following line. Write rates as decimals, so a rate of 42% goes into the formula as 0.42.

In this benchmark, each of the four B2B SaaS stage rates falls between 37% and 42%.

Define every stage the way your CRM does

A rate only means something if both ends of it are stages your system actually records. HubSpot's default lifecycle stages work as a reference set you can map against.

• Lead: "a contact or company that has converted on your website or through some other interaction with your organization beyond a subscription sign up" (HubSpot). Newsletter-only subscribers sit in a separate, earlier stage, so keep them out of the lead count.
• Marketing qualified lead (MQL): "a contact or company that your marketing team has qualified as ready for the sales team" (HubSpot). See MQL.
• Sales qualified lead (SQL): "a contact or company that your sales team has qualified as a potential customer" (HubSpot). See SQL.
• Opportunity: HubSpot ties it to a deal record. First Page Sage defines it more strictly as "An SQL who has a proposal or contract in hand and is actively considering a purchase" (First Page Sage). Pick one definition and use it for both the count and the rate.
• Customer: "a contact or company with at least one closed deal" (HubSpot).

If your team runs a sales accepted lead stage between MQL and SQL, add one more division for it. If sales accepts every MQL, that stage passes through unchanged.

Round up at every stage

You cannot generate part of a lead, so round each result up to the next whole number before you divide again. If you round down, the shortfall carries forward and grows at every stage above it. If you round only at the end, the plan shows counts your CRM can never report.

Where the rate inputs come from

Your own stage-to-stage history comes first. When you have none, a published benchmark can serve as a placeholder. First Page Sage reports B2B SaaS rates of 39% lead to MQL, 38% MQL to SQL, 42% SQL to opportunity and 37% opportunity to closed (First Page Sage). The same report says those averages are "significantly higher than the visitor to lead rates" (First Page Sage). Take the visitor-to-lead rate from your own analytics, not from a stage table. We compare more rates in funnel conversion benchmarks.

Worked example: what a $3,000,000 new-revenue target needs at each stage

Here is the full chain for a $3,000,000 new-revenue target at a $30,000 average deal. The conversion rates are illustrative. Replace each one with your own trailing history before you plan against it.

The chart traces the $3,000,000 target from 100 won deals back to 525,800 visitors, with each stage widening at its example conversion rate.

Each row divides the row above it by its rate and rounds up. For example, 100 ÷ 0.22 is 454.5, so the plan carries 455 opportunities. Rounding up at every stage keeps the plan from falling short.

Cut the target to marketing's share first

The $3,000,000 in this example is the figure marketing is responsible for sourcing, not the company number. Make that cut before you run any division. Spear Marketing Group puts the marketing share in a wide band: industry standards "vary widely, from 25% to 80%." If you skip the cut, every stage below inherits the inflation, and the visitor line grows the most.

Read it as a run rate

An annual total is hard to manage week to week. Divide by four for a quarterly target and by twelve for a monthly one:

• Won deals: 25 a quarter, about 9 a month
• Opportunities: about 114 a quarter, 38 a month
• SQLs: 207 a quarter, 69 a month
• MQLs: about 592 a quarter, 198 a month
• Visitors: about 131,450 a quarter, 43,817 a month

These are flat splits. If your sales cycle runs a full quarter, the leads that close in the first quarter had to arrive in the quarter before. Shift the top three rows earlier by your median cycle length.

Check coverage and cost

Matthews on Marketing describes the ratio of opportunities to target revenue as pipeline coverage and notes that a ratio of 3:1 is typical. Here, 455 opportunities at $30,000 is $13,650,000 of pipeline against $3,000,000, or about 4.55:1. In our reading, that is what a 22% win rate demands, so a 3:1 rule of thumb would leave this team short. See pipeline coverage and the pipeline coverage calculator.

For a first budget pass, Spear Marketing Group cites a common cost standard of $250 per MQL. At that rate, 2,366 MQLs come to $591,500. Use your own cost per MQL if you have it, then test channel splits in the demand gen budget allocator.

Which funnel stage has the biggest effect on the plan

A sensitivity table answers one planning question: if a single stage converts 10% better and nothing else changes, how much less traffic does the plan need at the top. The chart below runs that test on our illustrative rates, one stage at a time, against the base plan.

Why every row saves about the same

The reverse funnel is a chain of multiplications. Divide the target by five rates and you get visitors. Raise any one rate by 10% of itself and the product falls by the same proportion, whichever stage you touch. That is why each row lands near 478,000 visitors.

The leads column behaves differently. Improving visitor to lead leaves the lead requirement at 7,887, because leads are counted after that stage. Every improvement below the lead stage cuts leads needed as well, which matters if your marketing qualified lead (MQL) quota or your sales team's follow-up capacity is set in leads.

Relative lift versus percentage-point lift

A relative lift scales a rate by its own size. A percentage-point lift adds a fixed amount to it. The table uses relative lifts, so it shows every stage as equal. A percentage-point lift breaks that tie: the same added point is a large share of a small rate and a small share of a large one. In our reading, that means a percentage-point gain does the most work on the lowest rate in your funnel. First Page Sage notes that "for many industries, the Lead to MQL conversion rate is the lowest in the sales funnel", and visitor to lead usually sits lower still.

Picking the stage to work on first

1. Restate each planned improvement as a relative lift on your own current rate, so options compare on one scale.
2. Estimate what it costs to move each rate by that amount: a landing page test, a lead scoring rebuild, a sales follow-up rule.
3. Check headroom against funnel conversion benchmarks. A rate far below peers usually moves for less effort.
4. Prefer stages below the lead line when lead volume is the constraint, since those cut leads and visitors together.
5. Rerun the plan and the pipeline coverage calculator with the new rate before you commit budget.

First Page Sage's own guidance points the same way at the MQL stage: "Clear lead scoring processes will increase the percentage of MQLs who make it through to the SQL stage."

What conversion rates to plan with when you lack your own history

If you have no funnel history of your own, borrow a published range and label it as borrowed. Two public B2B sets show how wide that range is.

First Page Sage built its figures from client data gathered from 2017 through 2025 and reports them by industry. MarketJoy, an appointment setting agency, publishes one cross-industry set from its own pipeline data for 2024 to 2025.

The first row roughly agrees. Every row after it diverges by a factor of three to seven.

Worked example: the same target on both sets

Take a plan that needs 20 closed deals. Multiply the four stage rates to get lead-to-customer conversion, then divide.

That is a gap of roughly 75 times on the same target. No budget absorbs that kind of uncertainty, so the choice of benchmark is itself a planning decision.

Why the sets disagree

In our reading, the gap comes from what each source counts at each stage. MarketJoy treats an MQL as one of the leads that "fit your ICP and show engagement", where ICP means ideal customer profile. Its SQLs are vetted for budget, authority, need and timeline (BANT). First Page Sage sets a higher bar earlier: an MQL has expressed a clear buying interest and can afford the product. A stricter gate at MQL leaves fewer, warmer records downstream, so later stages convert at higher rates.

The two sources also locate the weak stage differently. MarketJoy says the biggest drop-off typically happens at the MQL → SQL stage. First Page Sage, as noted earlier, points to lead to MQL in many industries.

How to use the range

1. Write your own stage definitions first, using our MQL and SQL entries as a checklist.
2. Pick the benchmark set whose definitions match yours, not the one with the friendlier numbers.
3. Run the plan at both ends of the range and fund the lower case.
4. Replace each borrowed rate with your own after one full sales cycle.

More industry rows sit in our funnel conversion benchmarks.

Where your own conversion rates come from in the CRM

Your own stage-to-stage rates sit in the CRM's lifecycle history, not in a dashboard total. In HubSpot, each stage has a timestamp property: Date entered [stage] records when a contact or company entered it. Build every rate from those timestamps, by cohort.

Step 1: agree the definitions before you count anything

A rate is only as good as the stage rule behind it. The MQL definition advice is direct: document it, get sign-off from both marketing and sales leadership, and review it quarterly. The same source says verbal agreements reinterpreted by each team cause more alignment problems than wrong definitions. Write the rules into a service-level agreement that names who moves each stage and what evidence they log.

Step 2: know how stages move

HubSpot's default automatic updates only move the stage forward. To set an earlier stage with its tools, you must clear the value first. The calculated properties are not cleared when you move a stage backwards, so a recycled lead keeps its history.

Forward-only updates mean records can jump stages. Many businesses skip SQL and move from MQL into Opportunity when pipeline starts at the discovery call. Count a record as having passed a stage if it has an entry date for that stage or any later one. Otherwise skipped stages show up as drop-off.

Step 3: compute rates by cohort

A worked example with our own numbers:

1. Pull every record with Date entered MQL in the first quarter: 400.
2. Of those, count records with an entry date for SQL or Opportunity by the end of the second quarter: 120.
3. MQL-to-SQL rate: 120 ÷ 400 = 30 percent.
4. Repeat for each stage, using the same cohort window and a fixed follow-up window.

Exclude the Other stage. Its guidance is to keep out of funnel metrics. Also keep lead status out of stage counts: using lifecycle stage and lead status interchangeably corrupts your funnel reports.

If the definitions changed partway through the year, start the cohort after the change. Then compare your rates with the funnel conversion benchmarks to see which stage deserves a lead scoring review.

How to add a time lag to funnel math

A reverse funnel tells you how many leads you need. It does not tell you when they must arrive. A deal that closes on the last day of the quarter started as a lead weeks or months earlier, so every stage volume has to be pulled back by the time it takes to convert.

Start from the pipeline you need on day one

Insight Partners sets a starting in-quarter pipeline target by dividing bookings by the share of pipeline that historically converts. In its example, a team that entered recent quarters with about $8M in pipeline and closed $2M has a conversion rate of about 25%. With a $2.5M goal, that team should have $10M in pipeline at the start of the quarter.

The same piece flags invisible pipeline: deals created and closed inside the quarter. Short sales cycles produce more of it, and in our reading it is the main reason a lag-free plan looks wrong in month three.

Shift each stage back by its days-to-convert

Pull the average days between stage entry dates from your CRM, then work backward from the close date. The lag figures below are an illustrative worked example, not benchmarks.

The math is cumulative. Opportunities need 60 days to close, so they must exist 60 days before quarter end. SQLs need 10 more days, MQLs 14 more, leads 7 more. In this example, leads for this quarter's bookings had to arrive 91 days out, which means this quarter's revenue rests on last quarter's leads.

The milestone column follows the SiriusDecisions Demand Waterfall, whose modular stages define key milestones. In its original version, marketing generates inquiries, with a subset designated as marketing qualified leads, and sales then accepts, qualifies and wins the deal.

Turn the stock into a weekly flow

A day-one target is a stock. To keep it full, Insight Partners re-stocks the early-stage pipeline that depletes each quarter: in its example the team must generate $3.5M of pipeline each quarter, or $270K per week.

Apply the lags to that weekly number. A week's opportunity target needs its leads in the week that sits your total lag earlier. Put both dates in the plan: the week the volume is due and the week it converts. Then check the pipeline coverage at each quarter start, and track pipeline velocity so the lags you plan with stay current.

Mistakes that break a reverse funnel plan, and the steps to build yours

Most broken plans have correct arithmetic. The failure is usually in an input. Five errors show up often.

Five mistakes to check before you publish the plan

1. Planning on raw leads instead of marketing qualified leads (MQLs). Spear Marketing Group prefers to base budgets on MQLs because raw form-fills convert at widely disparate rates depending on channel and call to action. A target written in raw leads lets a cheap, low-intent channel fill the number.
2. Blending channels into one rate. Spear's examples are search engine marketing, webinars and content syndication, each with a different lead to MQL rate. Run a separate column per channel, then sum the MQLs.
3. Assigning marketing 100% of the target. Spear puts marketing's share of revenue or pipeline at 25% to 80% across the industry. Matthews on Marketing says that with a direct sales force, sales typically generates 15 to 50 percent of the pipeline. Agree the split in writing first.
4. Counting single leads when a buying group makes the decision. Forrester's Revenue Waterfall guide, published in August 2026, described a shift from individual leads to opportunities with connected buying groups. If several contacts from one account each become an MQL, your counts are inflated. We think you should dedupe to the account or opportunity before you apply rates.
5. Treating benchmarks as your history. Spear says your own historical numbers should take precedence. Where you lack history, Matthews advises picking lower conversion rates.

A sixth check: Spear names a too-generous MQL threshold as the weak point. Under that threshold, marketing hits its MQL goal while pipeline falls short. Tighten the MQL definition before you plan.

Copyable template

1. New-revenue target: $____
2. Marketing's agreed share: % → marketing revenue: $
3. Average selling price (ASP), using typical discounts, not list price: $____ → deals = step 2 ÷ ASP
4. Opportunities = deals ÷ close rate
5. Sales qualified leads (SQLs) = opportunities ÷ SQL to opportunity rate
6. MQLs = SQLs ÷ MQL to SQL rate, deduped by account
7. Leads per channel = that channel's MQL share ÷ that channel's lead to MQL rate
8. Budget check: MQLs × your cost per MQL

For step 8, Spear's sample showed that 606 MQLs at $250 requires a budget of $151,500. That figure covers programs only. Spear's budget excludes people, content and technology. If the result exceeds the budget you were given, test it in the budget allocator and confirm coverage in the pipeline coverage calculator.

What this page does not cover

This page does not set channel mixes, staffing or technology budgets, and its cost check covers programs only, not people or content. It does not evaluate any CRM, analytics tool or benchmark provider, and its illustrative rates and lags are examples, not benchmarks for your business. It is not financial advice.

Related on Take the Market: MQL to SQL conversion rate benchmarks and B2B funnel conversion rates by stage; Pipeline coverage calculator: the ratio you need from your own win rate and slippage; B2B marketing budget allocation calculator: split demand gen spend by pipeline per dollar.

Where the defaults come from