This version of Pardot reached end of life on July 30, 2020 and is no longer functioning.
Upgrade to the latest version (v1) to continue replicating data.
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 (v15-10-2015) integration, including release status, useful links, and the features supported in Stitch.
| STITCH | |||
| Release status |
Sunset on July 30, 2020 |
Supported by |
[Stitch] (https://community.qlik.com/t5/Support/ct-p/qlikSupport) |
| Stitch plan |
Standard |
API availability |
Not available |
| Singer GitHub repository |
Not applicable |
||
| REPLICATION SETTINGS | |||
| Anchor Scheduling |
Supported |
Advanced Scheduling |
Unsupported |
| Table-level reset |
Unsupported |
Configurable Replication Methods |
Unsupported |
| DATA SELECTION | |||
| Table selection |
Unsupported |
Column selection |
Unsupported |
| Select all |
Unsupported |
||
| TRANSPARENCY | |||
| Extraction Logs |
Unsupported |
Loading Reports |
Supported |
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 15-10-2015 of this integration.
pardotlists
Replication Method: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based Incremental
Primary Key: id
Contains Nested Structures?:
No
pardottags table contains info about the tags in your Pardot account.pardottagobjects
Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?:
No
pardottagobjects table contains info about the tag objects in your Pardot account.pardottagobjects 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: Key-based 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: Key-based 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: Key-based 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, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.