Customer data quality and duplicates
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.
Formula
Duplicate share = records above unique ÷ all records; completeness = records with the field ÷ all records
How to read
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.
Where it is discussed
Topics
Calculations
Documents
- CRM analytics: RFM, cohorts, retention, LTV/CAC, loyalty
- Customers’ personal data: Federal Law 152-FZ for a brand and a retailer. Grounds and consents, storage, localization, loyalty, mailings, liability