| Release Status | Released | Availability | Free |
| Status Page | Pardot Status Page | Default Historical Sync | 28 days |
| Whitelist Tables/Columns | Unsupported/Unsupported | Default Replication Frequency | 30 minutes |
| Full Table Endpoints | 0 | Incremental Endpoints | 9 |
| Destination Incompatibilities | None | ||
Connecting Pardot
Connecting your Pardot data to Stitch is a three-step process:
- Retrieve your Pardot API User Key
- Add Pardot as a Stitch data source
- Define the Replication Frequency
Retrieving Your Pardot API User Key
- Sign into your Pardot account.
- Hover over the User menu - it’s where your email address is displayed, in the upper right-hand corner of the screen.
- In the dropdown menu that displays, click the Settings option. Your user information will display.
- Locate the API User Key field.
Leave this page open for now - you’ll need it to complete the setup in Stitch.
Add Pardot as a Stitch Data Source
- On the Stitch Dashboard page, click the Add an Integration button.
-
Click the Pardot icon.
-
Enter a name for the integration. This is the name that will display on the for the integration; it’ll also be used to create the schema in your data warehouse.
For example, the name “Stitch Pardot” would create a schema called
stitch_pardotin the data warehouse. This schema is where all the tables for this integration will be stored. - In the Pardot User Key field, paste your API User Key.
Define the Replication Frequency
The Replication Frequency controls how often Stitch will attempt to replicate data from your Pardot integration. By default the frequency is set to 30 minutes, but you can change it to better suit your needs.
Before setting the Replication Frequency, note that:
- The more often Pardot is set to replicate, the higher the number of replicated rows.
-
The number of rows in the source may not equal the number of rows replicated by Stitch. Tables that use Full Table Replication will result in a higher number of replicated rows.
- If you’re using a data warehouses that doesn’t natively support nested structures, you’ll see a higher number of replicated rows due to the de-nesting Stitch performs.
To help prevent overages, we recommend setting the Replication Frequency to something less frequent - like 6 hours instead of 30 minutes. For tips on reducing your row count, check out the Reducing Your Row Count section of our Billing Guide.
After selecting a Replication Frequency, click Save Integration.
Pardot’s Intial Sync
After you finish setting up Pardot, you might see its Sync Status 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 sync for the integration. This may take some time to complete.
Pardot Schema
Stitch's Pardot integration includes these tables:
- pardotlists
- pardotlistmemberships
- pardotopportunity
- pardotprospect
- pardottags
- pardottabobjects
- pardotvisitor
- pardotvisits
- pardotvisitoractivity
pardotlists
Replication Method: Incremental
Primary Key: id
Contains Nested Structures?:
No
pardotlists table contains info about the lists in your Pardot account.pardotlists Attributes
While we try to include everything Pardot has here, this may not be a full list of attributes. Refer to Pardot's documentation for a full list and description of each attribute.
List ID (
id)name
is_public
is_dynamic
title
description
is_crm_visible
created_at
updated_at
pardotlistmemberships
Replication Method: Incremental
Primary Key: id
Contains Nested Structures?:
No
pardotlistmemberships table contains list membership info.pardotlistmemberships Attributes
While we try to include everything Pardot has here, this may not be a full list of attributes. Refer to Pardot's documentation for a full list and description of each attribute.
List Membership ID (
id)list_id
prospect_id
opted_out
created_at
updated_at
pardotopportunity
Replication Method: Incremental
Primary Key: id
Contains Nested Structures?:
No
pardotopportunity table contains info about the opportunities in your Pardot account.pardotopportunity Attributes
While we try to include everything Pardot has here, this may not be a full list of attributes. Refer to Pardot's documentation for a full list and description of each attribute.
Opportunity ID (
id)campaign_id
name
value
probability
type
stage
status
closed_at
created_at
updated_at
pardotprospect
Replication Method: Incremental
Primary Key: id
Contains Nested Structures?:
No
pardotprospect table contains info about your prosepcts and the attributes associated with them.pardotprospect Attributes
While we try to include everything Pardot has here, this may not be a full list of attributes. Refer to Pardot's documentation for a full list and description of each attribute.
Prospect ID (
id)campaign_id
salutation
first_name
last_name
email
password
company
prospect_account_id
website
job_title
department
country
address_one
address_two
city
state
territory
zip
phone
fax
source
annual_revenue
employee
industry
years_in_business
comments
notes
score
grade
last_activity_at
recent_interaction
crm_lead_fid
crm_contact_fid
crm_owner_fid
crm_account_fid
crm_last_sync
crm_url
is_do_not_email
is_do_not_call
opted_out
is_reviewed
is_starred
created_at
updated_at
pardottags
Replication Method: Incremental
Primary Key: id
Contains Nested Structures?:
No
pardottags table contains info about the tags in your Pardot account.pardottabobjects
Replication Method: Incremental
Primary Key: id
Contains Nested Structures?:
No
pardottabobjects table contains info about the tag objects in your Pardot account.pardottabobjects Attributes
While we try to include everything Pardot has here, this may not be a full list of attributes. Refer to Pardot's documentation for a full list and description of each attribute.
Tag Object ID (
id)tag_id
type
object_id
created_at
pardotvisitor
Replication Method: Incremental
Primary Key: id
Contains Nested Structures?:
No
pardotvisitor table contains info about the visitors who visit your Pardot website.pardotvisitor Attributes
While we try to include everything Pardot has here, this may not be a full list of attributes. Refer to Pardot's documentation for a full list and description of each attribute.
Visitor ID (
id)page_view_counts
ip_address
hostname
campaign_parameter
medium_parameter
source_parameter
content_parameter
term_parameter
created_at
updated_at
pardotvisits
Replication Method: Incremental
Primary Key: id
Contains Nested Structures?:
No
pardotvisits table contains info about visits made to your Pardot website.pardotvisits Attributes
While we try to include everything Pardot has here, this may not be a full list of attributes.
Visit ID (
id)visitor_id
prospect_id
visitor_page_view_count
first_visitor_page_view_at
last_visitor_page_view_at
duration_in_seconds
campaign_parameter
medium_parameter
source_parameter
content_parameter
term_parameter
created_at
updated_at
pardotvisitoractivity
Replication Method: Incremental
Primary Key: id
Contains Nested Structures?:
No
pardotvisitoractivity table contains info about the activities user engage - for example: open, custom URL click, video view, and so on - in during visits to your Pardot website.pardotvisitoractivity Attributes
While we try to include everything Pardot has here, this may not be a full list of attributes. Refer to Pardot's documentation for a full list and description of each attribute.
Visitor Activity ID (
id)visitor_id
prospect_id
type
type_name
details
email_id
form_id
form_handler_id
site_search_query_id
landing_page_id
paid_search_id_id
multivariate_test_variation_id
visitor_page_view_id
file_id
campaign
created_at
| Related | Troubleshooting |
Questions? Feedback?
Did this article help? If you have questions or feedback, please reach out to us.