One of the most common challenges all of my clients face is duplicate records. And the simple fact is, even the very best managed databases have some duplicate records. They are impossible to avoid. Why? There are several reasons:
- Your members use multiple emails. As a result, they may create new records that your system doesn’t detect as duplicate.
- Your members use multiple names, including nicknames. One of my best friends in middle school was named John Christopher. He went by Max. Go figure.
- Your members move. Is James Smith from ABC company the same guy as James Smith at XYZ company? Maybe.
First we have to accept that we cannot completely eliminate duplicate records. But we can do things to minimize the number of duplicates:
- Ensure our technology has duplicate-detection functionality, both on staff side and customer side. At a minimum your system should be checking for duplicate email addresses, but possibly more than that.
- Implement data integrity reports that check for potential duplicate records.
- Make sure staff is properly trained so that as they enter data, they are first checking to make sure the individual doesn’t already exist in the database.
Duplicate records are a fact of database life. Get used to it. But be sure to have procedures and tools in place to minimize duplicate records.