How to Score Your Salesforce Data Quality (With Queries)

Your Salesforce data is either an asset or a liability. Here's how to know which one you have.

The Data Quality Score

I score data quality on a simple 0-100 scale across 5 dimensions: completeness, accuracy, consistency, timeliness, and duplication. Here's how to check each one.

Completeness — Are Required Fields Actually Filled?

SELECT COUNT() FROM Contact WHERE Email = null
-- Repeat for Phone, MailingCity, Title, etc.

Calculate: (records with field / total records) × 100 for each critical field. If your Contact email completeness is below 80%, your marketing team is working with bad data.

Duplication — How Many Copies Do You Have?

SELECT Name, COUNT(Id) cnt FROM Account
GROUP BY Name HAVING COUNT(Id) > 1

Every duplicate means split pipeline, split activity history, and wrong reports. I've seen orgs where 15% of accounts were duplicates.

Timeliness — Is Your Data Current?

SELECT COUNT() FROM Account
WHERE LastModifiedDate < LAST_N_DAYS:365

Accounts not touched in a year are stale. If more than 30% of your accounts are stale, your territory model is based on outdated information.

Consistency — Do Fields Follow Standards?

Check for inconsistent formatting: "US" vs "USA" vs "United States" in country fields. "CA" vs "California" in state fields. These break every report and dashboard that filters by location.

Your Score

Average your completeness, duplication, timeliness, and consistency scores. Below 70 = your data is a liability. Above 85 = you're in good shape.

Or run a free scan and I'll calculate it for you automatically.