SentEvent
Contains tracking data for email send events in Salesforce Marketing Cloud. Each record captures subscriber-level delivery results, including send time, recipient address, and message identifier (Id). This view supports detailed tracking and reporting of message performance.
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 SentEvent WHERE Client_ID = 123 SELECT * FROM SentEvent WHERE Client_ID IN (123, 456) SELECT * FROM SentEvent WHERE EventDate > '2024/01/25'
Columns
| Name | Type | Description |
| SendID | Int | Specifies the unique identifier (Id) for the specific send operation that generated the sent event record. This Id enables reporting systems to associate the event with the correct outbound message. |
| SubscriberKey | String | Specifies the subscriber key that identifies the individual subscriber for whom the sent event was recorded. This value is used to correlate the event with subscriber-level activity. |
| EventDate | Datetime | Indicates the date and time when the sent event occurred as part of tracking and delivery reporting. |
| Client_ID | Int | Specifies the Id of the client that owns or administers the send and its associated event data. |
| EventType | String | Specifies the type of tracking event that is associated with the send, such as a system-generated representation of a successful send action. |
| BatchID | Int | Specifies the Id of the batch that groups related triggered send events for collective reporting and processing. |
| TriggeredSendDefinitionObjectID | String | Specifies the system-controlled Id that is associated with the triggered send definition used to generate the event. |
| ListID | Int | Specifies the Id of the subscriber list to which the subscriber belongs at the time of the send operation. |
| PartnerKey | String | Specifies the partner-assigned unique Id that is associated with the event record and available only through API access. |
| SubscriberID | Int | Specifies the Id of the subscriber that is associated with the sent event. |