The challenge
Aventedge, a global B2B events company, ran three event brands from one multi-brand Salesforce org and sent email through two platforms: MassMailer and Marketing Cloud Account Engagement (Pardot). Email bounce management was inconsistent, so nobody could say which contacts were safe to email for which brand. Poor CRM data hygiene had pushed the org over its Salesforce data storage limit and inflated the marketing database with hundreds of thousands of invalid records. Campaign automation ran on fragile Salesforce Flows with more than 20 campaigns hardcoded, and the Clay Salesforce integration kept failing to link enriched contacts to the right account or campaign because of record-locking errors. All of it had to be fixed in a production-only org, with no sandbox, without interrupting daily sales and marketing work.
What we did
- Built a single source of truth for email deliverability in Salesforce. We wrote a hard bounce and soft bounce classification engine in Apex and re-categorised 57,641 historical bounce events. Every contact now carries a per-brand deliverability status (Not Emailed, Deliverable, Soft Bounce, Hard Bounce or Blocked), and account-level rollups show the blocked percentage for each brand, refreshed hourly.
- Brought Pardot bounce data into Salesforce through a Data Cloud integration. An hourly pipeline pulls Account Engagement bounces and deliveries from Salesforce Data Cloud into the same deliverability model as MassMailer. The 2026 backfill loaded 4,468 bounces and 51,863 delivery records in about 40 minutes with zero failures.
- Ran a safe Salesforce data cleanup. We bulk deleted 677,721 obsolete suppression records and 103,466 invalid contacts identified by NeverBounce email verification and BounceBan, plus 19,164 related lead records. Each purge followed the same sequence: full backup, pilot batch, then Bulk API deletion. Opt-out records were preserved for compliance.
- Completed a Flow to Apex migration for campaign automation. Campaign creation and event lead routing now run on Salesforce Apex automation driven by 23 custom metadata campaign templates, replacing seven hardcoded Flows, with an on/off switch for instant rollback. For Clay contact enrichment, we built layered account matching (exact name, website domain, fuzzy, then search) that runs asynchronously, so an enrichment failure can never block a contact sync.
The result
The contact database dropped from 808,553 to 706,794 records, leaving a smaller marketing database of valid, mailable contacts, and more than 900 MB of Salesforce data storage came back within hours of the final purge. Every contact now carries a per-brand email deliverability status, so marketers exclude blocked and bounced addresses before each send, with bounce and delivery data from both email platforms landing in one model every hour without manual work. Adding a new campaign type is now a configuration row rather than a development task. Every change was validated, tested and deployed straight to production with a rollback path, and the business never lost a working day.