_SMSSubscriptionLog

MobileConnect subscription history by mobile number/keyword, including opt-in and opt-out state.

Retention: More than 6 monthsTime: 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
    sm.LogDate,
    sm.MobileNumber,
    sm.SubscriberKey,
    sm.OptInStatusID,
    sm.OptOutStatusID,
    sm.OptOutMethodID
FROM _SMSSubscriptionLog sm

Relationships

Where it connects.

Schema

Fields

Field	Type	Flags	Notes
`LogDate`	Date	NULLABLE	Date the subscription event was logged.
`SubscriberKey`	Text	NULLABLE	Subscriber key when available.
`MobileSubscriptionID`	Number		Unique subscription-record ID.
`SubscriptionDefinitionID`	Text / UUID		Keyword/subscription definition ID.
`MobileNumber`	Phone	INDEXED	Mobile number for the subscriber.
`OptOutStatusID`	Number	NULLABLE	Opt-out state. 1 represents OptedOut.
`OptOutMethodID`	Number	NULLABLE	How the opt-out was recorded; mobile-originated STOP methods have dedicated values.
`OptInStatusID`	Number	NULLABLE	Opt-in state. 2 represents OptedIn.
`OptInMethodID`	Number	NULLABLE	How the opt-in was recorded.
`Source`	Number	NULLABLE	Source identifier for the subscription event.

Operational notes

Only the first subscription event is logged for a given status; repeated opt-outs do not create repeated identical-status events.

A net-new mobile number can text STOP without a contact being created, so SubscriberKey can be absent.

Verified sources

Salesforce — Data View: SMSSubscriptionLog ↗

_SMSSubscriptionLog

Start from something valid.

Where it connects.

Fields

Keep following the context.