Tools / Funnel Calculator

Work back from your revenue target to find your estimated media budget.

Input your target ARR and a few pipeline metrics to back into your media budget and lead targets.

01The target
Revenue lost from customers who leave or cut back.
Upsell from today's customers, as a share of today's ARR.
02The deal
Annual value of a new customer.
First touch to signed contract.
The rest comes from sales outbound, partners and referrals.
03The funnel
Blended across paid channels.

These are example numbers. Replace them with yours.

Your budget.

$625Ka year in paid media, about $52K a month, to book $1.98M of new ARR through marketing. That is 31.6% of the ARR it brings in.

The funnel it takes.

Leads
4,168
At $150 each
MQLs40% of leads
1,667
$375 per MQL
SQLs30% of MQLs
500
$1,250 per SQL
Opportunities50% of SQLs
250
$2,501 per opportunity
Closed-won20% of opportunities
50
$12,504 per customer

Each stage rounds up to a whole number. Costs are paid media only; they leave out salaries, tools and agency fees.

Where the new ARR comes from

ARR today$7,000,000
Churn at 10%−$700,000
Expansion at 8%+$560,000
Kept at year end (98% net retention)$6,860,000
Gap to $10,000,000$3,140,000
New ARR lost to churn before year end+$153,839
New ARR to book$3,293,839
Marketing's 60%$1,976,303

That is 50 new customers at $40,000.

When the money goes out

Before the year startsMonths 1 to 12

A deal that signs in month 1 started as a lead 4 months earlier. To close evenly through the year, spend starts 4 months before it: $208K of the $625K goes out before month 1. Spend for this target stops after month 8; anything spent after that builds next year's pipeline.

Unit costs.

Cost per MQL$3751,667 MQLs from 4,168 leads.
Cost per opportunity$2,501250 opportunities for sales to work.
Media cost per customer$12,504Media cost covered by 3.8 months of contract revenue.
Lifetime revenue to media cost32×A customer stays about 10 years at 10% annual churn, worth $400K in revenue. Media cost only; margin and other acquisition costs are left out.

What moves the budget most.

One change at a time, everything else held: each rate up 5 points, cost per lead down 10%, contract value up 10%.

01Opportunity to closed-won20% to 25%: budget $500K−20%
02MQL to SQL30% to 35%: budget $536K−14.3%
03Lead to MQL40% to 45%: budget $556K−11.1%
04Average contract value$40,000 to $44,000: budget $563K−10%
05Cost per lead$150 to $135: budget $563K−10%
06SQL to opportunity50% to 55%: budget $569K−9%

Planning your pipeline?

We build your demand generation and media plan back from your revenue target, stage by stage, the way this page does.