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?