ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Note: To start, make a copy of this Google Sheet by clicking on File > Make a copy. You can change any variable value that you see in gold.
3
4
Google Advertising Goals
5
Is advertising with Google realistic?
6
7
Your Goals
8
Total Leads Per Month 20
9
Total Cost Per Lead $ 250
10
Total Sales Per Month 10
11
Total Cost Per Sale $ 500
12
13
Google Ads Keyword Metrics
14
Total Searches Per Month 36,770
15
Expected Click Through Rate (CTR)2%
16
Expected Website Sessions from PPC 735
17
Low Range Average Cost Per Click (CPC) $ 5.45
18
High Range Average Cost Per Click (CPC) $ 17.91
19
Cost Per Click (CPC) Weighting100%
20
Estimated Monthly Spend $ 8,588
21
22
Lead and Sales MetricsMonthly Potential 36.77
23
Website Lead Conversion Rate5% 37 Leads 8,588.20
24
Cost Per Lead $ 234 $ 16.43 18.39
25
Sales Close Rate 50% 18 Sales
26
Average Cost Per Sale $ 467 $ 32.87
27
28
Calculator provided by www.datadrivenu.com
29
30
31
32
33
34
35
36
37
38
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