Emails

Query emails to learn how prospects responded to the emails.

Table Specific Information

Select

The 本製品 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 本製品.

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	ReadOnly	References	Description
Id [KEY]	Int64	True		ID of the email.
ProspectId	Int64	True		Pardot prospect id related to this email.
CampaignId	Int64	True		Pardot campaign related to this object.
CreatedById	Int64	True		ID of the individual who created this object.
ClientType	String	True		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	True		The text content of the email. This field is retrieved only when filtering with email id.
HtmlMessage	String	True		The HTML content of the email. This field is retrieved only when filtering with email id.
ListId	Int64	True		ID of the list associated with this email.
listEmailId	Int64	True		ID of the list email associated with this email.
Name	String	True		Name of the email for identification in Pardot.
SentAt	Datetime	True		Time the email was sent.
Subject	String	True		The email subject.

ODBC Driver for Salesforce Marketing Cloud Account Engagement

Emails

Table Specific Information

Select

Columns