Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Expected Pardot Data

Now that Pardot is successfully connected to your Stitch account, what comes next? In this article, we'll cover:

Replicating Pardot Data

Historical Sync

By default, a historical sync of Pardot data goes back four weeks from the Stitch connection date.

Frequency

Stitch will replicate Pardot data based on the frequency you define. The default setting is every 30 minutes, but you can change it to something more frequent based on your needs.

Replication Method

Pardot data is replicated using Incremental Replication. This means that every time Pardot data is queued for replication, only new and updated records will be replicated to your data warehouse.

Pardot Tables in Your Data Warehouse

Click a table name to view a full list of attributes for that table in Pardot's API documentation.

pardotlists
Primary Key: _id

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

Attributes include the list ID (id), name, public and dynamic list settings, title, description, CRM visibility flag, and created and updated at timestamps.

pardotlistmemberships
Primary Key: _id

The pardotolistmemberships table contains list membership information.

Attributes include the list membership ID (id), list ID, prospect ID, opt out setting, and created and updated at timestamps.

pardotopportunity
Primary Key: _id

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

Attributes include the opportunity ID (id), name, campaign ID, probability, value, type, stage, status, closing date, and created and updated at timestamps.

pardotprospect
Primary Key: _id

The pardotprospect table contains information about all prospects and the attributes associated with them.

Attributes include the campaign ID (id), source, first and last name, address, email address, contact information, website URL, industry, CRM information, updated and created at timestamps, and more.

pardottags
Primary Key: _id

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

Attributes include the tag ID (id), name, and created and updated at timestamps.

pardottagobjects
Primary Key: _id

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

Attributes include the tag object ID (id), tag ID, type, object ID, and created at timestamp.

pardotvisitor
Primary Key: _id

The pardotvisitor table contains information about the parameters used in a visit.

Attributes include the visitor ID (id), page view count, IP address, hostname, created and updated at timestamps, and the campaign, medium, source, content, and term parameters from Google Analytics.

pardotvisits
Primary Key: _id

The pardotvisits table contains information about visits made to your website.

Attributes include the visit ID (id), visitor ID, prospect ID, page view data, visit duration, created and updated at timestamps, and the campaign, medium, source, content, and term parameters from Google Analytics.

pardotvisitoractivity
Primary Key: _id

The pardotvisitoractivity table contains information about all visitor activity.

Attributes include the visitor activity ID (id), visitor ID, type, type name, prospect ID, campaign ID, details, email ID, form ID, site search query ID, landing page ID, paid search ID, file ID, and created at timestamp.

RELATED

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!