_Unsubscribe

Unsubscribe events associated with email sends.

Retention: Most recent 180 daysTime: 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
    un.SubscriberKey,
    un.JobID,
    un.EventDate,
    un.IsUnique
FROM _Unsubscribe un

Relationships

Where it connects.

_Unsubscribe → _Sent

JobID = JobID · ListID = ListID · BatchID = BatchID · SubscriberID = SubscriberID

→

_Unsubscribe → _Subscribers

SubscriberKey = SubscriberKey

→

Schema

Fields

Field	Type	Flags	Notes
`AccountID`	Number		Account identifier.
`OYBAccountID`	Number	NULLABLE	OYB account identifier.
`JobID`	Number		Send job identifier.
`ListID`	Number		List identifier.
`BatchID`	Number		Batch identifier.
`SubscriberID`	Number		Internal subscriber identifier.
`SubscriberKey`	Text(254)		Subscriber key.
`EventDate`	Date		Unsubscribe event date/time.
`IsUnique`	Boolean		Unique/repeated flag.
`Domain`	Text(128)		Domain associated with event.

Operational notes

For complete status-change history, Salesforce also documents the StatusChanges extract.

Verified sources

Salesforce — Data View: Unsubscribe ↗

_Unsubscribe

Start from something valid.

Where it connects.

Fields

Keep following the context.