ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBM
1
Supermetrics Queries
2
Queries OK
3
All the queries created by Supermetrics are stored here, each in its own row.
11
4
15796847
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/viewsMetricsDimensionsPivot dimensionsFiltersSegment IDSortMax rows
Max pivot categories
Special settings
Other parameters
Result type
Language/country
Translate toSQLDatabase nameRange address (static)Report typeScope (Moz)Sort (Moz)
Highlight with colour
Refresh with user account
Returned dataQuery info
21
Budget Tool'
'Budget Tool'!$Y$20:$AU$20
2020-01-22 9:18:452020-01-22 9:18:45Created successfully1579684712576FALSETABLEAWthismonth["ALL_ACCOUNTS`ALL ACCOUNTS"]["Cost"]["Accountname"]["Date"][][]Accountname5050["NO_HEADERS"]{}Budget Tool'!Y20:AU20
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
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