10 Simple Rules for Effective Database Management


April 4, 2022

Data is a key asset for any association. It’s what drives member engagement, increases member retention, creates additional revenue, and enhances marketing efforts. The majority of associations are not doing as bad as they think at managing data. Still, there are always opportunities for improvement.

According to Wes Trochlil, president of Effective Data Management, it’s also important to remember that no matter what project you’re working on, there are always three elements involved in a successful endeavor: People, Process, and Technology. The intersection of those three elements is where ideal operations exist.

So if you have the right people in place, the processes are clear and explain how to do things properly and if you have the right technology in place you will be on the road to success. Interestingly enough, when things go wrong, it’s not usually the people or the technology at fault, it’s the processes.

Trochlil offers 10 rules on how to make sure your association’s processes for maintaining data don’t end up the weak link in the chain to data management, compliance, and governance.

Rule #1: Create data entry guidelines and user guidelines. This is all about documenting processes. Data entry guidelines tell us what type of data is being entered into any given field (i.e., if you’re entering an address, are you spelling out “street” or “St.”). User guidelines tell us how we're processing data for a given process (i.e., when a member joins, what happens).

Rule #2: Training. There are several things to keep in mind: Training must be made available to new staff and as a refresher later on; over-the-shoulder training is useless; and employees should be trained and/or tested in a sandbox, not in a live system. If trained in a live system, employees are more likely to react anxiously, worried that they may make a mistake that could be permanently damaging.

Rule #3: Eliminate shadow systems. A shadow system is any list of data being managed actively outside your primary system (Outlook list, spreadsheet, etc.). Every organization struggles with this, no matter how good.

Rule #4: Don’t manage to the exception. Many times, associations build processes for the exception rather than the rule. For example: An association with lawyers for members only wanted a certain type of lawyer as a member. So they created an approval process. It was explained that when a new member joined the process – from application to payment to approval, to membership – could take up to 60 days for the applicant to get full membership.

Rule #5: Capture all of your contacts in the primary system. Everyone should be doing business within the same system. Confusion can arise when multiple systems are operating separately and independently of one another. In the case of third-party systems and managing data, data should be brought back to the primary system so that everyone in the organization can have access to the information if necessary.

Rule #6: Processes for capturing non-financial, non-volunteer interactions. Capturing contacts that have value outside of financial and volunteerism can be a huge opportunity.
This refers to:
– People who want to volunteer
– People who give suggestions

Rule #7: Create data integrity reports. Such reports are designed to uncover whether you have erroneous data in your system. Think about what types of queries and reports can point out bad data (i.e., a report searching for whether there are “@” symbols in the email list, if an email address is missing one, it’s obviously not a good address). Weeding out bad data is something that must be done frequently if you want it to be successful.

When auditing old data, a good rule of thumb is to get rid of data that is three years old or older, especially if there’s been no interaction with the subjects in that time.

Rule #8: Start an internal user group. Even the most well-intentioned people can work with blinders on, working on and creating shadow systems unknowingly. An internal user group helps open the lines of communication to make people aware of what’s going on outside of their personal silos and encourages cooperation.

Rule #9: Practice database Public Relations. PR is about presenting the best face and the positive of a product or project. The reality of data management is that no one cares until they’re involved. Database PR is about putting over the process so that when something negative does happen people will still have faith that things can and do get better.

Rule #10: Pursue success, not perfection. Understand, as soon as data goes into your system it’s out of date. People die, lose jobs, and change addresses. So be comfortable knowing that your data is never going to be completely perfect and up to date.

Ultimately, your database is what you make of it and a direct reflection of how much you value it. By implementing even a couple of these ideas, you'll be well on your way to making positive progress in your data management effort. 

Multiview is invested in your association's digital marketing strategy and data management is a piece of that. Connect with our team to receive a free digital marketing assessment, or subscribe to our newsletter to get the best in association marketing and leadership updates direct to your inbox. 


Share This:

Newsletter Sign Up

Receive regular updates in your inbox.
Sign up for our newsletter!

Subscribe Here!

Discover more blog articles


Just as important as newsletter content and design, is the audience on the receiving end. Building a subscriber list is the best way to build a...


Your association newsletter is one of the most beneficial pieces to your industry, especially for members and prospects to stay up to date on events,...


If there is one thing the pandemic has shown, it is how resilient the American workforce is. On Labor Day, our nation honors the achievements and...


How can we help your association succeed

Complete the form and we'll connect with you right away.