You need a PLAN to deal with duplicates
Here's the thing about duplicate records: No matter what you do, you'll never get rid of them completely, because humans are human. Whether it's a staff member creating a duplicate record because they forgot to check if the record exists, or it's a customer who doesn't want to take the time to reset his password and just creates another record with a different email address, duplicates are going to happen.
And because duplicates are inevitable, you have to have a plan for dealing with them. Here are some suggestions:
- Create data integrity reports that will help you identify potential duplicate records, and run those reports consistently. ("Consistently" means at least once a month, if not more often.) And make sure someone (or several someones) on staff has responsibility for cleaning up this data.
- Make it everyone's job on staff to identify potential duplicates whenever they are using the database and make sure you have a clear process for how those duplicate records are reported. And make sure someone (or several someones) on staff has responsibility for cleaning up this data.
- And did I mention to make sure someone (or several someones) on staff has responsibility for cleaning up this data?
Managing duplicate records is a journey, not a destination. No matter how good your technology is, like weeds in a garden, duplicate records are going to appear. So you have to have a plan for dealing with them, not just now, but always.
![]()
Wes's Wednesday Wisdom Archives
“As good or better than me.”
“As good or better than me.” I was recently speaking with a software developer working […]
Documentation is insurance
Documentation is insurance In a conversation with a client about their data management needs, the client […]
It all comes down to fundamentals
It all comes down to fundamentals I’m preparing for a webinar that I’m presenting in […]
Blog post themes over 20 years…
Blog post themes over 20 years… I’ve been writing blog posts for nearly 20 years […]
Lots of feedback is a GOOD thing!
Lots of feedback is a GOOD thing! A client in the middle of their AMS […]
Doing the reps…
Doing the reps… I’m helping a client with the implementation of a new AMS. During […]
Add one, remove one
Add one, remove one In the world of home-organizing, there’s the “one in, one out” […]
Spring cleaning, all year long
Spring cleaning, all year long I talk frequently about “weeding the garden,” the idea that proactively […]
Don’t fall into the arrival fallacy trap
Don’t fall into the arrival fallacy trap The arrival fallacy is the false belief that […]
“The first time it lies to me is the last time I’ll use it.”
“The first time it lies to me is the last time I’ll use it.” Over […]
