UnsubEvent
Contains information regarding a specific unsubscription action taken by a subscriber.
View-Specific Information
Select
The driver 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 driver processes other filters client-side within the driver.
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 | Read-only identifier for an object. |
| ObjectID | String | System-controlled, read-only text string identifier for object. |
| PartnerKey | String | Unique identifier provided by partner for an object, accessible only via API. |
| CreatedDate | Datetime | Read-only date and time of the object's creation. |
| ModifiedDate | Datetime | Indicates the last time object information was modified. |
| Client_ID | Int | The Id of the client. |
| SendID | Int | Contains identifier for a specific send. |
| SubscriberKey | String | Identification of a specific subscriber. |
| EventDate | Datetime | Date when a tracking event occurred. |
| EventType | String | The type of tracking event |
| TriggeredSendDefinitionObjectID | String | Identifies the triggered send definition associated with an event. |
| BatchID | Int | Ties triggered send sent events to other events. |
| List_ID | Int | Indicates the id of the list involved in the unsubscription. |
| List_Type | String | Indicates type of specific list. Valid values include Public, Private, Salesforce, GlobalUnsubscribe, and Master. |
| List_ListClassification | String | Specifies the classification for a list. |
| IsMasterUnsubscribed | Bool | Indicates whether the subscriber master unsubscribed. |