Paid Channel Mix Template 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
3
All the queries created by Supermetrics are stored here, each in its own row.
23
4
15852224
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/Helsinki
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/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
fHKNkJsqww3mesyMzSfGdnoLwpc0QE
Test
Test!$A$2:$E$12
2020-03-10 21:00:14
Created successfully
FALSE0TABLEFAlastmonth
["act_917809321688850`Supermetrics Ads"]
["impressions","clicks","cost","CPC"]
["Date"][][][]10
["ACTION_REPORT_TIME_impression","SHOW_ALL_TIME_VALUES"]
{}Test'!A1:E11
3115073018511608
22
Paid Channel Mix'
'Paid Channel Mix'!$A$59:$C$67
TABLEACthismonthprevperc
["Clicks","Impressions","Spend","CTR_perc","CPC","AveragePosition","Conversions","ConversionRate_perc","CostPerConversion"]
[][][][]
["NO_HEADERS","SHOW_ALL_TIME_VALUES","METRICS_IN_ROWS"]
{}
Paid Channel Mix'!A59:C67
23
Paid Channel Mix'
'Paid Channel Mix'!$A$127:$H$134
TABLETAthismonthprevperc
["clicks","impressions","cost","CTR_perc","CPC","engagements","conversions","conversionsRate_perc"]
[][][][]100010
["NO_HEADERS","SHOW_ALL_TIME_VALUES","METRICS_IN_ROWS"]
{}
Paid Channel Mix'!A127:H134
24
Paid Channel Mix'
'Paid Channel Mix'!$A$38:$C$46
TABLEGAthismonthprevperc
["visits","entrancebouncerate_perc","avgtimeonsite_hms","pageviewspervisit","goalcompletionsall","goalconversionrateall_perc","mcf:assistedConversions","mcf:lastInteractionConversions","mcf:assistedToLastClickRatio"]
[][]
[{"field":"sourceMedium","operator":"==","value":"google / cpc","combineToPrev":";"}]
[]
["AVOID_SAMPLING","METRICS_IN_ROWS"]
{}
Paid Channel Mix'!A38:C46
25
Paid Channel Mix'
'Paid Channel Mix'!$A$73:$C$81
TABLEGAthismonthprevperc
["visits","entrancebouncerate_perc","avgtimeonsite_hms","pageviewspervisit","mcf:assistedConversions","mcf:lastInteractionConversions","mcf:assistedToLastClickRatio","goalcompletionsall","goalconversionrateall_perc"]
[][]
[{"field":"sourceMedium","operator":"==","value":"bing / cpc","combineToPrev":";"}]
[]100010
["AVOID_SAMPLING","METRICS_IN_ROWS"]
{}
Paid Channel Mix'!A73:C81
26
Paid Channel Mix'
'Paid Channel Mix'!$A$105:$C$113
TABLEGAthismonthprevperc
["visits","entrancebouncerate_perc","avgtimeonsite_hms","pageviewspervisit","mcf:assistedConversions","mcf:lastInteractionConversions","mcf:assistedToLastClickRatio","goalcompletionsall","goalconversionrateall_perc"]
[][]
[{"field":"sourceMedium","operator":"==","value":"facebook / cpc","combineToPrev":";"},{"field":"sourceMedium","operator":"==","value":"facebook / paid","combineToPrev":","}]
[]100010
["AVOID_SAMPLING","METRICS_IN_ROWS"]
{}
Paid Channel Mix'!A105:C113
27
Paid Channel Mix'
'Paid Channel Mix'!$A$139:$C$147
TABLEGAthismonthprevperc
["visits","entrancebouncerate_perc","avgtimeonsite_hms","pageviewspervisit","mcf:assistedConversions","mcf:lastInteractionConversions","mcf:assistedToLastClickRatio","goalcompletionsall","goalconversionrateall_perc"]
[][]
[{"field":"sourceMedium","operator":"==","value":"twitter / cpc","combineToPrev":";"},{"field":"sourceMedium","operator":"==","value":"twitter / paid","combineToPrev":","}]
[]100010
["AVOID_SAMPLING","METRICS_IN_ROWS"]
{}
Paid Channel Mix'!A139:C147
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...