Track Delivery in SMS Data Views

The March 2020 Release provides ability to get delivery receipts for individual SMS sends using the _SMSMessageTracking data view.

Full detail on the data view can be obtained here:

If you want to filter your query results to a particular send you need to get the MessageID.

To get the MessageID, we need to click on the message name and look at the last part of the page URL. The last characters preceding the last forward slash is your Base64 encoded text version of the MessageID.

Copy the Base64 encoded text and use an online Base64 decoder to decode the Base64 encoded text.

The Base64 Decoded result appears in this format: 157:78:0. Based on this result, the MessageID for this message is 157.

Message Overview Page
Decoded Base64

Lastly, create a Query to get the necessary information:

SELECT
SubscriberKey,
Mobile,
MessageID,
Name,
Sent,
Delivered,
Undelivered,
SMSStandardStatusCodeId,
Description
CreateDateTime,
ModifiedDateTime,
ActionDateTime,
MessageText
FROM _SMSMessageTracking
WHERE MessageID = 157 /* we could instead use [Name] column too */
AND Undelivered = 1

Did you know?

There is an SMSMessageTracking data extension template for quick DE creation.

I am a certified Salesforce Marketing Cloud Consultant at Bower House Digital in Melbourne, Australia.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store