[SalesForce] What does the Status column specify in the MobileConnect Demographics and MobilePush Demographics

What does the Status column specify in the MobileConnect Demographics and MobilePush Demographics? I want to build a custom preference management for SMS and Push and for that if some one opts out I want to update the status attribute of the Demographics tables accordingly. How are these tables accessible? Are the "_MobileAddress" and "_PushAddress" data extensions that are accessible via Ampscript/SQL same as the demographics table?

Best Answer

_MobileAddress._Status

  • 1 = active
  • -1 = unspecified
  • 2 = bounced
  • 3 = held
  • 4 = unsubscribed

_MobileSubscription._OptOutStatusID

  • 0 = opted-in
  • 1 = opted-out

_MobileSubscription._OptInStatusID

  • 0 = opted-out
  • 1 = Opt-In Pending
  • 2 = opted-in

Yes _MobileAddress and _PushAddress data views are available via SQL queries

There is API available to update the mobile connect subscription status. Refer here You need to send a MO message to you shortcode or long code with the message parameter containing the stop keyword. This will then update the _MobileSubscription data view status columns

There might be similar API for mobile push unsubscribe as well.

Related Topic