I have tried to find information about how to automate the export of MobileConnect status for unsubscribes with stop-code.

I've found this official documentation about querying data views as suggested in this thread here on stackexchange. But according to the documentation that query does not work with mobile connect.

This thread gave me some tips on a possible query but cant this be done as similar to a "Tracking extract activity" where no SOQL knowledge is necessary? Can someone point me in the right direction of where to look for a solution?

1 Answer 1


Probably the closest thing you can get to something like a Tracking Extract Activity would be to schedule a "SMS Message Detail Report" from within Analytics Builder and schedule it to save the file to the Enhanced FTP.

The resulting CSV report gives detail of every Mobile Originated and Mobile Terminated message that's gone through MobileConnect in the selected time range. This is overkill as you'll get STOP requests mixed in with everything else, but they're very easy to filter and no SQL required (SOQL is a Sales Cloud thing).

  • Thanks! As you said, a lot of other information in the report but with the filtering it gets the job done. Jul 18, 2017 at 9:08

You must log in to answer this question.

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