Opportunities

Last refreshed: 2026-06-30
DQ
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
5,497
Opportunities object
TOTAL FAILS
28,103
across all validators
VALIDATORS
22
8 passing · 14 failing
AVG FAIL RATE
23.24%
across all validators
OVERALL HEALTH
POOR
Worst: 97.82%
Critical (> 20%) Medium (5 — 20%) Low (< 5%) Pass (0%)
Download CSV
Critical > 20% 7
Lead source is missingi
97.82% 5,377 / 5,497
Opportunities with no contact rolei
95.43% 5,246 / 5,497
Start date is before close datei
94.4% 5,189 / 5,497
Opportunities with no primary campaigni
71.66% 3,939 / 5,497
Opportunities with no contact IDi
68.95% 3,790 / 5,497
Closed-lost deal has revenuei
32.25% 1,773 / 5,497
Recurring revenue is zeroi
26.71% 1,468 / 5,497
Medium 5 – 20% 2
Close date is before created datei
12.28% 675 / 5,497
Revenue missing or zeroi
9.82% 540 / 5,497
Low < 5% 5
Closed-won deal has zero revenuei
1.06% 58 / 5,497
Client status is missingi
0.49% 27 / 5,497
Country is missingi
0.33% 18 / 5,497
Start date is missingi
0.04% 2 / 5,497
Total revenue does not match ARR + NRRi
0.02% 1 / 5,497
Pass 0% 8
Close date is missingi
0.0% 0 / 5,497
Created date is missingi
0.0% 0 / 5,497
Created date is same as close datei
0.0% 0 / 5,497
Stage is missingi
0.0% 0 / 5,497
Late-stage deal has missing revenuei
0.0% 0 / 5,497
Late-stage deal has missing start datei
0.0% 0 / 5,497
Region is missingi
0.0% 0 / 5,497
Organization type is missingi
0.0% 0 / 5,497