_BusinessUnitUnsubscribes

Enterprise-level unsubscribe state by business unit. Query from the parent account.

Scope: Parent account onlyTime: CST; DST not observed

Trust & provenancePRODUCTION

Evidence tierPRODUCTIONOfficial sources1Other sources0Last verifiedNot recorded

Evidence tier describes my hands-on relationship with the content. Official sources describe platform contracts/documentation. Production observations should not automatically be treated as official limits.

Starter query

Start from something valid.

SELECT
    bu.BusinessUnitID,
    bu.SubscriberKey,
    bu.UnsubDateUTC,
    bu.UnsubReason
FROM _BusinessUnitUnsubscribes bu

Relationships

Where it connects.

_BusinessUnitUnsubscribes → _Subscribers

SubscriberKey = SubscriberKey

→

Schema

Fields

Field	Type	Flags	Notes
`BusinessUnitID`	Number		Business Unit account ID.
`SubscriberID`	Number	INDEXED	Internal subscriber identifier.
`SubscriberKey`	Text(254)	INDEXED	Subscriber key.
`UnsubDateUTC`	Date	NULLABLE	Date/time of the BU-level unsubscribe.
`UnsubReason`	Text(100)	NULLABLE	Configured unsubscribe reason.

Operational notes

Useful for Enterprise 2.0 scenarios where BU-level unsubscribe context matters.

Verified sources

Salesforce — Data View: BusinessUnitUnsubscribes ↗

_BusinessUnitUnsubscribes

Start from something valid.

Where it connects.

Fields

Keep following the context.