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.
本文章是否解决您的问题？
请与我们共享您的想法，以便我们进行改进！
