Pardot link
Pardot is a SaaS-based marketing automation application from Salesforce, enabling marketers to create, deploy and manage online promotion campaigns.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | PROSPECT and LIST_MEMBERSHIP tables |
| Custom data | check | PROSPECT and PROSPECT_ACCOUNT tables |
| Data blocking | check | Column level |
| Column hashing | check | |
| Re-sync | check | Connector level |
| History | ||
| API configurable | check | API configuration |
| Priority-first sync | check | EMAIL, VISIT, and VISITOR_ACTIVITY tables |
| Fivetran data models | check | Get the models: source / transform |
| Private networking |
Setup guidelink
Follow our step-by-step Pardot setup guide to connect Pardot with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all Pardot connections.
To zoom, open the ERD in a new window.Schema noteslink
VISITOR_ACTIVITY is an event table, where the type field is out of 34 known events. Notable events are:
- Click
- View
- Error
- Success
- Sent
- Search
- Open
- Unsubscribe Page
- Bounced
- Spam Complaint
For the complete list, refer to the Pardot documentation.
Sync overviewlink
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.