You are here:
Review Undelivered Messages in MobileConnect
Use a SQL query activity in Automation Studio to retrieve information about undelivered SMS messages. This information shows only messages that failed to reach the mobile device.
Messages can fail to reach the device for these reasons:
- Mobile device is powered off
- User is out of range of cellular networks
- Number is for a landline
- Causes not related to Marketing Cloud Engagement
- To hold the results of the SQL query activity, create a data extension.
-
Include these fields in your data extension:
- MobileNumber, phone
- Undeliverable, boolean
- BounceCount, number
- FirstBounceDate, date
- HoldDate, date
- Create a query activity with this syntax:
- To populate the data extension with the information from the UndeliverableSms data view, run the query activity.
Did this article solve your issue?
Let us know so we can improve!
