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

Lead-generation funnel with a long sales step: four expected sales carry the campaign

ToolAd Funnel and Budget Planner
Sourceoriginal
LevelProfessional

Problem

A services firm spends 15,000 on clicks at 7.50 each, plus 6,000 of fixed campaign costs. Of the clicks 4 % fill in the lead form, 40 % of the leads are qualified by sales, half of those receive a proposal and a quarter of the proposals are signed. A contract is worth 18,000 at a 55 % gross margin. Find the cost per lead and per customer, the net profit and the break-even spend.

Inputs to Enter

  • Advanced mode. Start from a budget: 15,000; priced per click at 7.50; click-through 2.5 %; fixed costs 6,000
  • Stages: Lead form 4 %, Sales qualified 40 %, Proposal 50 %, Signed 25 %
  • Order value 18,000, gross margin 55 %, 1 purchase per customer
Open the Ad Funnel and Budget Planner tool

Answers

  • Clicks 2,000; leads 80 (187.50 of ad spend each); qualified 32; proposals 16; customers 4
  • Cost per customer (15,000 + 6,000) / 4 = 5,250 against 9,900 of gross profit per customer
  • Revenue 72,000; gross profit 39,600; return on ad spend 4.80 against a break-even 1.82; net profit 39,600 − 15,000 − 6,000 = 18,600
  • Break-even spend 6,000 / (39,600 / 15,000 − 1) = 3,658.54
  • One sale more or fewer moves net profit by 9,900

Notes

Open this case in the tool: /analysis-tools/business/marketing/ad-funnel-budget-planner/?try=four-sales-carry-the-campaign. Original illustrative numbers. With four expected sales the close rate is known only roughly, and the result moves with it.

More Examples for This Tool