To find unsubscribe data for subscribers in your account at the enterprise level, query the _BusinessUnitUnsubscribes data view in Automation Studio. You can run this data view on the parent account only and not on child business units.
Dates and times are stored in Central Standard Time. Daylight Savings Time isn’t observed. To view time-related data in your time zone, set time zone user preferences.
Columns
SubscriberID and SubscriberKey columns are indexed.
| Name | Description | DataType | Data Extension Data Type | Nullable |
|---|---|---|---|---|
| BusinessUnitID | The Account ID for the Business Unit (BU). | bigint | Number | |
| SubscriberID | The subscriber ID for the affected subscriber. This number represents the unique ID for each subscriber record. | bigint | Number | |
| SubscriberKey | A potential alternate identifier for subscribers. Defaults to the value of Email Address. | varchar(254) | Text | |
| UnsubDateUTC | The date the subscriber unsubscribed from messages sent by BU. | smalldatetime | Date | X |
| UnsubReason | The reason listed is a custom value configured by your administrator. | varchar(100) | Text | X |