ROI-Budget-PPC
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Brought to you byElevated Marketing Solutions
2
Instructions: If you like it go to file then make a copy!
3
Proposed Ad Spend Monthly Budget$1,000How much does Adwords cost?
4
B2B Marketers Guide to PPC
5
Cost per click$20.00Keyword planner tool or reach out to usCustomer Journey to an online purchase
6
7
Geographical Scoping?Indianapolis
8
How much traffic is available? 5000Keyword planner tool or reach out to us
9
Average CTR is 3%, number of clicks you can get on above available traffic150*Figured, Don't TouchWhere are people searching? (Google Trends)
10
Expected # of Leads at a 5% Conversion (National Average)8*Figured, Don't TouchGoogle's Explanation of Conversions
11
Industry Benchmark Conversion Rates/Click Through Rates
12
Actual Ad Spend Budget Needed$3,000*Figured, Don't Touch
13
14
Variable Change in Conversion %6%
15
What is your normal website conversion?
16
New Expected Leads from Variable Conversion Rate9*Figured, Don't Touch
17
18
Average Value of Lead (Figure by % of close rate out of 10 leads, then taking that % of a total sale. If you close 60% of leads and your sales are worth $100. Your leads are worth $60)$900
19
Expected # of Leads at a 5% Conversion (National Average, line 10)8
20
Expected Revenue Generated from PPC at 5% conversion$6,750*Figured, Don't Touch
21
22
Expected Revenue Generated from PPC at variable Conversion Rate$8,100*Figured, Don't Touch
23
24
Management Fees *Fees vary based on account$1,000
25
26
Ad Spend$3,000*Figured, Don't Touch
27
Subtotal adspend + Management Fees$4,000
28
Expected Return After Management Fees $ Ad spend on 5% Conversion Fees$2,750*Figured, Don't Touch
29
30
Expected Return After Management Fees & Ad spend on Variable Conversion % Fees$4,100*Figured, Don't Touch
31
32
33
You're going to spend this:$4,000*Figured, Don't Touch
34
35
You're projected to make this:$6,750*Figured, Don't Touch
36
Return68.75%
37
38
Pay per click accounts take ramp up time and you should project these numbers at least 3 months out from launch.
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1