Query Workbook v1

	A	B	C	E	G	I	M	N	O	P	Q	R	S	T	U
1	Go to File > Make a copy to get started
2			AID FOR LEARNING QUERY (V1)
3			AID FOR LEARNING QUERY (V1)				Enter Data Range or Name	SAMPLEDATA		Use 'SAMPLEDATA' or your own source					"
4							Optional Headers			The number of rows for your header data
5
6		1	Select one of the examples in blue from the dropdown and ensure the purple box is empty. The query will compute and the complete formula shown in the green preview.				PREVIEW OF FORMULA	=query(SAMPLEDATA, "SELECT * WHERE UPPER(A) CONTAINS 'COLCHESTER'")
7
8							SELECT AN EXAMPLE	CONTAINS
9							SELECT AN EXAMPLE	CONTAINS
10		2	You can try your own statements in the purple box, typing only the statement highlighted below (no quotes needed)
11		2					TYPE YOUR OWN STATEMENT
12							TYPE YOUR OWN STATEMENT
13			=QUERY(DATARANGE,"QUERY STATEMENT", [OPTIONAL HEADERS]
14			=QUERY(DATARANGE,"QUERY STATEMENT", [OPTIONAL HEADERS]
15
16		3	You can also query your own data with this tool. Just add your data to a new tab and update the Data Range or Named Range in the yellow area accordingly (Cell N3)				Query	Last 28 days Clicks	Previous 28 days Clicks	Last 28 days Impressions	Previous 28 days Impressions	Last 28 days CTR	Previous 28 days CTR	Last 28 days Position	Previous 28 days Position
17		3					colchester motorcycles	2,664	2,968	14,244	11,868	18.70%	25.01%	2.46	1.5
18							motorcycle dealers colchester	814	581	5,672	4,054	14.35%	14.33%	1.95	2.45
19							yamaha colchester	554	268	11,288	9,426	4.91%	2.84%	4.81	5.83
20							motorbike shop colchester	510	334	6,689	5,530	7.62%	6.04%	3.11	3.42
21							colchester motorbikes	403	1,912	23,542	75,384	1.71%	2.54%	7.32	5.76
22			CLAUSES	LOGICAL	ARITHMETIC	SCALAR	motorcycle shop colchester	387	263	3,875	2,637	9.99%	9.97%	1.53	2.4
23							motorcycles colchester	361	300	4,638	3,838	7.78%	7.82%	1.55	1.65
24			SELECT	AND	+	LOWER	ducati colchester	216	190	953	780	22.67%	24.36%	2.03	1.99
25			WHERE	OR	-	UPPER	honda motorcycles colchester	214	164	16,252	11,538	1.32%	1.42%	6.62	6.13
26			GROUP BY	NOT	*		colchester motorcycle	186	147	6,551	5,226	2.84%	2.81%	3.87	3.49
27			PIVOT		/	MORE SCALAR	colchester yamaha	173	81	3,221	2,118	5.37%	3.82%	24.33	31.96
28			ORDER BY				motorbike shops colchester	142	83	11,588	9,007	1.23%	0.92%	5.94	7.2
29			LIMIT				suzuki motorcycles colchester	138	132	754	621	18.30%	21.26%	2.08	1.91
30			OFFSET	AGGREGATION	COMPARISON	STRING COMPARISON	motorcycle clothing colchester	134	91	1,920	1,474	6.98%	6.17%	3.95	4.56
31			LABEL				colchester bike breakers	126	66	1,960	1,436	6.43%	4.60%	2.65	3.46
32			FORMAT	SUM	>	CONTAINS	ktm colchester	126	21	1,944	108	6.48%	19.44%	8.3	8.04
33			OPTIONS	AVG	<	STARTS WITH	motorbikes for sale colchester	93	41	658	398	14.13%	10.30%	2.68	3.62
34				MIN	=	ENDS WITH	motorbike shops in colchester	91	83	15,059	12,311	0.60%	0.67%	8.23	7.69
35				MAX	<=	MATCHES	moto v colchester	85	7	1,269	127	6.70%	5.51%	6.94	10.55
36				COUNT	>=	LIKE	motorbike colchester	73	60	10,981	9,230	0.66%	0.65%	12.03	10.76
37			*Format, options and like will be added ASAP.		!= OR <>		sell my car colchester	34	26	161	149	21.12%	17.45%	1.09	1.03
38							part exchange colchester	33	49	2,261	1,780	1.46%	2.75%	5.32	5.47
39					IS NULL		honda colchester	33	27	422	342	7.82%	7.89%	3.46	3.55
40					IS NOT NULL		mot colchester	32	18	326	302	9.82%	5.96%	6.47	6.24
41							shops in colchester	27	10	169	99	15.98%	10.10%	2.03	2.9
42							sell your car colchester	20	13	169	139	11.83%	9.35%	1.27	1.6
43							heated seats colchester	16	11	185	211	8.65%	5.21%	5.39	4.8
44							sports shops colchester	15	18	507	419	2.96%	4.30%	5.72	5.79
45							used ford transit custom in colchester	14	17	535	632	2.62%	2.69%	8.26	8.23
46							colchester cycle stores	14	23	385	564	3.64%	4.08%	8.02	7.95
47							used bmw for sale colchester	14	0	140	0	10.00%	0.00%	3.26	0
48							used ford transit in colchester	13	7	1,020	964	1.27%	0.73%	6.23	6.05
49							personal shopping colchester	13	19	587	359	2.21%	5.29%	4.09	4.5
50							euro exchange colchester	13	11	346	282	3.76%	3.90%	10.08	9.79
51							suzuki colchester	12	7	77	57	15.58%	12.28%	2.08	2.11
52							used ford vans colchester	12	0	56	0	21.43%	0.00%	3.73	0
53							to be used again colchester	11	0	785	0	1.40%	0.00%	6.86	0
54							rent a workshop colchester	10	13	5,980	10,166	0.17%	0.13%	10.21	10.24
55							used mercedes benz colchester	10	9	129	87	7.75%	10.34%	5.81	6.29
56							used bmw colchester	10	9	88	81	11.36%	11.11%	5.06	4.4
57							mot a bike colchester	10	5	47	27	21.28%	18.52%	2.06	1.56
58							colchester model shop	9	15	628	560	1.43%	2.68%	3.89	2.99
59							used honda colchester	9	7	265	197	3.40%	3.55%	6.9	6.94
60							selling your business colchester	9	5	28	23	32.14%	21.74%	2.32	2.35
61							damage colchester	8	0	61	0	13.11%	0.00%	2.36	0
62							mercedes benz colchester	8	13	58	63	13.79%	20.63%	1.41	1.27
63							used suzuki colchester	8	6	45	29	17.78%	20.69%	1.56	1.48
64							bikes for sale colchester	8	0	21	0	38.10%	0.00%	1.81	0
65							colchester bikes	8	0	18	0	44.44%	0.00%	1.33	0
66							kawasaki colchester	7	13	2,495	2,225	0.28%	0.58%	13.24	12.9
67							bike shop colchester	7	0	277	0	2.53%	0.00%	8.66	0
68							cycle shops colchester	6	0	121	0	4.96%	0.00%	9.64	0
69							peugeot colchester	6	5	114	63	5.26%	7.94%	4.75	2.71
70							bikes colchester	0	11	0	297	0.00%	3.70%	0	5.35
71							mercedes colchester	0	9	0	35	0.00%	25.71%	0	2.54
72							bike shops colchester	0	8	0	140	0.00%	5.71%	0	5.53
73							colchester selling page	0	7	0	249	0.00%	2.81%	0	1.21
74							bmw colchester	0	7	0	33	0.00%	21.21%	0	4.73
75							bike shops in colchester	0	6	0	321	0.00%	1.87%	0	7.76
76							ford transit colchester	0	6	0	89	0.00%	6.74%	0	9.75
77							enfield to colchester	0	5	0	535	0.00%	0.93%	0	8.91
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100