Dirty data be gone! Five tips to spring-clean your database
Spring has sprung! The sun is shining, the days are a bit longer and the snow has finally melted. We have a renewed energy to change our surroundings – throw open the windows, let in some fresh air, clear cobwebs from the corners and purge items that no longer bring us joy.
What about your database? When was the last time you conducted some spring cleaning on your donor data so that data pulls, analysis and reporting didn’t require extra manual manipulation? Wouldn’t it be wonderful to run a list or generate a report knowing that the information could immediately be sent to the mail house or presented to your senior leadership team? It is possible. It just requires some vigilance with key data points.
Like spring cleaning, consider a day dedicated to database clean-up. Divide and conquer the inconsistencies, the missing or dirty data. Here is a checklist to help you get started on spring cleaning your database for greater efficiency in your fundraising:
Check for duplicate records
There is nothing more inefficient than sending the same communication multiple times to the same person. Once you have done an initial de-dup of your database, develop a schedule to check for duplicate records depending on how many new records are created and when.
Cross reference organizational contacts
Does the person that you send your mailings to really still work at Company ABC? Are they still the best person to connect with about your organization? A simple search via LinkedIn or through a paid database like iwave will confirm a person’s employment at an organization.
Search for lost donors
People and businesses move. Take some time to try and find a new mailing address for a donor so that you can reconnect with them.
Review codes for consistency and redundancy.
There is nothing more frustrating than having three codes within a field for the same piece of data. For example, have you tried to pull an email for a donors only to learn that for some the field is labelled ‘Email’, while others have the field labelled as ‘Home Email’ or ‘Primary Email’? Decide on the label and change the records to all be the same.
Are you coding the same piece of data in multiple fields within a person’s record? For example if a donor unsubscribes from your email newsletter, do you code this piece of information in one field or in a few different places? Marking the same piece of data in multiple places is a duplication of effort and inefficient. Decide where you will code key pieces of information. Be consistent with that coding in order to easily include or exclude the data when pulling a list or generating a report.
Bring your dark data into the light.
Fundraising in spring means golf tournaments, fun runs and planning for fall gala events. Often the events team rely on Excel spreadsheets to track registrants, foursomes, and table seating configurations.
Make a plan to record in your database registrant information. Track which foursome Major Gift Prospect golf’s with each year or which power couple your Board Members have seated at their table for your gala. Events are an incredible source of valuable information on connections – both business and personal. Are you recording these valuable connections into your database?
Spring cleaning your data is a big job. Consider enlisting a group of database power users on your team to divide and conquer the inconsistencies, the missing, dirty or dark data. Your efforts will be rewarded with accurate data that you can efficiently and confidently use for your fundraising efforts.
