Funnel Calculator For Media Plan
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKL
1
Instructions
2
3
Fill out all the boxes highlighted in yellow.
4
The sheet will then calculate the figures for each combination of cost per click and conversion rate (low, mid, high) to help with your analysis and campaign planning
5
If you don't have one of the offers listed then simply leave this cell blank with a dollar value of \$0
6
When entering the conversion rates, always use a conversion rate based on the initial number of clicks; as opposed to the conversion rate of people who took the previous offer converting to the next offer in the sequence.
7
Analyse the data against your target:
- Approximately how much do you need to spend in order to achieve the target?
- How likely is this to work commercially?
- What do the numbers need to be in order for the campaign to generate a positive return?
8
9
THE FUNDAMENTALSPRODUCT AND CONVERSION RATEEntry OfferMain OfferUpsell or Cross-sell OfferDownsell Offer
10
Media Budget\$10,000.00ProductFree TrialSoftware SubscriptionPlatinum Level SubscriptionN/A
11
Agency Fees\$2,500.00Price\$0.00\$360\$140\$0.00
12
Average CPC Low\$0.75Conversion Rate Low2.00%0.50%0.10%1.00%
13
Average CPC Mid\$1.00Conversion Rate Mid3.00%1.00%0.20%2.00%
14
Average CPC High\$1.25Conversion Rate High4.00%1.50%0.50%3.00%
15
16
Number of Clicks Low CPC13333
17
Number of Clicks Mid CPC10000
18
Number of Clicks High CPC8000
19
20
CRITICAL NUMBERSEntry OfferMain OfferUpsell or Cross-sell OfferDownsell OfferAcquisition Funnel TOTAL Acquisition Funnel GROSS RETURN
(Revenue - Spend)
21
Conversions Low CPC, Low C.Rate2676713133480
22
Revenue\$0.00\$24,000.00\$1,866.67\$0.00\$25,866.67\$13,366.67
23
Conversions Low CPC, Mid C.Rate40013327267827
24
Revenue\$0.00\$48,000.00\$3,733.33\$0.00\$51,733.33\$39,233.33
25
Conversions Low CPC, High C.Rate533200674001200
26
Revenue\$0.00\$72,000.00\$9,333.33\$0.00\$81,333.33\$68,833.33
27
Conversions Mid CPC, Low C.Rate2005010100360
28
Revenue\$0.00\$18,000.00\$1,400.00\$0.00\$19,400.00\$6,900.00
29
Conversions Mid CPC, Mid C.Rate30010020200620
30
Revenue\$0.00\$36,000.00\$2,800.00\$0.00\$38,800.00\$26,300.00
31
Conversions Mid CPC, High C.Rate40015050300900
32
Revenue\$0.00\$54,000.00\$7,000.00\$0.00\$61,000.00\$48,500.00
33
Conversions High CPC, Low C.Rate16040880288
34
Revenue\$0.00\$14,400.00\$1,120.00\$0.00\$15,520.00\$3,020.00
35
Conversions High CPC, Mid C.Rate2408016160496
36
Revenue\$0.00\$28,800.00\$2,240.00\$0.00\$31,040.00\$18,540.00
37
Conversions High CPC, High C.Rate32012040240720
38
Revenue\$0.00\$43,200.00\$5,600.00\$0.00\$48,800.00\$36,300.00
39
40
41
42
43
44
45
46
47
48
49
50