---
schema_version: "1"
id: 8a8e3ecfd3c6e9a8e15e51f8d8a0824ff978382457a250a0fbd4d08cc4d85c50
title: "Data View: SMSMessageTracking"
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_message_tracking.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_sms_message_tracking.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: a8e9c9984217a8aac1bd3242c04dfdc856c19b9ffe0ffd3db7d2024acfd13e22
description: To view your message send and receive history from MobileConnect SMS sends, query the _SMSMessageTracking data view. Information from this query relates to the owner of a private short code or long code. Query information can also relate to a client by using a shared short code to which the subscriber has opted in.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# Data View: SMSMessageTracking

To view your message send and receive history from MobileConnect SMS sends, query the \_SMSMessageTracking data view. Information from this query relates to the owner of a private short code or long code. Query information can also relate to a client by using a shared short code to which the subscriber has opted in.

Identify the name of the SMS message that you want to check on the MobileConnect Overview page.

1\. To retrieve the MessageID, click the message name.

2\. On the message Overview page, note the URL.

3\. Copy the Base64 encoded text.

4\. Use an online Base64 decoder to decode the Base64 encoded text. The format of an encoded message is {val}:{val}:{val}. The first value is the MessageID. For example, if the result is 65:78:0, the MessageID is 65.

![Example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_journeys_and_automations-264-0-0-production-enus/e08cdd71-c1c1-4ae5-a5e9-8a6dad583ad4/images/icon_example.png)

Example

Sample URL: https://mc.s10.exacttarget.com/cloud/#app/MobileConnect/Mobile/%23!/message/view/NjU6Nzg6MA

Sample Base64 encoded text: NjU6Nzg6MA

## Considerations

- Dates and times are stored in Central Standard Time. Daylight Savings Time isn’t observed.
- Code and keyword values are currently represented as a static GUID.
- There are some cases where MobileConnect has no subscriber ID. For example, if a net new number texts STOP, a contact isn’t created, but a record is logged.
- For shared codes, the delivery statuses shown in this data view only confirms delivery to the aggregator via the status code of 2000. The shared codes delivery receipts are returned to the Marketing Cloud Engagement account that owns the code.
- Use the \_SMSSubscriptionLog data view for Unsub, OptIn, and OptOut data.
- If you don’t name your activity in Journey Builder, your content name serves as your activity name.
- This data view retains data indefinitely. To improve query performance and limit the results, use WHERE conditions when retrieving a large amount of data.
- The JBDefinitionID field corresponds to the VersionID in the [Journey Data View](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_journey.htm&release=264.0.0&type=5 "To find a journey's status, created and last modified date, and other general journey information, query the _Journey data view.").

## Columns

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:36.50137741046832%">
          <col style="width:28.650137741046834%">
          <col style="width:12.396694214876034%">
          <col style="width:11.432506887052343%">
          <col style="width:11.019283746556475%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d25755e110"> Name </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d25755e113"> Description </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d25755e116"> Data Type </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d25755e119"> Data Extension Data Type </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d25755e122"> Nullable </th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">MobileMessageTrackingID </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Unique ID for tracking information related to the sent message </td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 "> bigint </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 "> Decimal (19, 0) </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">EID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Enterprise ID number for the sender </td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 "> bigint </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 "> Decimal (19, 0) </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">MID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Member ID</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bigint </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 "> Decimal (19, 0) </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">Mobile</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Mobile number for the subscriber</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">varchar(15)</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 "> Phone </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">MessageID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Mobile message ID</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">int </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 "> Number </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">MessageTypeID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Identifies the type of message for the tracking record. Returns 0 when
              undefined.</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">int</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Number</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">KeywordID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Unique identifier for the keyword</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">unique identifier </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 "> Text</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 "> X </td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">CodeID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Unique identifier for the SMS code</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">unique identifier </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Text </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">ConversationID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Not used (legacy)</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 "> bigint </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 "> Decimal(19,0) </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">ConversationStateID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Unique identifier that correlates mobile originated (MO) and mobile terminated
              (MT) messages as a single conversation</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">unique identifier</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Text</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">CampaignID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The SMS campaign tied to the record</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">int </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Number </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 "> X </td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">Sent</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">If the message was sent (1 = true, 0 = false)</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">tinyint </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Boolean </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">Delivered</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">If the message was delivered (1 = true, 0 = false)</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">&nbsp;</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Boolean</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">Undelivered</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Whether the message was delivered successfully or not (1 = true, 0 = false) </td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bit</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Boolean</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">Outbound</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">If the message was outgoing (1 = true, 0 = false) </td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bit</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Boolean</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">Inbound</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">If the message was incoming (1 = true, 0 = false) </td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bit</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Boolean</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">CreateDateTime</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The date and time the tracking record was created</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">smalldatetime</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Date and time</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">ModifiedDateTime</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The date and time (in Central Standard Time) the tracking record was
              modified</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">smalldatetime</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Date and time</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">ActionDateTime</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">
              <p>The actual date and time a delivery or non-delivery event was received by
                Marketing Cloud Engagement.</p>
              <p style="margin-bottom:0;">Timestamps for delivery receipts aren’t indicative of when a message was received
                on a handset. The SMS industry doesn’t support read receipts, and the data
                returned in this view are based on when a delivery receipt is returned to our
                system.</p>
            </td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">smalldatetime</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Date and Time</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">MessageText</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The text of the message</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">nvarchar(160)</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Text</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">IsTest</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">If the message was a test message</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bit</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Boolean</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">MobileMessageRecurrenceID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The ID of the recurrence schedule for the message. Can be used for
              troubleshooting send issues.</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bigint</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Decimal (19, 0)</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">ResponseToMobileMessageTrackingID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The tracking ID of the response to the message</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bigint</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Decimal (19, 0)</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">IsValid</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">If the message is valid</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bit</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Boolean</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">InvalidationCode</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Invalidation code for the message</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">smallint</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Number</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">SendID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The send ID number for the SMS send</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bigint</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Decimal (19, 0)</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">SendSplitID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">If the message was split, the ID of the split</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bigint</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Decimal (19, 0)</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">SendSegmentID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The ID of the segment tied to the message</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bigint</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Decimal (19, 0)</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">SendJobID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The job ID for the SMS send</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bigint</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Decimal (19, 0)</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">SendGroupID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The group ID for the SMS send</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bigint</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Decimal (19, 0)</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">SendPersonID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The sendperson ID for the SMS send</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bigint</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Decimal (19, 0)</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">SubscriberID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The subscriber ID for the affected subscriber. This number represents the
              unique ID for each subscriber record</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bigint</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Decimal (19, 0)</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">SubscriberKey</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The subscriber key for the affected subscriber</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">nvarchar(254)</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Text</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">
              <a href="https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/sms-status-codes.html" target="_blank">SMSStandardStatusCodeId</a>
            </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 "> SFMC delivery status code</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">int</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Number</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">Description</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Detailed description of the status code</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">nvarchar</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Text</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The name of your message</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">nvarchar</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Text</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">ShortCode</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">
              <p>The short code or long code used to send your message</p>
              <p style="margin-bottom:0;">The ShortCode column isn’t populated for inbound and MT sends. View the
                associated code in the CodeID column instead.</p>
            </td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">nvarchar</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Text</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">SharedKeyword</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The keyword used in your message</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">nvarchar</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Text</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">Ordinal</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Represents the parts in a multi-part message. Represented in ascending order
              starting at 0.</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">tinyint</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Number</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">FromName</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">From Name that an individual message was deployed with. Maximum length: 11
              characters</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">nvarchar</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Text</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">JBActivityID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Unique identifier for the journey activity the message was deployed
              from</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">unique identifier</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Text</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">JBDefinitionID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Unique identifier for the journey a message was deployed from</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">unique identifier</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Text</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">SMSJobID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Unique identifier for each SMS job triggered in MobileConnect</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">unique identifier</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">unique identifier</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">SMSBatchID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">Identifies a batch associated with an SMS send</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">bigint</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Decimal (19, 0)</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">X</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">SendDateTime</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">The date and time the message was sent to the aggregator. This value is
              accurate to the second and is displayed in Central Standard Time (CST).</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">datetime2(3)</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Date and time</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">Yes</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e110 ">DeliveredDateTime</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e113 ">
              <p>The date and time when Marketing Cloud Engagement received the delivery event. This value is
                accurate to the second and is displayed in Central Standard Time (CST).</p>
              <p style="margin-bottom:0;">The field gets populated only for successfully delivered messages. It's empty for
                all other statuses, including carrier-level acknowledgments, failures, or
                undelivered messages.</p>
            </td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e116 ">datetime2(3)</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e119 ">Date and time</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d25755e122 ">Yes</td>

          </tr>
        </tbody>
      </table>

#### 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)
- [Data View: SMSSubscriptionLog](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_sms_subscription_log.htm&release=264.0.0&type=5 "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.")
- [_Knowledge Article:_ Description of the fields in \_SMSMessageTracking dataview that return NULL values](https://help.salesforce.com/articleView?id=000355536&type=1&language=en_US)