Already have an account? Sign in

Pardot

Last updated: 9/15/2026

Pardot (v15-10-2015) end of life

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
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.

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

The pardotopportunity table contains info about the opportunities in your Pardot account.

Table Info & Attributes

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

The pardotprospect table contains info about your prosepcts and the attributes associated with them.

Table Info & Attributes

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

The pardottags table contains info about the tags in your Pardot account.

Table Info & Attributes

pardottags 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 ID (id)
name
created_at
updated_at

pardottagobjects

Replication Method: Key-based Incremental

Primary Key: id
Contains Nested Structures?: No

The pardottagobjects table contains info about the tag objects in your Pardot account.

Table Info & Attributes

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

The pardotvisitor table contains info about the visitors who visit your Pardot website.

Table Info & Attributes

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

The pardotvisits table contains info about visits made to your Pardot website.

Table Info & Attributes

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

The 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.

Table Info & Attributes

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

pardotlists

Replication Method: Key-based Incremental

Primary Key: id
Contains Nested Structures?: No

The pardotlists table contains info about the lists in your Pardot account.

Table Info & Attributes

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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here