To find subscription log information from MobileConnect SMS sends, query the _SMSSubscriptionLog data view in Automation Studio. For example, you can view a history of all mobile numbers subscribed to a keyword.
View subscription log information about SMS sends in MobileConnect by querying the _SMSSubscriptionLog data view. Information from this query relates to the owner of a private short code or long code or a client using a shared short code to which the subscriber has opted in. This data view shows more than 6 months of data.
Considerations
- Dates and times are stored in Central Standard Time. Daylight Savings Time isn’t observed. To view time-related data in your time zone, set time zone user preferences.
- When profile attributes are created in Enterprise 2.0 accounts, new columns are added to the _EnterpriseAttribute table. Data view queries in Enterprise 2.0 accounts can return results from profile attribute columns in addition to the columns listed here.
- Code and keyword values are currently represented as a static GUID.
- Records changes to keyword subscriptions. When a phone number that has never subscribed to a keyword sends STOP, no subscription record is created.
- Only the first subscription event is logged for a given status. For example, if a contact opts out three times, only the first opt-out is logged.
Columns
| Name | Description | DataType | Data Extension Data Type | Nullable |
|---|---|---|---|---|
| LogDate | The date the subscription is logged | datetime | Date | Yes |
| SubscriberKey | The subscriber key for the affected subscriber | nvarchar | Text | |
| MobileSubscriptionID | The unique ID of the subscription record | bigint | Number | |
| SubscriptionDefinitionID | The unique keyword ID | unique identifier | Text | |
| MobileNumber | Mobile number for the subscriber | nvarchar | Phone | |
| OptOutStatusID | Whether the subscriber has opted out of SMS messages. See key for values. | tinyint | Number | Yes |
| OptOutMethodID | Method the subscriber used to opt out of SMS messages. See key for values. | tinyint | Number | Yes |
| OptOutDate | Date the subscriber opted out of SMS messages | date | Date | Yes |
| OptInStatusID | Whether the subscriber has opted in to an SMS message. See key for values. | tinyint | Number | |
| OptInMethodID | Method the subscriber used to opt in to SMS messages. See key for values. | bit | Number | Yes |
| OptInDate | Date the subscriber opted in to SMS messages | date | Date | Yes |
| Source | The subscription source | tinyint | Number | Yes |
| CreatedDate | Date the message was created | date | Date | |
| ModifiedDate | Date the message was modified | date | Date |
To help with queries, the subscriberkey field for a MobileNumber that’s associated with more than one subscriberkey includes a “Multiple subscriber keys found” value.
The SubscriberKey field is populated if the MobileNumber matches a record in the All Contacts List in Contact Builder.
OptOutStatusID Key
0 = NotOptedOut
1 = OptedOut
10 = DeletingNotOptedOut
11 = DeletingOptedOut
OptOutMethodID Key
0 = Unspecified
1 = WebCollect
2 = API
3 = FTAF
4 = Import
5 = MoveCopy
6 = Application
7 = Salesforce
8 = Segmentation
9 = GenericExtension
10 = CustomObject
11 = RMM
13 = ServiceFeedback
14 = MobileOriginated (CustomStopKeyword)
15 = ContactsSuppression
18 = MobileOriginated (GlobalStopKeyword)
20 = Carrier Deactivation
A NULL value in this column indicates that a subscriber texted an opt-out
keyword.
OptInStatusID Key
0 = NotOptedIn
1 = OptInPending
2 = OptedIn
10 = DeletingNotOptedIn
11 = DeletingOptInPending
12 = DeletingOptedIn
OptInMethodID Key
0 = Unspecified
1 = WebCollect
2 = API
3 = FTAF
4 = Import
5 = MoveCopy
6 = Application
7 = Salesforce
8 = Segmentation
9 = GenericExtension
10 = CustomObject
11 = RMM
12 = Mobile Opt-In
13 = DeviceRegistration
Source Key
0 = Unspecified
1 = Webcollect
2 = API
3 = FTAF
4 = Import
5 = MoveCopy
6 = Manual
7 = Salesforce
8 = Segmentation
9 = GenericExtension
10 = CustomObject
11 = FacebookAPI
12 = SmartCapture
13 = MobileOptIn