To find failed SMS message deliveries to MobileConnect subscribers, query the _UndeliverableSMS data view.
Information from this query relates to the owner of a private short code or long code, or a client using a shared short code to which the subscriber has opted in.
Dates and times are stored in Central Standard Time. Daylight Savings Time isn’t observed. To view time-related data in your time zone, set time zone user preferences.
Note When profile attributes are created in Enterprise 2.0
accounts, new columns are added to the _EnterpriseAttribute table. Data view queries
in Enterprise 2.0 accounts can return results from profile attribute columns in
addition to the columns listed here.
Columns
| Name | Description | DataType | Data Extension Data Type | Nullable |
|---|---|---|---|---|
| MobileNumber | Mobile number for the subscriber | varchar(15) | Phone | |
| Undeliverable | Indicates that the number is Held and that MobileConnect discontinued sending messages to the subscriber | bit | Boolean | |
| BounceCount | Number of bounced SMS messages for subscriber | smallint | Number | |
| FirstBounceDate | The date when the first bounce occurred | datetime | Date | |
| HoldDate | The date when MobileConnect discontinued sending messages to the subscriber | datetime | Date | X |