Back to basics
Over the past couple of years I've noticed that some AMS vendors are adding in more sophisticated automated duplicate record checkers into their systems. These are not just "is this email already in the database" but much more. For example, one vendor has a tool that not only identifies potential duplicate records but also calculates the percentage likelihood of it being a duplicate!
Duplicate records are a challenge for every organization. And it will be a challenge forever. So the more tools we have at our disposal to address the issue, the better.
But like every tool, these tools are only as good as the staff using them. I've also observed over the past couple of years that many associations that know they have issues with duplicates aren't doing much about it. They say "We know this is a problem, but it's so overwhelming that we're just kind of working around it." Which said another way is "We're not doing anything about it."
Managing duplicates is a never-ending challenge for database management in general. But it's a core tenet to keeping a good, clean system. So be vigilant about managing duplicate records. And if you're not already, take advantage of all the duplicate management tools your vendor provides, and keep your system clean!
Wes's Wednesday Wisdom Archives
Painting the Bridge
Painting the Bridge According to this article, the Golden Gate Bridge is painted continuously year-round. …
Maintenance isn’t sexy
Maintenance isn’t sexy I remember reading once long ago that one of the reasons our …
“Will I still have a job when this is done?”
“Will I still have a job when this is done? While working with a client …
Evolution, not revolution
Evolution, not revolution I don’t recall where I first heard it many decades ago, but …
The power of the users’ group
The power of the users’ group Recently in an online users group forum for an …
Who is your data evangelist?
Who is your data evangelist? I was recently talking with a client of mine about …
Who is your data evangelist?
Who is your data evangelist? I was recently talking with a client of mine about …
Ratio of Data to Errors
Ratio of Data to Errors One of the elements of a good data governance plan …
Your people matter
Your people matter I’ve written many times about how people, process, and technology have to …
We remember moments…
We remember moments… “We do not remember days, we remember moments.” – Cesare Pavese Another …