Pardot

Pardot is a marketing automation application that benefits companies in creating significant connections, deploying and managing online campaigns.

Sync Pardot data to Sourcetable

Build reports once. Connect to Pardot and start modeling from live data.

Popular Use Cases

Pardot connector Sourcetable connector
Create automated reports from Pardot
Pardot + Sourcetable
Pardot connector Mailchimp connector
Create a combined report from Pardot and Mailchimp data
Pardot + Mailchimp
Pardot connector MySQL connector
Create reports using Hubspot and MySQL database data
Pardot + MySQL
Pardot connector Facebook Ads Manager connector
Analyze Pardot and Facebook Ads data
Pardot + Facebook Ads Manager
Pardot connector Mailchimp connector
Analyze Pardot and Mailchimp data
Pardot + Mailchimp
Here's a sample of the Pardot data that will be available in your Sourcetable spreadsheets:
CAMPAIGN

Contains the name of campaign and cost

CAMPAIGN_TAG

Contains the association of campaign and tag

EMAIL

Contains name, subject and created at information

EMAIL_TAG

Contains the association of email and tag

LIST

Contains name, description, title, updated at and flags for crm visible, dynamic and public

LIST_MEMBERSHIP

Contains the information of list, prospect, created at, updated at and opted out

LIST_TAG

Contains the association of list and tag

OPPORTUNITY

Contains the information of campaign, name, status, value, type and probability and stage

OPPORTUNITY_PROSPECT

Contains the association of opportunity and propect along with updated at information

OPPORTUNITY_TAG

Contains the association of opportunity and tag

PROSPECT

Contains the information of campaign, prospect account, user, address, contact information, password, and crm fields like crm url, crm owner fid

PROSPECT_ACCOUNT

Prospect account fields are customisable and it currently has name and id

PROSPECT_TAG

Contains the association of prospect and tag

TAG

Tag acts as a label that can be applied on various objects for easy identification

USER

Contains the user information like name, role, title, email and it's account information

USER_TAG

Contains the association of user and a tag

VISIT

Contains the information of prospect, visitor, and parametes like medium, source, term, campaign and content along with visitor page view count

VISITOR

The user which visits the campaign, it has fields like hostname, ip address and parameters like campaign, content, medium, source and term along with page view count

VISITOR_ACTIVITY

Contains the information of campaign, email, prospect, visitor, opportunity, visit and other association id's like email template id, file id etc

VISITOR_PAGE_VIEW

Contains the visit information along with url, title and created at