Funnel scenario modeling

Scenario modeling turns a revenue target into tests you can run before committing activity. Start with the outcome, work backward through the funnel, and change the assumptions that set required volume. A funnel gap can reflect low activity or weak conversion quality. Keep opportunity volume and deal value visible so you can see which assumption changes the result.¹ Determine whether the funnel is too small because activity is too low or whether its quality is poor because conversions are too low.²

Set the boundary

Before calculating, decide what counts as a stage and which period the model covers. Blurred stages can make the output look precise while hiding where volume drops.

The funnel divides the process into micro stages so you can see where leads are lost and what needs improvement.³ Choose whether to measure pipeline as weighted by stage or weighted by forecast.⁴ Select the period you want to forecast,⁵ then choose the user or team rollup for the view.⁶ Add filters for the opportunity fields that matter to the scenario.⁷

Use Lead, Qualified, Proposal, and Close as the model's checkpoints.⁸ Count a Lead when an organization or person has shown interest or fits the ideal customer profile.⁹ Move an opportunity to Qualified when it has a real need, decision power, and a credible path to funding and timing.¹⁰ Put it in Proposal when the documented solution and commercial offer are under evaluation.¹¹ Mark Close when the outcome is won or lost, contracts are executed, and the economics are realized.¹²

Build the baseline

A baseline exposes the assumptions that drive the result. Write them down before testing a better or worse case so every change has a clear starting point.

Enter total pipeline value, sales target, win rate, and average deal size.¹³ Use average sales price, or ASP, as the proxy value for an opportunity.¹⁴ Then add the current conversion rate between each stage and the activity level that feeds the first stage.

Work backward from the required close volume. Required volume at the stage above equals required volume at the stage below divided by the conversion rate at that step.¹⁵ For the opportunity calculation, divide deals needed by the opportunity to close rate to get opportunities needed.¹⁶ To size qualified leads from quota, divide the quota by the conversion rate for each lead type.¹⁷

Keep the formulas beside the assumptions. This shows whether the model needs more opportunities, a stronger conversion rate, a different deal size, or a different activity plan.

Run the scenarios

Change conditions deliberately and keep the output comparable. Freeze the stage definitions and forecast period, then change assumptions individually so you can see what moved the result.

Run a baseline, a bear case, a bull case, and a most likely case. The resulting view can show a distribution across those outcomes.¹⁸ Use real operating data to improve the projection.¹⁹ Adjust assumptions and volatility with what you know to be true about the business.²⁰

For historical win rates, use deals that were in each stage or forecast category at the same point in the sales period over the previous three periods, then use the average win rate of those deals.²¹

Test deal size, conversion, and activity separately before combining changes. If a small change in one input creates a large change in required volume, make that assumption visible in the planning discussion. If the result barely moves, spend less time debating that input and test the next one.

Read the result

Use the model as a diagnosis. It should tell you what to investigate next and when the scenario is clear enough for planning.

Start with the assumption that creates the largest movement in required volume. Then inspect the stage where that movement enters the model. A shortfall in early volume calls for an activity review. A shortfall caused by conversion points you toward qualification, messaging, or the handoff at that stage.

Regular funnel analysis can increase close ratio, shorten the sales cycle, accelerate sales, and help B2B organizations hit revenue quota more often.²² Review the model when actual conversion or deal size moves away from the baseline. Move on when you can explain the output in terms of the target, stage conversions, deal value, and activity level.

What not to do

These mistakes can make a scenario look more certain than its inputs justify.

• A funnel is relatively straightforward to model when deal size, velocity, and conversion rates stay consistent.²³ Once they change, do not assume it will remain easy to model.
• Treat neither the current sales forecast nor a previous funnel model as settled. They are going to be wrong.²⁴
• Modern B2B selling involves multiple competitors, longer sales cycles, and leads who are not actively seeking the product.²⁵
• Simplifying lead generation and sales around AIDA can kill their efficiency.²⁶

Before a planning call, enter the target, deal value, stage conversion assumptions, and activity level you intend to test. You can then show which change deserves action and which result depends on a fragile assumption.