Customer database completeness
Customers with a verified phone or email ÷ all customers in the database
- Formula
Customers with a verified phone or email ÷ all customers in the database- Unit
- %
- Aggregation rule
- Ratio of sums
- Source system
- CRM, CDP and loyalty program
- Owning role
- Head of marketing / CRM
- Frequency
- Monthly
Passport
- Grain
- Customer → base at a date
- Numerator
- Customers with a confirmed phone or email
- Denominator
- All customers in the base
- At zero or no data
- Zero denominator or no data: show “—”, not 0.
- Limits
- Confirmed means checked by a fact, not just a filled field. Duplicates are merged before calculating.
- Check example
- Confirmed customers: 7200; Customers in the base: 9000.
a/b*100. Result: 80.0% - Related metrics
Version 1.0 · valid from 2026-11-16 · checked 2026-11-16
Related pages
- Term: Customer data quality and duplicates
- Calculation: CRM coverage: how many sales and customers you can see and reach
Definition
Customer base quality and duplicates: completeness and accuracy of customer data (phone, email, consent, size). Duplicates are one person present several times; they understate repeat purchases and overstate the number of customers.
Suppose the base holds 100,000 records but 88,000 unique people: the duplicate share is 12%. Merge by normalized phone and email, keep the rule in writing. Purchases without an identifier do not reach LTV: watch the match rate.