Tools › Finance and Business › Marketing › Ad Funnel and Budget Planner › Example
Lead-generation funnel with a long sales step: four expected sales carry the campaign
| Tool | Ad Funnel and Budget Planner |
| Source | original |
| Level | Professional |
Problem
A services firm spends 15,000 on clicks at 7.50 each, plus 6,000 of fixed campaign costs. Of the clicks 4 % fill in the lead form, 40 % of the leads are qualified by sales, half of those receive a proposal and a quarter of the proposals are signed. A contract is worth 18,000 at a 55 % gross margin. Find the cost per lead and per customer, the net profit and the break-even spend.
Inputs to Enter
- Advanced mode. Start from a budget: 15,000; priced per click at 7.50; click-through 2.5 %; fixed costs 6,000
- Stages: Lead form 4 %, Sales qualified 40 %, Proposal 50 %, Signed 25 %
- Order value 18,000, gross margin 55 %, 1 purchase per customer
Answers
- Clicks 2,000; leads 80 (187.50 of ad spend each); qualified 32; proposals 16; customers 4
- Cost per customer (15,000 + 6,000) / 4 = 5,250 against 9,900 of gross profit per customer
- Revenue 72,000; gross profit 39,600; return on ad spend 4.80 against a break-even 1.82; net profit 39,600 − 15,000 − 6,000 = 18,600
- Break-even spend 6,000 / (39,600 / 15,000 − 1) = 3,658.54
- One sale more or fewer moves net profit by 9,900
Notes
Open this case in the tool: /analysis-tools/business/marketing/ad-funnel-budget-planner/?try=four-sales-carry-the-campaign. Original illustrative numbers. With four expected sales the close rate is known only roughly, and the result moves with it.
More Examples for This Tool
- Ad funnel: a 10 % better checkout rate against 10 % more budget
- Return on ad spend below break-even: a campaign that sells and loses money
- Working backward: the ad budget and traffic needed for 500 new customers
- Diminishing returns: a cost per click that rises with spend, the spend of greatest profit and the second break-even