---
schema_version: "1"
id: 906f77d2a6c49eecf3a455dfd5666394cbcbba42c5588349a0d9ae6aab15660c
title: "Data View: SMSSubscriptionLog"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_as_data_view_sms_subscription_log.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_sms_subscription_log.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: a719c19923d3f347fa73a9264af5533e1b2490e167b8827f5bdcdd003d0f36c4
description: 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.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# Data View: SMSSubscriptionLog

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`

#### See Also

- [Review Undelivered Messages](https://help.salesforce.com/s/articleView?id=mktg.mc_moc_retrieving_information_on_undelivered_sms_messages_for_mobileconnect.htm&type=5&language=en_US)
- [SQL Reference](https://help.salesforce.com/s/articleView?id=mktg.mc_as_sql_reference.htm&release=264.0.0&type=5 "Get SQL query information for Automation Studio’s SQL Query activity at a glance.")
- [SMS Deactivation Summary](https://help.salesforce.com/s/articleView?id=mktg.mc_re_carrier_deactivation_sms_summary_report.htm&language=en_US)