ABCDEFGHIJKLMNOPQRSTUV
1
Go to File > Make a copy to get started
2
AID FOR LEARNING QUERY (V1)
3
Enter Data Range or NameSAMPLEDATAUse 'SAMPLEDATA' or your own source"
4
Optional HeadersThe number of rows for your header data
5
6
1Select 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 lower(A) MATCHES 'motorcycle|motorbike'")
7
8
SELECT AN EXAMPLEMATCHES
9
10
2You can try your own statements in the purple box, typing only the statement highlighted below (no quotes needed)
11
TYPE YOUR OWN STATEMENT
12
13
=QUERY(DATARANGE,"QUERY STATEMENT", [OPTIONAL HEADERS]
14
15
16
3You 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)QueryLast 28 days ClicksPrevious 28 days ClicksLast 28 days ImpressionsPrevious 28 days ImpressionsLast 28 days CTRPrevious 28 days CTRLast 28 days PositionPrevious 28 days Position
17
motorcycle3152018,2176,7793.83%2.97%7.167.52
18
motorbike1111151,3701,0888.10%10.57%1.761.53
19
20
21
22
CLAUSESLOGICALARITHMETICSCALAR
23
24
SELECTAND+LOWER
25
WHEREOR-UPPER
26
GROUP BYNOT*
27
PIVOT/MORE SCALAR
28
ORDER BY
29
LIMIT
30
OFFSETAGGREGATIONCOMPARISON
STRING COMPARISON
31
LABEL
32
FORMATSUM>CONTAINS
33
OPTIONSAVG<STARTS WITH
34
MIN=ENDS WITH
35
MAX<=MATCHES
36
COUNT>=LIKE
37
*Format, options and like
will be added ASAP.
!= OR <>
38
39
IS NULL
40
IS NOT NULL
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