ListSend
Provides retrieve-only properties that describe the lists associated with completed send operations in Salesforce Marketing Cloud. Each record links a send event to one or more lists to support campaign tracking 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 ListSend WHERE Id = 123 SELECT * FROM ListSend WHERE Id IN (123, 456) SELECT * FROM ListSend WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ID [KEY] | Int | Specifies the read-only identifier (Id) that uniquely identifies the list-send record. |
| PartnerKey | String | Specifies the unique Id that is provided by a partner for the list-send record when accessed through the API. |
| Client_ID | Int | Specifies the Id of the client that owns or manages the send activity. |
| SendID | Int | Specifies the Id of the specific send operation associated with this record. |
| List_ID | Int | Specifies the read-only Id of the list that is associated with the send. |
| List_ListName | String | Specifies the name of the list that was used as the audience for the send. |
| Duplicates | Int | Specifies the number of duplicate email addresses that were detected across the lists included in the send. This value only appears when the send targets multiple lists. |
| InvalidAddresses | Int | Specifies the number of email addresses that were identified as invalid during the send process. |
| ExistingUndeliverables | Int | Specifies the number of email addresses that were already marked as undeliverable before the send occurred. |
| ExistingUnsubscribes | Int | Specifies the number of email addresses that were already unsubscribed before the send occurred. |
| HardBounces | Int | Specifies the number of hard bounces that occurred during the send. A hard bounce indicates a permanent delivery failure. |
| SoftBounces | Int | Specifies the number of soft bounces that occurred during the send. A soft bounce indicates a temporary or intermittent delivery failure. |
| OtherBounces | Int | Specifies the number of bounces that were classified as Other-type bounces during the send. |
| ForwardedEmails | Int | Specifies the number of forwarded email events that were recorded for the send. |
| UniqueClicks | Int | Specifies the number of unique contacts who clicked at least one tracked link within the message. |
| UniqueOpens | Int | Specifies the number of unique contacts who opened the message at least once as part of this send. |
| NumberSent | Int | Specifies the total number of emails that were sent during the send action. This value includes messages that later resulted in bounces. |
| NumberDelivered | Int | Specifies the number of sent emails that were successfully delivered and did not bounce. |
| Unsubscribes | Int | Specifies the number of unsubscribe events that occurred as a result of this send. |
| MissingAddresses | Int | Specifies the number of records in the send that did not contain a valid email address. |
| PreviewURL | String | Specifies the URL that can be used to preview the message associated with the send. |