What are YOUR data integrity reports?
Sitting in an AMS demo with a client recently, I was pleasantly surprised to see the AMS vendor had a short list of reports they called "Data cleaning" reports. These reports included a check for potential duplicate records, checking for erroneous emails, and checking for other missing data (e.g., physical address). With one click the staff could see a list of records that had potentially erroneous information and take action to clean it up.
This is fantastic, and something I'm seeing more frequently from AMS vendors. I work with my clients to help them identify data integrity reports that would be useful to them. And here's a fantastic example of data integrity reports in action at an association. (I've written a bunch about data integrity reports over the years; click here for more.)
Data integrity reports are critical for keeping your data clean over time.
My question for you: What data integrity reports do you have in place at your association?
![]()
Wes's Wednesday Wisdom Archives
Look up PARTIAL names!
Look up PARTIAL names! Train your staff to do look ups on partial names, not full […]
Not Just Technology
Not Just Technology There was recently a discussion on the ASAE online community about project management […]
Consider quitting
Consider quitting Patient: “Doctor, it hurts when I do this.” Doctor: “Then stop doing that.” […]
There is nothing so permanent as business rules
There is nothing so permanent as business rules Nobel Prize-winning economist Milton Friedman said, “There’s nothing […]
Budget for feature discovery and adoption
Budget for feature discovery and adoption When developing a budget for implementation of a new […]
Customize staff pages for better user adoption
Customize staff pages for better user adoption The single most important element to data management […]
Don’t ask questions for which you already know the answer
Don’t ask questions for which you already know the answer I was recently completing an […]
All decisions involve risk
All decisions involve risk Whether it’s choosing a new AMS or introducing a new product […]
Try flowcharting your processes
Try flowcharting your processes Working with a client recently on their membership join process reminded me […]
“I just want a system I don’t have to fight with.”
“I just want a system I don’t have to fight with.” I asked my client: […]
