This integration is powered by Singer's Pardot tap and certified by Stitch. Check out and contribute to the repo on GitHub.
For support, contact Stitch support.
Pardot integration summary
Stitch’s Pardot integration replicates data using the Pardot API. Refer to the Schema section for a list of objects available for replication.
Pardot feature snapshot
A high-level look at Stitch's Pardot (v1) integration, including release status, useful links, and the features supported in Stitch.
STITCH | |||
Release status |
Released on February 12, 2020 |
Supported by | |
Stitch plan |
Standard |
API availability |
Available |
Singer GitHub repository | |||
REPLICATION SETTINGS | |||
Anchor Scheduling |
Supported |
Advanced Scheduling |
Supported |
Table-level reset |
Unsupported |
Configurable Replication Methods |
Unsupported |
DATA SELECTION | |||
Table selection |
Supported |
Column selection |
Supported |
Select all |
Supported |
||
TRANSPARENCY | |||
Extraction Logs |
Supported |
Loading Reports |
Supported |
Connecting Pardot
Pardot setup requirements
To set up Pardot in Stitch, you need:
-
A user with a preferred timezone of UTC. This is required to ensure you don’t encounter Extraction errors during Daylight Savings Time, as some Replication Key fields used by Stitch are reported in Pardot using the user’s preferred timezone. By using UTC, this ensures that time data is accurately reported during extraction. Otherwise, you might encounter Extraction errors during Daylight Savings Time.
Step 1: Retrieve your Pardot business unit ID
- Sign into your Salesforce account.
- Navigate to the Setup page.
- Enter
Pardot Account Setup
in the Quick Find. - The Pardot setup page will display. Copy your 18-charater Pardot Business Unit ID and keep it readily available for the next step.
Step 2: Add Pardot as a Stitch data source
- Sign into your Stitch account.
-
On the Stitch Dashboard page, click the Add Integration button.
-
Click the Pardot icon.
-
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.
For example, the name “Stitch Pardot” would create a schema called
stitch_pardot
in the destination. Note: Schema names cannot be changed after you save the integration. - In the Pardot Business Unit Id field, paste your Business Unit ID that you copied in Step 1.
Step 3: Define the historical replication start date
The Sync Historical Data setting defines the starting date for your Pardot integration. This means that data equal to or newer than this date will be replicated to your data warehouse.
Change this setting if you want to replicate data beyond Pardot’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.
Step 4: Create a replication schedule
In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.
Pardot integrations support the following replication scheduling methods:
-
Advanced Scheduling using Cron (Advanced or Premium plans only)
To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.
Step 5: Authorize Stitch to access Pardot
- When finished in the Integration Settings page, click the Authorize button. You’ll be prompted to sign into your Pardot account.
- Sign into your Pardot account.
- After the authorization process is successfully completed, you’ll be directed back to Stitch.
- Click All Done.
Step 6: Set objects to replicate
The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.
Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.
For Pardot integrations, you can select:
-
Individual tables and columns
-
All tables and columns
Click the tabs to view instructions for each selection method.
- In the integration’s Tables to Replicate tab, locate a table you want to replicate.
-
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
-
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
- Repeat this process for all the tables and columns you want to replicate.
- When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
- Click into the integration from the Stitch Dashboard page.
-
Click the Tables to Replicate tab.
- In the list of tables, click the box next to the Table Names column.
-
In the menu that displays, click Track all Tables and Fields:
- Click the Finalize Your Selections button at the bottom of the page to save your data selections.
Initial and historical replication jobs
After you finish setting up Pardot, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.
For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.
Free historical data loads
The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.
Pardot table reference
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for version 1 of this integration.
This is the latest version of the Pardot integration.
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs
> customers
), while case is maintained in PostgreSQL destinations (CusTomERs
> CusTomERs
). Refer to the Loading Guide for your destination for more info.
campaigns
Replication Method : |
Key-based Incremental |
Replication Key |
id |
Primary Key |
id |
API endpoint : |
The campaigns
table contains info about the campaigns in your Pardot account.
id
The ID of the campaign. Reference: |
name
The name of the campaign. |
cost
The cost associated to the campaign. |
email_clicks
Replication Method : |
Key-based Incremental |
Replication Key |
created_at |
Primary Key |
id |
API endpoint : |
The email_clicks
table contains info about email click events.
id
The email click ID. |
created_at
The time that the email click occurred. |
drip_program_action_id
The ID for the drip program action associated with the email click. |
email_template_id
The ID for the email template associated with the email click. Reference: |
list_email_id
The ID for the list email associated with the email click. Reference: |
prospect_id
The ID of the prospect associated with the email click. Reference: |
tracker_redirect_id
The ID of the tracker redirect associated with the email click. |
url
The URL of the email click. |
Replication Method : |
Key-based Incremental |
Replication Key |
updated_at |
Primary Key |
id |
API endpoint : |
The lists
table contains info about the lists in your Pardot account.
id
The list ID. Reference: |
updated_at
The last time the list was updated. |
created_at
The time the list was created. |
description
The description of the list. |
is_crm_visible
If |
is_dynamic
If |
is_public
If |
name
The name of the list. |
title
The title of the list, as it displays to subscribers. |
list_memberships
Replication Method : |
Key-based Incremental |
Replication Key |
id : list_id : updated_at |
Primary Key |
id |
API endpoint : |
The list_memberships
table contains info about list memberships.
Note: To replicate this table, the lists
table must also be set to replicate.
id
The list membership ID. Reference: |
list_id
The ID of the list associated with this membership. Reference: |
updated_at
The time the membership was last updated. |
created_at
The time the membership was created in Pardot. |
opted_out
If |
prospect_id
The ID of the prospect associated with the membership. Reference: |
opportunities
Replication Method : |
Key-based Incremental |
Replication Key |
id : updated_at |
Primary Key |
id |
API endpoint : |
The opportunities
table contains info about the opportunities in your Pardot account.
id
The ID of the opportunity. Reference: |
updated_at
The time the opportunity was last updated. |
campaign_id
The ID of the campaign associated with the opportunity. Reference: |
closed_at
The time the opportunity was closed. |
created_at
The time the opportunity was created. |
name
The name of the opportunity. |
probability
The probability of the opportunity. This will be a value between |
stage
The stage of the opportunity. |
status
The status of the opportunity. Possible values are:
|
type
The type of the opportunity. |
value
The value of the opportunity. |
prospects
Replication Method : |
Key-based Incremental |
Replication Key |
updated_at |
Primary Key |
id |
API endpoint : |
The prospects
table contains info about the prospects in your Pardot account.
id
The prospect ID. Reference: |
updated_at
The last time the prospect was updated. |
address_one
The first line of the prospect’s address. |
address_two
The second line of the prospect’s address. |
annual_revenue
The prospect’s annual revenue. |
campaign_id
The ID of the campaign associated with the prospect. Reference: |
city
The city of the prospect’s address. |
comments
Comments about the prospect. |
company
The prospect’s company. |
country
The country of the prospect’s address. |
created_at
The time the prospect was created. |
crm_account_fid
The prospect’s account ID in a supported CRM system. |
crm_contact_fid
The prospect’s contact ID in a supported CRM system. |
crm_last_sync
The last time the prospect was synced with a supported CRM system. |
crm_lead_fid
The prospect’s lead ID in a supported CRM system. |
crm_owner_fid
The prospect’s owner ID in a supported CRM system. |
crm_url
The URL to view the prospect within the CRM system. |
department
The department of the prospect. |
email
The prospect’s email address. |
employees
The prospect’s number of employees. |
fax
The prospect’s fax number. |
first_name
The first name of the prospect. |
grade
The prospect’s letter grade. |
industry
The prospect’s industry. |
is_do_not_call
If |
is_do_not_email
If |
is_reviewed
If |
is_starred
If |
job_title
The prospect’s job title. |
last_activity_at
The time of the prospect’s last activity. |
last_name
The prospect’s last name. |
notes
Notes about the prospect. |
opted_out
If |
password
The prospect’s password. |
phone
The prospect’s phone number. |
prospect_account_id
The prospect’s account ID. |
recent_interaction
The prospect’s most recent interaction with Pardot. |
salutation
The prospect’s salutation. |
score
The prospect’s score. |
source
The source of the prospect. |
state
The US state of the prospect’s address. |
territory
The territory of the prospect’s address. |
website
The prospect’s website. |
years_in_business
The prospect’s number of years in business. |
zip
The prospect’s postal code. |
prospect_accounts
Replication Method : |
Key-based Incremental |
Replication Key |
updated_at |
Primary Key |
id |
API endpoint : |
The prospect_accounts
table contains info about prospect accounts.
id
The ID of the prospect account. |
||||||||||
updated_at
The time the prospect account was last updated. |
||||||||||
assigned_to
Details about who the prospect account is assigned to.
|
||||||||||
created_at
The time the prospect account was created. |
||||||||||
name
The name of the prospect account. |
Replication Method : |
Key-based Incremental |
Replication Key |
id : updated_at |
Primary Key |
id |
API endpoint : |
The users
table contains info about the users in your Pardot account.
id
The user ID. Reference: |
updated_at
The time the user was last updated. |
created_at
The time the user was created. |
email
The user’s email address. |
first_name
The user’s first name. |
job_title
The user’s job title. |
last_name
The user’s last name. |
role
The user’s role. |
visitors
Replication Method : |
Key-based Incremental |
Replication Key |
updated_at |
Primary Key |
id |
API endpoint : |
The visitors
table contains info about visitors.
id
The visitor ID. Reference: |
updated_at
The time the visitor was last updated. |
campaign_parameter
The campaign parameter ( |
content_parameter
The content parameter ( |
created_at
The time the visitor was created. |
hostname
The visitor’s hostname. |
ip_address
The visitor’s IP address. |
medium_parameter
The medium parameter ( |
page_view_count
The number of page views by this visitor. |
source_parameter
The source parameter ( |
term_parameter
The term parameter ( |
visitor_activities
Replication Method : |
Key-based Incremental |
Replication Key |
id |
Primary Key |
id |
API endpoint : |
The visitor_activities
table contains info about visitor activities.
id
The visitor activity ID. |
campaign
TODO |
created_at
The time the visitor activity was created. |
details
Details about the visitor activity. |
email_id
The ID of the email associated with the visitor activity. |
email_template_id
The ID of the email template associated with the visitor activity. Reference: |
file_id
The ID of the file associated with the visitor activity. |
form_handler_id
The ID of the form handler associated with the visitor activity. |
form_id
The ID of the form associated with the visitor activity. |
landing_page_id
The ID of the landing page associated with the visitor activity. |
list_email_id
The ID of the list email associated with the visitor activity. Reference: |
multivariate_test_variation_id
The ID of the multivariate test variation associated with the visitor activity. |
paid_search_id_id
The ID of the paid search ad associated with the visitor activity. |
prospect_id
The ID of the prospect associated with the visitor activity. Reference: |
site_search_query_id
The ID of the site search query associated with the visitor activity. |
type
The type of the visitor activity. Refer to Pardot’s documentation for a full list of possible values. |
type_name
The type name of the visitor activity. Refer to Pardot’s documentation for a full list of possible values. |
visitor_id
The ID of the visitor. Reference: |
visitor_page_view_id
The ID of the visitor page view associated with the visitor activity. |
visits
Replication Method : |
Key-based Incremental |
Replication Key |
id : updated_at |
Primary Key |
id |
API endpoint : |
The visits
table contains info about visits.
Note: To replicate this table, you must also set the visitors
table to replicate.
id
The ID of the visit. Reference: |
|||||
updated_at
The time the visit was last updated. |
|||||
campaign_parameter
The campaign parameter ( |
|||||
content_parameter
The content parameter ( |
|||||
created_at
The time the visit was created. |
|||||
duration_in_seconds
The length of the visit, in seconds. |
|||||
first_visitor_page_view_at
The time of the first page view for this visit. |
|||||
last_visitor_page_view_at
The time of the last page view for this visit. |
|||||
medium_parameter
The medium parameter ( |
|||||
prospect_id
The ID of the prospect associated with the visit. Reference: |
|||||
source_parameter
The source parameter ( |
|||||
term_parameter
The term parameter ( |
|||||
visitor_id
The ID of the visitor associated with the visit. Reference: |
|||||
visitor_page_view_count
The number of page views for this visit. |
|||||
visitor_page_views
Details about page views during the visit.
|
Related | Troubleshooting |
Questions? Feedback?
Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.