Search Position Click Through Rates from Google Webmaster Tools Data

From your Google Webmaster Tools Query Data

Google Webmaster Tools (GWT) enhanced the accuracy of its Search Query data at the start of 2014. iPullRank wrote an article about how this new data could be used to roll your own Click Through Rate (CTR) v Position charts. This can be used to find out how CTR changes based on search result positions in your own market. I liked the idea, so I've written this tool to make it simple for you to generate your own CTR study chart.

Input your Data

Click to see full size

CTR v Average Search Position Chart

Results are compared with the CTR studies from Catalyst. The example chart is using my own websites data.

Average Search Position Data Table

Average Position	Impressions	Clicks	CTR	Keywords
7	23,217	596	2.57%	197
2	2,169	346	15.95%	62
8	26,989	545	2.02%	260
4	5,468	629	11.50%	177
3	1,941	244	12.57%	80
5	3,949	197	4.99%	105
13	2,718	82	3.02%	54
11	5,228	94	1.80%	77
6	7,925	307	3.87%	178
12	5,665	77	1.36%	84
9	11,594	269	2.32%	246
10	8,300	166	2.00%	232
33	3,154	33	1.05%	76
15	1,905	41	2.15%	59
43	8,771	19	0.22%	83
19	1,193	21	1.76%	82
1	191	37	19.37%	41
16	1,945	17	0.87%	66
17	6,817	22	0.32%	74
36	3,093	11	0.36%	96
21	1,124	11	0.98%	53
28	1,389	16	1.15%	78
40	5,932	11	0.19%	94
31	5,475	9	0.16%	82
27	1,739	14	0.81%	55
32	1,952	13	0.67%	71
26	1,274	9	0.71%	53
23	874	6	0.69%	57
14	522	8	1.53%	55
46	5,061	6	0.12%	75
39	5,460	8	0.15%	98
22	1,185	8	0.68%	45
41	4,859	9	0.19%	92
25	1,338	8	0.60%	68
52	4,593	7	0.15%	34
69	1,647	2	0.12%	27
34	3,132	3	0.10%	71
62	1,646	3	0.18%	41
24	847	7	0.83%	59
20	1,917	11	0.57%	62
45	3,480	5	0.14%	71
30	1,290	3	0.23%	66
58	1,245	4	0.32%	30
78	896	4	0.45%	21
48	3,055	3	0.10%	77
110	4,103	2	0.05%	54
99	1,534	1	0.07%	14
51	2,437	2	0.08%	33
55	1,560	1	0.06%	23
53	963	4	0.42%	35
35	1,987	7	0.35%	73
57	1,806	1	0.06%	22
37	1,764	2	0.11%	79
86	953	1	0.10%	16
71	1,390	2	0.14%	26
64	2,050	1	0.05%	38
44	1,923	4	0.21%	92
50	1,120	2	0.18%	49
29	1,793	3	0.17%	77
190	104	1	0.96%	9
47	1,783	2	0.11%	88
87	305	2	0.66%	19
59	307	2	0.65%	40
42	1,967	1	0.05%	82
38	1,133	2	0.18%	92
18	411	3	0.73%	58
91	181	1	0.55%	18
88	343	1	0.29%	20
90	554	1	0.18%	19
130	627	1	0.16%	38
80	111	1	0.90%	19
94	271	1	0.37%	29
350	2,725	0	0.00%	2
76	2,524	0	0.00%	25
170	1,577	0	0.00%	17
77	1,539	0	0.00%	13
85	1,550	0	0.00%	20
97	1,337	0	0.00%	25
67	1,299	0	0.00%	26
49	1,514	0	0.00%	71
54	1,615	0	0.00%	27
70	1,549	0	0.00%	32
210	593	0	0.00%	24
100	1,113	0	0.00%	38
79	611	0	0.00%	19
89	817	0	0.00%	22
65	693	0	0.00%	36
74	581	0	0.00%	15
220	304	0	0.00%	24
61	466	0	0.00%	17
60	670	0	0.00%	31
92	633	0	0.00%	16
95	416	0	0.00%	15
56	390	0	0.00%	29
150	280	0	0.00%	22
120	397	0	0.00%	35
63	537	0	0.00%	28
81	299	0	0.00%	15
93	295	0	0.00%	21
83	475	0	0.00%	22
75	423	0	0.00%	15
72	182	0	0.00%	23
330	87	0	0.00%	2
140	265	0	0.00%	38
73	195	0	0.00%	11
84	218	0	0.00%	25
68	145	0	0.00%	22
66	160	0	0.00%	24
96	131	0	0.00%	17
280	40	0	0.00%	3
82	123	0	0.00%	16
300	58	0	0.00%	3
180	79	0	0.00%	10
240	60	0	0.00%	14
320	32	0	0.00%	4
160	94	0	0.00%	17
98	85	0	0.00%	17
310	26	0	0.00%	5
270	30	0	0.00%	4
230	51	0	0.00%	20
200	46	0	0.00%	15
250	19	0	0.00%	11
260	14	0	0.00%	4
290	5	0	0.00%	1
340	15	0	0.00%	10
630	4	0	0.00%	1
570	3	0	0.00%	1
620	4	0	0.00%	2
530	2	0	0.00%	1
420	2	0	0.00%	1
450	1	0	0.00%	1
510	2	0	0.00%	2
430	1	0	0.00%	1
520	1	0	0.00%	1
440	1	0	0.00%	1

Did this tool help you? Why not reward me with a

or support my late night development work by buying me a beer

Support this Development

Search Queries File (Required) In the Search Queries section of Google Webmaster Tools export via the "Download this Table" button. Then select it using this "Choose File" button. Select a larger data range to get a larger data set. Or add filters to analyse subsets. See right, where step 3 is not required.