Newbie alert. There are no options in the Automation Studio to track SMS sends. Data Extract activity at least does not have that option. Is it possible to collect that data through an Sql activity and then export to a file on FTP server?

1 Answer 1


You are right RE: Tracking SMS sends automation Studio. Generally reporting is on SMS is not as comprehensive as emails in SFMC (mainly undelivered and no deeper engagement data).

It is possible to query achieve some reporting through queries.

Follow these steps:

  1. Write Queries to pick up the data you need from _SubscriberSMS and __UndeliverableSms data view.
  2. Use Data Extract Activity to extract the data
  3. A File transfer activity to drop it in the Export folder of your FTP.

Hope this helps


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .