forked from fivetran/dbt_hubspot
-
Notifications
You must be signed in to change notification settings - Fork 0
/
engagement_events.yml
297 lines (208 loc) · 8.87 KB
/
engagement_events.yml
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
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
version: 2
models:
- name: hubspot__engagement_calls
description: Each record represents a CALL engagement event.
columns:
- name: _fivetran_synced
description: '{{ doc("_fivetran_synced") }}'
- name: call_duration_milliseconds
description: The length of the call in milliseconds
- name: disposition_id
description: The internal ID for the call outcome.
- name: engagement_id
description: The ID of the engagement.
tests:
- not_null
- unique
- name: external_account_id
description: For calls made in HubSpot, this will be the internal ID of the account used to make the call.
- name: external_id
description: For calls made in HubSpot, this will be the internal ID of the call.
- name: from_number
description: The phone number that was used as the from number.
- name: recording_url
description: The URL of the recording file .
- name: to_number
description: The phone number that was called.
- name: is_active
description: Whether the engagement is currently being shown in the UI.
- name: created_timestamp
description: A timestamp representing when the engagement was created.
- name: occurred_timestamp
description: A timestamp in representing the time that the engagement should appear in the timeline.
- name: owner_id
description: The ID of the engagement's owner.
- name: contact_ids
description: List of contacts related to the engagement.
- name: deal_ids
description: List of deals related to the engagement.
- name: company_ids
description: List of companies related to the engagement.
- name: hubspot__engagement_emails
description: Each record represents an EMAIL engagement event.
columns:
- name: _fivetran_synced
description: '{{ doc("_fivetran_synced") }}'
- name: attached_video_id
description: The ID of the video attached.
- name: email_html
description: The body of the HTML email.
- name: email_send_event_created_timestamp
description: When the SENT event occurred.
- name: email_send_event_id
description: The ID of the related SENT email event.
- name: email_status
description: The status of the engagement.
- name: email_subject
description: The subject of the email.
- name: email_text
description: The body of the text-only email.
- name: engagement_id
description: The ID of the engagement.
tests:
- not_null
- unique
- name: error_message
description: The error message, if applicable.
- name: from_email
description: The email address of the sender.
- name: from_first_name
description: The first name of the sender.
- name: from_last_name
description: The last name of the sender.
- name: media_processing_status
description: The processing status of the media content in the email.
- name: message_id
description: The ID of the message.
- name: sent_via
description: How the email was sent.
- name: thread_id
description: The ID of the email thread.
- name: was_attached_video_opened
description: Whether the the attached video was opened.
- name: was_attached_video_watched
description: Whether the the attached video was watched.
- name: is_active
description: Whether the engagement is currently being shown in the UI.
- name: created_timestamp
description: A timestamp representing when the engagement was created.
- name: occurred_timestamp
description: A timestamp in representing the time that the engagement should appear in the timeline.
- name: owner_id
description: The ID of the engagement's owner.
- name: contact_ids
description: List of contacts related to the engagement.
- name: deal_ids
description: List of deals related to the engagement.
- name: company_ids
description: List of companies related to the engagement.
- name: hubspot__engagement_meetings
description: Each record represents a MEETING engagement event.
columns:
- name: _fivetran_synced
description: '{{ doc("_fivetran_synced") }}'
- name: end_timestamp
description: A timestamp representing the end time of the meeting
- name: engagement_id
description: The ID of the engagement.
tests:
- not_null
- unique
- name: external_url
description: The external URL of the engagement.
- name: meeting_notes
description: The details or body of the meeting.
- name: meeting_outcome
description: The meeting outcome.
- name: meeting_title
description: The title or subject of the meeting
- name: source
description: The source of the meeting.
- name: source_id
description: The internal ID of the meeting source.
- name: start_timestamp
description: A timestamp representing the start time of the meeting
- name: web_conference_meeting_id
description: The ID of the web conference meeting.
- name: is_active
description: Whether the engagement is currently being shown in the UI.
- name: created_timestamp
description: A timestamp representing when the engagement was created.
- name: occurred_timestamp
description: A timestamp in representing the time that the engagement should appear in the timeline.
- name: owner_id
description: The ID of the engagement's owner.
- name: contact_ids
description: List of contacts related to the engagement.
- name: deal_ids
description: List of deals related to the engagement.
- name: company_ids
description: List of companies related to the engagement.
- name: hubspot__engagement_notes
description: Each record represents a NOTE engagement event.
columns:
- name: _fivetran_synced
description: '{{ doc("_fivetran_synced") }}'
- name: engagement_id
description: The ID of the engagement.
tests:
- not_null
- unique
- name: note
description: The body of the note. The body has a limit of 65536 characters.
- name: is_active
description: Whether the engagement is currently being shown in the UI.
- name: created_timestamp
description: A timestamp representing when the engagement was created.
- name: occurred_timestamp
description: A timestamp in representing the time that the engagement should appear in the timeline.
- name: owner_id
description: The ID of the engagement's owner.
- name: contact_ids
description: List of contacts related to the engagement.
- name: deal_ids
description: List of deals related to the engagement.
- name: company_ids
description: List of companies related to the engagement.
- name: hubspot__engagement_tasks
description: Each record represents a TASK engagement event.
columns:
- name: _fivetran_synced
description: '{{ doc("_fivetran_synced") }}'
- name: completion_timestamp
description: The timestamp the task was completed.
- name: engagement_id
description: The ID of the engagement.
tests:
- not_null
- unique
- name: for_object_type
description: One of CONTACT or COMPANY, what object type the task is for.
- name: is_all_day
description: Whether it is an all day task.
- name: priority
description: The priority of the task.
- name: probability_to_complete
description: The probability that the task will be completed.
- name: task_note
description: The body or details of the task.
- name: task_status
description: The status of the task.
- name: task_subject
description: The subject or title of the task
- name: task_type
description: The type of task
- name: is_active
description: Whether the engagement is currently being shown in the UI.
- name: created_timestamp
description: A timestamp representing when the engagement was created.
- name: occurred_timestamp
description: A timestamp in representing the time that the engagement should appear in the timeline.
- name: owner_id
description: The ID of the engagement's owner.
- name: contact_ids
description: List of contacts related to the engagement.
- name: deal_ids
description: List of deals related to the engagement.
- name: company_ids
description: List of companies related to the engagement.