MobileConnect keyword subscription history per mobile number. Replaces legacy _MobileSubscription. Retention beyond six months.
Schema last reviewed 2026-06-17
Opens _SMSSubscriptionLog in the interactive canvas with SQL Sandbox.
| Field | Type | Flags | Relations | Description |
|---|---|---|---|---|
LogDate |
Date | NULL | — | Date the subscription event was logged. |
SubscriberKey |
Text(254) | FK | _Subscribers.SubscriberKey _Sent.SubscriberKey _Open.SubscriberKey _Click.SubscriberKey _Bounce.SubscriberKey _Complaint.SubscriberKey _Unsubscribe.SubscriberKey |
Subscriber key when matched in All Contacts. |
MobileSubscriptionID |
Number | PK | — | Subscription record ID. |
SubscriptionDefinitionID |
Text(36) | FK | _SMSMessageTracking.KeywordID | Keyword GUID; join to _SMSMessageTracking.KeywordID. |
MobileNumber |
Text(15) | — | — | Mobile number. |
OptOutStatusID |
Number | NULL | — | Opt-out status code. |
OptOutMethodID |
Number | NULL | — | Opt-out method code. |
OptOutDate |
Date | NULL | — | Opt-out date. |
OptInStatusID |
Number | — | — | Opt-in status code. |
OptInMethodID |
Number | NULL | — | Opt-in method code. |
OptInDate |
Date | NULL | — | Opt-in date. |
Source |
Number | NULL | — | Subscription source code. |
CreatedDate |
Date | — | — | Record created date. |
ModifiedDate |
Date | — | — | Record modified date. |
SELECT TOP 100
SubscriberKey, LogDate, MobileSubscriptionID, SubscriptionDefinitionID, MobileNumber, OptOutStatusID
FROM _SMSSubscriptionLog
WHERE CreatedDate >= DATEADD(day, -30, GETDATE())
ORDER BY CreatedDate DESCValid 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.