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
_MobileSubscription._OptOutStatusID
_MobileSubscription._OptInStatusID
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.