Review Undelivered Messages
- To hold the results of the SQL query activity, create a data extension.
- Include these fields in your data extension: MobileNumber, phoneUndeliverable, booleanBounceCount, numberFirstBounceDate, dateHoldDate, date
- MobileNumber, phone
- Undeliverable, boolean
- BounceCount, number
- FirstBounceDate, date
- HoldDate, date
- Create a query activity with this syntax: SQL: SELECT *From _UndeliverableSms
- To populate the data extension with the information from the UndeliverableSms data view, run the query activity.
