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

Ad funnel: a 10 % better checkout rate against 10 % more budget

ToolAd Funnel and Budget Planner
Sourceoriginal
LevelUndergraduate

Problem

A store spends 10,000 on ads bought at 12 per thousand impressions with a click-through rate of 1.2 %. Of the clicks 8 % add to the cart, 55 % of those start the checkout and 45 % of those buy. An order is worth 85 at a 50 % gross margin and a customer places 1.4 orders over the period. Find the customers, the cost per customer, the return on ad spend against its break-even value and the net profit, and compare raising the last rate by a tenth with raising the budget by a tenth.

Inputs to Enter

  • Start from a budget: 10,000; priced per 1,000 impressions at 12; click-through 1.2 %
  • Stages: Add to cart 8 %, Start checkout 55 %, Purchase 45 %
  • Order value 85, gross margin 50 %, 1.4 purchases per customer
Open the Ad Funnel and Budget Planner tool (loaded with this example)

Answers

  • Impressions 10,000 / 12 × 1,000 = 833,333; clicks × 0.012 = 10,000; 800 carts, 440 checkouts, 198 customers
  • Cost per customer 10,000 / 198 = 50.51; a customer brings 85 × 1.4 × 0.5 = 59.50 of gross profit
  • Revenue 198 × 85 × 1.4 = 23,562; gross profit 11,781; return on ad spend 2.36 against a break-even 1 / 0.5 = 2.00; net profit 1,781
  • Purchase rate 45 % → 49.5 %: 217.8 customers at the same spend, net profit +1,178.10; budget 10,000 → 11,000: 217.8 customers at the same cost each, net profit +178.10
  • Gross profit carried by the people who leave: 135,482 before the cart, 9,639 before the checkout, 14,399 before the purchase (gross profit × (1 / rate − 1))

Notes

The tool opens on this case; press Submit, or open it in the tool: /analysis-tools/business/marketing/ad-funnel-budget-planner/?try=checkout-gain-beats-more-ads. Original illustrative numbers, not benchmarks; checked against an independent stage-by-stage computation (test_ad_funnel_budget_planner.php). An illustration of the arithmetic, not advice.

More Examples for This Tool