| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Paid Campaign Funnel Calculator - Display & Social Ads | ||||||
2 | by Ollo Metrics - www.ollometrics.com - (Click 'file' > 'Make a copy') | ||||||
3 | Ads | Total Ad Spend | $2,200 | Enter a Display or Social Ads Budget | |||
4 | Avg CPM | $10.00 | Enter CPM from a similar previous campaign | ||||
5 | Avg. Impressions | 220,000 | Total Ad Spend / Avg CPM x 1000 | ||||
6 | Avg. Link Click Thru Rate | 0.25% | Enter CTR from a similar previous campaign | ||||
7 | # of Clicks/Visits | 550 | Avg Impressions x Avg CTR | ||||
8 | Avg. Cost per Click | $4.00 | Total Ad Spend / # of Clicks | ||||
9 | Funnel | Website Conv. Rate | 3.00% | Insert value | |||
10 | # of Leads (Conv's) | 17 | Clicks x Website conv. rate | ||||
11 | Cost per Conversion | $133.33 | Ad spend / # of Leads | ||||
12 | Qualification Rate | 25% | What % of Leads are Qualified? | ||||
13 | # of Qualified Leads | 4.1 | # of Conversions x Qualification rate | ||||
14 | Close Rate | 50% | What % of Qualified Leads do you Close? | ||||
15 | # of Customers | 2 | # of Qualified leads x Close rate | ||||
16 | Profit | Average customer $ Value | $9,000 | Insert value | |||
17 | Gross margin | 40% | Insert value | ||||
18 | Gross Profit per customer | $3,600 | Avg. customer value x Gross margin | ||||
19 | Gross Profit | $7,425 | GP per customer x # of Customers | ||||
20 | Mgmt / Time | Number of months | 3 | Insert # of months | |||
21 | Total Gross Profit | $22,275 | Gross profit x # of months | ||||
22 | Total Ad Spend | $6,600 | Adspend x # of months | ||||
23 | Agency or Mktg Team Fees | $4,500 | Monthly fee x Number of Months | ||||
24 | Total Advertising Cost | $11,100 | Adspend + Agency Fees | ||||
25 | ROI | Total Return | $11,175 | Gross profit - Advertising cost | |||
26 | % Return on Investment (ROI) | 201% | Gross profit / Advertising cost | ||||
27 | |||||||