top of page

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

Analytics dashboard on a laptop screen
bottom of page