-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathevent_content_view.view.lookml
178 lines (137 loc) · 3.57 KB
/
event_content_view.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
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
- view: event_content_view
sql_table_name: qa.event_content_view
fields:
- dimension: id
primary_key: true
type: string
sql: ${TABLE}.id
- dimension: anonymous_id
type: string
sql: ${TABLE}.anonymous_id
- dimension: authors_name
type: string
sql: ${TABLE}.authors_name
- dimension: content_content_id
type: int
sql: ${TABLE}.content_content_id
- dimension: content_content_slug
type: string
sql: ${TABLE}.content_content_slug
- dimension: content_content_type
type: string
sql: ${TABLE}.content_content_type
- dimension: content_id
type: int
sql: ${TABLE}.content_id
- dimension: content_issue_id
type: int
sql: ${TABLE}.content_issue_id
- dimension: content_issue_name
type: string
sql: ${TABLE}.content_issue_name
- dimension: content_partner_id
type: int
sql: ${TABLE}.content_partner_id
- dimension: content_partner_name
type: string
sql: ${TABLE}.content_partner_name
- dimension: content_slug
type: string
sql: ${TABLE}.content_slug
- dimension: content_type
type: string
sql: ${TABLE}.content_type
- dimension: context_campaign_medium
type: string
sql: ${TABLE}.context_campaign_medium
- dimension: context_campaign_name
type: string
sql: ${TABLE}.context_campaign_name
- dimension: context_campaign_source
type: string
sql: ${TABLE}.context_campaign_source
- dimension: context_ip
type: string
sql: ${TABLE}.context_ip
- dimension: context_library_name
type: string
sql: ${TABLE}.context_library_name
- dimension: context_library_version
type: string
sql: ${TABLE}.context_library_version
- dimension: context_page_path
type: string
sql: ${TABLE}.context_page_path
- dimension: context_page_referrer
type: string
sql: ${TABLE}.context_page_referrer
- dimension: context_page_search
type: string
sql: ${TABLE}.context_page_search
- dimension: context_page_title
type: string
sql: ${TABLE}.context_page_title
- dimension: context_page_url
type: string
sql: ${TABLE}.context_page_url
- dimension: context_user_agent
type: string
sql: ${TABLE}.context_user_agent
- dimension: event
type: string
sql: ${TABLE}.event
- dimension: event_text
type: string
sql: ${TABLE}.event_text
- dimension: issue_id
type: int
sql: ${TABLE}.issue_id
- dimension: issue_name
type: string
sql: ${TABLE}.issue_name
- dimension_group: original_timestamp
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.original_timestamp
- dimension: partner_id
type: int
sql: ${TABLE}.partner_id
- dimension: partner_name
type: string
sql: ${TABLE}.partner_name
- dimension_group: received
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.received_at
- dimension_group: sent
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.sent_at
- dimension_group: timestamp
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.timestamp
- dimension: user_id
type: string
# hidden: true
sql: ${TABLE}.user_id
- dimension: uuid
type: int
sql: ${TABLE}.uuid
- measure: count
type: count
drill_fields: detail*
# ----- Sets of fields for drilling ------
sets:
detail:
- id
- partner_name
- issue_name
- context_campaign_name
- authors_name
- context_library_name
- content_partner_name
- content_issue_name
- users.last_name
- users.first_name
- users.id