Emails

Query emails to learn how prospects responded to the emails.

テーブル固有の情報

connector はSalesforce Marketing Cloud Account Engagement API を使用して、以下のカラムと演算子で構築されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドでconnector 内部で処理されます。

例えば、次のクエリはサーバーサイドで処理されます。

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


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.