Campaign Members

Last refreshed: 2026-06-30

Data Quality Dashboard

Salesforce CRM — Validator Audit Report

🔍

6 objects 90 validators

Note: Opportunity, Contact, Lead and Campaign Member records are limited to those created on or after Jan 1, 2025. Account, Campaign, Campaign Member Status and Opportunity Contact Role are unfiltered. Counts and validator results reflect this scope.

TOTAL RECORDS

843,074

Campaign Members object

TOTAL FAILS

339,172

across all validators

VALIDATORS

8 passing · 5 failing

AVG FAIL RATE

3.09%

across all validators

OVERALL HEALTH

HEALTHY

Worst: 24.88%

Critical > 20% 1

HasResponded mismatchi

24.88% 209,771 / 843,074

Medium 5 – 20% 2

Status missing or invalidi

5.58% 47,023 / 843,074

Status not valid for campaign typei

5.58% 47,083 / 843,074

Low < 5% 2

FirstRespondedDate before CreatedDatei

2.48% 20,905 / 843,074

Same Lead/Contact multiple entries same CreatedDatei

1.71% 14,390 / 843,074

Pass 0% 8

CampaignId is missingi

0.0% 0 / 843,074

LeadOrContactId is missingi

0.0% 0 / 843,074

HasResponded True but FirstRespondedDate missingi

0.0% 0 / 843,074

FirstRespondedDate present but HasResponded Falsei

0.0% 0 / 843,074

CreatedDate is missingi

0.0% 0 / 843,074

Campaign type is missingi

0.0% 0 / 843,074

Type is missingi

0.0% 0 / 843,074

Duplicate campaign member (CampaignId + LeadOrContactId)i

0.0% 0 / 843,074