TriggeredSendSummary
Summary of results for a specific triggered send.
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 | System-controlled, read-only text string identifier for object. |
| Client_ID | Long | The Id of the client. |
| Client_PartnerClientKey | String | User-defined partner key for an account. |
| CustomerKey | String | User-supplied unique identifier for an object within an object type. |
| PartnerKey | String | Unique identifier provided by partner for an object, accessible only via API. |
| Sent | Long | Indicates number of messages sent. |
| NotSentDueToOptOut | Long | Indicates number of sends not completed due to a subscriber's decision to opt out of receiving messages. |
| NotSentDueToUndeliverable | Long | Indicates number of sends not completed due to a subscriber's undeliverable status. |
| Bounces | Long | Indicates number of bounces resulting from a triggered send. |
| Opens | Long | Indicates number of opens from a triggered send. |
| UniqueOpens | Long | Indicates number of opens from a triggered send. |
| Clicks | Long | Indicates the number of clicks resulting from a triggered send. |
| UniqueClicks | Long | Indicates number of unique clicks on message. |
| OptOuts | Long | Indicates number of subscribers who opted out of receiving messages after receiving a triggered send. |
| SurveyResponses | Long | Indicates number of responses to a survey question contained in a triggered send. |
| FTAFRequests | Long | Indicates number of Forward To A Friend requests received as part of a triggered send. |
| FTAFEmailsSent | Long | Indicates Forward To A Friend emails sent as a result of a triggered send. |
| FTAFOptIns | Long | Indicates number of subscribers opting in to receiving messages as a result of a Forward To A Friend action from a triggered send. |
| Conversions | Long | Indicates the number of conversions results from a triggered send. |
| UniqueConversions | Long | Indicates number of unique conversions resulting from a triggered send. |
| InProcess | Long | Indicates the number of triggered send messages in progress. Deprecated. |
| NotSentDueToError | Long | Indicates number of triggered send messages not sent due to error. |
| RowObjectID | String | The row id of the object. |
| TriggeredSendDefinition_ObjectID | String | The Id of the associated triggered send definition for triggered send. |
| Queued | Long | Indicates number of messages queued for sending. |