Skip to main content
Marketing Agencies

Marketing Data Hygiene: What Agencies Should Clean Before Every Campaign

Campaign performance is only as good as the underlying data. Here's a pre-campaign data hygiene checklist every marketing agency should run before any major send.

Key Takeaways
  • Poor data hygiene limits campaign performance and makes it impossible to diagnose why
  • Check match rates for custom audiences — below 40% signals list data quality problems
  • Verify conversion events fire correctly before spending budget, not after
  • Test all dynamic personalization fields with edge cases before launch
  • Run hygiene 5 days before launch — not the day before when there's no time to fix problems

The Data That Drives Campaign Performance

Campaign performance depends on data at multiple points: audience data that determines who sees the message, creative and copy data that determines the message itself, and measurement data that determines whether you know if it worked.

Poor hygiene at any of these points limits campaign performance — and makes it impossible to know why.

Audience Data Hygiene

For email campaigns:

  • Deduplication (same email address twice = two sends = double the unsubscribes)
  • Invalid email removal (format checks and bounce history)
  • Unsubscribe suppression (anyone who opted out must not receive the campaign)
  • Segment accuracy (is everyone in the "active customers" segment actually an active customer?)

Sohovi automatically finds every duplicate in your dataset — including near-matches — and shows you exactly which rows are affected.

For paid social (Meta, TikTok) custom audiences:

  • Match rate check (upload your customer list and verify the match rate. Below 40% suggests data quality problems in name/email matching)
  • Audience freshness (a custom audience built 90 days ago may not reflect your current customer base)
  • Exclusion lists (are current customers excluded from acquisition campaigns?)

For Google Ads customer match:

  • Same email format checks as email campaigns
  • Phone number format standardization (Google matches on phone as well as email)
  • Address standardization if using address-based matching

Measurement Data Hygiene

Before a campaign launches, verify your measurement setup is working:

  • Conversion events: Fire a test conversion and confirm it appears in your analytics platform within 24 hours
  • UTM parameters: Click a test ad and verify the UTM source/medium/campaign appears correctly in GA4
  • Attribution window: Confirm the attribution window in each ad platform matches your reporting agreement with the client
  • Audience exclusions: Verify exclusion audiences are applying correctly in each platform

Measurement setup problems are far cheaper to catch before launch than after you've spent a week of budget on uncountable results.

Creative and Copy Data Hygiene

Before any asset goes live:

  • All dynamic fields (first name, company, product name) are tested with edge cases (long names, names with apostrophes, missing values)
  • All URLs are live and land on the correct page
  • All UTM parameters in URLs are correct
  • Any personalization that relies on CRM data is tested with records that have missing fields

Sohovi profiles every column in your dataset for completeness and flags the exact rows where values are missing — free to try.

The Pre-Campaign Hygiene Timeline

  • 5 days before launch: Audience list pulls, verification, deduplication
  • 3 days before launch: Measurement verification, test events
  • 1 day before launch: Creative QA, URL checks, UTM verification
  • Day of launch: Final audience size confirmation, budget checks, go/no-go

Frequently Asked Questions

How do I increase Meta custom audience match rates?

Provide multiple identifiers (email, phone, first name, last name). Normalize phone numbers to E.164 format (+1XXXXXXXXXX). Hash data if uploading manually (Meta does this automatically via API). Match rates above 60% are achievable with clean data.

What should I do if a conversion event isn't firing in testing?

Check the pixel/tag is installed on the correct page. Verify the event is triggered by the correct action (button click, form submission). Use browser developer tools or Google Tag Assistant to debug. Do not launch until events are confirmed firing.

How often should I refresh customer match audiences?

Monthly for active customers. Quarterly at minimum for lapsed customer segments. Stale audiences reduce targeting efficiency as your customer base changes.

Selva Santosh

Data quality, for people who ship

Selva writes practical guides on data quality, profiling, and governance to help teams ship better data.

Start for free

Stop guessing. Start knowing your data quality.

Sohovi profiles your datasets in minutes — surfacing completeness gaps, type mismatches, and duplicate patterns before they reach production.

No credit card required · Free forever plan

Marketing Data Hygiene Checklist for Agencies Before Every Campaign | Sohovi