ListSend
Specifies retrieve-only properties associated with the list(s) for a completed 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 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 | Read-only identifier for an object. |
| PartnerKey | String | Unique identifier provided by partner for an object, accessible only via API. |
| Client_ID | Int | The Id of the client. |
| SendID | Int | Contains identifier for a specific send. |
| List_ID | Int | Read-only identifier for an object. |
| List_ListName | String | The name of the list. |
| Duplicates | Int | Represent the number of duplicate email addresses associated with a send (exists only when a send occurs to multiple lists). |
| InvalidAddresses | Int | Specifies the number of invalid addresses associated with a send. |
| ExistingUndeliverables | Int | Indicates whether bounces occurred on previous send. |
| ExistingUnsubscribes | Int | Indicates whether unsubscriptions occurred on previous send. |
| HardBounces | Int | Indicates number of hard bounces associated with a send. |
| SoftBounces | Int | Indicates number of soft bounces associated with a specific send. |
| OtherBounces | Int | Specifies number of Other-type bounces in a send. |
| ForwardedEmails | Int | Number of emails forwarded for a send. |
| UniqueClicks | Int | Indicates number of unique clicks on message. |
| UniqueOpens | Int | Indicates number of unique opens resulting from a triggered send. |
| NumberSent | Int | Number of emails actually sent as part of an email send. This number reflects all of the sent messages and may include bounced messages. |
| NumberDelivered | Int | Number of sent emails that did not bounce. |
| Unsubscribes | Int | Indicates the number of unsubscribe events associated with a send. |
| MissingAddresses | Int | Specifies number of missing addresses encountered within a send. |
| PreviewURL | String | Indicates URL used to preview the message associated with a send. |