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

Diminishing returns: a cost per click that rises with spend, the spend of greatest profit and the second break-even

ToolAd Funnel and Budget Planner
Sourceoriginal
LevelGraduate

Problem

A click costs 1.20 at a spend of 10,000 and is assumed to rise as (spend / 10,000)^0.4. Of the clicks 9 % add to the cart and 40 % of those buy; an order is worth 70 at a 55 % gross margin and a customer places 1.5 orders. What does a budget of 40,000 bring, and at what spend is net profit greatest?

Inputs to Enter

  • Advanced mode. Start from a budget: 40,000; priced per click at 1.20; cost rise exponent 0.4; reference spend 10,000; click-through 2 %
  • Stages: Add to cart 9 %, Purchase 40 %
  • Order value 70, gross margin 55 %, 1.5 purchases per customer
Open the Ad Funnel and Budget Planner tool

Answers

  • Cost per click at 40,000: 1.20 × 4^0.4 = 2.0893; clicks 19,145; customers 689.2
  • Revenue 72,368; gross profit 39,802; net profit −197.60 (return on ad spend 1.81 against a break-even 1.82)
  • Net profit is greatest at a spend of 11,016.95 (7,344.63) and is zero again at 39,507.82
  • Break-even cost per click 70 × 1.5 × 0.55 × 0.036 = 2.079, which the rising cost passes just before 40,000

Notes

Open this case in the tool: /analysis-tools/business/marketing/ad-funnel-budget-planner/?try=more-spend-less-profit. Original illustrative numbers. The exponent is an assumption about how the cost of a click rises, not a market fact; the best spend and the upper break-even were checked against scipy (test_ad_funnel_budget_planner.php).

More Examples for This Tool