ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBM
1
Supermetrics Queries
2
Queries OK
3
All the queries created by Supermetrics are stored here, each in its own row.
9
4
15965209
5
On this sheet you can:
6
1. Modify the parameters of a query. Any changes will be visible when you run a refresh.
7
8
2. Remove a query by deleting its rowEurope/London
9
10
3. Add new queries: type a range address and query parameters, leave the query ID empty. The query will be added when you run a refresh. (Of course, it's much easier to use the sidebar to add new queries.)
11
12
4. Add queries that point to other spreadsheets: follow step 3, but also add a spreadsheet ID (you can see the ID in the URL when you have a file open)
13
14
15
16
17
18
19
Query IDSpreadsheet IDSheet nameRange addressCreatedUpdatedLast statusLast refresh ID
Results contain sampled data
Execution time (sec)
Object typeLinked chart IDData source
Date range type
Start dateEnd dateCompare to
Comparison value type
Accounts/views
MetricsDimensions
Pivot dimensions
FiltersSegment IDSortMax rows
Max pivot categories
Special settings
Other parameters
Result type
Language/country
Translate toSQL
Database name
Range address (static)
Report typeScope (Moz)Sort (Moz)
Highlight with colour
Refresh with user account
Returned data
21
y3SvAMGaH0wf7XEO6FcBx7mRdpsczM
SC keywords'
'SC keywords'!$A$1:$E$4359
2020-08-03 13:47:212020-08-04 7:02:05
Refreshed successfully
1596520908405FALSE2TABLEGWlast90days
["https://typeamedia.net/`https://typeamedia.net/"]
["impressions","ctr_perc","position"]
["query","page"][][][]500010
["BLANKS_TO_ZERO"]
{}
SC keywords'!A1:E4359
22
KAG4dHGoPODO2L3oVaKYUVPlimp9Iz
ph_semrush
ph_semrush!$A$1:$E$100
2018-07-09 16:40:102020-08-04 7:02:10
Refreshed successfully
1596520908405FALSE1TABLESR
["%RANGE:Setup!B7%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]100["NO_HEADERS"]
{"SRDB":"uk","maxResults":"100"}
ph_semrush'!A1:E100
phrase_fullsearch
48ed677f...
23
W8S8g2uVY5PjdfvurRhUXxFKrRbC0X
ph_semrush
ph_semrush!$G$1:$K$100
2018-07-09 16:40:352020-08-04 7:02:18
Refreshed successfully
1596520908405FALSE1TABLESR
["%RANGE:Setup!B8%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]100["NO_HEADERS"]
{"SRDB":"uk","maxResults":"100"}
ph_semrush'!G1:K100
phrase_fullsearch
48ed677f...
24
8Je26Wm8Xxe4yxCTEUXmhtQzlMJxvO
ph_semrush
ph_semrush!$M$1:$M$1
2018-07-09 16:40:502020-08-04 7:01:58
Error: No account selected
1596520908405FALSE1TABLESR
["%RANGE:Setup!B9%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]100["NO_HEADERS"]
{"SRDB":"uk","maxResults":"100"}
ph_semrush'!M1
phrase_fullsearch
48ed677f...
25
R4LMABmsLHEENgL1VRvsTk2EpsmXFu
ph_semrush
ph_semrush!$S$1:$S$1
2018-07-09 16:41:082020-08-04 7:02:03
Error: No account selected
1596520908405FALSE2TABLESR
["%RANGE:Setup!B10%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]100["NO_HEADERS"]
{"SRDB":"uk","maxResults":"100"}
ph_semrush'!S1
phrase_fullsearch
48ed677f...
26
TYr8RPemzHXqjXBVS7YCcdDBJZNvgh
ph_semrush
ph_semrush!$Y$1:$Y$1
2018-07-09 16:41:212020-08-04 7:02:10
Error: No account selected
1596520908405FALSE1TABLESR
["%RANGE:Setup!B11%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]100["NO_HEADERS"]
{"SRDB":"uk","maxResults":"100"}
ph_semrush'!Y1
phrase_fullsearch
48ed677f...
27
Lxtac414ONBGSuzQhwykQikDvbcsmG
ph_semrush
ph_semrush!$AE$1:$AE$1
2018-07-09 16:41:432020-08-04 7:02:18
Error: No account selected
1596520908405FALSETABLESR
["%RANGE:Setup!B12%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]100["NO_HEADERS"]
{"SRDB":"uk","maxResults":"100"}
ph_semrush'!AE1
phrase_fullsearch
48ed677f...
28
eKyBMFrsPO2a4YNzNQtZtvIMUhyMWY
ph_semrush
ph_semrush!$AK$1:$AK$1
2018-07-09 16:42:032020-08-04 7:02:06
Error: No account selected
1596520908405FALSETABLESR
["%RANGE:Setup!B13%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]100["NO_HEADERS"]
{"SRDB":"uk","maxResults":"100"}
ph_semrush'!AK1
phrase_fullsearch
48ed677f...
29
O31WMPNxxOYnswg6tyApUsF6L8WsgR
ph_semrush
ph_semrush!$AQ$1:$AQ$1
2018-07-09 16:42:222020-08-04 7:01:59
Error: No account selected
1596520908405FALSETABLESR
["%RANGE:Setup!B14%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]100["NO_HEADERS"]
{"SRDB":"uk","maxResults":"100"}
ph_semrush'!AQ1
phrase_fullsearch
48ed677f...
30
pWTld7noOk0pHgL5fCt1LOH7uIA5lP
ph_semrush
ph_semrush!$AW$1:$AW$1
2018-07-09 16:42:372020-08-04 7:02:20
Error: No account selected
1596520908405FALSETABLESR
["%RANGE:Setup!B15%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]100["NO_HEADERS"]
{"SRDB":"uk","maxResults":"100"}
ph_semrush'!AW1
phrase_fullsearch
48ed677f...
31
7BcaRaanPTJGiq9J9kMyErdMSua2Xv
ph_semrush
ph_semrush!$BC$1:$BC$1
2018-07-09 16:42:502020-08-04 7:01:57
Error: No account selected
1596520908405FALSETABLESR
["%RANGE:Setup!B16%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]100["NO_HEADERS"]
{"SRDB":"uk","maxResults":"100"}
ph_semrush'!BC1
phrase_fullsearch
48ed677f...
32
amhOF3GRl867FnEpA19PChGSKzxSQa
rl_semrush
rl_semrush!$A$1:$E$500
2018-07-09 16:43:442020-08-04 7:02:02
Refreshed successfully
1596520908405FALSE2TABLESR
["%RANGE:Setup!B7%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]50010["NO_HEADERS"]
{"SRDB":"uk","SRdisplayDate":"","maxResults":"500"}
rl_semrush'!A1:E500
phrase_related48ed677f...
33
3lYZ0vyv8WKr8HChhEpHpXhvzVw3lc
rl_semrush
rl_semrush!$M$1:$M$1
2018-07-09 16:45:102020-08-04 7:01:55
Error: No account selected
1596520908405FALSE3TABLESR
["%RANGE:Setup!B9%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]500["NO_HEADERS"]
{"SRDB":"uk","SRdisplayDate":"","maxResults":"500"}
rl_semrush'!M1phrase_related48ed677f...
34
I2aTl1ZtfJjhs0Lh4xlUeWLVIlCQ52
rl_semrush
rl_semrush!$S$1:$S$1
2018-07-09 16:45:322020-08-04 7:02:16
Error: No account selected
1596520908405FALSE1TABLESR
["%RANGE:Setup!B10%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]500["NO_HEADERS"]
{"SRDB":"uk","SRdisplayDate":"","maxResults":"500"}
rl_semrush'!S1phrase_related48ed677f...
35
TfvIzCKKVKLb4uOzgoAaKSCoNitarG
rl_semrush
rl_semrush!$Y$1:$Y$1
2018-07-09 16:45:492020-08-04 7:02:07
Error: No account selected
1596520908405FALSE7TABLESR
["%RANGE:Setup!B11%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]500["NO_HEADERS"]
{"SRDB":"uk","SRdisplayDate":"","maxResults":"500"}
rl_semrush'!Y1phrase_related48ed677f...
36
MMscm7V3KhGeJMVE6Ya7wikxNlEcmb
rl_semrush
rl_semrush!$AE$1:$AE$1
2018-07-09 16:46:092020-08-04 7:02:01
Error: No account selected
1596520908405FALSETABLESR
["%RANGE:Setup!B12%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]500["NO_HEADERS"]
{"SRDB":"uk","SRdisplayDate":"","maxResults":"500"}
rl_semrush'!AE1phrase_related48ed677f...
37
6mS2Pl8vPeUuqM8C94DokiWfffj4KN
rl_semrush
rl_semrush!$AK$1:$AK$1
2018-07-09 16:46:312020-08-04 7:02:07
Error: No account selected
1596520908405FALSETABLESR
["%RANGE:Setup!B13%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]500["NO_HEADERS"]
{"SRDB":"uk","SRdisplayDate":"","maxResults":"500"}
rl_semrush'!AK1phrase_related48ed677f...
38
Sy06PK5WSyxpZkM0PfbW6VHvXsShGE
rl_semrush
rl_semrush!$AQ$1:$AQ$1
2018-07-09 16:47:462020-08-04 7:01:57
Error: No account selected
1596520908405FALSETABLESR
["%RANGE:Setup!B14%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]500["NO_HEADERS"]
{"SRDB":"uk","SRdisplayDate":"","maxResults":"500"}
rl_semrush'!AQ1phrase_related48ed677f...
39
TyYc3PhETtTlGLdDKc50E6nAexwS2v
rl_semrush
rl_semrush!$AW$1:$AW$1
2018-07-09 16:48:042020-08-04 7:02:14
Error: No account selected
1596520908405FALSETABLESR
["%RANGE:Setup!B15%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]500["NO_HEADERS"]
{"SRDB":"uk","SRdisplayDate":"","maxResults":"500"}
rl_semrush'!AW1phrase_related48ed677f...
40
dIS1u1to3mrvXiAtc09TcccMD361aC
rl_semrush
rl_semrush!$BC$1:$BC$1
2018-07-09 16:48:252020-08-04 7:02:14
Error: No account selected
1596520908405FALSETABLESR
["%RANGE:Setup!B16%"]
["Nq","Cp","Co"]["Ph","Td"][]
[{"field":"database","operator":"==","value":"uk","combineToPrev":";"}]
[]500["NO_HEADERS"]
{"SRDB":"uk","SRdisplayDate":"","maxResults":"500"}
rl_semrush'!BC1phrase_related48ed677f...
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
101