What this calculator is for
I use this when the revenue plan says a channel has to create a certain amount of pipeline, but the demand plan still says only "more leads." The useful question is narrower: how many qualified opportunities are required, how many leads create those opportunities, and what CPL can the budget tolerate?
Why CPL targets go wrong
CPL is often negotiated before anyone checks the rest of the funnel. A cheap lead target can be too expensive if those leads do not become opportunities. A high CPL can be acceptable if the opportunity value and close rate support it. The number only makes sense after the opportunity math is visible.
Inputs used in the calculator
- Monthly pipeline target: the qualified pipeline value marketing needs to help create in a month.
- Monthly acquisition budget: the spend available for the channel or campaign being planned.
- Average opportunity value: the average value of a qualified opportunity created from this motion.
- Lead-to-opportunity rate: the share of qualified leads that become real opportunities.
- Opportunity win rate: the share of opportunities expected to become customers.
- Current qualified leads: the monthly lead volume the team is already producing at the same quality bar.
- Current CPL: the current cost per qualified lead for the comparable channel or campaign.
How to read the result
If required leads are higher than current leads and allowable CPL is lower than current CPL, the plan is asking for two changes at once. If lead volume is enough but allowable CPL is lower, the issue is cost or quality. If CPL is fine but lead volume is short, the question is whether the channel can scale without pulling in weaker buyers.
A quick example
A 5,000,000 pipeline target with 500,000 average opportunity value needs 10 qualified opportunities. If 5% of qualified leads become opportunities, the plan needs 200 qualified leads. With a 500,000 budget, allowable CPL is 2,500. If the current run-rate is 150 leads at 3,000 CPL, the gap is visible: 50 more leads, a 17% CPL reduction, or a lead-to-opportunity rate closer to 6% if budget and CPL stay unchanged.
Formula
Opportunities required = pipeline target / average opportunity value. Lead target = opportunities required / lead-to-opportunity rate. Allowable CPL = acquisition budget / lead target. Budget needed at current CPL = lead target times current CPL. Required lead-to-opportunity rate = opportunities required / leads affordable at the current CPL and budget. Expected closed-won revenue = pipeline target times opportunity win rate.
What I would check next
- If the lead target looks unrealistic, check whether the pipeline target is being pushed onto one channel.
- If allowable CPL is below market reality, check conversion rate before asking media to solve the full gap.
- If the lead-to-opportunity rate is weak, inspect offer clarity, form routing, enrichment, sales acceptance, and speed to lead.
- If expected closed-won revenue is too low, the issue may be win rate, deal size, or whether the pipeline target is enough.
Methodology and limitations
This is a backward plan, not a forecast. It assumes the average opportunity value is honest, the lead-to-opportunity rate uses the same lead definition, and the pipeline target is qualified pipeline rather than raw enquiry value. It does not account for sales cycle length, channel saturation, duplicate leads, outbound-sourced opportunities, or pipeline that slips between months.