Email sent from Salesforce and Account Engagement

1. Account Engagement Emails & Account Engagement Email Templates datasets

In this blog, we discussed Account Engagement Emails and the Account Engagement Email Templates datasets from the B2B Marketing Analytics app in CRM Analytics. Each row represents one day of statistics for an individual list email or an individual email template. 

Type	Account Engagement Emails	Account Engagement Email Templates
Measures	Click To Open Ratio
	Delivery Rate	Delivery Rate
	Opt Out Rate	Opt Out Rate
	Spam Complaint Rate	Spam Complaint Rate
	Total Bounced
	Total Clicks	Total Clicks
	Total CTR	Total CTR
	Total Delivered	Total Delivered
	Total Hard Bounced	Total Hard Bounced
	Total HTML Opens	Total HTML Opens
	Total Opt Outs	Total Opt Outs
	Total Queued	Total Queued
	Total Sent	Total Sent
	Total Soft Bounced	Total Soft Bounced
	Total Spam Complaint	Total Spam Complaint
	Unique Clicks	Unique Clicks
	Unique CTR	Unique CTR
	Unique HTML Open Rate
	Unique HTML Opens	Unique HTML Opens
Dates	Created At Date	Created At Date
	Sent On Date
	Stats Date	Stats Date
	Updated At Date	Updated At Date
Dimensions	Campaign ID (CRM)	Campaign ID (CRM)
	Campaign ID (external)	Campaign ID (external)
	Campaign	Campaign
	Created By
	Created By - User ID (CRM)
	Email ID	Email Template ID
	Name	Name
		Sender
	Sent To
	Stats ID	Stats ID
	Subject	Subject
	Suppressed From
	Tags	Tags
		Type
	Updated By
	Updated By - User ID (CRM)

Look at the Salesforce article B2B Marketing Analytics Datasets; there is a slight difference, as some fields are not available, such as bounce rate. Even between the email and email template datasets, there are slight differences in the field availability; see the blank values in the Account Engagement Emails and Account Engagement Email Templates columns.

There are 2 major challenges/issues with the email template dataset:

1. There is no Sent on Date, although we can use Stats Date and Total Sent
2. Unique HTML Opens always show 0; this is a bug and has been captured as a known issue.

As you read from above, there is no detail on who the email is sent to in the Account Engagement Emails and the Account Engagement Email Templates datasets.

2. Prospect and Activity dataset 

The Prospect and Activity dataset is another dataset provided by the B2B Marketing Analytics app. Each row represents a unique engagement activity and data related to the prospect who performed it. So, if a prospect performs multiple activities, such as list email click, list email open, landing page view, etc., they will appear as multiple rows with different activity dates (including timestamps). Here is the Salesforce article Prospect and Activity Dataset.

The screenshot below filters the prospect and activity with an ID (using Lead ID)

Here are the fields and the types available in this dataset:

Measures	Score
Dates	Activity Date
	Prospect Assigned Date
	Prospect Created At Date
	Prospect CRM Last Activity Date
	Prospect Last Activity Date
	Prospect Updated At Date
Dimensions	Account
	Account ID
	Account Name
	Activity
	Activity Campaign ID
	Activity Campaign Name
	Address One
	Address Two
	Annual Revenue
	Archived
	Asset Activity
	Asset ID
	Asset Name
	Asset Type
	Assigned User First Name
	Assigned User Full Name
	Assigned User Last Name
	CRM Contact FID
	CRM Lead FID
	CRM Owner FID
	City
	Comments
	Company
	Country
	Created By First Name
	Created By Full Name
	Created By Last Name
	Department
	Employees
	Email
	External ID
	Fax
	First Name
	Full Name
	ID
	Grade
	Industry
	Is Do Not Call
	Is Do Not Email
	Job Title
	Last Name
	Month
	Name
	Opted Out
	Pardot Account ID (external)
	Pardot Activity ID
	Pardot Asset ID
	Phone
	Prospect Archived
	Prospect ID (external)
	Prospect Job Title
	Prospect Pardot Campaign Id
	Prospect Type
	Salutation
	Source
	Source Campaign
	State
	Tags
	Territory
	Updated By First Name
	Updated By Last Name
	Website
	Years In Business
	Zip

We can relate the Pardot Asset ID in this dataset to the Email ID in the Account Engagement Emails and Account Engagement Email Templates datasets.

ID (API Name: ActorID) in this dataset is Salesforce Lead ID or Contact ID.

Prospect Type will contain 'Lead' or 'Contact' only.

3. Pardot Engagement History dataset

This is another CRMA dataset, but provided by the B2B Marketing Engagement History app, not the B2B Marketing Analytics app, where the datasets mentioned above are.

✔ 1 row = 1 activity event (per prospect per interaction)

I see this dataset is almost similar to the Prospect and Activity dataset, but lighter. It contains many similar fields, such as: ID (API Name: ActorID, which is Lead ID or Contact ID), Activity, Asset Activity, Asset ID, Asset Name, Asset Type, Prospect ID, Prospect Type, Pardot Activity ID, and Pardot Asset ID. But does not contain detailed information about the Prospect, such as Job Title, Address, Annual Revenue, Company, etc. -- this information can be retrieved from the Account Engagement Prospects dataset in the B2B Marketing Analytics app.

Dates	Activity Date
Dimensions	Account
	Account ID
	Activity
	Activity Campaign ID
	Activity Campaign Name
	Activity Date (Month Name)
	Asset Activity: Priority Page View, Landing Page View
	Asset ID
	Asset Name
	Asset Type:
	External ID
	ID
	Name
	Pardot Account ID
	Pardot Activity ID
	Pardot Asset ID
	Pardot Prospect Archived
	Pardot Prospect Job Title
	Prospect Pardot Campaign Id
	Prospect Type (Lead or Contact)

Some values of:

Asset Activity, in short, is Asset Type + Activity.

4. ListEmail object

This is not a CRM Analytics dataset; it is a Salesforce object. Each record in the ListEmail object represents a list email sent from Salesforce or sent from Account Engagement. However, this object does not include manually sent email from Salesforce; that record is stored in the EmailMessage object.

The ListEmail record prefix is 0XB, while the EmailMessage record prefix is 02s.

The email sent via Sales Cadence will have the ActionCadenceStepId set to the prefix 8C8; the Type would be "List Email" and SentVia = "Salesforce".

The ListEmailIndividualRecipient object links the List Email to recipients, represented by the Lead or Contact ID. Check the ListEmailId and RecipientId fields.

The ListEmailRecipientSource object connects the List Email with the source, such as Campaign or List View. SourceListId will be either the List View Id or the Campaign Id.

For email sent from MCAE, the record creator will be the user who connects Salesforce with MCAE, such as B2BMA Integration and SentVia = Pardot, while the list email sent from Salesforce (including Sales Cadence) will have SentVia = Salesforce. 

There is no Sent Date in this object, but look into the ScheduledDate. 

Field Name	Field Label	Type	Digits	Length	Precision	Scale
ActionCadenceStepId	Cadence Step ID	reference		18
CampaignId	Campaign ID	reference		18
CcAddress	CC Address	textarea		320
CreatedById	Created By ID	reference		18
CreatedDate	Created Date	datetime
CurrencyIsoCode	Currency ISO Code	picklist		3
DeliveryRate	Delivery Rate	percent			5	2
FromAddress	From Address	textarea		320
FromName	From Name	string		121
HasAttachment	Has Attachment	boolean
HtmlBody	Html Body	textarea		32000
Id	List Email ID	id		18
IsDeleted	Deleted	boolean
IsEmailArchiveRequired	Is Email Archive Required	boolean
IsSyntheticCcEnabled	Synthetic CC Enabled	boolean
IsTracked	Is Tracked	boolean
LastModifiedById	Last Modified By ID	reference		18
LastModifiedDate	Last Modified Date	datetime
LastReferencedDate	Last Referenced Date	datetime
LastViewedDate	Last Viewed Date	datetime
Name	Name	string		255
OpenRate	Open Rate	percent			5	2
OwnerId	Owner ID	reference		18
RelatedToId	RelatedTo ID	reference		18
ReplyToName	Reply To Name	string		121
ScheduledDate	Scheduled Date	datetime
Status	Status	picklist		255
Subject	Subject	textarea		3000
SystemModstamp	System Modstamp	datetime
TextBody	Text Body	textarea		32000
TotalDelivered	Total Delivered	int	9
TotalHardBounced	Total Hard Bounces	int	9
TotalOpens	Total Opens	int	9
TotalOutOfOffice	Total Out Of Office	int	9
TotalReplies	Total Replies	int	9
TotalSent	Total Sent	int	9
TotalSoftBounced	Total Soft Bounces	int	9
TotalTrackedLinkClicks	Total Clicks	int	9
UniqueOpens	Unique Opens	int	9
UniqueReplies	Unique Replies	int	9
UniqueTrackedLinkClicks	Unique Clicks	int	9

Reference:

• ListEmail
• ListEmail
• EmailMessage