Manual Funnel Revenue Opportunity Calculator
Adding a 10% improvement at three funnel stages does not mean adding 30% to revenue. Funnel stages multiply, and each rate must use the output of the prior stage as its denominator. This manual calculator keeps that relationship visible.
Use it in three steps: gather one eligible starting count and the three sequential rates, copy the formula for a baseline and one scenario, then compare contribution after quality adjustment and cost. The result is a funnel scenario, not a forecast.
Inputs
| Symbol | Input | Unit | Valid range |
|---|---|---|---|
T |
Eligible visits/inquiries in the window | count | integer ≥ 0 |
r1 |
Visit-to-lead rate | decimal | 0–1 |
r2 |
Lead-to-qualified rate | decimal | 0–1 |
r3 |
Qualified-to-customer rate | decimal | 0–1 |
M |
Contribution per customer | currency | ≥ 0 |
q |
Quality realization factor | decimal | 0–1 |
C |
Incremental scenario cost | currency/window | ≥ 0 |
Every input is user-supplied with no default. Analytics owns T and rates from first-party funnel records; Finance owns M, q, C. Copy the inputs/result to an approved worksheet; the page does not save or export.
Create a baseline set (r10, r20, r30) and a scenario set (r11, r21, r31) for the same population and window. Google Analytics funnel guidance and Google's conversion-rate definition reinforce consistent steps and denominators. See funnel exploration and conversion rate.
Formula
Customers = T × r1 × r2 × r3
Contribution = Customers × M × q
Opportunity contribution = Scenario contribution − Baseline contribution
Net opportunity = Opportunity contribution − C
Round only presentation values. Keep unrounded intermediate values. If a stage is not part of the path, remove it from both cases rather than setting an arbitrary rate.
Method and sources reviewed: 2026-08-16.
Worked scenarios
Northstar uses T=20,000, M=$800, q=0.85, and C=$8,000 per month. Baseline rates are 3%, 40%, and 25%.
Baseline customers: 20,000×0.03×0.40×0.25 = 60; contribution: 60×$800×0.85 = $40,800.
| Scenario | Visit→lead | Lead→qualified | Qualified→customer |
|---|---|---|---|
| Conservative | 3.1% | 41% | 25% |
| Base | 3.3% | 42% | 26% |
| Aggressive | 3.6% | 44% | 27% |
| Scenario | Customers | Contribution | Net opportunity |
|---|---|---|---|
| Conservative | 63.55 | $43,214 | -$5,586 |
| Base | 72.07 | $49,009 | $209 |
| Aggressive | 85.54 | $58,164 | $9,364 |
For a stacked view:
- Conservative: rates 3.1% → 41% → 25%; 63.55 customers; $43,214 contribution; -$5,586 net.
- Base: rates 3.3% → 42% → 26%; 72.07 customers; $49,009 contribution; $209 net.
- Aggressive: rates 3.6% → 44% → 27%; 85.54 customers; $58,164 contribution; $9,364 net.
Base recalculation: 20,000×0.033×0.42×0.26=72.072; incremental contribution is (72.072−60)×$800×0.85=$8,208.96; net is $208.96, or $209 rounded to the nearest dollar.
Interpret the result and check its limits
| Condition | Meaning | Action |
|---|---|---|
| Net negative across credible scenarios | Declared contribution does not cover cost | Do not proceed on this business case |
| Result depends on one stage | Evidence for that rate drives the decision | Test that stage and guard downstream quality |
Result positive only at q=1 |
Case ignores quality, cancellations or rework | Reject or add evidence-based adjustment |
If traffic is fixed but the audience mix changes, rates may not transport. If the same initiative affects several stages, avoid counting the same customer twice. Keep source/channel segments separate until definitions match.
Do not calculate with negative inputs, rates above 1, mixed currencies/windows, overlapping traffic, or stages whose denominators are unknown. The page stores no data and offers no benchmark defaults.
The output is a scenario range, not a forecast or causal estimate. It does not prove Easy AI performance or a market benchmark.
Frequently asked questions
Use these answers for cross-channel and reporting choices beyond the core funnel formula.
Can different channels share one funnel? Only when stage definitions, populations, and measurement windows align; otherwise calculate each channel separately.
How should fractional customer results be reported? Keep decimals in the calculation, round only the displayed scenario, and do not present a fraction as an observed customer count.
Can contribution and cost use different windows? No. Normalize both to the same declared window, prorate recurring cost consistently, and record the treatment in the worksheet.
What to do next
Use the website conversion audit to verify the stage most responsible for the decision.
Have Analytics approve event and cohort definitions, Sales Operations approve qualification/customer states, and Finance approve M, q, and C. Run the smallest test that can isolate the stage most responsible for the decision.