Sales & marketing · Calculator companion · By K Imports
Sales funnel forecast: practical guide
This guide explains how to use the Count.ie sales funnel forecast. Forecast leads, qualified opportunities, wins and sales revenue. Follow the inputs, method and worked example below, then compare your own scenario.
Guide written .
Open the Sales funnel forecast calculatorWhat to prepare
- Define the event, conversion, customer and attribution period before collecting data.
- Use spend and outcomes from the same reporting window.
- Distinguish revenue, contribution profit, recurring revenue and customer lifetime assumptions.
Understand the inputs
The calculation method
Each stage multiplies the previous stage by its conversion probability. Revenue = expected wins × average sale.
Worked example
Illustrative inputs and their result.
Example inputs
- Visitors or initial contacts
- 10000
- Visitor to lead (%)
- 3
- Lead to qualified (%)
- 40
- Qualified to sale (%)
- 25
- Average sale value (€)
- 1000
Calculated example result
- Expected Sales
- 30
- Forecast Revenue
- €30,000.00
- Overall Conversion Percent
- 0.3%
How to interpret the result
A marketing metric depends on its attribution and cost definitions. A favourable ratio is not proof that advertising caused every sale or that future customers will behave the same way.
Compare campaigns with the same attribution window and outcome definition. Test a lower conversion rate or shorter retention period before extrapolating a promising result.
Common mistakes to avoid
- Do not double-count a customer or conversion reported by multiple channels.
- Revenue is not the same as profit available to fund acquisition.
- Small samples and changing cohorts can produce unstable comparisons.
Assumptions and sources
Expected counts are fractional forecasts. Use conversion rates from comparable channels and cohorts.
If your case falls outside this scope, use a more suitable calculator or contact us about an unclear method.