Building an Email Data Quality Scorecard
You cannot improve what you do not measure. Most companies track campaign-level metrics like open rates and click rates, but very few track the underlying data quality metrics that determine whether those campaigns succeed or fail in the first place.
An email data quality scorecard gives you a single view of your database health. It tracks the metrics that matter, flags problems early, and shows improvement over time. Think of it as a dashboard for the foundation your entire email program sits on.
The Core Metrics
Your scorecard should track these metrics monthly:
Validity rate. The percentage of your active database that has been verified as valid within the last 90 days. Target: above 95%. Below 90% means you are sending to a meaningfully degraded list. This is your primary data quality metric.
Catch-all percentage (unresolved). The percentage of your database that is on catch-all domains and has not been resolved through specialized verification. Target: below 10%. If this number is high, you have a large segment of contacts with uncertain deliverability. Running these through CatchallVerifier brings this number down by converting uncertain addresses into confirmed deliverable or confirmed undeliverable.
Engagement rate (90-day). The percentage of contacts who engaged with at least one email in the last 90 days. Target: above 25%. Below 15% means most of your list is unresponsive and may be dragging down your sender reputation.
Bounce rate (campaign average). Your average bounce rate across campaigns in the last 30 days. Target: below 1%. Above 2% requires immediate investigation. Above 5% is an emergency.
Spam complaint rate. Average spam complaints as a percentage of emails delivered, over the last 30 days. Target: below 0.1%. Gmail requires under 0.3% (0.1% for high-volume senders). This is a hard threshold with real consequences.
Decay rate. The month-over-month increase in invalid addresses, expressed as a percentage. The industry average is approximately 2% per month. If your decay rate significantly exceeds this, investigate the cause (specific domain migrations, industry-specific turnover, etc.).
Source quality score. For each data acquisition source, track the percentage of imported addresses that verify as valid. Sources consistently below 85% validity warrant reconsideration.
Duplicate rate. The percentage of your database that contains duplicate records. Target: below 5%. Above 10% means your deduplication processes have gaps.
Scoring Framework
Assign each metric a status using a simple three-level framework:
Green (healthy): The metric is within target range. No action needed beyond continued monitoring.
Yellow (attention needed): The metric is outside the target but not yet critical. Plan corrective action for the current month.
Red (urgent): The metric has crossed a threshold where deliverability impact is likely or already occurring. Immediate action required.
Here are suggested thresholds for each level:
Validity rate: Green above 95%, Yellow 90-95%, Red below 90%. Catch-all unresolved: Green below 10%, Yellow 10-25%, Red above 25%. 90-day engagement: Green above 25%, Yellow 15-25%, Red below 15%. Bounce rate: Green below 1%, Yellow 1-2%, Red above 2%. Complaint rate: Green below 0.1%, Yellow 0.1-0.3%, Red above 0.3%. Decay rate: Green below 2%/month, Yellow 2-4%, Red above 4%. Source quality: Green above 90%, Yellow 80-90%, Red below 80%. Duplicate rate: Green below 5%, Yellow 5-10%, Red above 10%.
Building the Dashboard
The scorecard can be as simple as a monthly spreadsheet or as sophisticated as a real-time dashboard. Start simple and add complexity as needed.
Spreadsheet approach. Create a Google Sheet or Excel file with months as columns and metrics as rows. Color-code each cell green, yellow, or red based on the thresholds. Add a trendline chart for each metric. This takes 30 minutes to set up and 15 minutes per month to update.
BI tool approach. If you use a BI tool like Looker, Tableau, or Metabase, connect it to your CRM and email platform data. Build automated dashboards that pull metrics daily. Set up alerting rules to notify you when a metric crosses from green to yellow or yellow to red.
ESP native reporting. Most email platforms provide some of these metrics in their built-in reporting. Pull bounce rates and complaint rates from your ESP. Pull engagement data from your CRM. Combine them in your scorecard.
Monthly Review Process
Set up a monthly review cadence. This does not need to be a big meeting. A 15-minute review by the person responsible for email operations is sufficient:
Update all metrics. Compare to previous month. Identify any metrics that changed status (green to yellow, yellow to red, or improvements in the other direction). For any metric that worsened, identify the likely cause and plan corrective action. For any metric that improved, note what worked so you can continue or replicate it.
Share the scorecard with stakeholders monthly. Marketing leadership, sales ops, and anyone who imports data into your CRM should see the current state of data quality. This creates accountability and awareness that helps prevent quality problems at the source.
Using the Scorecard to Drive Action
A scorecard that just gets looked at and filed away is useless. Each metric should have a clear action plan for when it crosses into yellow or red territory:
Validity rate drops to yellow: Schedule an immediate re-verification of your database, focusing on contacts not verified in the last 90 days. Run catch-all addresses through CatchallVerifier.
Bounce rate hits red: Pause all campaigns to non-verified segments. Run emergency verification. Investigate which domain or segment is generating bounces. Suppress problematic addresses before resuming sends.
Complaint rate hits yellow: Review recent campaign content and targeting. Check if you are sending to unengaged segments. Verify your unsubscribe mechanism is working. Consider reducing send frequency for less engaged segments.
Engagement rate drops to red: Implement engagement-based segmentation immediately. Stop sending to contacts with no engagement in 180+ days. Run a re-engagement campaign for the 90-180 day segment. Focus sends on engaged contacts to rebuild sender reputation.
The scorecard transforms data quality from a vague concern into a manageable, measurable practice. When you can see the trends, you can act before problems become crises. When you can show improvement over time, you can justify the investment in verification, cleaning, and maintenance that good data quality requires.
