Emails

Query emails to learn how prospects responded to the emails.

Table Specific Information

Select

The component uses the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the component.

Id supports '=', '<', '<=', '>', '>='.
ProspectId supports '=', '<', '<=', '>', '>='.
ListEmailId supports '=', '<', '<=', '>', '>='.
SentAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM Emails WHERE Id = 50
SELECT * FROM Emails WHERE ProspectId = 23
SELECT * FROM Emails WHERE SentAt > '01/01/2022'

Columns


Name	Type	References	Description
Id [KEY]	Int64		ID of the email.
ProspectId	Int64		Pardot prospect id related to this email.
CampaignId	Int64		Pardot campaign related to this object.
CreatedById	Int64		ID of the individual who created this object.
ClientType	String		Value is 'Builder' if the email was sent via the Lightning Email Builder. Value is 'Web' if it was sent via the legacy Pardot email builder.
TextMessage	String		The text content of the email. This field is retrieved only when filtering with email id.
HtmlMessage	String		The HTML content of the email. This field is retrieved only when filtering with email id.
ListId	Int64		ID of the list associated with this email.
listEmailId	Int64		ID of the list email associated with this email.
Name	String		Name of the email for identification in Pardot.
SentAt	Datetime		Time the email was sent.
Subject	String		The email subject.

SSIS Components for Salesforce Marketing Cloud Account Engagement

Emails

Table Specific Information

Select

Columns