Campaign Members

DQ
Data Quality Dashboard
Salesforce CRM — Validator Audit Report
🔍
6 objects 83 validators
TOTAL RECORDS
839,543
Campaign Members object
TOTAL FAILS
334,397
across all validators
VALIDATORS
13
8 passing · 5 failing
AVG FAIL RATE
3.06%
across all validators
OVERALL HEALTH
HEALTHY
Worst: 24.71%
Critical (> 20%) Medium (5 — 20%) Low (< 5%) Pass (0%)
Download CSV
Critical > 20% 1
HasResponded mismatchi
24.71% 207,479 / 839,543
Medium 5 – 20% 2
Status not valid for campaign typei
5.53% 46,441 / 839,543
Status missing or invalidi
5.52% 46,384 / 839,543
Low < 5% 2
FirstRespondedDate before CreatedDatei
2.35% 19,701 / 839,543
Same Lead/Contact multiple entries same CreatedDatei
1.71% 14,392 / 839,543
Pass 0% 8
CampaignId is missingi
0.0% 0 / 839,543
LeadOrContactId is missingi
0.0% 0 / 839,543
HasResponded True but FirstRespondedDate missingi
0.0% 0 / 839,543
FirstRespondedDate present but HasResponded Falsei
0.0% 0 / 839,543
CreatedDate is missingi
0.0% 0 / 839,543
Campaign type is missingi
0.0% 0 / 839,543
Type is missingi
0.0% 0 / 839,543
Duplicate campaign member (CampaignId + LeadOrContactId)i
0.0% 0 / 839,543