_SMSMessageTracking
MobileConnect SMS send and MO/MT tracking. Retained indefinitely; use WHERE for performance. Join JB fields to Journey views.
Schema last reviewed 2026-06-17
Opens _SMSMessageTracking in the interactive canvas with SQL Sandbox.
MobileConnect SMS send and MO/MT tracking. Retained indefinitely; use WHERE for performance. Join JB fields to Journey views.
Schema last reviewed 2026-06-17
Opens _SMSMessageTracking in the interactive canvas with SQL Sandbox.
| Field | Type | Flags | Relations | Description |
|---|---|---|---|---|
MobileMessageTrackingID |
Number | PK | — | Unique tracking ID per message. |
EID |
Number | NULL | — | Enterprise ID. |
MID |
Number | NULL | — | Business Unit MID. |
Mobile |
Text(15) | — | — | Subscriber mobile number. |
MessageID |
Number | — | — | Mobile message ID. |
KeywordID |
Text(36) | NULL | — | Keyword GUID. |
CodeID |
Text(36) | NULL | — | SMS code GUID. |
ConversationID |
Text(36) | NULL | — | Legacy conversation ID; usually null. |
ConversationStateID |
Text(36) | NULL | — | MO/MT conversation correlation ID. |
CampaignID |
Number | NULL | — | SMS campaign ID when applicable. |
Sent |
Boolean | — | — | Whether the message was sent. |
Delivered |
Boolean | NULL | — | Whether the message was delivered. |
Undelivered |
Boolean | NULL | — | Delivery failure flag. |
Outbound |
Boolean | NULL | — | Outgoing message flag. |
Inbound |
Boolean | NULL | — | Incoming message flag. |
CreateDateTime |
Date | — | — | Record creation timestamp. |
ModifiedDateTime |
Date | — | — | Record modification timestamp. |
ActionDateTime |
Date | — | — | Delivery or non-delivery event timestamp. |
MessageText |
Text(160) | NULL | — | Message body text. |
IsTest |
Boolean | — | — | Test message flag. |
MobileMessageRecurrenceID |
Number | NULL | — | Recurrence schedule ID. |
ResponseToMobileMessageTrackingID |
Number | FK, NULL | _SMSMessageTracking.MobileMessageTrackingID | Parent message tracking ID. |
IsValid |
Boolean | NULL | — | Validity flag. |
InvalidationCode |
Number | NULL | — | Invalidation code. |
SendID |
Number | NULL | — | SMS send ID. |
SendSplitID |
Number | NULL | — | Send split ID. |
SendSegmentID |
Number | NULL | — | Send segment ID. |
SendJobID |
Number | NULL | — | SMS send job ID. |
SendGroupID |
Number | NULL | — | Send group ID. |
SendPersonID |
Number | NULL | — | Send person ID. |
SubscriberID |
Number | FK, NULL | _Sent.SubscriberID _Open.SubscriberID _Click.SubscriberID _Bounce.SubscriberID _Complaint.SubscriberID _Unsubscribe.SubscriberID |
Subscriber ID when available. |
SubscriberKey |
Text(254) | FK, NULL | _Subscribers.SubscriberKey _Sent.SubscriberKey _Open.SubscriberKey _Click.SubscriberKey _Bounce.SubscriberKey _Complaint.SubscriberKey _Unsubscribe.SubscriberKey |
Subscriber key when available. |
SMSStandardStatusCodeId |
Number | NULL | — | SFMC delivery status code. |
Description |
Text | NULL | — | Status code description. |
Name |
Text | NULL | — | Message or Journey activity name. |
ShortCode |
Text | NULL | — | Short or long code used to send. |
SharedKeyword |
Text | NULL | — | Keyword used in the message. |
Ordinal |
Number | NULL | — | Multi-part message part index. |
FromName |
Text(11) | NULL | — | From name on the message (max 11 chars). |
JBDefinitionID |
Text(36) | FK, NULL | _Journey.VersionID | Journey version ID for Journey SMS sends. |
JBActivityID |
Text(36) | FK, NULL | _JourneyActivity.ActivityID | Journey activity ID for Journey SMS sends. |
SMSJobID |
Text(36) | NULL | — | SMS Send Log job GUID (Spring 2023+). |
SMSBatchID |
Number | NULL | — | SMS Send Log batch ID. |
SELECT TOP 100
SubscriberKey, SubscriberID, MobileMessageTrackingID, EID, MID, Mobile
FROM _SMSMessageTracking
WHERE ActionDateTime >= DATEADD(day, -30, GETDATE())
ORDER BY ActionDateTime 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.