Salesforce Pardot | Prospect Standard Dataset
Patricia Robinson
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. |