Tools › Finance and Business › Marketing › Ad Funnel and Budget Planner › Example
Return on ad spend below break-even: a campaign that sells and loses money
| Tool | Ad Funnel and Budget Planner |
| Source | original |
| Level | Undergraduate |
Problem
A campaign spends 6,000 at 1.50 per click. Of the clicks 10 % add to the cart and 35 % of those buy one order of 60 at a 30 % gross margin. The return on ad spend is above 1: does the campaign make money?
Inputs to Enter
- Start from a budget: 6,000; priced per click at 1.50; click-through 3 % (it sets only the impressions)
- Stages: Add to cart 10 %, Purchase 35 %
- Order value 60, gross margin 30 %, 1 purchase per customer
Answers
- Clicks 6,000 / 1.50 = 4,000; 400 carts; 140 customers; revenue 140 × 60 = 8,400
- Return on ad spend 8,400 / 6,000 = 1.40; break-even return on ad spend 1 / 0.30 = 3.33
- Gross profit 8,400 × 0.30 = 2,520; net profit 2,520 − 6,000 = −3,480
- Cost per customer 42.86 against 18.00 of gross profit per customer; break-even cost per click 60 × 0.30 × 0.035 = 0.63
- A dollar of spend brings back 0.42 of gross profit, so no spend breaks even at these rates
Notes
Open this case in the tool: /analysis-tools/business/marketing/ad-funnel-budget-planner/?try=sales-made-money-lost. Original illustrative numbers. Revenue above the ad spend is not enough: the gross profit must cover it, which is what 1 / margin says.
More Examples for This Tool
- Ad funnel: a 10 % better checkout rate against 10 % more budget
- Lead-generation funnel with a long sales step: four expected sales carry the campaign
- 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