forked from pipeline-looker-blocks/facebookads
-
Notifications
You must be signed in to change notification settings - Fork 0
/
insights_country__actions.view.lookml
68 lines (54 loc) · 1.3 KB
/
insights_country__actions.view.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
- view: ad_actions_by_country
sql_table_name: looker_facebook.facebook_ads_insights_country_x__actions
fields:
# - dimension: 1d_click
# type: number
# sql: ${TABLE}.1d_click
#
# - dimension: 1d_view
# type: number
# sql: ${TABLE}.1d_view
#
# - dimension: 28d_click
# type: number
# sql: ${TABLE}.28d_click
#
# - dimension: 28d_view
# type: number
# sql: ${TABLE}.28d_view
#
# - dimension: 7d_click
# type: number
# sql: ${TABLE}.7d_click
#
# - dimension: 7d_view
# type: number
# sql: ${TABLE}.7d_view
- dimension: ad_id
type: string
sql: ${TABLE}._rjm_source_key_ad_id
- dimension: adset_id
type: string
sql: ${TABLE}._rjm_source_key_adset_id
- dimension: campaign_id
type: string
sql: ${TABLE}._rjm_source_key_campaign_id
- dimension_group: date_start
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}._rjm_source_key_date_start
- dimension: action_destination
type: string
sql: ${TABLE}.action_destination
- dimension: action_type
type: string
sql: ${TABLE}.action_type
- dimension: value
type: number
sql: ${TABLE}.value
- measure: count
type: count
drill_fields: []
- measure: total_actions
type: sum
sql: ${TABLE}.value