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?
Add a comment
|
1 Answer
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:
- Write Queries to pick up the data you need from _SubscriberSMS and __UndeliverableSms data view.
- Use Data Extract Activity to extract the data
- A File transfer activity to drop it in the Export folder of your FTP.
Hope this helps
answered Aug 3, 2017 at 7:27
-
Thank you. But is it possible to get SMS sends info via Job? Or is job only limited to Email sends? Commented Aug 3, 2017 at 7:30
-
1As far as I understand, _Job is for emails only. help.marketingcloud.com/en/documentation/automation_studio/… Commented Aug 3, 2017 at 7:31
-
Thank you so much! Let me try it out and come back if your guide worked. I'll accept it as answer if it did. Commented Aug 3, 2017 at 7:40