Webinar

Keeping your Donor Database healthy, wealthy, and wise

Robin L. Cabral, MA, CFRE will lead you through the why and how of creating your own database standards manual and processes to ensure that you are not leading your organization down the path of “Garbage In=Garbage Out.” Consider it your legacy to your organization’s future revenue.

Learning Objectives

By the end of this webinar, you will be able to:

  • Explain why clean, consistent data is essential for reporting, strategy, and donor retention.
  • Structure your database with campaigns, funds, and appeals, and apply consistent naming conventions.
  • Create data entry standards, including USPS address formats, and train staff and volunteers on them.
  • Build a regular schedule of cleanup reports and reconciliation to keep your database healthy.

Transcript:

Steven Shattuck: Okay, Robin, I’ve got 1:00 Eastern. Is it okay if I go ahead and get this party started?

Robin Cabral: Hey, let’s go ahead.

Steven Shattuck: All right, awesome. Well, good afternoon, everybody. Good morning, if you’re on the West Coast, I should say. And if you’re watching this recording, I hope you’re having a good day no matter when and where you are. We are here to talk about keeping your donor database healthy, wealthy, and wise. I did put that in there because I’m not even presenting, so I can make that up on the fly. Basically, we’re here to talk about dirty donor data and how to prevent it. So you are in the right place if you care about this topic. Thanks for being here. I’m Steven. I’m over here at Bloomerang, and I’ll be moderating today’s discussion as always.

Just a couple of quick housekeeping items before we get going. We are recording the session, and I’ll be sending out the recording, as well as the slides, later today. You should actually already have the slides, but if I missed you, don’t worry, we will get those to you later today. So if you have to leave early or get interrupted, don’t worry, we’ll get all those goodies to you. Most importantly, a lot of you have already done it, but introduce yourself in the chat. Ask questions as we go along. We’re going to have a Q&A session at the end, so don’t be shy. We’d love to hear from you. Tell us how the weather is, what your organization does, anything fun you want to tell us. You can also do that on Twitter. There’s a Q&A tab, so put your questions in the Q&A tab. They might not get lost in the shuffle as much as in the chat, but we’ll keep an eye on all of those things. Bottom line is we’d love to hear from you.

If this is your first Bloomerang webinar, welcome. We do these webinars every single Thursday. We love it. It’s one of our favorite things we do here at Bloomerang. If you’ve never heard of us beyond the webinars, or you’re wondering what the heck Bloomerang is, we are a provider of donor management software. It’s a donor database, apropos to this topic. Check it out if you’re interested in what we have to offer or maybe thinking about switching. But don’t do that right now, because one of my favorites is joining us from my hometown of New Bedford, Massachusetts, one of the many reasons why Robin and I get along. Robin Cabral, how’s it going? You doing okay?

Robin Cabral: Hey, I’m doing just fine.

Steven Shattuck: This is awesome to have you. You’ve been a stalwart on the webinars for Bloomerang for many years. And last time we had you, you were stuck in Australia . . .

Robin Cabral: I was, yeah.

Steven Shattuck: . . . because of the pandemic, true story.

Robin Cabral: True story.

Steven Shattuck: But now you’re back home, which I’m very happy for because I was worried about you.

Robin Cabral: I’m back home. Yeah.

Steven Shattuck: And it’s not 2:00 a.m. or whatever time it was when you did the last webinar. Yeah, the Whaling Museum in New Bedford. That’s right. They were the whaling capital of the world at one point, right, Robin?

Robin Cabral: Oh, yeah. I’ve been to the Whaling Museum in New Bedford.

Steven Shattuck: Good job. Beyond being New Englanders, if you don’t know Robin, dang, you’ve got to check her out. She’s been doing this a long time, over 25 years of experience. She helps a lot of organizations, including organizations in Australia, an interesting little niche for her. She has a great website and resources, which we’ll connect you to, and she really is our go-to for data cleanliness and data hygiene. We’ve collaborated on some content, and she’ll tell you about that. But anyway, people don’t want to hear from me. I’m going to stop sharing. Robin, why don’t you bring up those beautiful slides.

Robin Cabral: Let’s see if I can do this. All right, are we ready to rock and roll or what?

Steven Shattuck: All right, take it away, my friend.

Robin Cabral: I’m shy, so I’m going to shut off my video, and then I’ll bring it back on later, okay?

Steven Shattuck: Okay. Me too.

Robin Cabral: All right. Cool. Awesome. All right, everyone, I just love this topic. I call this “Garbage In is Garbage Out.” How many of you feel my pain?

As Steven was saying, I live in New Bedford, Massachusetts, and part-time in Mollymook Beach, New South Wales, Australia, curiously enough. I own a company called Development Consulting Solutions. I’m a Certified Fund Raising Executive, and I have my master’s in philanthropy and fund development from St. Mary’s University of Minnesota. And I’m an MFIA. What the heck does that mean? A Member of the Fundraising Institute of Australia. I have 27 years working for and with nonprofits, and I’m on a mission to transform organizations through effective philanthropy. I work with clients throughout the world now, and the one universal global thing is that data is just bad. No matter where you go, the first thing you’re going to run into is, wow, just bad data. So this webinar is absolutely critical.

Here’s what we’re going to cover today. Why clean data? Those of you who are probably thinking “duh, we already know this,” let’s go over it anyway, because you’re going to have to advocate for dedicating some time within your organization to cleaning up your data. So you’ve got to make that case. How do you structure your database? What should it look like? How do you enter data so it stays the same from year to year to year? And how do we keep it clean? As Steven suggested, a while back we collaborated on a manual. It’s the donor management software policies and procedures template that Bloomerang and I co-created and worked on together. If Steven hasn’t made that available to you, I’m sure he can, or I can as well. I also threw in an article I wrote a little while back on how to keep your database clean and up to date.

So why do we need this case for consistent, clean data? Do I have to stress it? Your database is like your brain, your fundraising brain. It allows you to create reports around campaigns, appeals, and events. I have a webinar on doing a development audit and assessment, and in order to do an audit and assessment, you have to know what your baseline data is so you can create goals around it and then benchmark against those goals. You need to be able to compare apples to apples and not apples to oranges. How many of you feel my pain out there? Just type into the chat box. Yes, right?

You also want to identify loyal donors who may be prospects for major and planned giving. I serve as interim development staff for organizations, so yes, I see them all. I’m working on developing a telemarketing program for monthly donor conversions for a group in Australia, and what am I doing? I’m looking at the donor base for recency and frequency. Imagine if you had bad data. That would all be off. It also determines strategy. Keep the yeses coming if you feel my pain.

What if a database is too expensive? I say these days it’s never too expensive. I’m not pushing Bloomerang, but it’s a very cost-affordable option. There are lots of other software systems out there, so you no longer have to pay $20,000 to get Raiser’s Edge. You can have a database that fits your particular budget, and they range from the powerhouse to the basics. But I say don’t use Excel, because guess what, Excel is not a database. It’s a spreadsheet. Products do exist out there, so just remember that.

Now, when I go into databases, what’s the number one thing I look at? I look at how it’s structured, the big internal structure. That’s when everything falls apart, because then you see people have set up their campaigns wrong, their funds wrong, their appeals incorrectly. There is a way to structure your database so that it is organized and consistent.

These are my definitions, just broad ones. Every database has the same kind of structure but may call it something different, and maybe Steven wants to type into the chat box what Bloomerang uses to categorize these topical areas. There are three things: campaigns, funds, and appeals. Campaigns, to me, and Steven, correct me if I’m wrong, are that broad, general category. When I think of campaigns, you’re running three or four different kinds: your annual campaign, maybe a capital campaign, an endowment campaign, or maybe even some kind of restricted gift campaign.

Funds are the categories of restricted and unrestricted funds. Then you may have something like scholarship funds, or the music fund, or something like that. That’s how I define campaigns and funds, so make sure you have that clear. What about appeals? You may have something called appeals, or activities, or whatever. To me, that’s how you solicited the gift. What prompted this gift? Appeals can be very specific things like your fall appeal or your calendar year-end appeal. They can be things like events, your spring auction, your golf tournament. Or grants. It could be your grants category for 2021. When I look at it, that’s how you solicited the gift, what prompted that gift.

Type into the chat box whether you kind of understand these campaigns, funds, and appeals. “I get it.” Okay, cool. “Making sense.” Okay. How many of you came into your database and it was so not structured this way, and you were thinking “OMG”? Type “OMG, that was me.” All right. Oh my gosh, wow. That’s a big OMG fast in there. Janet is creating our database now. Okay, so now you get it, right, Janet? Campaigns, funds, and appeals. And Katie too. “It’s awful.” Wow, gee.

Here we go. When you’re organizing your campaigns and appeals, think about where this fundraising money will be used. Is it annual? Is it capital? Is it unrestricted? Is it restricted? Funds should be categorized based on specific use, like scholarship funds, restoration funds, unrestricted, grant, whatever. If an event or appeal is recurring, include the fiscal year. I’ll do something like “Calendar Year-End Appeal 2020,” “Calendar Year-End Appeal 2021,” and make sure the naming conventions are consistent. How many of you went into your database when you first opened it up and wondered, was that last year’s calendar year-end appeal? I don’t know. What about the year before? Maybe that’s it. Yeah, I see this a lot. Because I do interim fundraising for clients and run their fundraising programs on a contract basis, I’m in their database. Yikes. I feel the pain.

For annual appeals, don’t lose your donors before they open the envelope. One thing you can do is run National Change of Address (NCOA) on your database. You have to, number one, but do it regularly. Many mail houses and data systems offer it. Does Bloomerang designate NCOA for its clients? I’m not sure.

Steven Shattuck: Yup, every night we do it for free.

Robin Cabral: Every night?

Steven Shattuck: Oh, yeah.

Robin Cabral: For free? Holy moly, everybody, look up Bloomerang now, every night for free. So it’s updating your data file with changes of address. That is gold right there. You have the most up-to-date address for each of your contacts, so you have that continuity of contact. Check that out.

Now, 50% of people pay more attention to direct mail than to any other marketing channel. It is so obvious. That’s why it’s important to keep your addresses clean. Here’s a great example. I go in and look at clients who just use email and send out their email. Do you know what the average open rate is? I don’t know what it is statistically nationally, but for most of my clients it’s around 25%. Imagine, only a quarter of the people you’re sending your email to. Amy, thank you, 23%. Only about a quarter are actually even opening it. Are they even paying attention to it? Who knows.

But when you send a direct mail piece, every afternoon at 1:00, I just missed my one o’clock, I go to my mailbox. I’ve been doing it for what, 30 years, even when I was a kid. I’d walk out to my mailbox every day and get the mail for my parents. How many of you were like that? You sift through the mail before you even start walking back to the door. We pay attention to our mail. That’s why direct mail is still important, and having correct information is absolutely critical.

Nothing is worse than mailing to a donor who’s passed away. There’s also something called, and I don’t know, Steven, if Bloomerang checks this, the Social Security Death Index. That sounds awful, doesn’t it? But you don’t want to be mailing to people who have exited this earthly sphere. These are ways to keep your data clean and make sure your envelope gets opened. There are places you can do research. You can look up people through these different links, or you can get software systems like Bloomerang that do it nightly for you. And Steven says it’s nightly deceased suppression. Holy cow. I don’t know. You’re selling me. That’s awesome.

Other times to remove a donor from a mailing list: sometimes following a significant gift, but not all the time. The Veritas Group, if you don’t subscribe to their blog, you should, because their blog is all about major gifts. They put together an awesome blog, and they say yes, you should send your major donors your direct mail. Absolutely. The one thing I’m famous for saying, Veritas, Diane, is don’t make assumptions for your donors. Don’t decide for them. Send them the mail. They’re going to tell you. They’re going to send the gift or they’re not.

Following a large campaign pledge, sometimes. Stacy out there knows who I’m going to reference in a second. I’m working with a client who is finishing up a large campaign, and when we did their most recent direct mail pieces, we suppressed large pledge donors who are in the middle of a very significant pledge. And of course, how many of you will admit to having forgotten to check off or exclude the do-not-mail or do-not-solicit requests? All the time. You need to do that. How many of us have forgotten to do that? Just put “me, me, me, so me.” “Me, I have.” “Me, I have done it.” Okay. These donors may be contacted, but in a very individual way, and you decide with your staff and your campaign cabinet the best approach, meaning major gift donors, pledged donors, and other people. And if they’ve unsubscribed from your newsletter, does that mean they don’t want to be sent direct mail? That’s another assumption. All right, we kind of belabored that.

How do we enter data so it’s used effectively? The number one thing I see is no data consistency standards in databases. It goes for how we enter data, when we enter data, how it’s actually entered. How many of you feel the pain on that one? “Street” is sometimes spelled out, and then you’ve got “St.” Then you’ve got a donor’s last name in big capital letters and their first name in small. And then you go to do a mailing and think, “Oh, gee. OMG, there it is. I’ve got to fix this record.” It irritates me. It’s a nightmare, isn’t it? It’s your data. Protect it, clean it up.

I get so cautious. I’m Portuguese. Steven knows we live in a place with many descendants of Portugal. I get [a Portuguese expression], like chest pains, when I hear a client say to me, “I’m giving all of our board members access to the database, and they’re going to go in and enter donor data,” or “I’m having one of these volunteers or a high school student come in and enter donor data.” And I say, [Portuguese expression]. There should be one person who is trained and who does all of the donor data entry. What we’re hoping for is that it’s entered consistently and properly.

Laura here is asking, “Doesn’t NCOA end up capitalizing everything?” It may. But what I mean is, consistency. You determine whether you’re going to keep capitalization, then you keep it for everyone so our records all match.

Improperly entered data costs us, as we all know, wasted time, lost efforts, all of those kinds of things. A lot of vendors like Bloomerang, I get a weekly email, I think on Fridays, with all the training available for the database, so take advantage of that. In some cases you may have someone else who is cross-trained to enter data. Make sure you indoctrinate them into your data consistency standards, and you get that manual as part of this webinar. Make sure they go through a training. And remember, you may want to have them sign a confidentiality form. How many of you actually do that? Remind them that donor information is highly confidential.

For me, board members, who are just volunteers who have not been trained to enter data, entering data is inappropriate. Do not set someone loose. It’s like the cartoon character, the whirly guy. I can’t remember his name. It’s like a tornado going around in rooms. That’s the same exact thing when you let someone into your database who hasn’t been trained. Taz, yes. Thank you, Amanda. The Tasmanian Devil. How many of you cringe when your executive director says, “Let’s just ask some of these high school students who come in after school”? OMG. Someone who’s not a stakeholder may take costly shortcuts. I love that, Tasmanian Devil. That’s Australian, from Tasmania.

Ensure consistent donor data entry. Have a procedure. Steven, Bloomerang, and I are giving you a data consistency manual of sorts. How many of you out there have a data consistency manual right now? Yes or no? Type into the chat box. “Nope.” All right. After today, you have one. You can’t say “nope” anymore. You’re going to get one. They’re going so fast, Steven. The link just went right off my screen. Look at that. Set a standard procedure for data entry. If you want all caps, have all caps, but make sure the person entering the data knows that.

Make sure you use proper salutations. Make sure that informal is actually informal. What does that mean? Define it in your manual. What does a formal salutation look like? Give examples in your manual.

For primary addresses, check the postal processing requirements. Why do we say that? Someone asked what’s the difference between “St.” and “Street.” There is a difference, because the Postal Service will deliver mail quicker if you meet their processing requirements and standards. So go online and Google the Postal Service processing requirements. How many of you have done that and know what they are? I believe in the Bloomerang manual we put together, I used those standards. Bookmarked. Okay, all right. I see some of you are doing that. How many of you are not looking at the U.S. Postal Service standards? That means your mail is going to be sent faster if it meets those standards.

Regularly update contact information, email addresses, and telephone numbers. I’m going to give you some suggested reports you can run on a weekly, monthly, bi-monthly, or annual basis to do data checks. How many of you do regularly scheduled data checks, have some checks and balances and a system of reports for your database? Type in yes or no. Avoid nicknames. I don’t like them. Use full names. Use the fields provided for alternate names, if you can, for those nicknames. And determine what data you really, really need to keep. That seems overwhelming. Nope, nope.

There are folks who do data assessment. You can print out your data file or look at it and get an assessment of the health of it overall. How many of you did that on your first day and thought, “Oh no, another one”? It’s not that hard to figure out how good or bad your data is. How many of you said that?

What would you like to know about your data? There are a couple of things: preferred method of contact, how often you want to contact them, and if they tell you, you’d better honor that. You may want to know things like their volunteer interest and their history. Certainly you want to record all of this in your database. Most databases today can be customized, even though they come somewhat canned. There are lots of customization options available.

We need rules. I know you’re probably sitting there saying, “I don’t have time to develop these rules.” But imagine, this is like Nirvana, you walk into an organization and they developed rules ten years ago. They cleaned up all their data, they have a data standards manual, their volunteers and staff using it are all cross-trained, and the data is pristine. You sit down at your desk and you’re ready to go. How much time is that going to save you? How many people are thinking, “That’s Nirvana, and I wish I had that”?

Some of this comes from the postal standards, USPS. “North” is “N.” Oh look at that, I have a spelling error too, like Steven did. “Soutwest” becomes “Southwest.” Street types, this is the U.S. Postal Service, should be Ave, Blvd, St. You pick one but use the postal regulation, and I believe it’s “St,” “Blvd,” and “Ave” for the U.S. Postal Service. Does anyone know offhand what that is? Look at that, whoever put that in the chat box, there’s the link. State postal requirements: you can write them out or use the abbreviations, but again, default to the postal requirements. The Post Office loves, loves, loves it when you use a zip+4. “As musch,” look at that, another spelling error. Oh geez. As much as possible, 00850-6641. How many of you are thinking, “Oh, I know, but I hate looking it up”? That’s me. All right, I admit it.

Post Office Box should be “PO Box” or “PO Box G.” That’s how it should be written. Someone put the link in. Look at this. Thank you, Amy. USPS says never use the period. Guess what? Machines read the mail, and periods don’t work too well with machines. Look at that. Lucille has given us some references, the USPS abbreviations and a zip code lookup. I should add that in here. That would be great, huh, Lucille? Cool.

Here are some other rules. Abbreviate “apartment” to “Apt,” “suite” to “Ste.” These are all in the USPS regulations and abbreviations. Schools and businesses should be written out in full, MSU versus Montclair State University. We all know the common prefixes, but sometimes we get confused, don’t we? And as someone was saying, “Atty,” no period for the Postal Service. It doesn’t like periods. Okay. There are also some common suffixes.

You all know my common suffix of MFIA. Quiz: what does it mean? Quick, someone type into the chat box. Were you paying attention? No googling. All right. Laura, no. Anne, wrong. Jessica, okay, cool. Yep, Member of the Fundraising Institute of Australia. Kind of close. All right, you got it.

Some databases actually have a notes field where you can track some notes. You can record things like interactions. Maybe you sent someone a note, or you made a call, or you sent them an email, and you can put in who actually did that. Now, imagine Nirvana.

Once you have that data clean and you’re sitting in Nirvana saying “well, it’s nice and clean,” how do we keep it clean? Number one, duplicate checks. I have a client right now that has a different database system than the company hosting this. I won’t mention the names. They don’t have a built-in email system, so they have to integrate with another email system, and another landing page system, and another this and that. What happens? When someone goes online and enters a gift on that donate page, sometimes it creates a duplicate in the data file, because it just doesn’t integrate well. So run duplicate checks on an ongoing basis. This online gift could trigger a duplicate. Accidents happen. You don’t want to be sending out duplicates. Duplicates are so passé. Sending out two mailings should not be happening anymore. Not with today’s database systems. I hate the word “shouldn’t,” but it’s true. We look really unprofessional when we send out duplicates.

Create queries and reports. Here’s another thing I’m going to throw in. I don’t know if I have a slide, but I like to be impromptu. How many of you have gone into your queries and reports and thought, “What happened here? There are like 200 of them”? How many of you? Horrors. Someone just created a query to test something and never deleted it. So clean up regularly. Set a reminder on your calendar to clean up your queries and your reports so you don’t have 200 of them the next time you go in.

Here are some examples of queries you can run: people living in the same zip code, or those who gave to the annual appeal. I created the Bloomerang template for a client and passed it along. I was hired to go in and clean up their database. I was like the enforcer. It was so cool. I went through and said to them, “Okay, what are the commonly run queries you use? What kinds of reports do you need on an ongoing basis? We are going to get rid of everything else and just keep those.” Every so many months, quarterly, I’d go in and check, and wouldn’t you know it, lo and behold, there were more queries and more reports in the database. What did I do? Deleted them. It was so liberating to not have all of that stuff just hanging around.

Here are some examples of reports you should be looking at for data cleanliness. That’s where we are right now. Do a data quality review monthly of all accounts created. Run a report of all the new accounts created, or whatever you call your donors, each month, and check all of the data fields to make sure, number one, that you’re not missing something, and number two, that the data meets the quality standards you’ve defined.

The other important thing is looking at credit card expiration dates, particularly if you have a robust or growing monthly giving program. You want to do that monthly to stay on top of it. Do a duplicate report monthly, particularly if your email system is not integrated. I know this seems like a lot, but if you create these reports to start off with, all you have to do is make yourself a reminder and press a button. Simple as that.

Run transaction reports monthly. You want to examine campaigns, funds, and appeals. Are we keeping them consistent? Are we using the right ones? I have a client right now that emails out a donor transaction report every day of all of the transactions for the day. Everyone on the fundraising team can take a look at each transaction and make sure it’s coded accordingly.

Which reminds me, when I think about coding, how many of you have walked into a database and it has 6,000 constituent codes? That’s the worst, right? I don’t know what you call it in your particular donor file, but clean those up to the bare-bones minimum of constituent codes.

Look at security and account access yearly, if not more often. Embarrassing: how many of you still have staff who left the organization or were terminated and still have access to your database? Put yes or no. Or volunteers who have long since gone and still have access? How many of you have not checked your security access? “Last year.” Okay, yes. Someone said they haven’t checked. I see Sam on other webinars. Haven’t I, Sam? I knew it, Sam.

Relationship reports for accuracy. Maybe someone got divorced and they’re no longer husband and wife. How many of you update that on an ongoing basis? Out-of-date queries, we talked about that, and I would say reports as well that you’re not using. Get rid of them. I’m like the Marie Kondo of databases. Get rid of the stuff you’re not using. Please look at it monthly.

And keep up to date with database training, if it’s offered. Things are changing all the time in our databases. These companies like Bloomerang are listening to your feedback and making modifications to make your life easier and simpler and to boost your bottom-line fundraising results, retention results, all the key metrics. So stay up to date with them. Know what the new features are. Know what the best practices are. Subscribe to their blog or their newsletter.

If you do not have that data entry manual, and I love to say this on all my webinars, Sam will probably concur, I love to give stuff away. You walk away from my webinars with a data consistency and data standards manual. You can take it back, and you don’t have an excuse anymore to say “I don’t have one.” A database manual allows you to create a standardized procedure for data entry. Because you have it now and everybody’s trained in it, you’re going to reduce mistakes and get rid of duplicates. In your data manual you should also talk about how you organize campaigns, appeals, funds, and events, or whatever you call them. You should document that organizational foundation, the basic structure of your database.

This is a true story. I was going to say, if you have a staff member who gets hit by a bus, how many of you have used that saying? Someone else can just pick up the manual and walk into your database and know how to keep it clean, know how to enter data, all of that. Well, I had a staff person who wasn’t hit by a bus, but she tripped on a sidewalk and was out of work for three months. And she was our data entry queen. So having a manual is important. If one of my staff won the lottery and left, hopefully they wouldn’t. Hopefully they’d win the lottery and stay because they love working for you so much, because you’re the best boss, and they would donate some of it back.

This database manual provides a clear outline for your organization. It should include things like the data template, profile management, transaction management, interaction management, and report management. Those are the main categories your data manual should have. Profile management is all about how we enter data consistently, how we avoid duplication, and how we regulate donor entry. The transaction management portion should be about how we enter funds and how we structure campaigns and appeals, so that when you need information, you can find it. Then there’s report management, which outlines things like giving history, event history, donor interaction, and next steps. And interaction management outlines gift acknowledgments, online gift management, letter templates, contacts, all those kinds of things. I’m not sure whether I actually looked at that manual to see if it includes a section on policies and procedures. Yes, it does.

In addition to having a manual, how many of you actually have a gift processing policy? It outlines, step by step, when a gift comes in, it goes first to the receptionist, who opens the mail and date stamps it. Then it routes to finance. From there, she makes two copies and sends it on to development, who then data enters it, whatever that policy might be. I’m seeing some of you say nope, and some say it’s being tracked together. No, we’re on the right track. Yes, this procedure is so important. Anyone else? “We have it in our development office policies.” Okay. “Nope.” Okay.

How about a gift reconciliation procedure? Some database systems and accounting systems can interface and talk with each other. But how many of you make sure you do some kind of reconciliation on an ongoing basis? Yes, Leeann. They do that with their finance, because guess what, the board of directors, you know those people, they don’t care what the development numbers say. Oops, did I say that? You know whose numbers they look at at the board meeting? They look at the finance numbers. Finance numbers are king with the board. So how many of you make sure your numbers and finance’s numbers reconcile? That’s absolutely critical.

Making sure you do some kind of ongoing monthly reconciliation of your donor database is absolutely critical. And don’t wait six months. What a bear that process is, finding gifts six months later when you’re five pennies off. Do you know how difficult that is? Do that monthly. Have some kind of process in place monthly.

Wow, we have like 10 minutes left. Leeann is asking, “Do you have a successful procedure to teach finance and [inaudible] pledges count?” I might have a gift acceptance policy with something in it about pledges somewhere in my brain.

Here’s what I hope you learned. How many of you learned something in this webinar? Ensure consistently clean data in a professional data system. We recognize that they are very inexpensive these days, so that’s no excuse. How many of you are going to go back to your department and say, “Hey, Excel is not a database”? Just put quotation marks around it and attribute it to Robin. Organize your campaigns and appeals, and why that structure is so critical. That’s the first step. You’ve got to get that backbone, I call it the skeleton of your database, in place first: campaigns, appeals, and funds, or campaigns, funds, and appeals. Then you need to enter your data consistently. If it’s “St,” make sure it’s “St.” And use the Postal Service standards, because guess what, we want our mail zipping along, especially at Christmas and the holiday time, calendar year-end, when everybody’s in the mail stream. And then have some ongoing reporting and keep that data clean, so have cleanliness reporting. You don’t have to think too hard, because you get the manual. So just thank us all, you get that data entry manual.

With that, how will you use this information, this emotional and informational lecture? Do you know why I’m so emotional about this? Because every single client I have, I have yet to find in my life one database that I go into that’s clean. If I find one, I will retire tomorrow. I will retire the next day. It’s like winning the lottery. I will be in database Nirvana. All right, I’m going to call Steven back on and see if we have any questions I can answer. And if anyone doesn’t have a question, you can share what you’re going to do. And here I am. Look at that. I took off my jacket and it got so sweaty.

Steven Shattuck: Yeah, you’re getting fired up. I’m not surprised. Dang, it’s getting hot just listening to you too. Thanks, Robin. That was awesome. And don’t worry, folks, we have Robin on every year. I would not let a year go by without her. Robin, that was awesome. Thank you. You’re speaking my language. Obviously, I’m kind of a database guy, if folks didn’t know that already.

But listen, if you don’t use Bloomerang, that’s cool. You can still do all this stuff, and you should. No problem. But grab that free manual. I’ve put it in the chat a bunch of times. It is vendor agnostic. If you’re on Neon, eTapestry, Raiser’s Edge, or DonorPerfect, you can use it. And if you download it, by the way, we don’t ask for your email address, so we won’t bug you. It’s not a trick or anything. We just love you all very much. So download it.

Robin, we’ve got a lot of questions. One of my favorites just popped up in here: how long do you keep data? Are you a fan of deleting old data? What’s your take on that?

Robin Cabral: I’m not. Here’s my tip. I’m a fan of making it inactive. I’ve worked in so many places where we got a $250,000 bequest one day and were like, who was Mrs. Smith? We could go back to the gift history and realize Mrs. Smith, in 2006, gave $10 once. So we have that historical record. What I’m a fan of is using the data to try a warm acquisition or re-engagement strategy. If people haven’t given in a number of years, let’s try to re-engage them and use some techniques around that. Then if we can’t re-engage them, maybe put them into inactive, or tag them as inactive and don’t mail to them at all, or only infrequently, maybe just once a year. So use different strategies around that.

Steven Shattuck: I’m right with you. A lot of these databases, Bloomerang included, you can just mark someone as inactive. They stay in there. That’s nice. I know a lot of the programs charge by how many people you have, and that could be tempting. You’re going to think I’m biased because I work at one, but, again, you never know when that data . . .

Robin Cabral: Yeah, you just never know.

Steven Shattuck: It’s hard.

Robin Cabral: Someone was just asking, “How about old alumni?” I’m thinking, wouldn’t you use alumni lists for other things as well? I don’t know what they’re using their CRM for, but I would keep them in there. You’d want to know who your alumni are within the same CRM. Okay, there’s a specific Bloomerang question.

Steven Shattuck: Yeah. Bloomerang questions, I’ll handle, because other people probably don’t care if it was Bloomerang. But here’s a good one: what do you think about honorifics, Robin? Mr. and Mrs., Mx.? It seems like if you’re not really confident about someone’s gender identity, that maybe that can be a potential pitfall. What do you think, Robin?

Robin Cabral: Yeah, that’s a great question. The worst thing you can do is get someone’s name wrong. There are a few things. You can send mail to people who have left this earthly sphere, as I call it, deceased. You can send mail to people who do not want mail. You can send people their name incorrectly, or if you decided to abbreviate their first name from Alexandria to Alex and they prefer Alexandria, boo. And then there’s getting someone’s gender wrong. That happens to me, because Robin in some countries like Australia and England is a name for a male. I’ll often get addressed as “he” or “him.” I think that’s just, “No, I’m a woman. Let’s get that right.”

Getting rid of the Mr. and Mrs. salutation goes to what your formal and informal salutations are. I prefer, if we’re talking to friends and our donors are our friends, that we use informal, like “Dear Bob and Jane,” no prefixes. Look at that, people are just answering. I can’t keep up. Singular “they” for everyone. What other questions do we have?

Steven Shattuck: That’s right. The Bloomerang crew, I’m telling you, they’re good.

Robin Cabral: Does the Post Office do well with the name on two lines? Some couples need mailing labels. You may want to check the postal regulations. They have them all right online, because guess what, they want you to make their job easy. So go to the Post Office. People have been posting that link. Someone else want to post it for folks again, USPS, and just look at the postal standards they require for mail. Anyone else have questions?

Steven Shattuck: Yeah, there are a couple in here, Robin. We’ve probably got time for one more. If we didn’t get to you, Robin, how can folks reach out to you?

Robin Cabral: Oh, sure. Let’s just see here.

Steven Shattuck: Oh, there you go. Cool.

Robin Cabral: There’s my website. My email address, that’s really bright blue, isn’t it? My phone number. And I have a Twitter account, and LinkedIn, and Facebook, and yada, yada, yada.

Steven Shattuck: Yeah, great Facebook group, by the way.

Robin Cabral: Okay, someone’s in it. It’s the Nonprofits Survive and Thrive Facebook group, and this was pre-pandemic, folks. I think I developed this Facebook group in 2018. Jenny, did you learn about the webinar in the Facebook group? So I bet a lot of people during the pandemic went for that name and thought, “Oh, that Robin, she got it.” All right, what’s the question? Sorry about that.

Steven Shattuck: Appeal codes, what’s your take? Is it a separate appeal code every time?

Robin Cabral: I don’t have a set rule on appeal codes, because I really think you need to develop a standard for things, and whatever that standard is, be consistent. If it’s “Spring Appeal 21,” SPR21, then make sure Spring Appeal 22 is SPR22. Have some kind of naming convention, but make it consistent. Does that make sense?

Steven Shattuck: Yep. No matter what your format is, as long as it’s consistent.

Robin Cabral: Yeah, exactly. I’ve seen “Spring Appeal” spelled out, “21.” Whatever it is, just make sure it’s consistent. Inconsistency in data is a pet peeve of mine. Anything else?

Steven Shattuck: Well, we’re almost out of time. I don’t want to keep people too long. But reach out to Robin if we didn’t get to your question. And reach out to me if you are a Bloomerang user with very Bloomerang-specific questions. I was trying to keep up with them in the chat. But if I missed you, just email me or reply to the email you’re going to get from me in a couple of hours with the recording and the slides.

Robin Cabral: Cool.

Steven Shattuck: And, Robin, this was awesome to have you. Thanks for doing this once again.

Robin Cabral: It’s so good to be back on such an important topic that I’m super passionate about. As I say, I’m in databases every single day. And it doesn’t matter if it’s Bloomerang, DonorPerfect, Network for Good, or Little Green Light, it’s the same problems over and over and over again.

Steven Shattuck: Funny how that works.

Robin Cabral: Yeah, it’s a pet peeve. So thank you for having me back, Steven.

Steven Shattuck: Anytime.

Robin Cabral: And hopefully you’ll get to New Bedford soon.

Steven Shattuck: I need to. And now that you’re back in the States, I’m also happy for you that you’re not stranded there, although I know Australia is very lovely.

Robin Cabral: It is.

Steven Shattuck: Thanks for doing it. And thanks to all of you for hanging out. I know you’re probably busy. Maybe you’re wrapping up your fiscal year, so I really appreciate seeing a full room. We have one more webinar before the mid-year point of the year. We’re going to finish strong with our buddy, Kristal Frazier.

Robin Cabral: Cool.

Steven Shattuck: She’ll talk about email, social media, and some digital communications. It’s going to be a good one. I think it’ll help you with the second half of the year. So be there next Thursday at noon Eastern. Bring a sandwich, bring a bowl of soup, or a salad, or some sushi takeout. Grab some lunch and hang out with us, and probably breakfast if you’re on the West Coast. That’s cool too. Look for an email from me with the recording and the slides. We’ll get all that good stuff to you later today. Hopefully we’ll see you next week. Have a good rest of your Thursday. Have a good weekend. Stay safe. Stay cool. Watch out for those storms. There are going to be some storms brewing, so be careful out there. We’ll talk to you again soon. Bye now.

Robin Cabral: All right, make it a good day.

Steven Shattuck: See you.

Robin Cabral: See you later.

Key takeaways:

  • Clean, consistent data is the foundation of your fundraising. Robin Cabral calls your database your “fundraising brain,” because it powers reports, audits, and strategy. Good donor database data hygiene also lets you identify loyal donors and major gift prospects by recency and frequency. She stresses that Excel is a spreadsheet, not a database.
  • Structure your database around campaigns, funds, and appeals. Campaigns are the broad category (annual, capital, endowment), funds are restricted or unrestricted categories, and appeals describe how you solicited the gift. Include the fiscal year in recurring appeal names and keep naming conventions consistent.
  • Standardize data entry, and limit who does it. Train one person (and a few cross-trained backups) on your standards, and don’t let untrained board members or volunteers enter data. Follow U.S. Postal Service formats for addresses, and document your rules in a data entry manual.
  • Keep data clean with regular reports and routines. Robin recommends a monthly review of new accounts, duplicate checks, credit card expirations, and transaction coding, plus yearly security and access reviews. She also suggests deleting unused queries and reports, and reconciling gifts with finance monthly.
  • Protect mail deliverability and donor trust. Run NCOA and deceased suppression regularly, honor do-not-mail requests, and don’t assume major or pledged donors should be dropped from mailings without a deliberate decision. Keep inactive records instead of deleting them, since an old $10 donor could turn into a $250,000 bequest.
Helping you help others

Every act of generosity starts here.

Empower your team to connect deeply and fundraise confidently.