Adapte Dijital
Kurumsal
Müşteri Girişi
Dijital Yönetim
AI SEO
Marka Yönetimi
Danışmanlıklar
Web & App & AI
Ads & Reklam
Kitle Yönetimi
Veri Yönetimi
Amaç & Hedef
Videolar
AINEO
Dijitale Yatırım Yap
Blog
Data Consulting

How do you clean duplicate records?

AuthorDilek Lök Published6 October 2026 Reading Time3–5 dk
How do you clean duplicate records?
💡 Kısaca: The same customer appears three times in the list.

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

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

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

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

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

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

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.

FOUR COSTS OF DUPLICATES WRONG COUNTlist inflates SPLIT HISTORYloyalty hidden REPEAT MESSAGESannoyance UNRELIABLE REPORTSback to gut Duplicates leak into every report

CLEAN-UP · FOUR STEPS 1 · Backup — going back must be possible 2 · Unify formats — phone and email 3 · List candidates — no automatic deletion 4 · Merge with care — history and consent kept

PREVENTING NEW DUPLICATES SEARCH FIRSTthen add SYSTEM WARNINGsame phone ONE WAY INmaster list MONTHLY CHECKclean while few Without a rule, duplicates come back

BÖLÜM 07

📝 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.

A store’s customer list held thousands of records; once phone formats were unified and sorted, a large share turned out to be duplicates.
BÖLÜM 08

📖 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.

Duplicate record: more than one record for the same person or company.
BÖLÜM 09

⚡ 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.

BÖLÜM 10

🎯 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.

Let us clean your records: use the consult your expert form.
FREQUENTLY

Frequently Asked Questions

Sık Sorulan Sorular

Are automatic merge tools reliable?

They are useful for finding candidates. But merge decisions, especially doubtful ones, should be checked by hand; wrong merges lose data.

Which record should be the master?

Usually the most complete and up-to-date one. The other record’s history and consent move into it.

How often should clean-ups happen?

One big clean-up, then short monthly checks. If the entry rule works, monthly checks take very little time.

Source: KOSGEB — business development resources

Bu Konuyla İlgili Diğer İçerikler

Share this article
WhatsAppXLinkedInFacebook

Comments

TREN