Pardot Pulled Objects List

List of objects and activities we pull from Pardot.

Lead (Prospects)

We pull Prospect records from Pardot and create a Lead object for each. The prospect is identified by their email or Pardot prospect ID.

HockeyStack Property
Pardot Field

pardot__lead_id

id

lead_id

salesforceLeadId / salesforceContactId / salesforceId / id

lead_name

firstName + lastName

lead_email

email

lead_created_at

createdAt

lead_createddate

createdAt

lead_updateddate

updatedAt

lead_source

source

lead_industry

industry

lead_country

country

lead_title

jobTitle

lead_owner_id

assignedTo.salesforceId / assignedTo.id

lead_owner_name

assignedTo.firstName + assignedTo.lastName

lead_owner_email

assignedTo.email

lead_owner_title

assignedTo.jobTitle

lead_owner_userrole_name

assignedTo.roleName

lead_campaign_pardot_id

campaign.id

lead_campaign_id

campaign.salesforceId

lead_campaign_name

campaign.name

pardot__is_converted

true if convertedAt date is present

pardot__company_id

the company's domain, if it exists, or prospectAccount.salesforceId / prospectAccount.id

Activities

Every activity has the following common properties:

HockeyStack Property
Pardot Field

pardot_activity_id

id

pardot_campaign_id

campaignId

pardot_campaign_name

campaign.name

Activity Types

Email Activities

The following email-related activities share these properties:

HockeyStack Property
Pardot Field

pardot_email_subject

email.subject

pardot_email_id

emailId

pardot_email_list_name

listEmail.name

pardot_email_template_id

emailTemplateId

pardot_email_template_name

emailTemplate.name

Email actions pulled:

  • Email Sent - An email is sent to a prospect

  • Email Opened - A prospect opens an email

  • Email URL Clicked - A prospect clicks a link in an email

  • Email Bounced - An email bounces for a prospect

  • Unsubscribed from Mail List - A prospect unsubscribes from an email list

  • Resubscribed to Mail List - A prospect resubscribes to an email list

Form Activities

HockeyStack Property
Pardot Field

pardot_form_name

form.name / formHandler.name

Form actions pulled:

  • Form Viewed - A prospect views a form

  • Form Completed - A prospect submits a form or form handler

Page View Activities

HockeyStack Property
Pardot Field

pardot_page_title

visitorPageView.title

pardot_page_url

visitorPageView.url

Page actions pulled:

  • Page Viewed - A prospect views a page

HockeyStack Property
Pardot Field

pardot_paid_search_ad_id

paidSearchAdId

pardot_paid_search_ad_headline

details

Paid search actions pulled:

  • Paid Search Ad Clicked - A prospect clicks a paid search ad

Last updated