-
Notifications
You must be signed in to change notification settings - Fork 27
/
placement_and_device_insights.dashboard.lookml
174 lines (166 loc) · 6.43 KB
/
placement_and_device_insights.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
- dashboard: placement_and_device_insights
title: Placement and Device Insights
layout: grid
rows:
- elements: [cpc_ctr_frequency, cpp_cpm]
height: 500
- elements: [top_level_avgs, top_level_totals]
height: 200
- elements: [reach_v_clicks, cpa_v_actions]
height: 500
filters:
- name: placement
type: field_filter
explore: ad_insights_by_placement_and_device
field: ad_insights_by_placement_and_device.placement
- name: device
type: field_filter
explore: ad_insights_by_placement_and_device
field: ad_insights_by_placement_and_device.impression_device
elements:
- name: cpc_ctr_frequency
title: CPC, CTR, and frequency by device
type: looker_column
model: facebook
explore: ad_insights_by_placement_and_device
dimensions: [ad_insights_by_placement_and_device.impression_device]
measures: [ad_insights_by_placement_and_device.avg_cpc, ad_insights_by_placement_and_device.avg_ctr,
ad_insights_by_placement_and_device.avg_frequency]
sorts: [ad_insights_by_placement_and_device.avg_cpc desc]
limit: 500
column_limit: 50
stacking: ''
colors: ['#FFCC00', '#1E2023', '#3399CC', '#CC3399', '#66CC66', '#999999', '#FF4E00', '#A2ECBA', '#9932CC', '#0000CD']
show_value_labels: false
label_density: 25
legend_position: center
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: true
limit_displayed_rows: false
y_axis_combined: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
show_x_axis_label: true
show_x_axis_ticks: true
x_axis_scale: auto
y_axis_scale_mode: linear
show_null_labels: false
- name: cpp_cpm
title: CPP and CPM by device
type: looker_bar
model: facebook
explore: ad_insights_by_placement_and_device
dimensions: [ad_insights_by_placement_and_device.impression_device]
measures: [ad_insights_by_placement_and_device.avg_cpp, ad_insights_by_placement_and_device.avg_cpm]
sorts: [ad_insights_by_placement_and_device.avg_cpp desc]
limit: 500
column_limit: 50
stacking: ''
colors: ['#FFCC00', '#1E2023', '#3399CC', '#CC3399', '#66CC66', '#999999', '#FF4E00', '#A2ECBA', '#9932CC', '#0000CD']
show_value_labels: false
label_density: 25
legend_position: center
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: true
limit_displayed_rows: false
y_axis_combined: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
show_x_axis_label: true
show_x_axis_ticks: true
x_axis_scale: auto
y_axis_scale_mode: linear
show_null_labels: false
- name: top_level_avgs
title: Top level averages
type: looker_single_record
model: facebook
explore: ad_insights_by_placement_and_device
measures: [ad_insights_by_placement_and_device.avg_cpc, ad_insights_by_placement_and_device.avg_cpm,
ad_insights_by_placement_and_device.avg_cpp, ad_insights_by_placement_and_device.avg_ctr,
ad_insights_by_placement_and_device.avg_frequency]
sorts: [ad_insights_by_placement_and_device.avg_cpc desc]
limit: 500
column_limit: 50
show_view_names: true
- name: top_level_totals
title: Top level totals
type: looker_single_record
model: facebook
explore: ad_insights_by_placement_and_device
measures: [ad_insights_by_placement_and_device.total_reach, ad_insights_by_placement_and_device.total_actions,
ad_insights_by_placement_and_device.total_clicks, ad_insights_by_placement_and_device.total_impressions,
ad_insights_by_placement_and_device.total_spend]
sorts: [ad_insights_by_placement_and_device.total_reach desc]
limit: 500
column_limit: 50
show_view_names: true
- name: reach_v_clicks
title: Reach v. clicks by placement and device
type: looker_scatter
model: facebook
explore: ad_insights_by_placement_and_device
dimensions: [ad_insights_by_placement_and_device.impression_device, ad_insights_by_placement_and_device.placement]
measures: [ad_insights_by_placement_and_device.total_reach, ad_insights_by_placement_and_device.total_clicks]
hidden_fields: [ad_insights_by_placement_and_device.impression_device, ad_insights_by_placement_and_device.placement]
sorts: [ad_insights_by_placement_and_device.total_reach desc]
limit: 500
column_limit: 50
stacking: ''
colors: ['#FFCC00', '#1E2023', '#3399CC', '#CC3399', '#66CC66', '#999999', '#FF4E00', '#A2ECBA', '#9932CC', '#0000CD']
show_value_labels: false
label_density: 25
legend_position: center
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: true
limit_displayed_rows: false
y_axis_combined: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
show_x_axis_label: true
show_x_axis_ticks: true
x_axis_scale: auto
y_axis_scale_mode: linear
show_null_points: true
point_style: circle
- name: cpa_v_actions
title: CPA v. actions by placement and device
type: looker_scatter
model: facebook
explore: ad_insights_by_placement_and_device
dimensions: [ad_insights_by_placement_and_device.impression_device, ad_insights_by_placement_and_device.placement]
measures: [ad_insights_by_placement_and_device.total_spend, ad_insights_by_placement_and_device.total_actions]
dynamic_fields:
- table_calculation: cost_per_action
label: Cost per action
expression: ${ad_insights_by_placement_and_device.total_spend} / ${ad_insights_by_placement_and_device.total_actions}
hidden_fields: [ad_insights_by_placement_and_device.impression_device, ad_insights_by_placement_and_device.total_spend,
ad_insights_by_placement_and_device.placement]
sorts: [ad_insights_by_placement_and_device.total_spend desc]
limit: 500
column_limit: 50
stacking: ''
colors: ['#FFCC00', '#1E2023', '#3399CC', '#CC3399', '#66CC66', '#999999', '#FF4E00', '#A2ECBA', '#9932CC', '#0000CD']
show_value_labels: false
label_density: 25
legend_position: center
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: true
limit_displayed_rows: false
y_axis_combined: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
show_x_axis_label: true
show_x_axis_ticks: true
x_axis_scale: auto
y_axis_scale_mode: linear
show_null_points: true
point_style: circle