I simply want to have an automated daily export of our SMS opt outs to our ftp.
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
This could be done under Automation Studio:
Create a DE to store the unsubscribers
SELECT _MobileSubscriptionID AS SubscriptionID, _MobileNumber AS MobileNumber, _OptOutStatusID AS OptOutStatusID, _OptOutDate AS OptOutDate FROM _MobileSubscription WHERE _OptOutStatusID = 1