SendSummary
A retrieve only object that contains summary information about a specific send event.
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.
For example, the following (but not only) queries are processed server side:
SELECT * FROM SendSummary WHERE Client_ID = 123 SELECT * FROM SendSummary WHERE Client_ID IN (123, 456) SELECT * FROM SendSummary WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| Client_ID | Int | The Id of the client. |
| AccountID | Int | Identifier for account. |
| SendID | Int | Contains identifier for a specific send. |
| DeliveredTime | String | Indicates the time a message was delivered. |
| CreatedDate | Datetime | Read-only date and time of the object's creation. |
| ModifiedDate | Datetime | Indicates the last time object information was modified. |
| 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. |
| AccountName | String | Name of account. |
| AccountEmail | String | Specifies email address attached to account. |
| IsTestAccount | Bool | Specifies whether or not an account is a 'Test' account. |
| TotalSent | Int | Indicates total number of messages sent as part of a send. |
| Transactional | Int | Indicates number of transactional messages included in a send. |
| NonTransactional | Int | Specifies number of marketing (non-transactional) messages included as part of a send. |