Five Steps to Ensure the Success of Your Database

5 steps to ensure the success of your databaseEvery year associations collectively invest millions of dollars to upgrade their current membership database systems or to buy brand new systems.  Yet it seems that the more money we invest in our databases, the louder the protests are from staff, complaining that the database just doesn’t work.  How can this be?

There are five steps you can take to ensure that your database lives up to the expectations of its users.  By addressing each of these areas, association executives and those responsible for the associations’ database can help to minimize complaining from staff and maximize the usefulness of the database.

Step #1: Review, refine and re-engineer business processes — Today’s increasingly sophisticated relational databases offer a myriad of functions:  membership dues processing, events registration and invoicing, publications sales, fundraising, exhibit management, and many more.  One element common to all is process.

We define process as how information moves through the association and through the database.  For example, we process membership dues by reviewing the membership application, entering the key data elements, creating an invoice, entering payment against the invoice, printing a welcome letter, sending a welcome packet, and so on.

When contemplating a new database or an upgrade, completely review your business processes.  This will help you determine if you have inefficient or improper (or just plain outdated) procedures in place.  Discuss these processes with your association software developer.  Your developer has created the software to handle each process in a particular manner.  This may differ from yours.  Find out what it is, and if you can adapt your process to fit more closely what the developer had in mind, without sacrificing your business practice, do it.  This may require some fairly radical changes to how you do business internally, but in the long run will help to make the database more useful.

The primary danger of implementing a new database without reviewing your business process is that you may wind up automating bad process.  Bad process automated will continue to give you the wrong information, only faster than before. Don’t do it.  (In addition, if bad process is causing your database to function improperly, you can bet the staff will blame the software.)

Step #2: Develop Proper Training and Documentation — These two go hand-in-hand and are perhaps the issues most commonly complained about by association executives.  Once a review of the business process is complete and the installation or upgrade has begun, training and documentation become vital.  Unfortunately, association software providers are able to provide only generalized documentation and training for their system.  Neither their training nor their documentation will be specific to your particular membership database and its special elements.  This is where you need a specialist on the inside.

Some associations are now creating full-time positions, such as a member records administrator or database coordinator.  The position is responsible for providing documentation and training for the membership database. From processing new members, to changing membership entitlements, to simply changing an email address, this position is responsible for providing step-by-step instructions for each of the processes.

If a full-time position is not possible, consider using part-time help.  You may also want to contract with a database consultant.  Have the consultant learn your processes and your database, and then work with staff to document processes and develop training materials.

Step #3: Develop and Rigidly Adhere to Data Standards — You may have heard the term GIGO; garbage in, garbage out.  Simply put, this means that if the information you store in your database is not entered accurately or uniformly, no amount of reporting, consulting, or crying is going to give you the information you need.  This is where data standards come into play.

At one association we spent many months working with key database users developing a set of standards by which to enter all data.  Not only do the data standards state explicitly how to enter data (e.g., Street, not St., PO, not P.O., etc.), but it also clearly explains where to enter data and what fields must absolutely be entered in order for a record to be complete.

Standardizing data entry is critical for developing useful and accurate management reports.  Without strict standards, sorting of data can become difficult if not impossible.  For example, without clearly defined standards for titles, selecting and sorting on the title of vice president quickly becomes impossible, due to the myriad variations of this title (Vice President, VP, V.P., Vice Pres., etc.).  With a data entry standard that clearly states that one enters the title vice president as “Vice President,” selecting on this title now becomes very easy.  The same will be true of any other data fields you may choose to select or sort on.

Step #4: Continuously Collect Data — The old saying goes, the minute a directory is printed, it’s already out of date.  The same is true for association databases.  Depending on the industry or profession you serve, the addresses in your database may change as frequently as 5% per month.  Over the course of the year, with no updating being done, you could have a database with over 50% incorrect information! So how do you keep up?  Build data collection into the process.

Develop a laundry list of methods, both passive and active, for collecting data to update your database.  Some of the more obvious data collection mechanisms are publication order forms, meeting registration forms, and an annual directory update.  But there are other methods for collecting and updating data in your database.  These include establishing a web site that lets your members review their contact information, setting up computers with your database at your annual meeting for members to review, and working with your regions, chapters, or affiliates to assist you with data collection.

Data is gold to an association.  Keep your gold shining by actively and continuously seeking to update your data.

Step #5: Know What You Need and Want From Your Database — Too often, associations select an association database system based on what it is capable of doing, rather than on whether it does what the association needs it to do.  Understanding what you need from your database is not only key in the selection of your database but is essential to its continued effectiveness.

Typically there are several functions that a database needs to provide: contact management (address, phone, fax, email), membership tracking and invoicing, volunteer/committee activity, and more.  But what are some of the other items you need to track now or may need to track in the future?  How about meeting attendance, publications purchasing history, continuing education credits, or areas of interests?  All of these issues require the collection of data.  If you’re not collecting it, you can’t report it out, and you have to know you want to report it out to begin collecting it.

Understanding what your needs are now, and anticipating what your needs may be in the future can go a long way toward creating an effective database.  Be sure that you understand your needs and can articulate them to your software provider.


Did you like this article? If you’d like to receive notice of articles like these as they are posted in the future, click here.

Scroll to Top