TriggeredSendSummary
Provides summary metrics for specific triggered send operations in Salesforce Marketing Cloud. Each record includes counts for messages sent, delivered, and failed, supporting operational and performance analysis.
View-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) queries are processed server side:
SELECT * FROM TriggeredSendSummary WHERE ObjectID = 'nzxcaslkjd-123'
SELECT * FROM TriggeredSendSummary WHERE ObjectID IN ('nzxcaslkjd-123', 'nzxcaslkjd-456')
SELECT * FROM TriggeredSendSummary WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ObjectID [KEY] | String | Specifies the system-controlled text string that serves as the unique identifier (Id) for the triggered-send summary record. |
| Client_ID | Long | Specifies the Id of the client account that is associated with the triggered-send summary. |
| Client_PartnerClientKey | String | Specifies the partner-provided unique key that is associated with the client account and used only within partner integrations. |
| CustomerKey | String | Specifies the user-supplied unique Id for the triggered-send summary object. |
| PartnerKey | String | Specifies the partner-provided unique Id for the triggered-send summary object and available only through partner integrations. |
| Sent | Long | Indicates the total number of triggered-send messages that were successfully sent. |
| NotSentDueToOptOut | Long | Indicates the number of triggered-send messages that were not delivered because the subscribers opted out of receiving communications. |
| NotSentDueToUndeliverable | Long | Indicates the number of triggered-send messages that were not delivered because the destination addresses were undeliverable. |
| Bounces | Long | Indicates the total number of bounce events that resulted from the triggered send. |
| Opens | Long | Indicates the total number of opens recorded across all messages in the triggered send. |
| UniqueOpens | Long | Indicates the number of distinct subscribers who opened at least one message within the triggered send. |
| Clicks | Long | Indicates the total number of click interactions recorded for the triggered send. |
| UniqueClicks | Long | Indicates the number of distinct subscribers who clicked at least one link within the triggered send. |
| OptOuts | Long | Indicates the number of subscribers who opted out of receiving future messages after receiving the triggered send. |
| SurveyResponses | Long | Indicates the number of responses submitted to any survey questions included in the triggered send. |
| FTAFRequests | Long | Indicates the number of Forward To A Friend (FTAF) request actions that were initiated from within the triggered send. |
| FTAFEmailsSent | Long | Indicates the number of Forward To A Friend (FTAF) emails that were sent as a result of subscriber requests. |
| FTAFOptIns | Long | Indicates the number of subscribers who opted in to future communications as a result of a Forward To A Friend (FTAF) action. |
| Conversions | Long | Indicates the total number of conversions that resulted from the triggered send. |
| UniqueConversions | Long | Indicates the number of distinct subscribers who completed a conversion action that is associated with the triggered send. |
| InProcess | Long | [DEPRECATED] Indicates the number of triggered-send messages that are currently in progress. |
| NotSentDueToError | Long | Indicates the number of triggered-send messages that were not delivered because an error occurred during processing. |
| RowObjectID | String | Specifies the row-level unique Id for the triggered-send summary record. |
| TriggeredSendDefinition_ObjectID | String | Specifies the system-controlled unique Id of the triggered-send definition that is associated with the summarized results. |
| Queued | Long | Indicates the number of triggered-send messages that are queued and awaiting processing. |