_BusinessUnitUnsubscribes

Contacts currently unsubscribed at the Business Unit level (snapshot, not event log). Parent account queries only for enterprise BU-unsubscribe mode.

Schema last reviewed 2026-06-17

Open Interactive Workspace All data views

Opens _BusinessUnitUnsubscribes in the interactive canvas with SQL Sandbox.

Fields (5)

Field	Type	Flags	Relations	Description
`BusinessUnitID`	Number	PK	—	Business Unit account ID (MID).
`SubscriberID`	Number	PK	—	Subscriber record ID.
`SubscriberKey`	Text(254)	FK	_Subscribers.SubscriberKey	Subscriber key.
`UnsubDateUTC`	Date	NULL	—	BU unsubscribe timestamp in UTC.
`UnsubReason`	Text(100)	NULL	—	Administrator-configured unsubscribe reason.

Example query

SELECT TOP 100
  SubscriberKey, SubscriberID, BusinessUnitID, UnsubDateUTC, UnsubReason
FROM _BusinessUnitUnsubscribes

Valid in Query Studio and Automation Studio Query Activities. GROUP BY is only needed for aggregates; ORDER BY is optional but recommended with TOP so rows are meaningful. Narrow date ranges on large tracking views to avoid timeouts.