Don't forget about periodic maintenance
Just as most automobiles need periodic maintenance, keeping your data as up to date as possible requires maintenance, as well. And while most cars have a "typical" maintenance schedule, they are not all exactly the same (all-electric cars, for example, don't need oil changes!).
The same is true for the data in your AMS; not every organization is the same and so the maintenance won't be identical for all groups. But here are four suggested periodic maintenance activities that would apply to most associations:
- Review all demographic fields being captured against individuals and organizations, and determine if any need to be updated or eliminated. For example, if you collect experience level for individuals (e.g., "new," "mid career," "experienced"), as time passes, that data becomes incorrect. The same is true for "areas of interest" and even "markets served" (for organizations). I recommend doing this annually.
- Send a periodic reminder to your members to review and update their basic contact information (e.g., address and email, title). This should be done at least annually, but for some organizations, even more frequent check-ins may be necessary.
- For trade associations, check to make sure you have correct contact information for primary and other key contacts (e.g., billing, secondary/alternate, etc.). Depending on your dues cycle, this should be done at least annually if not more frequently.
- If you have a student membership, send a periodic reminder to students to confirm their expected date of graduation or other key data that you collect from them (e.g., area of study). Given the high rate of changes, especially among undergraduates, this should be done twice per year.
These are just four examples of the kind of maintenance all associations should be executing on a regular basis. Your organization probably has many more that should be done. So make sure you develop this "maintenance checklist" and that it is assigned to the appropriate staff to execute when necessary, to keep your database running like...a well-maintained automobile.
Wes's Wednesday Wisdom Archives
The hidden costs of bad data
The hidden costs of bad data Nobody likes bad data, and presumably we’re all working […]
Don’t let your customers edit their names online!
Don’t let your customers edit their names online! This issue came up recently and I […]
Once is an accident, twice is coincidence, three times is a pattern.
Once is an accident, twice is coincidence, three times is a pattern. We’ve probably all […]
“Every association does this.”
“Every association does this.” One of the most significant values I bring to my clients […]
Trust your gut
Trust your gut When I help associations with selection of a new technology system (e.g., […]
“People more frequently require to be reminded than informed.”
“People more frequently require to be reminded than informed.” “People more frequently require to be […]
Problems without solutions are not problems, they are facts of life
Problems without solutions are not problems, they are facts of life “Problems without solutions are […]
Perfect is not possible
Perfect is not possible We’ve all heard the phrase “Perfect is the enemy of good” and […]
“Different” isn’t necessarily better or worse.
“Different” isn’t necessarily better or worse. One of the biggest challenges I face when working […]
The Rule of 100 and 1,000 and automation
The Rule of 100 and 1,000 and automation I originally coined the rule of 100 […]