Pardot
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect Pardot to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Connect Salesforce Marketing Cloud Account Engagement (formerly Pardot) to pull your marketing data into the PostHog Data warehouse.
Connect a Salesforce account that has access to Account Engagement, then enter the ID of the business unit you want to sync.
Configuration
| Option | Description |
|---|---|
Salesforce accountType: oauth Required: True | |
EnvironmentType: select Required: True | Choose sandbox if your business unit belongs to a sandbox, demo or developer org. |
Business unit IDType: text Required: True | The 18-character ID starting with |
Linking Pardot to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Pardot
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
prospects | A person tracked in Account Engagement, with their profile, scoring and activity timestamps. | Incremental, Full refresh | createdAt, updatedAt | — |
prospect_accounts | A company record that prospects are grouped under, mirroring a Salesforce account. | Full refresh | — | — |
lists | A static or dynamic list of prospects used for sending and segmentation. | Incremental, Full refresh | createdAt, updatedAt | — |
list_memberships | The membership of one prospect on one list, including their opt-out state. | Incremental, Full refresh | createdAt, updatedAt | — |
campaigns | A marketing campaign that prospects and assets are attributed to. | Incremental, Full refresh | createdAt, updatedAt | — |
opportunities | A sales opportunity synced from Salesforce and linked to Account Engagement campaigns. | Incremental, Full refresh | createdAt, updatedAt | — |
users | A user of the Account Engagement business unit. | Incremental, Full refresh | createdAt, updatedAt | — |
visits | A browsing session on your tracked site, grouped from a visitor's page views. | Incremental, Full refresh | createdAt, updatedAt | — |
visitors | An anonymous or identified browser tracked by the Account Engagement tracking code. | Incremental, Full refresh | createdAt, updatedAt | — |
visitor_activities | A single tracked action by a prospect or visitor, such as a form submit, email click or page view. | Incremental, Full refresh | createdAt, updatedAt | — |
custom_fields | A custom prospect field defined in the business unit. | Incremental, Full refresh | createdAt, updatedAt | — |
forms | An Account Engagement form used to capture prospect submissions. | Full refresh | — | — |
list_emails | A one-off email sent to lists of prospects. | Full refresh | — | — |