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 table only |
| Custom Data | check | PROSPECT and PROSPECT_ACCOUNT tables |
| Data Blocking | ||
| Column Hashing | ||
| Re-sync | check | Connector level |
| History | ||
| API Configurable | check | |
| Priority-first sync | check | EMAIL, VISIT, and VISITOR_ACTIVITY tables |
| dbt Package | check | Get the package: source / transform |
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 ERD in 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 notelink
Fivetran cannot sync the permanently deleted records of the PROSPECTS table because the Pardot API doesn’t return these details. Fivetran captures deletes using the prospects that you have moved to the Recycle Bin.