SendSummary
Provides summary information for a completed send event in Salesforce Marketing Cloud. Each record includes key metrics such as total sent, delivered, opened, and bounced messages. This retrieve-only view supports campaign reporting 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 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 | Specifies the identifier (Id) of the client that owns or operates the send activity. |
| AccountID | Int | Specifies the unique Id for the account that is associated with the send summary record. This Id is used to link sending activity back to the originating account. |
| SendID | Int | Specifies the Id that identifies the specific send operation for which summary information is being reported. |
| DeliveredTime | String | Indicates the time at which the message that is associated with the send was delivered to the destination system or provider. |
| CreatedDate | Datetime | Indicates the system-generated date and time when the send summary record was created. |
| ModifiedDate | Datetime | Indicates the date and time when the send summary record was last modified as part of reporting or administrative updates. |
| CustomerKey | String | Specifies the user-supplied unique Id that is assigned to this send summary object within its object type. |
| PartnerKey | String | Specifies the partner-supplied unique Id that is associated with this send summary record and is available only through API access. |
| AccountName | String | Specifies the name of the account that is associated with the send operation. |
| AccountEmail | String | Specifies the email address that is associated with the account and that is used for reporting, administrative notices, or message attribution. |
| IsTestAccount | Bool | Returns a value of 'true' when the account is configured as a test account for validation or non-production sending scenarios. It returns a value of 'false' when the account operates as a standard production environment. |
| TotalSent | Int | Indicates the total number of messages that were sent as part of the send operation. |
| Transactional | Int | Indicates the number of transactional messages that were included in the send operation. |
| NonTransactional | Int | Specifies the number of marketing or non-transactional messages that were included as part of the send operation. |