Funnel to revenue forecast
A full funnel model in three steps to show how small rate improvements compound into pipeline and revenue.
Example scenario
A growth team models 120,000 monthly visitors entering its demand funnel, converting 2.8% into leads through demo and content-gated forms. Of those leads, 42% reach qualified status after SDR triage, and sales closes 18% of qualified opportunities at an average deal value of $6,200. Under those defaults, the funnel projects about 254 closed deals and roughly $1,574,899.20 in estimated closed revenue, making stage-by-stage conversion improvements easier to prioritize.
Funnel to revenue forecast
Visitors x lead% x qualified% x close% x avg deal
Want a similar calculator on your website?
Describe your fields and formula in plain English, match your brand, and embed the widget anywhere—WordPress, Webflow, Shopify, or custom HTML. Capture leads when you're ready.
How to use the funnel to revenue forecast
- Input monthly visitors from the same analytics source used in reporting, excluding known internal and bot traffic where possible.
- Set lead conversion rate (%) based on your current lead definition, then apply lead qualification rate (%) using consistent MQL/SQL criteria.
- Input close rate on qualified leads (%) from recent sales performance and average closed deal value ($) from weighted won-deal history.
- Review estimated closed deals and estimated closed revenue together, then run conservative and upside scenarios to guide channel and sales-capacity planning.
B2B funnel conversion planning context
- Lead-rate variability by traffic source
- Paid, organic, referral, and partner traffic often convert at materially different lead rates, so blended assumptions should be channel-weighted.
- Qualification and close-rate dependency
- Higher lead volume can reduce qualification quality if targeting broadens, which can pressure downstream close rates unless scoring and routing improve.
- Average deal value mix effects
- A single average deal value can hide segment shifts; enterprise mix changes can move revenue forecasts more than conversion-rate changes.
Best use cases
- Forecasting and scenario planning
- Client education and pre-qualification
- Budget and performance decision support
Frequently asked questions
Should close rate be calculated from all leads or only qualified leads?
In this model, close rate is specifically applied to qualified leads. If your CRM reports close rate against all leads, convert the metric before inputting.
Why can revenue forecasts miss even when lead volume hits target?
Forecasts can drift when qualification quality shifts, sales-cycle length changes, or average deal size mix changes across segments.
Can I use one blended average deal value for all products?
You can for a quick estimate, but segmented deal values by product line or customer tier usually produce more reliable forecasts.
How often should I refresh funnel assumptions?
Most teams update monthly or quarterly, and immediately after major changes in channel mix, qualification policy, pricing, or sales process.
Glossary
Scenario modeling
Testing multiple assumptions to estimate possible outcomes before execution.
Commercial intent
User behavior indicating readiness to buy, subscribe, or request a quote.
Related calculators
Category: Revenue operations & funnel analyticsTopics: Lead-to-sale conversion, Pipeline yield modeling, Closed revenue forecasting
Last reviewed: 2026-05-07
Reviewed by: Calclet Growth Team