I simply want to have an automated daily export of our SMS opt outs to our ftp.


1 Answer 1


This could be done under Automation Studio:

  1. Create a DE to store the unsubscribers

    -- SubscriptionID,MobileNumber,OptOutStatusID,OptOutDate

  2. SQL Query:

SELECT _MobileSubscriptionID AS SubscriptionID, _MobileNumber AS MobileNumber, _OptOutStatusID AS OptOutStatusID, _OptOutDate AS OptOutDate FROM _MobileSubscription WHERE _OptOutStatusID = 1

  1. Data Extract
  2. File Transfer

You must log in to answer this question.

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