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?