AdWords & Organic Keyword Performance Template (Для правок: нажмите Файл -> Создать копию)

	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
241	Google Ads & Organic Keyword Performance					Template provided by:	#REF!		Instructions on how to use this template >>>	> Install the Supermetrics add-on with the link on the right (skip this if you've installed the add-on) > Launch the Supermetrics sidebar (Add-ons menu -> Supermetrics -> Launch sidebar) > Go to Add-ons menu -> Supermetrics -> Template Gallery > Find the template and click “Add template"				Install the add-on
242
243
244	В этом отчете сравниваются данные Google Ads и органические данные Google. Выберите запрос или прокрутите страницу вниз, чтобы просмотреть все данные по ключевым словам.
245
246	Диапазон дат (выберите диапазон дат и обновите запросы Supermetrics)	last3months
247	Выберите кампанию	All
248
249	Какие данные вы хотите видеть
250	Which keywords have good PPC visibility but low organic impressions?
251	Find out which of your PPC keywords are accumulating the most impressions and are seeing low organic visibility.
252
253
254	Keyword	PPC Clicks	PPC Impressions	PPC Avg. Pos	Organic avg Pos	Organic Clicks	Organic Impressions	PPC CPC	PPC CTR	PPC Cost	PPC Conversions	PPC Conv Rate	PPC Cost Per Conv
255	(Example) - Buy Coffee	1153	33405	4.1	10.98	11	254	0.75	3.74	1374.56	39	2.13	35.25
256	(Example) - coffee bean	841	19310	4.02	8.78	20	1212	0.82	5.09	1646.32	36	1.8	45.73
257	(Example) - coffee pot	241	8968	5.05		0	0	0.86	4.4	151.55	6	3.39	25.26
258	(Example) - coffee maker	1032	7094	2.55	9.02	3	172	0.28	27.94	1158.83	231	5.61	5.02
259	(Example) - keurig coffee maker	194	5969	4.31	9.87	0	44	0.88	4.42	120.05	0	0
260	(Example) - coffee beans online	654	4983	2.71	8.46	4	105	0.92	2.49	228.85	2	0.8	114.43
261	(Example) - coffee pot	214	2776	3.39	3.07	238	2707	0.86	4.4	151.55	6	3.39	25.26
262	(Example) - cuisinart coffee maker	135	2557	3.82		0	0	0.92	7.53	238.59	8	3.1	29.82
263	(Example) - best coffee beans	267	2444	4.1	9.46	3	56	0.76	12.16	497.01	14	2.13	35.5
264	(Example) - best coffee beans	373	2326	3.14	6.32	11	226	0.76	12.16	497.01	14	2.13	35.5
265	(Example) - small coffee maker	117	2283	2.26	12.77	0	13	0.92	7.25	196.62	2	0.93	98.31
266	(Example) - coffee online	326	2254	3.18	8.98	5	289	0.88	7.36	342.58	11	2.81	31.14
267	(Example) - best coffee maker	454	2251	2.68	7.81	1	173	0.99	5.63	448.22	8	1.76	56.03
268	(Example) - coffee maker	388	2188	2.3	9.21	19	1689	0.28	27.94	1158.83	231	5.61	5.02
269	(Example) - buy coffee beans	305	2160	3.78	11.61	4	73	0.56	5.37	142.25	2	0.79	71.13
270	(Example) - espresso coffee maker	166	2147	2.91	23.29	0	14	0.93	3.67	93.91	5	4.95	18.78
271	(Example) - buy coffee online	308	1999	3.19	7.95	9	265	0.98	6.35	304.09	7	2.25	43.44
272	(Example) - coffee shop online	151	1927	3.73	11.37	14	665	0.86	7.51	161.26	6	3.19	26.88
273	(Example) - whole bean coffee	145	1649	4.61	5	14	105	0.7	8.38	270.53	17	4.37	15.91
274	(Example) - best coffee	377	1576	2.94	5.67	12	232	0.69	4.11	181.79	5	1.89	36.36
275	(Example) - small coffee maker	187	1548	1.56	10.89	0	74	0.92	7.25	196.62	2	0.93	98.31
276	(Example) - italian coffee maker	169	1494	1.09	9.42	9	478	0.94	5.49	146.44	3	1.92	48.81
277	(Example) - whole bean coffee	278	1424	3.46	3.36	126	1275	0.7	8.38	270.53	17	4.37	15.91
278	(Example) - best coffee maker	263	1416	1.11	9.12	6	236	0.99	5.63	448.22	8	1.76	56.03
279	(Example) - coffee beans online	422	1346	3.35	7.63	5	118	0.92	2.49	228.85	2	0.8	114.43
280	(Example) - espresso coffee	208	1303	3.7	4.39	117	942	0.84	9.34	274.32	14	4.29	19.59
281	(Example) - latte machine	173	1295	4.35	10.28	3	25	1	2.85	82.05	1	1.22	82.05
282	(Example) - best coffee machine	209	1213	3.15	5.33	69	1181	0.85	8.54	263.67	16	5.16	16.48
283	(Example) - automatic coffee machine	163	1170	2.35	9.15	13	1008	0.6	7.04	115.49	1	0.52	115.49
284	(Example) - coffee online	258	1129	2.98	5.59	6	151	0.88	7.36	342.58	11	2.81	31.14
285	(Example) - espresso machine	136	1120	4.26	5.08	67	1688	0.62	5.89	124.81	1	0.5	124.81
286	(Example) - k cup coffee maker	181	1047	2.78	7.68	1	145	0.53	6.21	96.96	0	0
287	(Example) - bulk coffee beans	148	1012	1.02	9.55	1	88	0.95	4.68	110.64	2	1.72	55.32
288	(Example) - best coffee	270	983	2.31	6.56	28	926	0.69	4.11	181.79	5	1.89	36.36
289	(Example) - espresso machine	208	980	2.3	8.73	17	856	0.62	5.89	124.81	1	0.5	124.81
290	(Example) - green coffee bean	231	953	2.77	5.42	75	916	1.16	2.85	128.93	7	6.31	18.42
291	(Example) - buy coffee online	251	931	1.12	7.88	2	113	0.98	6.35	304.09	7	2.25	43.44
292	(Example) - best coffee machine	141	826	3.76	4.8	56	1040	0.85	8.54	263.67	16	5.16	16.48
293	(Example) - buy coffee beans	179	783	1.84	1.98	37	220	0.56	5.37	142.25	2	0.79	71.13
294	(Example) - coffee machine price	117	724	1.97	10.79	0	19	0.29	9.16	80.83	5	1.8	16.17
295	(Example) - cuisinart coffee maker	202	572	1.11	8.91	0	57	0.92	7.53	238.59	8	3.1	29.82
296	(Example) - good coffee beans	156	549	2.4	5.73	3	48	0.92	3.57	84.62	0	0
297	(Example) - online coffee beans	161	525	3.32	4.22	44	578	0.87	3.88	87.74	1	0.99	87.74
298	(Example) - coffee brewer	169	499	1.99	6.43	10	477	0.95	6.49	173.99	6	3.26	29
299	(Example) - filter coffee machine	172	480	3.03	4.58	34	468	0.77	2.41	53.33	1	1.45	53.33
300	(Example) - keurig coffee maker	122	392	1.88	6.43	8	375	0.88	4.42	120.05	0	0
301
302
303
304
305
306
307	All Keywords
308
309	AVERAGES			421.9	4615.5	128.6	1343.7	2759.0	3.0	7.7	2.9	89.6	550.6	4615.1	86.9
310
311	Campaign name	Ad group name	Keyword	Clicks	Impressions	Organic clicks	Organic queries	Organic impressions	Organic clicks per query	Organic average position	Average position	Organic impressions per query	Combined clicks	Combined queries	Combined clicks per query
312	(Example) Brand	On Top Coffee Masters	(Example) - On Top Coffee Masters	4110	11123	4632	10958	77058	78.7	1.18	1.01	2634.64	8742	11121	500.3
313	(Example) - Coffee - Generic - UK	Coffee	(Example) - Buy Coffee	1994	37006	212	15676	15676	0	8.71	4.46	22	2206	37006	36.4
314	(Example) - Coffee - Generic - UK	Coffee	(Example) - coffee bean	1790	46167	251	19559	19559	0	8.67	4.79	23	2041	46165	22.7
315	(Example) - Coffee - Generic - CH	Coffee	(Example) - Buy Coffee	1153	33405	11	254	254	0	10.98	4.1	2	1164	33404	11.8
316	(Example) - Coffee - Generic - UK	Coffee Machines	(Example) - coffee maker	1032	7094	3	172	172	0.1	9.02	2.55	4	1035	7094	22.9
317	(Example) - Coffee - Generic - CH	Coffee	(Example) - coffee bean	841	19310	20	1204	1212	3.2	8.78	4.02	56.09	861	19310	375.6
318	(Example) - Coffee - Generic - UK	Coffee	(Example) - coffee beans online	654	4983	4	105	105	0	8.46	2.71	3	658	4983	26.8
319	(Example) - Coffee - Generic - UK	Coffee Machines	(Example) - best coffee maker	454	2251	1	171	173	0	7.81	2.68	34.5	455	2249	235.9
320	(Example) - Coffee - Generic - CH	Coffee	(Example) - coffee beans online	422	1346	5	118	118	0.2	7.63	3.35	20	427	1346	273.1
321	(Example) - Coffee - Generic - CH	Coffee Machines	(Example) - coffee maker	388	2188	19	1671	1689	0.7	9.21	2.3	100.51	407	2188	103
322	(Example) - Coffee - Generic - UK	Coffee	(Example) - best coffee	377	1576	12	207	232	5.2	5.67	2.94	101.47	389	1576	193.8
323	(Example) - Coffee - Generic - UK	Coffee	(Example) - best coffee beans	373	2326	11	209	226	5.8	6.32	3.14	78.51	384	2326	168.6
324	(Example) - Coffee - Generic - UK	Coffee	(Example) - coffee online	326	2254	5	283	289	1.3	8.98	3.18	40	331	2254	91.9
325	(Example) - Coffee - Generic - UK	Coffee	(Example) - buy coffee online	308	1999	9	260	265	2.5	7.95	3.19	49.83	317	1999	107.9
326	(Example) - Coffee - Generic - UK	Coffee	(Example) - buy coffee beans	305	2160	4	72	73	2.3	11.61	3.78	23.03	309	2160	164.9
327	(Example) - Coffee - Generic - UK	Coffee	(Example) - whole bean coffee	278	1424	126	1258	1275	3	3.36	3.46	74.56	404	1424	83.2
328	(Example) - Coffee - Generic - CH	Coffee	(Example) - best coffee	270	983	28	910	926	1.4	6.56	2.31	75.73	298	983	77.7
329	(Example) - Coffee - Generic - CH	Coffee	(Example) - best coffee beans	267	2444	3	46	56	1	9.46	4.1	26.37	270	2444	113.1
330	(Example) - Coffee - Generic - CH	Coffee Machines	(Example) - best coffee maker	263	1416	6	225	236	0.8	9.12	1.11	45.33	269	1415	126.7
331	(Example) - Coffee - Generic - CH	Coffee	(Example) - coffee online	258	1129	6	133	151	3.1	5.59	2.98	64.14	264	1129	130.3
332	(Example) - Coffee - Generic - CH	Coffee	(Example) - buy coffee online	251	931	2	112	113	1.1	7.88	1.12	45	253	931	124.1
333	(Example) - Coffee - Generic - CH	Coffee Machines	(Example) - coffee pot	241	8968	0	0	0	0		5.05	0	241	8967	10.4
334	(Example) - Coffee - Generic - UK	Coffee	(Example) - green coffee bean	231	953	75	916	916	2.5	5.42	2.77	61	306	953	61.8
335	(Example) - Coffee - Generic - UK	Coffee Machines	(Example) - coffee pot	214	2776	238	2700	2707	0.4	3.07	3.39	18.02	452	2776	12.6
336	(Example) - Coffee - Generic - UK	Coffee Machines	(Example) - best coffee machine	209	1213	69	1179	1181	4	5.33	3.15	45.5	278	1213	48.6
337	(Example) - Coffee - Generic - UK	Coffee	(Example) - espresso coffee	208	1303	117	923	942	6	4.39	3.7	73.15	325	1303	94.8
338	(Example) - Coffee - Generic - UK	Coffee Machines	(Example) - espresso machine	208	980	17	849	856	0.2	8.73	2.3	60.13	225	980	60.2
339	(Example) - Coffee - Generic - UK	Coffee Machines	(Example) - cuisinart coffee maker	202	572	0	53	57	0	8.91	1.11	30	202	572	99.8
340	(Example) - Coffee - Generic - UK	Coffee Machines	(Example) - keurig coffee maker	194	5969	0	44	44	0	9.87	4.31	2	194	5969	3.4