forked from fivetran/dbt_pardot
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpardot.yml
210 lines (206 loc) · 8.31 KB
/
pardot.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
version: 2
models:
- name: pardot__campaigns
description: Each record represents a campaign in Pardot
columns:
- name: _fivetran_deleted
description: "{{ doc('_fivetran_deleted') }}"
- name: _fivetran_synced
description: "{{ doc('_fivetran_synced') }}"
- name: campaign_id
description: Pardot ID for this campaign
tests:
- unique
- not_null
- name: campaign_name
description: Campaign's name
- name: cost
description: Cost associated to the campaign
- name: count_prospects
description: Number of prospects associated with the campaign
- name: count_opportunities
description: Count of all campaign opportunities
- name: count_opportunities_won
description: Count of all campaign opportunities won
- name: sum_opportunity_amount_won
description: Sum of all campaign opportunities won
- name: count_opportunities_lost
description: Count of all campaign opportunities lost
- name: sum_opportunity_amount_lost
description: Sum of all campaign opportunities lost
- name: pardot__lists
description: Each record represents a list in Pardot.
columns:
- name: _fivetran_synced
description: "{{ doc('_fivetran_synced') }}"
- name: created_timestamp
description: Time list is created in Pardot.
- name: description
description: List's description
- name: list_id
description: Pardot ID of this list
tests:
- unique
- not_null
- name: is_crm_visible
description: If true, list is visible in CRM to add or remove from
- name: is_dynamic
description: If true, list has prospects dynamically added to it via a set of chosen rules
- name: is_public
description: If true, list will show on EPC pages to prospects
- name: name
description: List's name (internal to Pardot)
- name: title
description: List's title (visible to subscribers)
- name: updated_timestamp
description: Last time list was updated
- name: count_activity_emails
description: Count of email activities associated with the members of the list.
- name: count_activity_visits
description: Count of visit activities associated with the members of the list.
- name: most_recent_email_activity_timestamp
description: Timestamp of most recent email activity of a list member
- name: most_recent_visit_activity_timestamp
description: Timestamp of most recent visit activity of a list member
- name: pardot__opportunities
description: Each record represents an opportunity in Pardot.
columns:
- name: _fivetran_synced
description: "{{ doc('_fivetran_synced') }}"
- name: opportunity_id
description: Pardot ID for this opportunity
tests:
- unique
- not_null
- name: campaign_id
description: Pardot ID of the campaign associated with this opportunity
- name: opportunity_name
description: Opportunity's name
- name: amount
description: Opportunity's value
- name: probability
description: Opportunity's probability
- name: opportunity_type
description: Opportunity's type
- name: stage
description: Opportunity's stage
- name: opportunity_status
description: Opportunity's status
- name: closed_timestamp
description: Opportunity's closed date
- name: created_timestamp
description: Time opportunity is created in Pardot
- name: updated_timestamp
description: Last time opportunity was updated in Pardot
- name: count_prospects
description: Number of prospects associated with the opportunity.
- name: pardot__prospects
description: Each record in the table represents a prospect in Pardot.
columns:
- name: _fivetran_deleted
description: "{{ doc('_fivetran_deleted') }}"
- name: _fivetran_synced
description: "{{ doc('_fivetran_synced') }}"
- name: prospect_id
description: Pardot ID for this prospect
tests:
- unique
- not_null
- name: campaign_id
description: Pardot ID of the campaign associated with this prospect
- name: user_id
description: Pardot ID of the user associated with this prospect
- name: salutation
description: Prospect's formal prefix
- name: first_name
description: Prospect's first name
- name: last_name
description: Prospect's last name
- name: email
description: Prospect's email address
- name: password
description: Prospect's password
- name: company
description: Prospect's company
- name: prospect_account_id
description: Prospect's account ID
- name: website
description: Prospect's website URL
- name: job_title
description: Prospect's job title
- name: department
description: Prospect's department
- name: country
description: Prospect's country
- name: address_one
description: Prospect's address, line 1
- name: address_two
description: Prospect's address, line 2
- name: city
description: Prospect's city
- name: state
description: Prospect's US state
- name: territory
description: Prospect's territory
- name: zip
description: Prospect's postal code
- name: phone_number
description: Prospect's phone number
- name: fax
description: Prospect's fax number
- name: prospect_source
description: Prospect's source
- name: annual_revenue
description: Prospect's annual revenue
- name: employees
description: Prospect's number of employees
- name: industry
description: Prospect's industry
- name: years_in_business
description: Prospect's number of years in business
- name: comments
description: Comments about this prospect
- name: notes
description: Notes about this prospect
- name: score
description: Prospect's score
- name: grade
description: Prospect's letter grade
- name: last_activity_at
description: Time stamp of this prospect's latest visitor activity; Time is reported in API user's preferred timezone
- name: recent_interaction
description: Describes the prospect's most recent interaction with Pardot
- name: crm_lead_fid
description: Prospect's lead ID in a supported CRM system
- name: crm_contact_fid
description: Prospect's contact ID in a supported CRM system
- name: crm_owner_fid
description: Prospect's owner ID in a supported CRM system
- name: crm_account_fid
description: Account ID in a supported CRM system
- name: crm_last_sync
description: Last time this prospect was synced with a supported CRM system
- name: crm_url
description: URL to view the prospect within the CRM system
- name: is_do_not_email
description: If value is 1, prospect prefers not to be emailed
- name: is_do_not_call
description: If value is 1, prospect prefers not to be called
- name: opted_out
description: If value is 1, prospect has opted out of marketing communications
- name: is_reviewed
description: If value is 1, prospect has been reviewed
- name: is_starred
description: If value is 1, prospect has been starred
- name: created_timestamp
description: Time prospect is created in Pardot; Time is reported in API user's preferred timezone
- name: updated_timestamp
description: Last time prospect was updated in Pardot; Time is reported in API user's preferred timezone
- name: count_activity_emails
description: Count of email activities associated with the prospect.
- name: count_activity_visits
description: Count of visit activities associated with the prospect.
- name: most_recent_email_activity_timestamp
description: Timestamp of most recent email activity of the prospect.
- name: most_recent_visit_activity_timestamp
description: Timestamp of most recent visit activity of the prospect.