fbpx

Your fundraising database should be the hub — the destination — for everyone in your department. To achieve this, your fundraising database must be clean, tidy, logical, and friendly. For every working person on the planet, when they start their day, they open up their email to check in on what is happening. The perfect scenario for development professionals is to open their email….but then also open their fundraising database.

If you can tackle and overcome these top 10 fundraising database issues, you are well on your way to data health and integrity!

Let’s talk through the top 10 fundraising database issues that we see when we clean up databases. These are in no particular order as they are all troublesome in their own special ways…

Duplicate Constituents. These are the worst! They wreak havoc on your reporting and mailing lists (and on your sanity!). This can be a big undertaking if you are sitting on years and years of duplicates.

Pledges with no payment schedules. My blood pressure just went up thinking about this. When a pledge is entered, it must have a payment schedule. The payment schedule drives your reminders, and if you don’t send reminders, you don’t get your payments.

Conflicting Communication Codes. Oftentimes we see databases where a constituent is coded as “do not mail” but then that same constituent is also coded as “mail newsletter.” What the what? Honoring donor communication preferences is super important and these codes need to be in good shape so you can comply with your donors’ requests.

Missing Gift Codes. Oddly enough, the issue with gift coding isn’t always the codes are wrong — it’s the lack of coding. We often find that the only pieces of data that are captured are gift date, gift amount, and designation. If you don’t track your solicitations and campaigns, how will you know what is working or not working?

Outdated Security. When someone leaves your organization, they shouldn’t still have access to your fundraising database. You would be shocked (shocked!) at how often we are sunsetting users that haven’t worked at the organization in 2 or more years.

Funds do not match Finance. I want to be very clear…if the funds in your fundraising database do not match the funds in Finance’s database, you will never reconcile. It is imperative that your funds echo what Finance has, and Finance should drive which funds should be active.

Addressees & Salutations. If your organization has established a standard around how you’ll address your donors (either formally or informally). All you have to do is pull a list of all addressees and salutations and fix the ones that don’t meet the standard.

Relationships are outdated. Relationships between donors is what makes your database a relational, robust system. The challenge is keeping up with those relationships, especially corporate and foundation contacts. This takes the village and major gift officers and grant officers should be trained on how to update these contacts. That also goes for their own portfolios!

Custom Fields are Out of Control. As time goes on, many attributes and custom fields lose their meaning. One staff member tagged a bunch of records, but that staffer isn’t there any longer. So no one knows what that code means. If no one knows what a code means, it should probably go. Custom fields should be purposeful codes!

Everybody uses notes instead of the Right Fields. People love their notes. The challenge is that notes are hard to query on because they are free text fields. I find that people use notes instead of putting data in the actual field. This occurs when marking individuals deceased, using notes to record donor interactions, and others.

If you can overcome these, you have taken a HUGE step toward database health. We’ve probably missed a few fundraising database issues. Comment below to tell us what your biggest issue is.