I have noticed a sizeable chunk of data imported into MobileConnect has an incorrect Opt-in and Opt-out status.

I would like to correct the data, but don't want to do so manually on thousands of records. How can one update fields already in specifically in MobileConnect Subscription Data (and not in MobileConnect Demographics).

I intended to do so with queries or import definitions, but it would seem one cannot target _MobileSubscription.

Does anyone have any exprience with editing existing Mobile Subscription data

2 Answers 2


If you go to contact builder => import, you can create an import that can import subscribers from a data extension to a keyword, and then set their correct status based by a column's value in the DE.

You need one data extension and import definition per keyword.

Note, the subscription is BU specific.

** UPDATE **

If a person has opt'ed out, they need to update their status by either opt'ing in with an actual SMS or you need to update their status using an API call

  • Hitting the issue with the out->in update. Which API are you using Kenneth? The Contact Attributes or Mobile Connect?
    – Doug
    Dec 13, 2017 at 0:12
  • If memory serves, You need to update the mobile connect all subscribers list :) Dec 13, 2017 at 5:31
  • Hmm thats only the general opt in not the keyword so if all keywords are opt out you still cannot even if the general is opt in.
    – Doug
    Dec 15, 2017 at 1:18
  • Sorry, might be confusing things - there are two scenarios right? I opt out from the account or i opt in to the keyword. Keyword based opt in. I believe One from my team has solved it using ampscript in an e-mail that confirms the mobile opt in, which basically re-subscribes you to the keyword. Believe It’s mobile connect api :) Dec 15, 2017 at 7:42
  • Hmm.. Yea it seems API is the only reliable way :( We looked at this, having the MobileConnect Demographic data updated from SFDC, but creating it only works using singular contacts (not batch) so would be a massive drag on performance for our volumes :( Once the contact is there, we can do mass subscription using attribute set REST Methods but you need to extract the Keyword GUID, which can only be done based on the GET Attributes method, because no where on the interface or via API is it else visible :( ..another "come on, salesforce" moment it seems :(
    – Doug
    Jan 5, 2018 at 8:10

That is correct, opt-in can only be done manually, or opt-in from mobile or via API.

Opt-out can be done via Import in Mobile - All contact and populate the Status field with the value Unsubscribe (MobileConnect Demographics).

You must log in to answer this question.

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