Tools › Finance and Business › Marketing › Ad Funnel and Budget Planner › Example

Working backward: the ad budget and traffic needed for 500 new customers

ToolAd Funnel and Budget Planner
Sourceoriginal
LevelUndergraduate

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
Open the Ad Funnel and Budget Planner tool

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