TriggeredSendSummary
Summary of results for a specific triggered send.
View-Specific Information
Select
The driver 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 driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.
For example, the following (but not only) queries are processed server side:
SELECT * FROM TriggeredSendSummary
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. |