Welcome to our new website!
Feb. 19, 2025

Optimizing Your Donor Database for Greater Impact

Optimizing Your Donor Database for Greater Impact

Send us a text

In this episode, Nathan discusses the vital role of donor relationship management systems in enhancing nonprofit fundraising efforts. Providing some practical insights and tips, Nathan explores key features such as donor management, fundraising tools, and data analytics, we emphasize the importance of selecting the right database tailored to an organization's needs.


Support the show

The Hosts of The Practice of NonProfit Leadership:

Tim Barnes serves as the Executive Vice President of International Association for Refugees (IAFR)

Nathan Ruby serves as the Executive Director of Friends of the Children of Haiti (FOTCOH)

They can be reached at info@practicenpleader.com

All opinions and views expressed by the hosts are their own and do not necessarily represent those of their respective organizations.

Chapters

00:09 - Effective Nonprofit Database Management

13:24 - Database Integration and Security Considerations

23:28 - Show Recommendation Request

Transcript
WEBVTT

00:00:09.029 --> 00:00:11.512
Welcome to the Practice of Nonprofit Leadership.

00:00:11.512 --> 00:00:12.753
I'm Nathan Ruby.

00:00:12.753 --> 00:00:17.402
Today, we are going to be talking about databases.

00:00:17.402 --> 00:00:34.033
Now, this is important for you because if you have a good database, because if you have a good database, well and some people call them CRMs, customer relationship management CRM comes from the for-profit world, the for-profit sales world, to be exact.

00:00:34.033 --> 00:00:41.439
That's where the acronym came from, so I guess for us it'd be donor relationship management, right?

00:00:41.439 --> 00:00:42.402
So we'd call it.

00:00:42.402 --> 00:00:45.127
What is that DRM?

00:00:45.127 --> 00:00:47.491
So DRM for us.

00:00:47.491 --> 00:01:08.085
But anyway, if you have a good database and that is or DRM, or CRM, whatever you want to call it, it will help you raise more money, and so it is worth the time and effort to get the right one to help you be the most successful you can in your fundraising program.

00:01:08.085 --> 00:01:10.087
So what does that look like?

00:01:10.087 --> 00:01:12.253
Well, let's take a look at it and see.

00:01:12.253 --> 00:01:23.975
All right, here are a few things that you need to focus on when you're looking for your first database, or if you've got a database that you've kind of outgrown and you need to upgrade, so this is relevant for you too.

00:01:23.975 --> 00:01:26.221
So, thegrown and you need to upgrade, so this is relevant for you too.

00:01:26.823 --> 00:01:29.469
So the first thing we want to look at is donor management.

00:01:29.469 --> 00:01:32.724
How does this system help you with donor management?

00:01:32.724 --> 00:01:37.034
And by that we mean tracking donor information.

00:01:37.034 --> 00:01:53.870
So is it easy to store contact details so phone numbers and emails, and summer homes and winter homes in Florida or Texas or Arizona, wherever your donor might, winter Giving history?

00:01:53.870 --> 00:02:00.531
Is that an easy thing that you can find and look at, because that becomes very important when we're asking for gifts this year.

00:02:00.531 --> 00:02:08.373
Can you track communication preferences, such as no mail or only send an appeal letter?

00:02:08.373 --> 00:02:24.274
And now, as we are getting, we all of us fundraisers are a little bit more and more and more on online giving and email, looking for gifts through email and online.

00:02:24.274 --> 00:02:30.868
Is there a place to do no email or no email on specific appeals?

00:02:30.868 --> 00:02:32.775
That's actually something I'm dealing with.

00:02:32.775 --> 00:02:32.996
Now.

00:02:32.996 --> 00:02:37.586
I've got a couple of donors who have asked to not receive.

00:02:37.586 --> 00:02:45.175
They're fine with the direct mail, but it's the email that we're doing that they want to manage, and so is that easily manageable?

00:02:45.175 --> 00:02:50.429
And the answer on the database I have is not quite as easy as I would like it to be.

00:02:50.429 --> 00:02:55.210
We found a workaround, but it wasn't quite as easy as it should have been.

00:02:56.033 --> 00:02:58.061
And then, of course, any other relevant notes.

00:02:58.061 --> 00:03:06.074
Is there a notes section to where you can make notes about conversations that you had with donors, donor preferences.

00:03:06.074 --> 00:03:13.693
And here's one that I do with my donors and they are in the notes that I keep on my donors.

00:03:13.693 --> 00:03:26.689
I track what their favorite drink is, whether it be an adult beverage or a Coke, or Pepsi or Diet Coke, or I've got one donor that's diet Dr Pepper.

00:03:26.689 --> 00:04:07.283
I write that down because then the next time we meet, when, if you're at a restaurant or someplace like that and we're getting ready to order and I could say diet Coke, right, or diet Dr Pepper, or and it's, and it's amazing how people, if I remember what you drink, that means we are in a relationship and it is a reinforcement for that donor to say, oh, my gosh, nathan, really we're in a relationship, he really knows me and that is a big deal when it comes to fundraising me and that is a big deal when it comes to fundraising.

00:04:07.283 --> 00:04:09.271
So I'm not saying you have to do that, but that's where I keep that information.

00:04:09.271 --> 00:04:18.180
It's not because I have an amazing memory and it's because I wrote it down and I looked at it before I went into the restaurant, so anyway.

00:04:18.180 --> 00:04:21.826
So remember that stuff and that's a place to put those notes.

00:04:22.908 --> 00:04:25.312
What else is in the donor management section?

00:04:25.312 --> 00:04:26.855
Segment donors.

00:04:26.855 --> 00:04:30.908
Can you track donors by different criteria?

00:04:30.908 --> 00:04:39.846
So maybe you'll be looking for any donor with 500 and above because you're going to do a special invitation to them to the gala.

00:04:39.846 --> 00:04:48.997
Or maybe you're looking for people, donors, who gave last year less than they did in 2023.

00:04:48.997 --> 00:04:57.173
That's actually something you should be looking for you should be going through your database now and who gave less in 24 than they did in 23.

00:04:57.173 --> 00:05:00.509
So can you segment donors that way?

00:05:00.509 --> 00:05:15.684
And then, last, of course, is gift tracking, and so, just you know, is it easy to be able to keep track of one time, somebody who gave one time during the year, or your monthly donors or people that give once a quarter?

00:05:15.684 --> 00:05:19.752
Is it easy to track that, the frequency of gifts?

00:05:19.752 --> 00:05:26.752
So, under under donor management, you know, donor information, segment donors and gift tracking.

00:05:26.752 --> 00:05:28.887
Those are kind of the three things that we're looking for.

00:05:30.701 --> 00:05:32.548
Next is fundraising tools.

00:05:32.548 --> 00:05:43.869
So this is a little bit more about okay, how are they going to help you raise money now, all right, and so there's a couple, two, three ways they could do that.

00:05:43.869 --> 00:06:03.464
One is donation forms, and donation forms is how you can do easily online giving through customizing the forms, and I don't know all the details on that and how to walk you through the or explain that, because I just know it works and I know that it needs that.

00:06:03.464 --> 00:06:04.607
So that's got to be.

00:06:04.607 --> 00:06:11.348
One of your question is how easy are the donation forms to work with and can I understand how to use them?

00:06:11.348 --> 00:06:20.735
So donation forms through online giving, campaign management, to track and manage your fundraising strategies?

00:06:20.735 --> 00:06:31.141
So we're going back to your fundraising plan and you're going to have, you know, depending on on how sophisticated and how big your your fundraising program is two or three or four.

00:06:31.141 --> 00:06:39.790
Some of you may even have five uh fundraising strategies that you're doing, and so it is important throughout the year to be able to track that.

00:06:39.790 --> 00:06:43.420
So is our uh gala fundraiser?

00:06:43.420 --> 00:06:46.930
Are we uh, you know ahead or ahead or behind of where we want to be?

00:06:46.930 --> 00:06:52.211
Our gala is in a month, but our 5K run is in the fall.

00:06:52.211 --> 00:06:56.391
We've got four or five months, but are we on track for that?

00:06:56.391 --> 00:07:06.581
And oh, how's our direct mail doing so to easily track those individual fundraising strategies and maybe even down to the tactics level?

00:07:06.581 --> 00:07:15.124
It's important for your database to be able to help you with that, because the database, the CRM, should help you.

00:07:15.124 --> 00:07:30.896
It should help you with these things so that you could do them faster, quicker, more accurately and you don't have to spend so much time trying to figure out and working on piece of paper and pencil to try to figure out where you are in these things.

00:07:30.896 --> 00:07:33.968
So campaign management is a piece of the fundraising tools.

00:07:34.488 --> 00:07:55.288
And then gift acknowledgement, and this is really important in the giving cycle because the gift a lot of people, a lot of executive directors, make the mistake and they think that the gift acknowledgement is the end of the gift and I mean, I guess technically it is the end of that particular gift.

00:07:55.288 --> 00:07:58.920
So somebody writes a check, puts it in an envelope and sends it in.

00:07:58.920 --> 00:08:11.449
Somebody goes on your website and clicks the give here or give now button and they give, or they find a QR code on your direct mail piece and they use their phone to give online.

00:08:11.449 --> 00:08:13.341
That way, however, they make their gift.

00:08:13.341 --> 00:08:14.583
That's fine.

00:08:14.583 --> 00:08:17.771
And then the acknowledgement letter goes out.

00:08:17.771 --> 00:08:28.062
So they get a letter it says thank you very much and at the bottom of the letter maybe it's got the tax receipt documentation on it, or maybe you do that at the end of the year.

00:08:28.062 --> 00:08:55.740
Either way is OK, but whatever you're sending that letter out, your database should make that simple and easy for you and it should be a seamless system or a seamless process because, yes, while it's the end of that particular gift, it also marks the beginning of the next gift.

00:08:56.379 --> 00:09:13.466
So when you're sending your donor a thank you letter, that is, you are now gearing them up for their next gift and the next gift and the next gift, and so we want that gift acknowledgement to be really good and we want it to go out rather quickly.

00:09:13.466 --> 00:09:17.488
If we could get that out the same week, that would be awesome.

00:09:17.488 --> 00:09:20.750
Uh, 48 hours would be even more awesome.

00:09:20.750 --> 00:09:25.852
Manure, awesome, awesomer, awesomer, awesomest Uh 48 hours is is.

00:09:25.852 --> 00:09:30.355
We'd really like it to be that quick, but you know some organizations we just can't do that.

00:09:30.355 --> 00:09:31.836
We just can't get to that standard.

00:09:31.836 --> 00:09:34.878
Uh, and so within a week would be.

00:09:34.878 --> 00:09:39.480
You know, in that case, a week would be great and anyway.

00:09:39.480 --> 00:09:42.903
So that thank you letter is part of that important process.

00:09:43.863 --> 00:09:46.594
Okay, number three reporting and analytics.

00:09:46.594 --> 00:09:51.976
Your database you want it to be able to spit out reports for you.

00:09:51.976 --> 00:10:01.304
You know reports for you know donors and their tax requirements for auditing, foriting for tracking just your overall fundraising.

00:10:01.304 --> 00:10:37.879
And some databases are more geared towards a higher level of skill set when it comes to putting in queries and running reports, and the more flexibility you have in creating the report, the more complex the setup of the query is, which means the more knowledgeable you need to be in databases and running queries.

00:10:37.879 --> 00:10:42.626
You need to be in databases and running queries, and so.

00:10:42.626 --> 00:10:53.897
So, for instance, if you want to run a list of every donor from your town, uh, for last year, so you would have you know whatever name of your town, I want every donor who gave in that town.

00:10:53.897 --> 00:10:59.745
Um, or maybe that's not the best example, but we'll with it because that's what we started with.

00:10:59.745 --> 00:11:04.174
So, any town I've got X town, I want every donor in that town.

00:11:04.355 --> 00:11:05.918
Okay, so it runs the list.

00:11:05.918 --> 00:11:12.294
Well, do you want the list to be in this format?

00:11:12.294 --> 00:11:19.332
Do you want it first name, last name, address, phone number, email, gift amount?

00:11:19.332 --> 00:11:22.365
Do you want it to be just first name, last name, gift amount.

00:11:22.365 --> 00:11:30.730
Do you want it to be first name, gift name, or first name, last name, phone number and cumulative giving for the year?

00:11:30.730 --> 00:11:47.019
So the more flexibility you have in creating what the list looks like, the more complex it's going to be to create that list, whereas some databases will just have one way or maybe two ways of looking at it.

00:11:47.019 --> 00:11:59.140
So if you want more flexibility in what reports look like, you better be able to know how to do queries, or at least be willing to learn how to do it.

00:11:59.140 --> 00:12:03.172
And so that's just again.

00:12:03.172 --> 00:12:05.037
One's not right and one's not wrong.

00:12:05.037 --> 00:12:05.765
It's just.

00:12:05.765 --> 00:12:18.018
If you don't have experience in running queries, it's way easier to look at databases that maybe have a little less flexibility, but they just run out the basic reports for you.

00:12:20.304 --> 00:12:21.967
Okay, next would be donor trends.

00:12:21.967 --> 00:12:31.389
You know, we want to know, we absolutely want to know if we had a donor who didn't give last year, holy smokes.

00:12:31.389 --> 00:12:36.239
We really want to know who that is and then we could decide.

00:12:36.239 --> 00:12:37.830
You know, is that somebody we want to call?

00:12:37.830 --> 00:12:44.958
Is that somebody we want to contact and reestablish the relationship?

00:12:44.958 --> 00:12:47.384
But we won't know that if we don't run the report.

00:12:47.384 --> 00:12:50.792
So you definitely want to have good donor trends.

00:12:50.792 --> 00:13:07.682
So lapsed donors, monthly donors, your largest donors, so different ways to segment those donor trends to help you make decisions about how should I engage with this donor and how should I do that.

00:13:07.682 --> 00:13:09.849
So that's going to come from reporting analytics.

00:13:09.849 --> 00:13:13.378
And then the last one on this is campaign metrics.

00:13:13.378 --> 00:13:23.674
We want to be able to evaluate the success of specific campaigns, um, and the reason you want to do that is you want to be able to to determine the ROI, the return on investment.

00:13:24.096 --> 00:13:28.000
So we did, uh, you know, we did, a direct mail piece in September.

00:13:28.000 --> 00:13:29.341
Well, how did it do?

00:13:29.341 --> 00:13:41.684
Did did that come back the way we thought it would, based on the expenses of, of, you know, doing it, writing the letter and, you know, sending it to the printer to be formatted and the design of it.

00:13:41.684 --> 00:13:46.096
And then you know, we had envelopes and we had, you know, printing costs.

00:13:46.096 --> 00:13:50.697
So we had mail cost and then we had staff cost of doing the thank yous.

00:13:50.697 --> 00:13:53.875
You know we had that all in all, that expense.

00:13:53.875 --> 00:14:01.294
And then we look at the total revenue from that, from that mail piece, and then we could say, ok, that worked or no, that didn't work.

00:14:01.294 --> 00:14:12.014
But we can't do that if we can't segment out that metric and determine what was that September appeal letter, how much revenue came in on that.

00:14:12.014 --> 00:14:14.652
So you've got to make sure that your databases can do that.

00:14:14.652 --> 00:14:15.975
So, all right.

00:14:15.975 --> 00:14:18.589
So reporting, that is reporting analytics.

00:14:19.730 --> 00:14:25.480
I think another one that's really important is looking at integration with other tools.

00:14:25.480 --> 00:14:35.630
So how does the database integrate with how you are giving online?

00:14:35.630 --> 00:14:40.940
So if you're using, you know, stripe or if you're using PayPal I don't know, people still use PayPal.

00:14:40.940 --> 00:14:43.328
I think PayPal is getting a little dated, um.

00:14:43.328 --> 00:14:51.073
But whatever, whatever online giving processing system you use, how will that integrate with the database?

00:14:51.073 --> 00:15:05.648
And that is a big one, because if your processing doesn't talk to the database, you're, you're, uh, you're you're happy to double entry and you're just making things more complex for you.

00:15:05.648 --> 00:15:18.076
So if you already have an online payment processing system you use and you're looking at a database, that's one of the first questions I'd ask is do you integrate with whatever you're using?

00:15:18.076 --> 00:15:20.980
So, payment gateway integration?

00:15:21.865 --> 00:15:26.600
Another one that I would really be interested in is your accounting system.

00:15:26.600 --> 00:15:31.732
Does the database interact with whatever accounting system you're using?

00:15:31.732 --> 00:15:39.413
Because if it does, then that could save your accounting staff a ton of time.

00:15:39.413 --> 00:15:49.274
I mean, how cool would it be if somebody comes onto the website, hits the buy now or buy now, the give now button.

00:15:49.274 --> 00:15:51.184
They make their gift online.

00:15:51.184 --> 00:15:56.812
It goes right into the database, it goes right into your accounting system and you don't even have to enter that.

00:15:56.812 --> 00:15:57.703
That is seamless.

00:15:57.703 --> 00:15:59.067
So I definitely would check accounting system, and you don't even have to enter that, that is seamless.

00:15:59.067 --> 00:16:03.014
So I definitely would check accounting system.

00:16:03.014 --> 00:16:07.488
And then any other systems, any other computer systems you're using.

00:16:07.488 --> 00:16:16.576
I don't know what they would be, but if you've got other databases that you're using within your organization, to ask the question if they would integrate with those.

00:16:16.576 --> 00:16:18.392
So that's something that's important.

00:16:26.985 --> 00:16:28.027
And then, lastly, security and compliance.

00:16:28.027 --> 00:16:29.229
Now I will again say I am not a data security expert.

00:16:29.229 --> 00:16:30.812
I don't know that stuff.

00:16:30.812 --> 00:16:34.219
I know people who do know it, but I don't personally know it.

00:16:34.219 --> 00:16:51.677
But those are some questions that you need to ask is because you're literally trusting this organization with your donors, financial information, and so you know what are the encryptions, uh, where, where's the data stored, what are the protections for that?

00:16:51.677 --> 00:16:56.212
Um, there are some privacy laws, uh, that are out there.

00:16:56.212 --> 00:17:18.051
So, um, you, so you just ask the question and if you feel like you're not getting the answer that you kind of thought you were, if you just don't understand it, then I would definitely find somebody, a volunteer, somebody with some online data security and compliance knowledge to help walk you through that.

00:17:18.051 --> 00:17:22.876
I think that would definitely be worth the extra effort to find that out.

00:17:24.681 --> 00:17:40.780
All right, so you know, I think, when you boil this all down there are, there are three quick things that, like that, are pretty important to consider, um, outside of of the stuff that we've just talked about.

00:17:40.780 --> 00:17:46.707
Uh and one is budget and the the greatest database.

00:17:46.707 --> 00:18:03.953
There are databases out there that are the Lamborghini or the Mercedes-Benz or the Cadillac of databases and they come with a price tag that is the same as a Lamborghini, a Mercedes or a Cadillac.

00:18:03.953 --> 00:18:14.147
They are really, really expensive, and not only are there upfront costs, but then there are monthly costs that go on and they are really pricey.

00:18:14.147 --> 00:18:17.269
And does every nonprofit need that?

00:18:17.269 --> 00:18:25.722
No, no, you do not need, especially if you're just getting started and this is your first database that you're really looking at net.

00:18:26.163 --> 00:18:57.821
Don't spend a massive amount of money, because often when you have big databases that are expensive, they come with a level of complexity that is overwhelming, and if you don't have dedicated staff to be working in that database every day and to have the training and the repetition, so that I mean you could be trained something, but then if you don't do it for six months, we forget it.

00:18:57.821 --> 00:19:03.971
So I would be very leery of high end, expensive databases.

00:19:03.971 --> 00:19:22.431
If this is your first one and you've got a $200,000 budget or a $50,000 budget, there are some free options out there of databases that will do you just fine and will be totally adequate for your needs without spending a ton of money.

00:19:22.431 --> 00:19:26.290
So, budget make sure you take your budget into account.

00:19:26.480 --> 00:19:26.865
Next is ease of use.

00:19:26.865 --> 00:19:27.759
Make sure you take your budget into account.

00:19:27.759 --> 00:19:45.232
Next is ease of use and again, just like I was talking with budget, there are some databases are designed for simplicity and will give you the basic information you need at the touch of a couple of buttons.

00:19:45.232 --> 00:19:57.391
Other databases are like I was talking a little bit earlier, are built for more flexibility, and with flexibility comes complexity, so they're harder to use.

00:19:57.391 --> 00:20:03.130
Now you get to, you can cut your information 14 different ways and look at it.

00:20:03.130 --> 00:20:05.442
Do you want to look at it in landscape?

00:20:05.442 --> 00:20:06.464
Do you want to look at it this way?

00:20:06.464 --> 00:20:07.689
Do you want to look at it that way?

00:20:07.689 --> 00:20:08.540
Do you want it to be this?

00:20:08.540 --> 00:20:11.587
And that's all great and those can be very helpful.

00:20:11.587 --> 00:20:21.426
But if you're just getting going and you're kind of getting your feet wet in this, I would choose simplicity over complexity every day of the week.

00:20:22.409 --> 00:20:24.212
And then the third one is scalability.

00:20:24.212 --> 00:20:39.127
We're going to make the assumption that your fundraising is going to grow and get bigger because you're using a database and, like I said at the beginning, if you have a database and you use it well, it will help you raise more money.

00:20:39.127 --> 00:20:42.863
So we're just going to make that assumption that we're going to get bigger as we go.

00:20:42.863 --> 00:20:53.709
So I would be asking about scalability, you know, as maybe we we don't need this service now, but as we grow, that might be something we'd be interested in.

00:20:53.709 --> 00:20:57.301
How does, how does this database grow with us?

00:20:57.301 --> 00:21:21.257
Um, now, some of them will have the capacity to do that and others won't, and so I, I I will always recommend that you try to not switch databases if at all possible, because when you convert from one database to another, it is absolutely, excruciatingly painful.

00:21:21.257 --> 00:21:23.968
So we try to avoid doing that.

00:21:24.579 --> 00:21:29.163
However, that said, you may have to at some point.

00:21:29.163 --> 00:21:43.836
You may have a database that is very simple, very basic, and it does your needs very well, and then, down the road, two, three, four years, you've maxed out its capacity and you're going to have to go to something different.

00:21:43.836 --> 00:21:47.147
That's okay, I wouldn't worry about it.

00:21:47.147 --> 00:21:51.221
That's okay.

00:21:51.221 --> 00:21:56.880
I wouldn't worry about it If your budget is zero and there are some very good databases out there that are free up to a certain level of donor entries, of records.

00:21:56.880 --> 00:21:58.163
They call them a record.

00:21:58.163 --> 00:22:02.333
So if you have a donor, that goes into the database, that's one record.

00:22:02.333 --> 00:22:09.791
So there are some very good databases out there, very simple, that will do the job for you.

00:22:10.393 --> 00:22:22.993
If you have 50 donors and then all of a sudden, two years from now and you have 200 donors or 300 or 400, and you've outgrown the database, you're in, that's okay.

00:22:22.993 --> 00:22:32.084
We'll take that as we'll be happy about that, and we will grin and bear going through a database transition or transfer.

00:22:32.084 --> 00:22:35.705
But if we can avoid it, that would be good.

00:22:35.705 --> 00:22:47.133
So, budget ease of use, scalability yes, absolutely 100%.

00:22:47.133 --> 00:23:05.344
If you use a good database or CRM or what do we call it, drm, if you have a good database and you use it correctly, it will help you raise more money, no question about it.

00:23:05.344 --> 00:23:15.201
But and this is a big but a CRM is like anything else If you don't use it, it won't help you raise a penny.

00:23:15.201 --> 00:23:26.788
So spend the time and energy to get the right database for you and your organization and then use it, and it will pay for itself many times over.

00:23:28.432 --> 00:23:52.384
Thank you for listening today, and can I ask you a favor and this is from Tim and I both If there is someone you know who you think would benefit from our show whether it's this show or one of the other episodes that you've listened to could you just forward them a copy of the episode and by doing that, you would introduce them to this show and and maybe it'll help them like it helped you.

00:23:52.384 --> 00:23:53.847
Um, that would.

00:23:53.847 --> 00:23:59.422
It would be a huge favor to us and tim and I would really really appreciate that.

00:23:59.422 --> 00:24:06.385
Okay, that's all for today, until next time you.