Pardot
Pardot is a SaaS-based marketing automation application from Salesforce, enabling marketers to create, deploy and manage online promotion campaigns.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | PROSPECT and LIST_MEMBERSHIP tables |
| History mode | ||
| Custom data | check | PROSPECT and PROSPECT_ACCOUNT tables |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | EMAIL, EXTERNAL_ACTIVITY, VISIT, VISITOR_ACTIVITY and VISITOR_PAGE_VIEW tables |
| Fivetran data models | check | |
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step Pardot setup guide to connect Pardot with your destination using Fivetran connectors.
Sync overview
Sync strategy for PROSPECT table
We capture deletes using the prospect records that you have moved to the recycle bin in the source. We set the _FIVETRAN_DELETED column for the records in the recycle bin to true. For prospects deleted from the Recycle Bin, we set the is_permanently_deleted column to true. On weekends, we perform a full re-sync of the PROSPECT table to capture the permanently deleted prospect records.
Sync strategy for TAG_OBJECT table
We sync only those objects that have associated tags.
Schema information
This schema applies to all Pardot connections.
To zoom, open the ERD in a new window.Schema notes
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.
Limit historical data sync
In the setup form, you can set a limit on the amount of historical data you want to sync during historical syncs and initial syncs. This limit applies to the following tables:
EMAILEXTERNAL_ACTIVITYLIST_MEMBERSHIPVISITOR_ACTIVITYVISITOR_PAGE_VIEW