SMS Compliance & Automation Restructure
STATE MEDICAID AGENCY · SALESFORCE MARKETING CLOUD
The challenge
Members who had opted out of text messages were still receiving them. Phone numbers were stored as 10 digits in the member data and 11 digits in the unsubscribe list, so the two never matched and suppression silently failed. That was a serious TCPA compliance risk.
What I did
• Built a staging layer that standardizes every phone number to 11 digits before any send.
• Split one large, fragile automation into three focused ones: a weekly file-drop import, a daily journey data refresh and a daily MobileConnect sync.
• Audited SMS bounces and held statuses, uncovering a 45% duplicate subscriber key problem.
• Built a Mobile Number Health Check that sorts every number into a suppression list, held contacts and a high-bounce watchlist.
The result
Opt-outs are honored on every send, a failure in one step no longer breaks the whole flow, and the team has a clear, auditable record of who can be texted.
Tools: Marketing Cloud · MobileConnect · Automation Studio · Journey Builder · SQL
