Client Budget Tracker & Alert (Google Ads) by Supermetrics
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBM
1
Supermetrics Queries
2
Queries OK
3
All the queries created by Supermetrics are stored here, each in its own row.
12
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 row
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 ID
Spreadsheet ID
Sheet name
Range address
CreatedUpdatedLast status
Last refresh ID
Results contain sampled data
Execution time (sec)
Object type
Linked chart ID
Data source
Date range type
Start dateEnd dateCompare to
Comparison value type
Accounts/viewsMetricsDimensions
Pivot dimensions
FiltersSegment IDSortMax rows
Max pivot categories
Special settings
Other parameters
Result type
Language/country
Translate toSQLDatabase name
Range address (static)
Report typeScope (Moz)Sort (Moz)
Highlight with colour
Refresh with user account
Returned data
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
Loading...