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
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?

SMS Status Codes

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

22 October 2020

Salesforce Marketing Cloud Release October 2020

We're back again with the October 2020 release, the another Marketing Cloud release of 2020. So we have picked out some of the most interesting parts of the release.

Read more

20 July 2020

Salesforce Marketing Cloud Release July 2020

The Salesforce Marketing Cloud July 2020 release will be rolled out between July 25 through to August 1, 2020. The team have picked out some of the most interesting parts of the release.

Read more

10 June 2020

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.

Read more