forked from llooker/improvado
-
Notifications
You must be signed in to change notification settings - Fork 0
/
template_channel_perfomance.dashboard.lookml
261 lines (256 loc) · 7.22 KB
/
template_channel_perfomance.dashboard.lookml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
- dashboard: template_channel_perfomance
title: Template Agency Command Center
layout: newspaper
filters:
- name: Date Range
title: Date Range
type: date_filter
default_value: 2016/08/01 to 2016/10/01
allow_multiple_values: true
required: false
- name: Clients by substring
title: Clients by substring
type: string_filter
default_value: "%etl%"
allow_multiple_values: true
required: false
- name: Select Metric
title: Select Metric
type: field_filter
default_value: impressions
allow_multiple_values: true
required: false
model: template_project
explore: campaign_bindings
listens_to_filters: []
field: campaign_bindings.metric_selector
- name: Select Segment
title: Select Segment
type: field_filter
default_value: binding^_name
allow_multiple_values: true
required: false
model: template_project
explore: campaign_bindings
listens_to_filters: []
field: campaign_bindings.segment_selector
elements:
- title: Client Overview
name: Client Overview
model: template_project
explore: campaign_bindings
type: table
fields:
- campaign_bindings.binding_name
- campaign_bindings.impressions
- campaign_bindings.clicks
- campaign_bindings.ctr
- campaign_bindings.cost
- campaign_bindings.cpc
sorts:
- campaign_bindings.impressions desc
limit: 8
total: true
show_view_names: true
show_row_numbers: true
truncate_column_names: false
hide_totals: false
hide_row_totals: false
table_theme: white
limit_displayed_rows: false
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
stacking: ''
show_value_labels: false
label_density: 25
legend_position: center
x_axis_gridlines: false
y_axis_gridlines: true
point_style: none
y_axis_combined: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
x_axis_scale: auto
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
series_types: {}
series_labels:
campaign_bindings.binding_name: Client name
campaign_bindings.impressions: Impressions
campaign_bindings.clicks: Clicks
campaign_bindings.ctr: Click Through Rate
campaign_bindings.cost: Spend
campaign_bindings.cpc: Cost Per Click
listen:
Date Range: campaign_bindings.date_date
Clients by substring: campaign_bindings.binding_name
row: 6
col: 0
width: 12
height: 6
- title: KPIs Over Time
name: KPIs Over Time
model: template_project
explore: campaign_bindings
type: looker_line
fields:
- campaign_bindings.metric
- campaign_bindings.segment
- campaign_bindings.date_date
pivots:
- campaign_bindings.segment
sorts:
- campaign_bindings.segment
limit: 500
stacking: ''
show_value_labels: false
label_density: 25
legend_position: center
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
point_style: none
limit_displayed_rows: false
y_axis_combined: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
x_axis_scale: auto
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
show_null_points: true
interpolation: linear
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
ordering: none
show_null_labels: false
show_row_numbers: true
truncate_column_names: false
hide_totals: false
hide_row_totals: false
table_theme: editable
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
series_types: {}
colors:
- 'palette: Santa Cruz'
series_colors: {}
limit_displayed_rows_values:
show_hide: hide
first_last: first
num_rows: 0
y_axes:
- label: Spend
orientation: left
series:
- id: digital analytics consulting - campaign_bindings.cost
name: digital analytics consulting
axisId: campaign_bindings.cost
- id: digital marketing analysis tools - campaign_bindings.cost
name: digital marketing analysis tools
axisId: campaign_bindings.cost
- id: digital marketing reporting tools - campaign_bindings.cost
name: digital marketing reporting tools
axisId: campaign_bindings.cost
- id: tools of digital marketing - campaign_bindings.cost
name: tools of digital marketing
axisId: campaign_bindings.cost
showLabels: true
showValues: true
valueFormat: ''
unpinAxis: false
tickDensity: default
tickDensityCustom: 5
type: linear
x_axis_label: Dates
hidden_fields: []
listen:
Date Range: campaign_bindings.date_date
Clients by substring: campaign_bindings.binding_name
Select Metric: campaign_bindings.metric_selector
Select Segment: campaign_bindings.segment_selector
row: 0
col: 0
width: 24
height: 6
- title: Platforms Overview
name: Platforms Overview
model: template_project
explore: campaign_bindings
type: table
fields:
- campaign_bindings.product_name
- campaign_bindings.impressions
- campaign_bindings.clicks
- campaign_bindings.ctr
- campaign_bindings.cost
- campaign_bindings.cpc
sorts:
- campaign_bindings.impressions desc
limit: 500
total: true
show_view_names: true
show_row_numbers: true
truncate_column_names: false
hide_totals: false
hide_row_totals: false
table_theme: white
limit_displayed_rows: false
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
stacking: ''
show_value_labels: false
label_density: 25
legend_position: center
x_axis_gridlines: false
y_axis_gridlines: true
point_style: none
y_axis_combined: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
x_axis_scale: auto
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
series_types: {}
series_labels:
campaign_bindings.product_name: Platform name
campaign_bindings.impressions: Impressions
campaign_bindings.clicks: Clicks
campaign_bindings.ctr: Click Through Rate
campaign_bindings.cost: Spend
campaign_bindings.cpc: Cost Per Click
listen:
Date Range: campaign_bindings.date_date
Clients by substring: campaign_bindings.binding_name
row: 6
col: 12
width: 12
height: 6