Tools › Finance and Business › Marketing › Ad Funnel and Budget Planner › Example
Working backward: the ad budget and traffic needed for 500 new customers
| Tool | Ad Funnel and Budget Planner |
| Source | original |
| Level | Undergraduate |
Problem
A subscription service wants 500 new customers. Ads cost 9 per thousand impressions with a click-through rate of 0.9 %; 12 % of the clicks sign up and 25 % of the sign-ups place a first order. An order is worth 45 at a 60 % gross margin and a customer places 3 orders over the period. What budget and how much traffic does the target take?
Inputs to Enter
- Start from a target: 500 new customers; priced per 1,000 impressions at 9; click-through 0.9 %
- Stages: Sign-up 12 %, First order 25 %
- Order value 45, gross margin 60 %, 3 purchases per customer
Answers
- Clicks = 500 / (0.12 × 0.25) = 16,667; impressions = 16,667 / 0.009 = 1,851,852
- Budget = 1,851,852 / 1,000 × 9 = 16,666.67; cost per customer 33.33
- Revenue 500 × 45 × 3 = 67,500; gross profit 40,500; return on ad spend 4.05 against a break-even 1.67; net profit 23,833.33
Notes
Open this case in the tool: /analysis-tools/business/marketing/ad-funnel-budget-planner/?try=what-500-customers-cost. Original illustrative numbers. The same budget follows from a revenue target of 67,500.
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
- Lead-generation funnel with a long sales step: four expected sales carry the campaign
- Diminishing returns: a cost per click that rises with spend, the spend of greatest profit and the second break-even