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 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 | ||
| dbt Package |
Setup guide
Follow our step-by-step Pardot setup guide to connect Pardot with your destination using Fivetran connectors.
Schema information
This schema applies to all Pardot connections.
To zoom, open ERD in 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.