I'm trying to query subscribers who didn't receive a SMS by using the _smsmessagetracking data view.
I am using the following SQL query:
Select
Mobile as Celular
From
_smsmessagetracking
Where
MessageText = 'Message text'
and
Sent = 1
and
Undelivered = 1
But it doesn't return the mobile numbers that didn't receive the message.
What does the 'Undelivered' field mean? Is it possible to query contacts who didn't receive a message that was sent to them?