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.

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.

SMS Status Codes

If you need help with Track Delivery in SMS Data Views please reach out.