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

Paid Search Activities

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