How do you clean duplicate records?
The same customer appears three times in the list. Once by full name, once abbreviated, once with a mistyped phone. Campaign messages reach them three times; your customer count looks bigger than it is. 👯
Duplicates look like minor untidiness but leak into every report: customer count, repeat rate, average spend.
Short answer: first write a matching rule, then merge, and finally set an entry rule that stops new duplicates. 🧽
Four costs of duplicates
BU BÖLÜMÜN ÖZETİ
- Wrong customer count
- Split history
- Repeated messages
- Unreliable reports
Invisible costs. 💸
Wrong customer count
The list looks big; the real customer base is smaller. 📉
Split history
A customer’s purchases spread across two records; a loyal customer looks new. 🔀
Repeated messages
Two or three sends to one person; annoyance and cost. 📩
Unreliable reports
When every number is suspect, decisions go back to gut feel. 🎲
The matching rule
BU BÖLÜMÜN ÖZETİ
- Phone number
- Email address
- Tax or customer number
- Name alone isn’t enough
How do we know it’s the same person? 🔍
Phone number
Normalised phone numbers are the strongest clue. 📞
Email address
Lower-cased email is the second strong clue. 📧
Tax or customer number
The most certain key for business customers. 🧾
Name alone isn’t enough
Different people share names; names are a supporting clue. 🪪
The clean-up process
BU BÖLÜMÜN ÖZETİ
- Take a backup
- Unify formats
- List candidates
- Merge with care
Four steps. 🧹
Take a backup
The list before clean-up is kept; going back must be possible. 💾
Unify formats
Phone and email into one format; see the data entry guide. ✍️
List candidates
Pairs matching the rule go on a list; no automatic deletion. 📋
Merge with care
History and consent kept; doubtful cases checked by hand. 🤝
Preventing new duplicates
BU BÖLÜMÜN ÖZETİ
- Search before adding
- System warning
- One way in
- Monthly check
Four rules. 🛡️
Search before adding
Before a new record, search by phone or email. 🔎
System warning
The tool warns when the same phone is entered. 🔔
One way in
Records only into the master list; see the scattered lists guide. 🚪
Monthly check
New duplicates are cleaned while still few. 🗓️
Four common mistakes
BU BÖLÜMÜN ÖZETİ
- Bulk automatic deletion
- Throwing away history
- Losing consent
- Clean once and forget
All four damage data. 🚧
Bulk automatic deletion
A wrong match deletes a real customer. ❌
Throwing away history
When merging, purchase history must gather in one record. 📜
Losing consent
Which record had consent? It must not be lost in the merge. ✅
Clean once and forget
Without a rule, duplicates come back. 🔁
What should I do today?
BU BÖLÜMÜN ÖZETİ
- Step 1: sort by phone
- Step 2: write the matching rule
- Step 3: set “search first”
- If you want help
Three steps, one hour. 🪜
Step 1: sort by phone
Sort the list by phone; how many identical numbers sit side by side? 📞
Step 2: write the matching rule
Phone, email, tax number; one page. 📝
Step 3: set “search first”
Search before every new record; tell the team today. 🔎
If you want help
Let us clean your records together: use the consult your expert form. For your current setup see the digital audit; the bigger picture sits in the data housekeeping roadmap. 🎯
Related reading from the archive: who owns the audience · collecting product reviews.
📝 Notes From the Field
A store’s customer list held thousands of records; once phone formats were unified and sorted, a large share turned out to be duplicates. After careful merging the true customer count shrank, but the repeat purchase rate rose noticeably. Many customers thought to be one-off buyers were actually regulars.
📖 Short Glossary
Duplicate record: more than one record for the same person or company. Matching rule: criteria deciding records belong to one person. Merging: combining duplicates into one record. Format consistency: information always written the same way.
⚡ Quick Summary
Duplicates leak into every report. 👯 They inflate customer counts, split history and repeat messages. Match by phone, email and tax number; names alone aren’t enough. Clean with a backup, unified formats and careful merging. “Search before adding” prevents new duplicates.
🎯 Next Step
Let us clean your records: use the consult your expert form. Entry rules sit in the data entry guide; for your setup see the digital audit.
Frequently Asked Questions
Sık Sorulan Sorular
They are useful for finding candidates. But merge decisions, especially doubtful ones, should be checked by hand; wrong merges lose data.
Usually the most complete and up-to-date one. The other record’s history and consent move into it.
One big clean-up, then short monthly checks. If the entry rule works, monthly checks take very little time.
