Funnel math

Funnel math turns a revenue target into a workload. Run it backward from the target through deal size and conversion rates until you reach qualified accounts, meetings, replies, and activity. Keep volume and conversion as separate levers.¹ An audited 5% improvement in a BDR-to-AE handoff was estimated to add $549,477 in annualized bookings without extra spend at the top of the funnel.²

Start with the target

Put the revenue target and planning period at the left side of the sheet. Each result should answer one question: how much activity must happen to produce that target?

Start with the revenue goal, then use a B2B pipeline tracker to calculate the deals, opportunities, and qualified accounts needed.³ Work backward through each conversion rate to calculate the required qualified-account volume.⁴ The forward model multiplies Activity by conversion rate to produce Opportunities, then Opportunities by close rate to produce Closed/Won deals, then Closed/Won deals by average contract value to produce Revenue.⁵

Use the reverse form for planning:

• Revenue target divided by average contract value gives required closed/won deals.
• Required closed/won deals divided by close rate gives required opportunities.
• Required opportunities divided by meeting-to-opportunity rate gives required held qualified meetings.⁶
• Required held qualified meetings divided by show rate gives the booked-meeting workload.⁷
• Continue dividing through the account and activity conversion rates you track until you reach the required volume of touches.

Operators can multiply forward from planned activity or divide backward from a pipeline target to find the required activity level.⁸ The backward calculation sets the plan; the forward calculation checks that the plan produces the target.

Write the unit beside every output. Keep deals, opportunities, held meetings, booked meetings, qualified accounts, and activities as separate rows. Move on only when each row has a rate, a denominator, and a clear definition.

Work from deals to meetings

The middle of the funnel turns a target into a meeting requirement. Treat the close rate as a planning input. Without a close assumption, pipeline value cannot tell you how many opportunities you need.

A 30% close rate requires a little more than three times as much pipeline.⁹ Apply that relationship to your own close rate, then divide the resulting opportunity requirement by your meeting-to-opportunity rate to get held qualified meetings.⁶

Keep booked meetings and held qualified meetings separate. Show rate determines how much booked-meeting volume is needed to produce the held-meeting requirement.⁷ When the held number looks healthy but the opportunity number still misses, inspect qualification or meeting quality before increasing bookings.

Use the output to ask which conversion rate would reduce the most downstream work if it improved. The handoff example in the opening shows why that question belongs in the model. More activity can change the result, but a better rate at a later stage can do so without filling the top of the funnel.

Turn meetings into accounts and touches

Once the meeting requirement is clear, translate it into accounts and channel activity. This is where outbound planning becomes an executable workload.

Translate the qualified-account requirement into a monthly number when the plan is monthly.¹⁰ Start with average deal size and conversion rates, then map the account-engagement volume required two to three quarters ahead.¹¹ That timing keeps the activity plan ahead of the period when the resulting opportunities need to close.

For a call-led motion, the dials-to-meeting ratio is the product of connect rate, conversation rate, and meeting conversion rate.¹² For full-funnel planning from dials, add meeting show rate, opportunity rate, and win rate to the chain.¹³

Treat each channel as its own funnel. Track email reply rates, LinkedIn acceptance rates, and cold-call connect rates independently, then apply an overlap adjustment so meetings from the same prospect are counted once.¹⁴ This prevents a multichannel sequence from making the meeting requirement look smaller than the work needed to create it.

For each channel, record the required activity, the response or connection rate, the meeting rate, and the share of meetings that overlap with another channel. If one channel has no usable rate, label the assumption and keep it separate from observed performance. Do not blend unlike rates into one average until you know they describe the same stage.

Build the waterfall

A reverse model helps in a planning conversation when someone can follow the path from target to activity. Show the calculation as a waterfall, with each row feeding the next.

Build a waterfall pipeline-generation model to understand how the team will reach the revenue target.¹⁵ Walk the sales leader backward from the pipeline required to hit the target.¹⁶ Show the pipeline amount needed to hit the sales target, then the meetings required to reach that pipeline goal.^{17, 18} Continue down to qualified accounts and activity by channel.

Use the waterfall to locate the first gap between required and actual performance. If activity is below plan while conversion holds, the problem is volume. If activity is on plan while opportunities or pipeline are below plan, inspect the stage where the rate falls short. Match the next action to that gap.

Keep a forward check beside the reverse model. Multiply the planned activity through every rate and compare the result with the target. If the two paths disagree, stop at the first row where the units or definitions change. Arithmetic rarely causes the disagreement; mixed definitions usually do.

What not to do

• Keep a current-quarter view from driving the whole plan. Sales representatives often interpret the target as the current quarter's number and devise ways to pull deals forward from future quarters.^{19, 20}
• Sales leaders push sales representatives to complete unlikely deals and achieve wins against the odds.²¹ Sales teams can close only opportunities already in play.²² Do not rely on a "Hail Mary" deal to repair a thin funnel.
• Do not wait for a future-quarter miss before starting prospecting. Top-of-funnel effort strongly affects whether later quarters finish strongly or struggle to meet the target.²³
• Do not forecast with conversion rates you are not tracking in weekly campaign reports.²⁴