Engineering Atlas
☰ Menu
PortfolioAtlasDeploySQLData ViewsEnvBites
PT
Engineering Atlas / Data Views / _UndeliverableSMS
MobileConnectPRODUCTION

_UndeliverableSMS

Current MobileConnect held/undeliverable mobile-number state and bounce history.

Time: CST; DST not observed
Context Pack →Open Workspace →
Trust & provenancePRODUCTION
Evidence tierPRODUCTIONOfficial sources1Other sources0Last verifiedNot recorded

Evidence tier describes my hands-on relationship with the content. Official sources describe platform contracts/documentation. Production observations should not automatically be treated as official limits.

Starter query

Start from something valid.

SELECT
    un.MobileNumber,
    un.Undeliverable,
    un.BounceCount,
    un.FirstBounceDate,
    un.HoldDate
FROM _UndeliverableSMS un
Relationships

Where it connects.

Schema

Fields

FieldTypeFlagsNotes
MobileNumberPhone(15)INDEXED Subscriber mobile number.
UndeliverableBooleanIndicates the number is Held and MobileConnect stopped sending.
BounceCountNumberSMS bounce count for the subscriber.
FirstBounceDateDateDate of first bounce.
HoldDateDateNULLABLEDate MobileConnect stopped sending to the number.
Connected knowledge

Keep following the context.

Explicit and inferred relationships from the Atlas model.

View this node in graph →
RecipeDIRECT LINK
SMS Delivery & Opt-Out Diagnostic

Trace MobileConnect send state, delivery semantics, held numbers and subscription events without treating one status field as the whole truth.

Recipe step
DeploymentDIRECT LINK
MobileConnect / SMS Launch

SMS program or Journey activity with consent and tracking validation.

Deployment check → knowledge
DeploymentDIRECT LINK
Multi-Channel Journey Release

Journey release spanning email plus MobileConnect and/or WhatsApp with cross-channel identity and suppression checks.

Deployment check → knowledge
Snippet
Held / Undeliverable Mobile Numbers

Inspect MobileConnect numbers that are held after repeated delivery failures.

_UndeliverableSMS referenced in snippet
Runbook
MobileConnect / Journey SMS Troubleshooting

Trace an SMS from account configuration and consent through Journey execution, tracking status and held-number state.

_UndeliverableSMS referenced in runbook
Snippet
SMS Tracking by Journey Version

Map Journey-sent SMS tracking records to the Journey version via JBDefinitionID.

Shared context: mobileconnect
Snippet
Recent MobileConnect Opt-Outs

Review recently logged SMS opt-outs without assuming every row has a SubscriberKey.

Shared context: mobileconnect
Production Bite
A STOP Can Exist Without a SubscriberID

You see an opt-out/subscription event for a mobile number but no corresponding contact/subscriber ID.

Shared context: mobileconnect
Operational notes

Use this view when SMS is not being delivered and you need to determine whether the mobile number is held.

Verified sources
Salesforce — Data View: Undeliverable SMS ↗