Architecture 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

AE Email + AE Email Template Dataset Fields

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
	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:

Prospect and Activity 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.

Pardot Engagement History Dataset

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)

Sample values of the Activity and Asset fields:

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 email sent from Salesforce; those records are 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 will be "List Email" and SentVia will be "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. For Pardot Email, Type = List Email for AE Email and Type = Automated Email for AE Email Template.

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

Salesforce ListEmail Fields

API Name	Type	Refers To
ActionCadenceStepId	Lookup	ActionCadenceStep
CampaignId	Lookup	Campaign
ClickThroughRate	Percent
ClickToOpenRatio	Percent
DeliveryRate	Percent
EmailContentId	Lookup
FromAddress	Textarea
FromName	String
HasAttachment	Boolean
HtmlBody	Textarea
IsTracked	Boolean
LastReferencedDate	DateTime
LastViewedDate	DateTime
Name	String
OpenRate	Percent
OptOutRate	Percent
OwnerId	Lookup	Group, User
ProgramName	String
ScheduledDate	DateTime
SentVia	Picklist
SpamComplaintRate	Percent
Status	Picklist
Subject	Textarea
TextBody	Textarea
TotalDelivered	Int
TotalHardBounced	Int
TotalOpens	Int
TotalOutOfOffice	Int
TotalReplies	Int
TotalSent	Int
TotalSoftBounced	Int
TotalSpamComplaints	Int
TotalTrackedLinkClicks	Int
Type	Picklist
UniqueOpens	Int
UniqueOptOuts	Int
UniqueReplies	Int
UniqueTrackedLinkClicks	Int

Reference: 

• ListEmail