Estimate ROI

	A	B	C	D	E	F	G	H	I
1		Current Cicks	Current Impressions	Current CTR	Current Pos	Estimated Clicks	Estimated Impressions	Estimated CTR	Estimated Avg Pos
2	vashon	2,999	144,563	2.07%	7.3	6,440	138,210	4.7%	5
3	things to do	1,345	13,662	9.84%	1.3	248	2,400	10.3%	1
4	seattle	0	0			80	1,200	6.7%	3
5
6
7
8
9	Note: Only edit the cells highlighted in grey to estimate your average position.
10	In the "Keywords to Target" tab, only replace the keywords and volume data (in grey). The rest are lookup formulas.
11	In the "Avg CTRs" the cells in grey you can change to lookup a set of terms that include those specified terms. No need to change anything else.
12	In the "Current Keywords Data" you can replace each column with the data you pulled in Keylime Toolbox (or use GSC data). Be sure to match up your columns with the right data (i.e. Impressions should stay in column "C" and so on).
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
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