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

ToolAd Funnel and Budget Planner
Sourceoriginal
LevelUndergraduate

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

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