Pardot is a SaaS-based marketing automation application from Salesforce, enabling marketers to create, deploy and manage online promotion campaigns.
|Capture deletes||check|| |
|Custom data||check|| |
|Data blocking||check||Column level|
|API configurable||check||API configuration|
|Priority-first sync||check|| |
|Fivetran data models||check||Get the models: source / transform|
Follow our step-by-step Pardot setup guide to connect Pardot with your destination using Fivetran connectors.
This schema applies to all Pardot connections.To zoom, open the ERD in a new window.
VISITOR_ACTIVITY is an event table, where the
type field is out of 34 known events. Notable events are:
- Unsubscribe Page
- Spam Complaint
For the complete list, refer to the Pardot documentation.
Sync strategy for PROSPECT tablelink
We capture deletes using the prospects that you have moved to the Recycle Bin. We set the
_FIVETRAN_DELETED column for such records to
true. For prospects that are deleted from the Recycle Bin, we set the
is_permanently_deleted column to
true. We perform a full re-sync of the
PROSPECT table on weekends to capture the permanently deleted prospect records.
Sync strategy for TAG_OBJECT tablelink
We sync only those objects that have associated tags.