--- schema_version: "1" id: 19b6504099c5849b3fb78bacbfef6b15d7a274343dd1da7bc70d6ffe859d5620 title: Prospect and Activity Dataset collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/pardot_b2bma_prospect_activity_dataset.md canonical_url: https://help.salesforce.com/s/articleView?id=mktg.pardot_b2bma_prospect_activity_dataset.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: e32ca28b8ccfba93b96f216e5f818b96ab732c61b834e8784ebea79f353acfb9 description: To identify which content influences prospects in your sales funnel, add the optional Prospect and Activity dataset. Create a lens using this dataset to identify the individual prospect record that acted on a certain asset. products: - Marketing - Marketing Cloud Account Engagement release: "264" --- # Prospect and Activity Dataset To identify which content influences prospects in your sales funnel, add the optional Prospect and Activity dataset. Create a lens using this dataset to identify the individual prospect record that acted on a certain asset. ### Required Editions
Available in: Account Engagement Plus, Advanced, and Premium Editions with Salesforce Enterprise Edition or higher
Available for an extra cost in legacy Account Engagement Pro and Ultimate Editions with Salesforce Enterprise Edition or higher
To use the Prospect and Activity dataset, enable it in Marketing Setup and then select it during the app setup in Analytics Studio. In Marketing Setup, enter B2B Marketing in the Quick Find box. Open the B2B Marketing Analytics setup page, and click **Enable Dataset** next to the Prospect Activity heading. The Prospect and Activity dataset includes prospect demographic fields and fields that describe their associated engagement activity. Some metrics, such as email sends, don’t appear in this dataset and are derived by other methods. As a result, prospect activity metric values in this dataset can vary from values in other datasets and dashboards. Account API Name: AccountName Name of the account associated with prospect activity Account ID API Name: AccountId Salesforce identifier for the prospect’s associated account Account Name API Name: Prospect.account\_name Name of the prospect’s associated account Activity API Name: ActivityType Engagement activity type: click, view, success, or open Activity Campaign ID API Name: ActivityCampaignId Salesforce identifier for the associated campaign Activity Campaign Name API Name: ActivityCampaignName Campaign associated with the activity Activity Date API Name: ActivityDate Date and time the prospect engaged in the activity (UTC) Address One API Name: Prospect.address\_one Address One field associated with the prospect Address Two API Name: Prospect.address\_two Address Two field associated with the prospect Annual Revenue API Name: Prospect.annual\_revenue The prospect’s associated company’s annual revenue Archived API Name: Prospect.is\_archived True or false whether the prospect has been archived Asset Activity API Name: AssetActivity Combined label for asset and activity type: form view, form success, list email click, list email open, file view success, file view, custom URL click, landing page view, landing page success, form handler success, automated email click, automated email open, website visit, or priority page view Asset ID API Name: AssetId Salesforce identifier for the asset a prospect engaged with Asset Name API Name: AssetName The name of the asset a prospect engaged with: form, list email, file, custom URL, landing page, form handler, automated email, website, or priority page Asset Type API Name: AssetType The type of asset a prospect engaged with Assigned User First Name API Name: Prospect.assigned\_user\_first\_name First name of the prospect’s assigned user Assigned User Full Name API Name: Prospect.assigned\_user\_full\_name Full name of the prospect’s assigned user Assigned User Last Name API Name: Prospect.assigned\_user\_last\_name Last name of the prospect’s assigned user CRM Contact FID API Name: Prospect.crm\_contact\_fid Salesforce identifier for the contact record associated with the prospect CRM Lead FID API Name: Prospect.crm\_lead\_fid Salesforce identifier for the lead record associated with the prospect CRM Owner FID API Name: Prospect.crm\_owner\_fid Salesforce identifier for the prospect owner City API Name: Prospect.city The prospect’s city Comments API Name: Prospect.comments The text of user comments associated with the prospect Company API Name: Prospect.company The prospect’s company Country API Name: Prospect.country The prospect’s country Created by First Name API Name: Prospect.created\_by\_first\_name First name of the user who created the prospect Created by Full Name API Name: Prospect.created\_by\_full\_name Full name of the user who created the prospect Created by Last Name API Name: Prospect.created\_by\_last\_name Last name of the user who created the prospect Department API Name: Prospect.department The prospect’s department Email API Name: Prospect.email The prospect’s email address Employees API Name: Prospect.employees Number of employees working at the prospect’s company External ID API Name: ActorExternalId Unique identifier for the prospect Fax API Name: Prospect.fax The prospect’s fax number First Name API Name: Prospect.first\_name The prospect’s first name Full Name API Name: Prospect.full\_name The prospect’s full name Grade API Name: Prospect.grade The prospect’s grade ID API Name: ActorId Salesforce identifier for the prospect’s associated lead or contact record. This field is used to match prospects to CRM leads and contacts. Industry API Name: Prospect.industry The prospect’s industry Is Do Not Call API Name: Prospect.is\_do\_not\_call True or false whether the prospect can receive phone calls Is Do Not Email API Name: Prospect.is\_do\_not\_email True or false whether the prospect can receive emails Job Title API Name: Prospect.job\_title The prospect’s job title Last Name API Name: Prospect.last\_name The prospect’s last name Name API Name: ActorName The prospect’s full name Opted Out API Name: Prospect.opted\_out True or false. whether the prospect has opted out of marketing emails Pardot Account ID (external) API Name: Prospect.pardot\_account\_id Unique identifier for the prospect. This field is used to match prospects to CRM leads and contacts. Pardot Activity ID API Name: ActivityExternalId Unique identifier for the activity. This field is used to match engagement activity to prospects, leads, and contacts. Pardot Asset ID API Name: AssetExternalId Unique identifier for the asset that a prospect engaged with Phone API Name: Prospect.phone The prospect’s phone number Prospect Archived API Name: ProspectIsArchived True or false. Whether the prospect has been archived Prospect Assigned Date API Name: Prospect.assigned\_date Date a prospect was assigned to a user (UTC) Prospect CRM Last Activity Date API Name: Prospect.crm\_last\_activity\_date Date of the prospect’s last recorded interaction with an asset (UTC) Prospect Created At Date API Name: Prospect.created\_at\_date Date the prospect was created Prospect ID (external) API Name: Prospect.id Unique identifier for the prospect. This field is used to match prospects to CRM leads and contacts. Prospect Job Title API Name: ProspectJobTitle The prospect’s job title Prospect Last Activity Date API Name: Prospect.last\_activity\_date Date of the prospect’s last activity recorded Prospect Pardot Campaign Id API Name: ProspectCampaignExternalId Unique identifier for the first-touch Account Engagement campaign that a prospect is associated with Prospect Type API Name: ActorType Type of record: Prospect, Lead, or Contact Prospect Updated At Date API Name: Prospect.updated\_at\_date Date a prospect was last updated Salutation API Name: Prospect.salutation The prospect’s preferred title Score API Name: Prospect.score The prospect’s score Source API Name: Prospect.source How the prospect was added Source Campaign API Name: Prospect.source\_campaign The name of the associated Account Engagement campaign State API Name: Prospect.state The prospect’s state Tags API Name: Prospect.tags Tags associated with the prospect Territory API Name: Prospect.territory The prospect’s territory Updated by First Name API Name: Prospect.updated\_by\_first\_name First name of the user who last updated the prospect Updated by Last Name API Name: Prospect.updated\_by\_last\_name Last name of the user who last updated the prospect Website API Name: Prospect.website Website URL associated with the prospect’s company Years In Business API Name: Prospect.years\_in\_business Number of years the prospect’s company has been in business Zip API Name: Prospect.zip The prospect’s ZIP code ## Member Values for Recipes When using recipes in B2B Marketing Analytics, use these labels and member values to map your fields. Field Label: Asset Type Form, “1” List Email, “2” Custom Url, “4” Landing Page, “5” Form Handler, “6” Automated Email, “7” Website Visit, “8” Priority Page View, “9” Field Label: Activity Type Click, “1”, “21” View, “2” Success, “4” Open, “11” Visit, “20” Field Label: Asset Activity Form View, “1 2” Form Success, “1 4” List Email Click, “2 1” List Email Open, “2 11” File View, “3 2” Custom Url Click, “4 21” Landing Page View, “5 2” Landing Page Success, “5 4” Form Handler Success, “6 4” Automated Email Click, “7 1” Automated Email Open, “7 11” Website Visit, “8 20” Priority Page View, “9 2” Field Label: Prospect Type Lead, “1” Contact, “2” Prospect, “3” #### See Also - [Prospect and Activity Dataset for Object Sync](https://help.salesforce.com/s/articleView?id=mktg.pardot_b2bma_prospect_activity_dataset_osp.htm&release=264.0.0&type=5 "To identify which content influences prospects in your sales funnel, add the optional Prospect and Activity dataset. Create a lens using this dataset to identify the individual prospect record that acted on a certain asset.")