MobileConnectPRODUCTION
_SMSMessageTracking
MobileConnect SMS send/receive tracking, delivery-status context and Journey identifiers.
Retention: Indefinite per current Salesforce documentation; filter large queriesTime: CST; DST not observed
Trust & provenancePRODUCTION
Evidence tierPRODUCTIONOfficial sources1Other sources0Last verifiedNot recorded
Evidence tier describes my hands-on relationship with the content. Official sources describe platform contracts/documentation. Production observations should not automatically be treated as official limits.
Starter query
Start from something valid.
SELECT
sm.MobileMessageTrackingID,
sm.Mobile,
sm.SubscriberKey,
sm.SMSStandardStatusCodeId,
sm.Description,
sm.JBDefinitionID,
sm.SendDateTime,
sm.DeliveredDateTime
FROM _SMSMessageTracking smSchema
Fields
| Field | Type | Flags | Notes |
|---|---|---|---|
MobileMessageTrackingID | Number | INDEXED | Unique tracking identifier for the message record. |
MID | Number | NULLABLE | Member/Business Unit ID. |
Mobile | Phone(15) | Subscriber mobile number. | |
MessageID | Number | Mobile message ID. | |
MessageText | Text(160) | NULLABLE | SMS message text. |
SubscriberID | Number | NULLABLE | Internal subscriber ID when one exists. |
SubscriberKey | Text(254) | NULLABLE | Subscriber key when one exists. |
SMSStandardStatusCodeId | Number | NULLABLE | SFMC delivery status code. |
Description | Text | NULLABLE | Detailed status description. |
Name | Text | NULLABLE | Message/activity name. |
ShortCode | Text | NULLABLE | Short or long code; not populated for some inbound/MT rows. |
JBActivityID | Text / UUID | NULLABLE | Journey activity identifier for Journey-sent SMS. |
JBDefinitionID | Text / UUID | NULLABLE | Journey definition/version identifier; Salesforce maps this to _Journey.VersionID. |
SendDateTime | Date | NULLABLE | Time sent to the aggregator. |
DeliveredDateTime | Date | NULLABLE | Time SFMC received successful delivery event. |
Operational notes
A net-new number can produce a STOP-related record without SubscriberID/SubscriberKey.
For shared codes, status 2000 in this view confirms aggregator delivery, not necessarily final handset delivery.
Use _SMSSubscriptionLog for OptIn/OptOut history.
Verified sources