Prospect and Activity Dataset for Object Sync

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

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.AddressOne

Address One field associated with the prospect

Address Two

API Name: Prospect.AddressTwo

Address Two field associated with the prospect

Annual Revenue

API Name: Prospect.AnnualRevenue

The prospect’s associated company’s annual revenue

Archived

API Name: Prospect.IsArchived

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.AssignedUser.first_name

First name of the prospect’s assigned user

Assigned User Full Name

API Name: Prospect.AssignedUser.full_name

Full name of the prospect’s assigned user

Assigned User Last Name

API Name: Prospect.AssignedUser.last_name

Last name of the prospect’s assigned user

CRM Contact FID

API Name: Prospect.ContactId

Salesforce identifier for the contact record associated with the prospect

CRM Lead FID

API Name: Prospect.LeadId

Salesforce identifier for the lead record associated with the prospect

CRM Owner FID

API Name: Prospect.OwnerId

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.CreatedBy.first_name

First name of the user who created the prospect

Created By Full Name

API Name: Prospect.CreatedBy.full_name

Full name of the user who created the prospect

Created By Last Name

API Name: Prospect.CreatedBy.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

Fax

API Name: Prospect.Fax

The prospect’s fax number

First Name

API Name: Prospect.FirstName

The prospect’s first name

Full Name

API Name: Prospect.FullName

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.IsDoNotCall

True or false whether the prospect can receive phone calls

Is Do Not Email

API Name: Prospect.IsDoNotEmail

True or false whether the prospect can receive emails

Job Title

API Name: Prospect.JobTitle

The prospect’s job title

Last Name

API Name: Prospect.LastName

The prospect’s last name

Name

API Name: ActorName

The prospect’s full name

Opted Out

API Name: Prospect.OptedOut

True or false whether the prospect has opted out of marketing emails

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 Assigned Date

API Name: Prospect.FirstAssignedAt

Date a prospect was assigned to a user (UTC)

Prospect CRM Last Activity Date

API Name: Prospect.LastSync

Date of the prospect’s last recorded interaction with an asset (UTC)

Prospect Created At Date

API Name: Prospect.CreatedDate

Date the prospect was created

Prospect ID (external)

API Name: Prospect.ExternalAd

Unique identifier for the prospect. This field is used to match prospects to CRM leads and contacts.

Prospect Last Activity Date

API Name: Prospect.LastActivityAt

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.LastModifiedDate

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 to Account Engagement

Source Campaign

API Name: Prospect.SourceCampaign

The name of the associated Account Engagement campaign

State

API Name: Prospect.State

The prospect’s state

Tags

API Name: Prospect.TagName

Tags associated with the prospect

Territory

API Name: Prospect.Territory

The prospect’s territory

Updated By First Name

API Name: Prospect.UpdatedBy.first_name

First name of the user who last updated the prospect

Updated By Full Name

API Name: Prospect.UpdatedBy.full_name

Full name of the user who last updated the prospect

Updated By Last Name

API Name: Prospect.UpdatedBy.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.YearsInBusiness

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”