Marketing Cloud Account Audit & Billable Contact Cleanup
HEALTHCARE & GOVERNMENT CLIENTS · SALESFORCE MARKETING CLOUD
The challenge
Marketing Cloud accounts that have run for years collect contacts nobody can reach: orphaned records, duplicate subscriber keys and contacts with no email or phone number. Every one of them still counts toward the billable contact limit, and they make reporting less reliable.
What I do
• Inventory contacts across business units to see what exists and where. On one engagement this surfaced more than 268,000 orphaned contacts.
• Find duplicate subscriber keys and contacts with no channel address using SQL in Query Studio and Automation Studio.
• Agree a keep, delete or review list for data extensions with the client before anything is removed.
• Batch-delete unreachable contacts safely through Contact Builder, then confirm the new counts.
The result
A leaner account with fewer billable contacts, cleaner data behind every journey, and reports the team can trust.
Tools: Marketing Cloud · Contact Builder · Query Studio · Automation Studio · SQL
