Tag Archives: fundraising research

The Devil’s in the Data! When should you get an audit?

binary-503598_1280Guest post by Darrel Spacone

Stop and think about the health of the data in your donor database.  When was the last time any cleaning or maintenance was done? Is it part of a normal routine?

We all run into situations on an almost daily basis that scream “Dirty Data”, “Duplicate Data”, “Useless Data”, etc.  But what are you doing about it? Do you know what to do or how to do it?  There are always issues with data that will creep up over and over again until they are addressed.

Your donor database is highly complicated and detailed. Over the course of time, how many staff and volunteers, with different skill sets, have been allowed to edit your data in some way and contribute to the less than stellar shape that it is in?

Most organizations face the same issues, but how they deal with or ignore them separates them. An audit is the starting point to finding out exactly what and how much is amiss, addressing it, and then making maintenance and cleaning part of your normal routine.

In my career I have had direct experience with wearing many hats and having heavy workloads thrust upon me as a nonprofit employee. Sometimes there is little or no time to navigate the data trail, finding and fixing common, glaring issues.

You know or suspect you have problems, but how and when can you tackle it?

If you don’t have someone on staff with the expertise to clean up your donor database, consider hiring a consultant to provide you with an audit. An audit will identify what you are doing right, what is going wrong, and what steps you need to take to get back on track.

So, when should you get an audit?  NOW of course!

Following are some of the benefits of an audit:

  • Mailings: An audit will expose missing titles, names, addresses, addressees, salutations.  Are you mailing to or soliciting minors? What about your service area or state? Do you target solicitations to certain counties? Is the county field populated?
  • Duplicate records: Do you have the same person with multiple records?  Are they necessary?  Are you mailing to spouses or other household members separately? Should you?
  • Duplicate addresses: Every time you add a new, preferred address, are you checking the address tab?
  • Merged records: Duplicate information can be copied over during this process.
  • Security: Are you lazy when it comes to security?  Does everyone have the same access regardless of their job function and capabilities?  Often this is the single largest problem and causes the most damage.
  • Deceased constituents: Are you mailing to or soliciting dead people? Have you overlooked the surviving spouse?
  • Record archiving: How long do you solicit a prospect? How long has the record been in the system without any activity?  Do you know how to keep your history, but remove from your mailings?

Data underpins all of your development efforts from gift acknowledgement, invitations, prospect identification, stewardship and beyond. When your data becomes a tangled web, your ability to fundraise suffers. Donors are not thanked and renewed. Major gift opportunities are lost forever. When you add up the losses incurred from bad data, the return on investment in your data skyrockets.

The Devil’s in the data! Make it Good.

darrel.spaconeAbout Darrel Spacone, bCRE
Darrel Spacone is the Chief Information Officer at Donor-Data-Done, LLC, a Blackbaud Certified Raiser’s Edge Consulting firm. With thirteen years of experience with Raiser’s Edge, he has helped healthcare, arts, child welfare and social services organizations identify problems and fix their donor databases. He provides audits and solutions, so that you can focus on your day-to-day tasks without missing a beat, saving you time and money while you are raising money.
Connect with Darrel:

More Resources You Might Like

How To Keep From Being Automated Out Of A Job

robot clockLet’s not be shortsighted. Information technology has improved rapidly and many of the tasks that fall under the prospect research umbrella are automated. They are. Wealth screenings have replaced me as the first course of action in a small organization. They have. No use crying over it. And it’s not going to stop there. So how do we stay relevant in our field?

Find >> Analyze >> Synthesize

We researchers like to use the word analysis to justify our role, but we need to do even more than that. According to Merriam Webster, analysis is an explanation of the nature and meaning of something. But synthesis is something that is made by combining different things such as ideas.

Yes, we need to analyze information to point out the pieces that are relevant to fundraising – whether that is in a profile, trends in our relationship management system, or statistical analysis of our database.

But what if we could learn to take it a step further and routinely synthesize the information, churning out insights that our development officers can act on? It would be another step towards job security, that’s what!

What might that look like?

Charlie is a good prospect for a legacy gift. He has announced he will be retiring in five years. When he retires he will receive a lump sum payment of all of his restricted stock units in the company’s deferred compensation plan, which is currently valued at around $45 million. He has been a top executive for fifteen years and is not likely to be relying upon that sum for retirement and may be interested in ways to offset tax liabilities.

You are not just analyzing and preparing the pieces of information in that profile, you are doing that PLUS putting the different pieces together to create a new idea: he is a good legacy gift prospect.

.

.

.

.

.

.

.

Janice is a good prospect to leverage for peer giving. She is past president of the local Chamber of Commerce and has the most relationships with others in your prospect pool. She has a high wealth rating and served as co-chair for the campaign of Local Organization.

Applying external data to evaluate the prospects in your development officer’s pipeline is not enough anymore. Not if you are capable of pulling those external pieces together into a recommended action that will move her entire pipeline forward.

.

.

.

.

.

We should run an additional analysis to identify women major gift prospects. In this table are the prospects that have the highest predictive value for making a major gift to our campaign, but only one percent of them are women. Sixty-five percent of our active donors are women and as of 2009 women controlled 39% of U.S. wealth with predictions of that number increasing.

Sometimes the method of analysis is technically accurate and perfectly defective. It takes a curious mind and some sincere synthesis to process information in both micro and macro environments and make a recommendation.

.

.

.

.

.

.

Practice, Practice, Practice … and Be Bold!

It’s likely that no-one has ever explicitly taught you to synthesize the information and provide recommendations. You may have even been made to feel foolish or been chided for providing recommendations in the past.

Be Bold! Oil your feathers and let the water roll off of them! You won’t get better at this skill if you don’t practice. And when your insights and recommendations are shot down (and they will be at least once because development officers don’t always share what they know with us), shake off the embarrassment and write down what you learned.

When you recognize that you, I mean you the individual, are a really amazing person, then you can also recognize that you may or may not be good at providing insights and recommendations. That’s okay. You weren’t good at cursive either, until you practiced. (Do children still learn cursive in school?).

So forget your fear of failure and start practicing the art and science of providing insights and recommendations. Synthesize that data baby!

More Articles You Might Like

5 Benefits to Make the Case for Prospect Research at Your Organization

Guest Post by Sarah Tedesco

bulbpencilSMThink of your nonprofit like a light bulb and money as the filament. You’ve got plenty of conducting wire to glow for a long time, but are you shining as bright as possible? Is your light reaching as far as it could or are you casting shadows upon donors just out of reach?

Prospect research provides philanthropic and wealth data that helps you to spot the major gift prospects who will donate the additional funds that you need.

Below are five ways to convince the head honchos of your organization to make a strategic investment in prospect research.

Benefit #1 – Receive more information about existing major donors

Does your prospect have a good poker face? Does he enjoy bubble baths with a glass of red wine? Is he an ancient Greek pottery aficionado? Prospect research won’t answer those questions, but it will deliver the sort of information that you need to improve your major gift fundraising.

Prospect research provides:

  • Philanthropic histories – Know who your donors have given to and how much.
  • Wealth markers – Discover what your donors invest in, such as stocks, real estate, etc.
  • Group analysis of long donor lists – Receive comprehensive reports that summarize donor lists according to where they donate, how much, and more.
  • Business relationships – Discover your donors’ employers to discover if they work for companies that offer matching gift programs.
  • And more! – Different prospect research companies and consultants can deliver different types of information in different ways, so be sure to conduct research before you commit to a company or private researcher.

The fundraising experience becomes more personalized when you know more about donors. Your loyal donors are your most important donors, and remaining abreast of who they are and how to best continue to solicit donations ensures that your relationships will last.

Benefit #2 – Fundraise more efficiently!

While you’re busy hosting events, managing staff, and taking care of other tasks, your most valuable resource is always tick, tick, ticking away… Time.

With prospect research, you can pick out the highest quality major gift prospects on your list and dedicate your time, staff, and resources accordingly. Your fundraising efforts will be focused on the prospects who can deliver the biggest impacts for your organization.

Prospect research methods include:

  • Screening companies – After compiling data from a plethora of databases, screening companies return comprehensive philanthropy and wealth data to help you identify your major gift prospects.
  • Prospect research consultants – Consultants can provide you with a deeper level of research and fundraising insights on specific prospects. They can also help you streamline and coordinate all of your prospect research efforts. It’s important to know what you want from your consultant to achieve the best results.
  • Do it yourself – There is an abundance of search tools out there, and you can teach yourself or get training for yourself or a staff member on how to conduct and manage prospect research.

Benefit #3 – Find and convert new major gift prospects

While modest donations help, major gifts deliver big, immediate impacts for your nonprofit, and finding more major gift donors is the fastest way to increase fundraising. However, when it comes to increasing your number of significant donors, new isn’t always better.

The top indicator of a major gift prospect is previous giving to your nonprofit, but that doesn’t mean that the previous giving is in the $5,000+ range of a major gift. Despite only giving modest amounts, your loyal donors are your most fertile source of new major gift prospects.

Annual donors, no matter how little they give, have a demonstrated, consistent affinity for your organization. Some of these donors can’t give more, but prospect research can reveal which ones can. However, if loyal donors have the capacities to give more, and care so much about your organization, then why don’t they give more?

The explanation may be as simple as that you’ve never asked these prospects to give more, so they’ve never thought to do so. There may be other reasons, and a thorough job of prospect research can help to solve the mystery, so you can turn these annual fund donors into major gift donors.

An old rule of prospect research is that 80% of funds are raised from 20% of the donations, although many organizations claim that it’s more like 90% of funds from 10% of donations, and others find that an even larger portion of their money comes from an even smaller contingency of major donors. You likely have several major donors, but the more the merrier, as these are the people who will provide most of your annual revenue.

Benefit #4 – Clean up your donor databases

Ring. Ring. Ri…

Prospect: Hello?

You: Hi! Is this Mr. Major Donor?

Prospect: I think you have a wrong number.

Fundraising doesn’t have to be like that phone call. You can call the right numbers more often than not, but only if you have up-to-date information.

Prospect research keeps crucial contact information up to date, such as:

  • Phones numbers
  • Email addresses
  • Mailing addresses
  • Spousal information
  • Hobbies and preferred activities
  • And more!

Don’t just take this new information and throw it into a cluttered closet. Embrace the opportunity to clean up your database, so that your donor records are easily searchable and accessible.

Benefit #5 – Identify planned or deferred giving prospects

You know that you can find new major gift prospects among your current donors, and that you shouldn’t overlook even low-level donors, but there’s also a specific type of major gift to be aware of.

Many donors save their biggest donations to be planned or deferred gifts, and, according to a planned giving expert, planned gifts typically come from regular, modest donors.

Prospect research provides the data that reveals potential planned giving donors.

Landing donations, and especially planned gifts, can be a long game, and donors have long-term value that might be patient to reveal itself. Prospect research helps you to find all of these people and delivers comprehensive information that allows you to make more individualized pitches that will better resonate with prospects and land more major gifts, even if they’re gifts that you have to wait a little longer to receive.

These tips should help you make the case at your organization for the importance of investing in prospect research! You’re a nonprofit with a bold heart and an important mission, so increase your fundraising with prospect research in order to focus on what you’re meant to do.

About Sarah Tedesco

TedescoSarahSarah Tedesco is Executive Vice President at DonorSearch, a prospect research and wealth screening company that focuses on proven philanthropy. Sarah is responsible for managing the production and customer support department concerning client contract fulfillment, increasing retention rate and customer satisfaction. She collaborates with other team members on a variety of issues including sales, marketing and product development ideas.

Connect with Sarah:

 

Warning! Wealth Screenings Create a Skills Gap

MindTheGapSMReally good wealth screenings are changing the way we fundraise and they’re bumping campaign results ever higher. That’s definitely good. Yet wealth screenings are putting research decisions into the hands of non-researchers. Like you. Is this a good thing or bad thing? It’s up to you to decide!

I’ve been having more conversations with nonprofits about training prospect researchers. And they haven’t been the typical “I want to set up shop” conversations. The director of development doesn’t want me to help them choose a research subscription or craft a profile template.

She wants me to teach the researcher things like recognizing when prospects have wealth types in common (recognize patterns) or to focus more on the information that will help the gift officer to create a cultivation strategy (fundraising analysis).

Notice I said I’m talking to the director of development (or advancement) – not the director of research. Non-researchers are being pushed into taking the lead on research decisions. And I blame wealth screenings. (Technically, it’s more than screening for wealth. Vendors now give meaningful ratings and data analytics too.)

What exactly is changing?

Imagine you are the director of development for a smallish university, hospital or human services organization (and maybe you are). Your fundraising goals keep getting higher every year and you’ve brought some 7-figure gifts through the door. Your database manager has transitioned into your full-time prospect researcher.

As you gear up for the biggest-ever campaign you are faced with some challenges:

  • Your researcher has been churning out profiles for eight hours a day for months. She’s become a profile zombie!
  • Yes, your researcher can find information, but she doesn’t seem to really understand how prospect cultivation and solicitation works, which makes her work less helpful. She’s disconnected from the actual fundraising.
  • You’ve been prioritizing with wealth screenings and ratings, but now that information is a jumbled mess in the database. You don’t know how to fix it and your researcher is busy doing profiles.

Why are the wealth screening vendors to blame?

Because now that raw data has become more tightly matched, you have enough confidence in it to prioritize your donor prospects and get out on your discovery visits.

You don’t need a prospect researcher to do much.  Until you do.

The path to prospect research used to be a bit wider and longer. In the new, shortened time-frame your prospect researcher isn’t always ready to do more when you are.

So, you, the development director are tasked with managing prospect research in a way you never anticipated. How can you bridge the gap between your researcher’s current skill set and where she needs to be?  Grab your manager’s hat and explore some capacity building opportunities!

MOTIVATE by connecting your researcher with outcomes

Slow down the profile mill ever so slightly – just enough to establish a system to track completed research in your database. Maybe it’s a contact or action item. Whatever field you use, make sure you can pull reports that will demonstrate things like which researched prospects made a gift and were visited.

If you really want to have a little fun, track the researcher’s capacity rating in its own field so you can compare that against the screening rating and against the ask and gift amounts.

We all want to feel like our work creates something. Knowing that her work led to a really big gift is going to be motivating!

But tracking your research efforts is just a first step. Make sure there is opportunity for regular communication between the gift officer and the researcher. You want your researcher to hear how the gift officer sees wealth on those visits. You know what I’m talking about. The “he belongs to this club” or “she had to drop at least a thousand dollars on that handbag”.

Get the gift officer and researcher in a conversation about wealth and a lot of great education will happen both ways. Including more motivation. More teamwork.

INVOLVE the researcher in creating solutions

Work with your researcher to identify ways to solve problems like too many profiles and not enough new prospect identification and qualification.

  • Are gift officers getting too much information too soon? Maybe there should be guidelines about what actions need to happen before a comprehensive profile can be requested.
  • Is your researcher spending too much time digging deeper than needed? Have him track how long it takes to do profiles over a few weeks and reflect on the results. By watching the clock can he get more focused?

You may need to take a lot of the lead in the beginning, but loosen the leash as much as you possibly can. Prospect researchers are notoriously good at learning new things and problem-solving. Give them some room and many can become really good managers.

CREATE some structure around research

As your researcher is getting re-energized and challenged to solve problems, you need to recognize where to create structure to keep everyone and everything moving in sync. You are no doubt under a lot of pressure to make miracles happen in wickedly short time-frames. Keep your eye out for imbalance and act quickly.

  • Is the researcher spending an hour talking shop with a gift officer? Direct her to create a more formal research request process and channel those wonderful conversations into an established prospect review meeting.
  • Is your researcher creating a fully functional but too complex prospect management system? Continue to let her create it, but challenge her to make it simpler. (Playing a little dumb is a perfectly acceptable way to get someone to stretch a little. You have my permission!)

BIG fundraising doesn’t happen without prospect research

It’s a fact of fundraising that you need to harness the power of prospect research to raise the kind of money your mission needs and deserves. And yet, new tools like wealth screenings can allow a skill gap to creep up on you just when you need it the LEAST.

You don’t have to become a prospect research guru to make good decisions about it. And you don’t always have to fire and hire. Strengthen your managerial skills and use them to stretch and grow the prospect researcher and other staff that have an aptitude for prospect research.

Motivate. Involve. Create. And you and your organization will find yourself doing some really BIG fundraising!

And if you need a little outside help to train your staff, evaluate your procedures or create some, Aspire Research Group and the Prospect Research Institute are only a phone call away at 727 202 3405. And we have email too!

Other Articles You Might Like

Yikes! Donor Personality Traits Can be Predicted?

Who’s watching your brain?

Wouldn’t it be great if we could discover the personalities, values and needs of our donors and prospects? Now we have access to demographic information – things like age, sex, marital status, residence, average income. But what if we could really *know* what makes our prospects tick?

Of course, businesses would love this deeper layer of extremely personal information too. And a group of researchers at IBM’s Almaden Research Center in San Jose, California are getting much closer to making this information accessible. How? Well, just for fun, let’s use the current buzzword – Big Data!

But it’s a little more nuanced than that. Really it’s social media. That’s the place where we bare ourselves the most. We talk with our friends candidly and share our feelings along with facts. Led by Eben Haber, the IBMers are capitalizing on research done by Tal Yarkoni at the University of Colorado on how certain words correlate with certain personality traits. Dr. Yarkoni looked at blogs. Dr. Haber and crew are looking at Twitter.

What do you say in your Twitter feed? A new product created by Dr. Haber and his team is being tested by a financial services company. The claim is that in just 50 tweets it can describe your personality reasonably well. In 200 tweets it gets uncomfortably accurate.

The big question is: Could we use information about personality traits to raise more money?

Up until now, the big data sets have been pretty exclusive to higher education and sometimes other large institutions. This is not because they have so many individual records (although they often do), but because universities have so many pieces of data on each of their alums. They keep track of things like what clubs they belonged to, how many degrees received, events attended, participation in directories and more recently, online alum communities. The local food bank is not likely to ever have that much information about each of its donors. But could organizations have more information in the future?

Multi-channel fundraising – print, email, website, Facebook, Twitter, etc. – means that organizations have access to multi-channels of data. This data is attached to specific individuals. Before you can blink your eyes, the software to ride the big social media data beast will drop in price and become more accessible to the masses of nonprofit organizations. Okay, maybe it will take a few eye blinks, but if the past is a good predictor of the future, it is definitely coming.

Right now the most common piece of data we use to determine whether someone has an affinity (likes our org) is giving. We want to see things like frequency, recency and longevity. We can do a wealth screening to identify people capable of giving a lot, but that does not help us turn them into donors – into people who have an affinity for our organization and its work.

Now close your eyes and imagine … wait! read this first before closing your eyes … that you can run your database through a screening that assigns rated personality traits to each constituent record. Ahhhh! Now you can group people by personality traits and create messaging that resonates with who they are – resonates with the core of their personality. WOW! People would convert to donors at amazing rates! Right?

Until that magical day, let’s see if we can’t work on our current messaging. Little things like communicating with donors in the medium in which they like to give. No more of this sending paper to people who have demonstrated online giving. Many organizations are still struggling with what feels like “traditional” message segments, but are quite new to many. Messaging. It’s like exercise and good nutrition. There’s no magic pill (or database screening) that will ever replace it.

Which brings us back to the heart of fundraising – relationship building. Some organizations are better at it than others – regardless of budget size or the depth of data.

So although it is always fun to play with new technology and to imagine a day when science will turn “magic” into a software product, the feet on the ground (you and I) need to stay focused on what builds the best and most relationships with our organizations and missions. The right messages. The phone calls and face-to-face visits. Being real with real people.

P.S. Are you on Twitter? Let’s connect! You can find me @jenfilla I promise I won’t try to predict your personality!!

Other Resources You Might Like