UnsubEvent
Contains data about unsubscription events in Salesforce Marketing Cloud. Each record captures the subscriber, timestamp, and context of the unsubscribe action. This view supports compliance reporting and audience retention 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 UnsubEvent WHERE Id = 123 SELECT * FROM UnsubEvent WHERE Id IN (123, 456) SELECT * FROM UnsubEvent WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ID | Int | Specifies the read-only unique identifier (Id) for the unsubscribe event record. |
| ObjectID | String | Specifies the system-controlled text string that serves as the unique Id for the unsubscribe event object. |
| PartnerKey | String | Specifies the partner-provided unique Id for the unsubscribe event object that is available only through partner integrations. |
| CreatedDate | Datetime | Specifies the read-only date and time when the unsubscribe event record was created. |
| ModifiedDate | Datetime | Indicates the date and time when the unsubscribe event record was last modified. |
| Client_ID | Int | Specifies the Id of the client account that is associated with the unsubscribe event. |
| SendID | Int | Specifies the Id of the send operation that is associated with the unsubscribe event. |
| SubscriberKey | String | Specifies the user-supplied subscriber key that identifies the subscriber who performed the unsubscription. |
| EventDate | Datetime | Specifies the date and time when the unsubscribe tracking event occurred. |
| EventType | String | Specifies the type of tracking event that is associated with the unsubscribe action. |
| TriggeredSendDefinitionObjectID | String | Specifies the system-controlled Id of the triggered-send definition that is associated with the unsubscribe event. |
| BatchID | Int | Specifies the batch Id that ties the unsubscribe event to a related group of triggered-send events. |
| List_ID | Int | Specifies the Id of the list that is associated with the unsubscription action. |
| List_Type | String | Specifies the type of list that is associated with the unsubscription event. Valid values include 'Public', 'Private', 'Salesforce', 'GlobalUnsubscribe', and 'Master'. |
| List_ListClassification | String | Specifies the classification that is applied to the list that is associated with the unsubscription event. |
| IsMasterUnsubscribed | Bool | Indicates whether the subscriber performed a master unsubscribe action. It returns a value of 'false' when the subscriber did not perform a master unsubscribe. |