Tag Archives: data analytics

Score! takes the edge off analytics

I just read Score! cover to cover and here’s why I think you should too…

With Score! Peter Wylie and Kevin MacDonell have written a highly accessible book that works effectively as a beginner’s guide to driving your organization’s decision-making with fundraising analytics. It’s no surprise to those of us in the prospect development field. Peter has been writing entertaining and informative books and articles for years and Kevin’s CoolData blog is encouraging and full of easy-to-understand visuals. Both of them write about personal experiences that nicely demonstrate the ideas and concepts in the book.

This is not a do-it-yourself manual. Peter did that already with his book Data Mining for Fund Raisers. This book is for leadership and for aspiring analysts alike who want a guide to getting something great to happen. No-one feels like a fool for not knowing how analytics works (or even how to define it) and although Peter calls out leadership’s common foibles, an ambitious leader can easily swallow that pill because it helps him navigate past the pitfalls.

The book is conveniently grouped into three sections so you can decide what you want to read. Part one, Becoming a Data-Driven Organization, discusses how analytics can help you make decisions that lead to success. Part two, Your Data Driven Job, discusses what it’s like to pursue analytics in your prospect development career. Part three is devoted to case studies.

Part one launches with scenarios that are happening in advancement offices every day, but when highlighted in a short paragraph make one blush with embarrassment. You also get great information on obstacles you are likely to encounter as you seek to invest in analytics and a helpful discussion about whether to hire someone new or train an existing employee.

One of the salient points made in the book from start to finish is that fundraising analytics is all about valuing affinity – the relationship someone has with your organization. Wealth ratings and other external data is nice, but only works really well when paired with affinity. The wealth screening companies have drowned the marketplace with sales, advertising, and educational content that does not shine such a bright spotlight on using analytics to find and leverage the conversation your prospects and donors are having with your organization as recorded in your databases. Score! gets you back on track.

If you are facing the challenge of clueless leadership that does not value data, then this first section falls a bit short. Given Peter’s years of consulting I was hoping for a few guerrilla tactics and approaches to persuading leadership that analytics is the new, shiny object every leader has to use. Instead the authors give us brief vignettes of some of the good stories where leaders model the kind of behavior that encourages analytics efforts to succeed.

Part two is where the aspiring analyst gets some very thoughtful and perceptive advice about the skills needed to take on these kinds of tasks. By including a chapter on soft skills, and putting it first, there is a clear message. You can be awesome at analyzing data, but unless you can translate your results into information others can use and understand, you are not likely to achieve success. Kevin’s CoolData blog is a living example of good and useful presentation. As a bonus, Kevin and Peter share their personal stories on how they came to analyze nonprofit data for a living.

Part two also has some gems that surprised me and made me think more deeply. Although I have been using the term fundraising analytics as an umbrella term here, Kevin and Peter give you an education about the difference between data mining and analytics. You also get some terms and techniques defined – a few fundamentals. But don’t worry! The authors walk you through some step-by-step starter tasks. The highlighted quote is just one of many that should assure you that you won’t break anything by trying.

“Don’t let missing, incomplete, or suspect data stop you from jumping right in and trying to work with it just as it is.” (p.91)

Part three is a series of case studies. As the authors emphasize, these are not do-it-yourself instructions. They are case studies that illustrate the types of questions you might ask your data and some answers others have found. Kevin and Peter do a great job here of outlining the steps they took and then going into detail about what happened as a result. These case studies will give you big picture ideas to guide you as you craft your own projects. They are helpful to leadership too because they demonstrate winning applications.

In particular I was intrigued by the call center data case studies. And, of course, just a few days after reading the book a fundraising colleague described to me how she does not give to her alma mater and will not give to them, yet they have been calling, emailing and writing her repeatedly each year. She just rolls her eyes.

A huge shift is just beginning to happen as younger generations earn and accumulate income and wealth in an era of rapid changes in information technology that is creating new and changing expectations for communicating. The popular LifeHacker blog wrote a recent post with this title: How Can I Donate to Charity Without Getting Harrassed By Them Later?

It will be those organizations that listen to the conversations in their data and respond to them that will win those donors’ trust…and dollars. Score! is written about analytics in higher education, but the lessons apply equally to human services organizations. Don’t miss out. Buy, read and Score!

Don’t believe me? Read what Susan Bridgers of APRA Carolinas has to say about it!

Want to catch up on the most current buzz? Search the Twitter hashtag: #scorethebook

The Future of Donors in Your Data

From Pushing information to Partnering to Creating Conversations, prospect research has come a long way to uncover donors in your data.

Before the internet and before relational databases, the world had a different perspective on information. Gathering information, analyzing it and producing a thoughtful presentation that pulled all of the pieces together looked like books, white papers and other time-consuming and laborious efforts. Post internet and relational databases, it can still look like that. But now those books and white papers have a whole lot of other company in the form of shorter and/or more precise groupings of information, and often leave us, the users, to draw our own conclusions.

Pushing Information

Before the world went digital, prospect research required visits to the library, combing through paper files and interviewing people in the organization. After this manual collection, the information was compiled into a profile. You might have gotten suggestions on how to cultivate and what gift to ask for from the prospect, and you might not have. Browsing newspapers and magazines for who’s who in the community was dominated by the front-line fundraisers.

Now, the internet supplies us with extraordinary access to information in our town, state, country and in the world. With some prospects, the challenge is not finding information, but whittling down the information to what is most relevant and useful for fundraising. Relational databases give us the ability to store multiple levels of connecting information, such as all gifts made to a fund over a period of time or one individual’s gifts to a fund over a period of time. We can ask questions that our database can answer quickly and easily. Because of this, prospect researchers have moved out of the library and onto the computer.

Becoming Strategic Partners

For many researchers, we have stopped pushing information and have begun partnering with our front-line fundraisers. We don’t create the same prospect profile for every request. We customize our research to answer the most common and most pressing questions. More and more we are being brought to places like the campaign planning table, where we present information about our donors to assist leadership in making decisions. Questions answered might include, “Do we have enough prospects with the capacity and affinity to make the leadership gifts we need to launch the campaign?” or “How many of our annual fund donors made their usual operating gift plus a gift to a special project when asked?”

Prospect research has been providing reactive research such as profiles and proactive research such as filling prospect pipelines and maintaining relationship management systems. In many organizations, especially higher education and large hospitals, prospect research has become a strategic partner on the fundraising team. Prospect research ensures that front-line fundraisers have the prospects to visit and the information intelligence to solicit the largest and most appropriate gift.

The Explosion of Big Data

When you combine the storage and retrieval advances of relational databases with the internet, especially social platforms, you have an explosion of information – most often referred to as “big data”. Most people are aware of the results of harnessing the power of this much data, but few understand how it works and are capable of applying it to new situations. Results look like Amazon.com offering you suggestions on what others purchased with that book you were browsing or other popular titles in that section. It also looks like Google’s Flu Trends that helps specific hospitals predict patient volume during the flu season.

Creating Conversations With Data Analytics

The future of prospect research is already here. Right now, organizations across the country are using new tools to answer complex questions and track complex trends. These new tools are visual and manage multiple file formats with the same ease with which Superman leaps tall buildings in a single bound. Your database might be clunky and difficult to get information out of, but as long as the data is consistent, these new tools make analysis and reporting pretty simple. Often using an online “community” setting, prospect researchers create projects and share them with other fundraising staff. In some cases, with a little training, those front-line fundraisers and other staff can tweak the results on their own.

For example, using intuitive drag-and-drop technology, a prospect researcher can view information from the donor database from multiple perspectives. Let’s say the business school wants to send invitations to exclusive events around the country to raise funds for a new program. Our researcher might start with a quest to find business school alumni, within a certain graduating year span, who were members of a particular school club. She uploads that file to the project area. Next, she calls the business school fundraiser. On the call, the researcher and fundraiser discuss the project they can both view live on their desktops. They begin to “play” with the uploaded list.

  • Can you show me who made gifts at $1,000+?
  • Now who lives within 50 miles of the first location?
  • Hmmm. Too small.
  • Okay. What do the people who live within 50 miles look like? Wait! We limited the graduation years. Can we include all graduation years?
  • Another file is uploaded to the project space with much broader information this time.
  • What do the people who live within 50 miles look like? Gift size, graduation year, club participation, frequency of giving and whether they are assigned to a gift officer.
  • The researcher creates a bar chart of giving frequency because she thinks there might be a pattern.
  • Wow! It looks like club participants are frequent givers. What if we look at all frequent givers whose past 5-year total is over $5,000?
  • The researcher clicks on the bar in the bar chart of most frequent givers and “pulls” it out. She then applies a filter for past 5-year total giving.
  • Okay. That’s still too many. How many live within 50 miles?
  • The researcher clicks on the new list and applies another filter.
  • But I can’t invite anyone who is already assigned to a major gift solicitor.
  • Another filter is applied.
  • That’s a good number of people!
  • The researcher saves that “report” so the fundraiser can pull it for the mailing and RSVP list. The unique constituent number is attached so that the invitation mailing and other activities can be recorded in the donor database.
  • After the event, a new file is pulled into the project space so that the effort can be evaluated using the same techniques.

This was a simple example, but notice how the researcher was beginning to create conversations around the data? She could recognize certain trends and demonstrate them visually to the front-line fundraiser.

Do You Have Enough Data for Analytics?

If you think that you don’t have enough “big data” for projects like this, I suggest you think it over. Most organizations collect more data than they view or use in any meaningful way. We have Facebook friends, Twitter followers and email campaigns. We have the data, but it’s like the junk drawer in your kitchen. It’s all a jumble and finding anything specific takes too much time. For example, lots of organizations of all sizes are still struggling with email campaigns. New email donors receive snail mail instead of email, or nothing at all. Especially for emerging organizations, all of these separate fundraising and stewardship/marketing efforts are often collecting data separately and they may or may not be able to access that data in any meaningful way.

But if we could throw our jumble of data files into a “project”… we might learn thing like we have (a) donors who (b) like us on Facebook, (c) click on our videos more than other posts and (d) make higher online gifts than other online donors. That would be useful information, right? You might then want to learn which video topics generate a better response than other video topics. If you had no idea this was going on, you would continue to randomly post videos on whatever content, and maybe even platform, that felt good at the moment. Combining donor data with Facebook data yielded new insights that could change behavior leading to higher giving with less effort.

Is Analytics Really Out of Reach?

Even if you feel that these “sophisticated” techniques are out of your reach, either because of staff skill level or cost, I urge you to take a larger look at your fundraising program – just to be sure. Many of us lament that leadership does not see the value in investing in fundraising staff or donor acquisition. We wish they could go beyond counting existing dollars to see the magic of investing in a staff member who raises far more funds than her salary. I am inviting you to step out of your technology “counting” and see the magic of streamlining your fundraising efforts through the efficient use of data.

I’m not suggesting that you jump into “big data” collection and analysis – unless you really see value there. I’m suggesting that you consider how a combination of outsourcing and internal skill-building could lead to consistently improved results. What if you could…

  • Put in place a routine appeal evaluation (snail mail, email, or social media) that showed you in numbers, and visually, how you performed this time and compared to other efforts.
  • Know how much you could spend on donor acquisition and still make a great return on your investment based on knowledge of existing donors?
  • Tightly track the behaviors that lead to consistent major gifts – whether that’s multi-year pledges to special projects or high-end yearly gifts?

And those examples don’t even touch social media, website performance or whether your stewardship program actually leads to loyal, increased giving.

You are Never Too Small, Too New, Too Anything, for Good Strategy

When you hire a prospect researcher, as a consultant or staff member, you can hire and train a strategic thinker who will help you streamline your fundraising, raising more money with lower costs. Prospect research has something of benefit for all organizations. Whether or not you join it, prospect research’s path in fundraising continues to move forward into new territory, leaving behind it a clear and certain trail of fundraising success!

Other Posts You Might Like

Millionaires Use Social Media

The Multi-Channel Fundraising Game

Facial Recognition Software and Donors

About Aspire Research Group LLC

Headquartered in Tampa Bay, Florida, Aspire Research Group was founded so that every development office could have the benefits of professional prospect research. Known for our creativity and clear communications, we work with organizations who are worried about finding their next big donor, concerned about what size gift to ask for, and frustrated that they aren’t meeting their major gift goals. Do you need to close more major gifts?

www.AspireResearchGroup.com 727 231 0516