Prospect and Activity Dataset

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”