NotSentEvent
Contains information about email messages that failed to send in Salesforce Marketing Cloud. Each record includes diagnostic codes and timestamps to support root-cause analysis of delivery failures.
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 NotSentEvent WHERE SendID = 123 SELECT * FROM NotSentEvent WHERE SendID IN (123, 456) SELECT * FROM NotSentEvent WHERE CreatedDate > '2024/01/25'
Columns
| Name | Type | Description |
| SendID | Int | Specifies the identifier (Id) of the specific send that is associated with the not-sent event. |
| SubscriberKey | String | Specifies the value that identifies the subscriber that is associated with the not-sent event within Salesforce Salesforce Marketing Cloud. |
| EventDate | Datetime | Indicates the date and time when the not-sent tracking event occurred. |
| Client_ID | Int | Specifies the Id of the client that is associated with the event. |
| EventType | String | Specifies the classification of the tracking event that captures why the message was not sent. |
| BatchID | Int | Specifies the batch Id that groups the event with related triggered-send activity. |
| TriggeredSendDefinitionObjectID | String | Specifies the system-generated object Id that is used to associate the event with its corresponding triggered send definition. |
| ListID | Int | Specifies the list Id that identifies the list to which the subscriber belonged at the time of the not-sent event. |
| PartnerKey | String | Specifies the partner-provided unique Id used by external systems to reference the event through the API. |
| SubscriberID | Int | Specifies the Id that uniquely identifies the subscriber within Marketing Cloud. |