Subscribe to my newsletter EDM News
Why you can’t eliminate dupes
15 January 2008, by , in Data Management, No comments

I’ll frequently hear from my clients and other database managers, “Our members keep creating duplicate records of themselves, rather than using their existing database record. What can I do to eliminate duplicate records that are created by my customers and members?”

This is a common problem across all of my clients, without regard to the system they are using. There are several elements at play:

  1. Customers are busy, just like the rest of us, so they’ll take the path of least resistance. If you don’t make it obvious how to retrieve a password AND explain why that’s better/easier than recreating their record, they’ll keep recreating records.
  2. Customers are human, so regardless of how much we beg, cajole, and threaten, we will have some amount of dupes. No matter what.
  3. It’s difficult to design a system that checks for dupes without creating all kinds of obstacles for the customer and slowing the whole process down, thus negating its value.
  4. We have to have systems in place for dealing with the dupes. I recommend to my clients developing several data integrity reports to check for this kind of problem regularly. Here are a couple of earlier posts on that subject: active vs. passive data management and weeding the garden.

Finally, keep in mind that, generally speaking, cleaning up the duplicate records is still easier and better than other alternatives (e.g., having staff do all the data entry, or setting up barriers that are so high that customers stop using the website.)

My point is that while we should continually strive to minimize dupes, we’ll never eliminate them.

About author:

Archives

Sign-up for EDM News

 

 

Testimonials

“Wes was able to come in and offer tangible, relevant advice that made us more productive immediately. I value his understanding of databases but more so, his understanding of how nonprofits work. There was no lost time educating him about how membership organizations are “different.” Wes recommended changes in processes as well as tips and tricks that were easy to implement made an immediate positive impact.”

Mary Pat Paris, Executive Director
International Registration Plan

“We came to Wes because we were very frustrated with our existing AMS and we wanted to improve our capabilities as soon as practicable. Wes very quickly helped us through a process of identifying our needs, identifying potential vendors, and selecting a new system that we’ll be able to move into very quickly. I especially appreciated Wes’s candor about our processes as well as the systems we were looking at. He was a great resource to have in a period of high anxiety for our organization. I would highly recommend Wes for any similar project.”

Jack Chiasson, CMP Executive Director
National Association of Life Brokerage Agencies

“Wes was able to come in and offer tangible, relevant advice that made us more productive immediately. I value his understanding of databases but more so, his understanding of how nonprofits work. There was no lost time educating him about how membership organizations are “different.” Wes recommended changes in processes as well as tips and tricks that were easy to implement made an immediate positive impact.”

Mary Pat Paris, Executive Director
International Registration Plan

Mary Pat Paris
International Registration Plan

“This is the second database implementation we’ve done since I have been at Western Arts Alliance (WAA). The first I did on my own. This time we engaged Wes Trochlil as our database planning consultant. Let me tell you, this process is a whole lot easier having Wes on your team! For a small association like WAA, it’s tempting for board and EDs to question the justification and expense of a database planning consultant. But it’s the small associations that need Effective Database Management the most. Wes strengthened our planning process, clarified our needs requirements, helped us steer around solutions that couldn’t meet our objectives, and saved us money in the long haul.”

Tim Wilson, Executive Director
Western Arts Alliance

Tim Wilson
Western Arts Alliance
%d bloggers like this: