Over my 20 years of consulting with associations, one action that my most successful clients execute effectively is what I call data integrity reports. These are queries and reports that can help you identify potentially incorrect data.
I recently had the pleasure of participating in a presentation with Jennifer Richards, Director, Membership, at the American Association of Airport Executives. Part of her presentation included her data management schedule, reproduced below with her permission. This is one of the most fantastic examples I’ve seen.
The most important aspect to this schedule, which is implied but not explicit, is discipline. Jennifer and her team have the discipline to execute these processes regularly, to ensure the data is continuously cleaned at AAAE, thus keeping them in the virtuous cycle of data management.
Every organization should have some type of data management schedule similar to this. Does yours?