Salesforce Pardot | Prospect Standard Dataset

Below are the measures and dimensions Alight Analytics considers standard for Salesforce Pardot - Prospect dataset. There is a two day lag on Salesforce Pardot, and data is pulled for one day.

Field Name Type Description 
Id Whole Number Pardot ID for this prospect.
Campaign Id Whole Number Pardot ID of the campaign associated with this prospect.
Company Dimension Prospect’s company.
Score Whole Number Prospect’s score.
Recent Interaction Dimension Describes the prospect’s most recent interaction with Pardot.
Created At DateTime Time prospect was created in Pardot; Time is reported in API user’s preferred timezone.
Updated At DateTime Time prospect was updated in Pardot; Time is reported in API user’s preferred timezone.
Last Activity At DateTime Time stamp of this prospect’s latest visitor activity; Time is reported in API user’s preferred timezone.
Lead Status Dimension Lead’s status.
Opportunity Id Dimension Pardot ID for this opportunity. 
Opportunity Name Dimension Opportunity’s name.
Opportunity Value Dimension Opportunity’s value. 
Opportunity Type Dimension Opportunity’s type.
Opportunity Stage Dimension Opportunity’s stage.
Opportunity Status Dimension Opportunity’s status.
Opportunity Closed At DateTime Opportunity’s closed date.
Opportunity Created At DateTime Time opportunity was created in Pardot; Time is reported in API user’s preferred timezone.
Opportunity Updated At DateTime Time opportunity was updated  in Pardot; Time is reported in API user’s preferred timezone.
Insert Date DateTime Internal use: When the row was inserted in the table.
ChannelMix Profile Dimension When needed, distinguishes between Salesforce Pardot  accounts – Contents defined by Alight.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.