Opportunities

DQ
Data Quality Dashboard
Salesforce CRM — Validator Audit Report
🔍
6 objects 83 validators
TOTAL RECORDS
4,260
Opportunities object
TOTAL FAILS
21,726
across all validators
VALIDATORS
22
8 passing · 14 failing
AVG FAIL RATE
23.18%
across all validators
OVERALL HEALTH
POOR
Worst: 99.81%
Critical (> 20%) Medium (5 — 20%) Low (< 5%) Pass (0%)
Download CSV
> 20% 7
Lead source is missingi
99.81% 4,252 / 4,260
Opportunities with no contact rolei
95.26% 4,058 / 4,260
Start date is before close datei
94.48% 4,025 / 4,260
Opportunities with no primary campaigni
69.18% 2,947 / 4,260
Opportunities with no contact IDi
66.88% 2,849 / 4,260
Closed-lost deal has revenuei
32.0% 1,363 / 4,260
Recurring revenue is zeroi
27.09% 1,154 / 4,260
5 – 20% 2
Close date is before created datei
13.0% 554 / 4,260
Revenue missing or zeroi
10.4% 443 / 4,260
< 5% 5
Closed-won deal has zero revenuei
1.01% 43 / 4,260
Client status is missingi
0.47% 20 / 4,260
Country is missingi
0.38% 16 / 4,260
Total revenue does not match ARR + NRRi
0.02% 1 / 4,260
Start date is missingi
0.02% 1 / 4,260
0% 8
Close date is missingi
0.0% 0 / 4,260
Created date is missingi
0.0% 0 / 4,260
Created date is same as close datei
0.0% 0 / 4,260
Stage is missingi
0.0% 0 / 4,260
Late-stage deal has missing revenuei
0.0% 0 / 4,260
Late-stage deal has missing start datei
0.0% 0 / 4,260
Region is missingi
0.0% 0 / 4,260
Organization type is missingi
0.0% 0 / 4,260