Tag Archives: apra

Getting Started in Data Mining (It's easier than you think!)

I have had a few requests for articles on simple data mining techniques and the related database maintenance necessary to make the results meaningful. Look for my upcoming companion blog post on data mining resources, too.

Before we get started, let’s talk a little bit about what might be holding us back.

  • Fear that it’s too complicated – Not much anyone can do about this one, except you. Jump in! The water is warm!
  • Assumptions that leadership will not invest and support it – Data mining and analytics are keyword candy to leadership. Leadership loves to get intelligent answers to questions like “What percent of donors rated at $100K+ gave at that level?”
  • No clear understanding of the pain/need/goal – What keeps your leadership awake at night? Is it prospect pools that don’t perform? Finding leadership donors for the upcoming campaign? If you don’t know, you can’t make a compelling case for data mining.

Donor Database Reports

Do you remember that scene in the Sound of Music where Maria is trying to teach the von Trapp children to sing? She stops singing “Do-Re-Mi” and says, “Oh, let’s see if I can make it easier”. We can do that in data mining too. (I haven’t come up with a song yet, but I’m working on it.) Here is an easy and fun way to get started in data mining – explore all the canned reports in your donor database. I’m not kidding! Even if you have no idea what deep, insightful questions you want to answer, you can begin with reports.

Consider these common reports:

  • Consecutive years giving – When donors give many years, especially consecutively, it usually means they really like us. Who are these people? Do they have high wealth ratings? Could they be good planned gift prospects?
  • Top donors – Are all of your top-giving donors getting regular attention?
  • LYBUNT, SYBUNT, & new donors – Within these reports you might find donors capable of increasing their gift, some major gift sleepers, and some new donors with wealth.
  • Lifetime giving and number of years giving – So many forgotten donors can be found in this list as well as some very good planned gift prospects.

Digging a Little Deeper

MS Excel is on most of your desktops. If you take a little time to learn to use it – I’m not talking complicated formulas, just tips and tricks – it will truly open the world of data mining to you. Imagine that you pull a report into Excel with all of the key fields in the above reports (last gift date and amount, largest gift date and amount, lifetime giving, etc.). Add in wealth ratings if you have them.

Now consider this scenario:

Custom sort:  First by largest gift amount (descending), second by lifetime giving (descending), third by last gift date (descending)

Analysis:  By scrolling down the list you can see if any donors who have made larger gifts (largest gift amount) and have lapsed (last gift date). Is there some high lifetime giving low on the list? Why?

Imagine sorting first by wealth rating and then largest gift. How about lifetime giving and wealth rating? This is fun! (I told you the water was warm.) Just be sure to watch your time. Prospect researchers have gotten lost in the data mining game.

The Secret Data Mining Trick

The secret trick to analyzing your donor information is to understand your fundraising fundamentals. Remember the fundraising pyramid?

The pyramid illustrates your areas of opportunity:

  • Occasional: Did that first-time $1,000 donor get personal attention?
  • Annual: Are there small annual gift planned giving prospects in there?
  • Annual: Can we motivate annual donors to move up a giving level?
  • Major: Do any of your major gift donors have unexplored planned gift potential?
  • Planned: Are there any planned gift donors who could make a cash gift?

Common Data Errors that Under-Mine Your Efforts (pun intended)

Now that you have the idea that you can sort on specific fields in your donor database, you will very soon realize that even sorting becomes problematic if the data is full of errors and omissions. Use your blossoming interest in data mining to clean up the database! Then when you are ready for more complicated data mining challenges, your data will be ready for you.

  • Data errors in any of the fields you pull – e.g., incorrect or missing dates or dollar values
  • Duplicate records – often happens in gift entry or multiple hands in the database
  • Deceased or bad address – if you don’t mail to your list, you probably aren’t getting your list cleaned; if you are mailing, you might not be getting a file back from the printer to update the records

What can you do about problems like these? People don’t usually like to hear this, but you need some documentation.

  • Your database probably has some maintenance reports. Set up a schedule to run them and fix the errors.
  • Do you need to run a report of all changed records daily or weekly?
  • Gift entry staff should be trained to search for the donor name first, instead of entering a new record. As in, create your own training manual for how gift entry is performed in your organization.
  • Someone should review all gifts entered, probably daily.

Robert Weiner is a consultant with some excellent free articles about keeping your database up to snuff. You can find his articles here: http://www.rlweiner.com/articles

Taking Data Mining to the Next Level

Once you have your data in order, some understanding about how the information is stored, how you can retrieve it, and what kinds of things it can tell you about your donors and prospects, I suspect you will be a lot more likely to sign up for that data mining webinar or take advantage of the APRA Analytics Symposium. It feels good to be ready, doesn’t it?

Watch out Prospects! Got a Photo? Gotcha!

Do you know how it is when you find a new tool and suddenly it appears EVERYWHERE?! This is how I feel about relationship mapping. Ever since I purchased a subscription to Prospect Visual, I have started to notice different relationship mapping techniques and applications all over the place. My recent quest for facial recognition searches on photos is a case in point.

My typical nonprofit client doesn’t have a huge warehouse of internal data and often feels an urgency to add to its current donor pool to meet special fundraising initiatives. Relationship mapping holds such promise for identifying prospect gold in uncharted territories! Or does it? Yet?

My feel for the technologies involved is that it is early days. Some of what is currently being commercialized could be easily disrupted by what we might now consider ancillary or “extra” services. Facial recognition is a good example.

Technologies like facial recognition are both shockingly advanced and woefully inadequate. Most things start out expensive and, especially with technology, can become affordable in a remarkably short period of time. Here’s hoping that happens with facial recognition. Unless of course you are searching on me!

Here’s how my facial recognition quest began. I was working on a difficult prospect assignment. Not many donor lists out in the public domain in this particular city, and board members with limited profiles and middle-income wealth. And then I stumbled on a Flickr account with gala pictures from a past event of a similar organization. Eureka!

But no captions on the photos. And I am not personally familiar with the who’s who of that city. Bummer! Or is there a way? To find out I consulted the best talent around – the research list-serv hosted by APRA – and received two good sources:

Google Images

Did you know that you could search for other images using an existing image? You can! And it did make good *exact* matches to find pages where my picture was located (because, of course, I tested it on myself first). But when it came to similar matches…wildly differing pictures appeared. But, ahem, it did find one of Julia Roberts, which I agree is very similar to mine.

TinEye.com

This site seemed so promising, but it didn’t find any matches on my photo, which was disappointing.

These sites were not enough to help me identify the pictures on that Flickr account. But apparently there is some seriously powerful software available that has the potential to make a prospect researcher’s dream come true and find out way more than just linkage or connection.

Social media maven and all-around talented researcher, Lori Hood Lawson, pointed out a 60 Minutes episode that demonstrated the power of some maturing technologies – and has me even more determined to vote at every possible opportunity!

Check out the 60 Minutes episode here: http://www.cbsnews.com/video/watch/?id=50153673n

With the proliferation and popularity of photos and videos all over the public domain, it creates an opportunity not currently considered in the text-based products such as Prospect Visual and Relationship Science that are on the market for nonprofits right now.

Relationship mapping and other prospect research techniques often follow behind competitive intelligence and other for-profit efforts. The uses are similar, but not the same, and as prospect researchers, we often find ourselves getting “creative” to make products work for us. However, with the nonprofit industry growing to such a powerful size, we might see a shift.

But don’t worry donors, prospect researchers have a code of ethics we take incredibly seriously!

Other Articles You Might Like: Relationship Mapping for New Prospects

Join the Relationship Mapping Workgroup:  Click Here to Sign Up

Questions? Want to talk about this post? Call Jen Filla at 727 202 3405 or email jen at aspireresearchgroup dot com.

7 Resources That Keep My Fundraising Loaded!

Keeping my skills current and keeping up with the field of fundraising and prospect research is critical to my role as a prospect research consultant. Slowly I have been shaping my favorite reading list, trying to get it to represent what I need to know most – because I don’t have the time to browse aimlessly!

I run a small, virtual business and that means, like many of you, my head is piled high with hats! I manage to juggle all the hats pretty evenly, catching each one and passing it along … until something new gets thrown into the mix. Then I start playing catch-up. One hat falls down and I let it stay there until I can get used to the new hat in the mix. Once I adjust to the new rhythm I can grab the lost hat and keep going. In this case, I dropped my blog writing while I adjusted to some new skill building.

Now that I am back on track and blog writing is in the mix, I thought it might make a lot of sense to share with you my favorite sources for prospect-research-biased fundraising news and clues. Since readers are of a mixed variety, I’ve kept the really technical research reading out of the mix. I hope you will chime in and comment in whatever platform you find this article. What am I missing? I’m always looking for the best, must-have reading favorites!

1-Chronicle of Philanthropy

Not having been in a traditional “office” for years, I had neglected to subscribe. As soon as I did, I realized once again the Chronicle’s charms. First, they send me paper. Love that. So I can catch up on the weekends or over lunch on the balcony. The Chronicle prints a great mix of information and I get good clues about changes and trends. The October 18th edition, especially the articles on the Missouri Arts center and The Y, really had me thinking about fattening the middle $1,000 to $5,000 donor pool and how that translates into approaching the data.

2-AFP’s Advancing Philanthropy and APRA’s Connections

These are my two all-time favorite associations and I love, love, yes love, their magazines. Okay, so AFP is moving digital and APRA is already there. I have a printer. And paper. Every issue of these magazines goes beyond the how-to and gives me something real that changes my thinking or expands my ideas.

3-Advancing the Nonprofit Sector

This blog is written by a number of different fundraising consultants. I like it because it reminds me that the fundraising world is bigger than prospect research and it helps me stay in tune with the practical needs front-line fundraisers face daily. I like that it covers local Florida topics too.

4-CoolData

Kevin MacDonald does an amazing job of making me want to read his blog. Not only is he having a conversation with me, but he uses lots of pictures and graphics to demonstrate what he is talking about. Okay, so it’s pretty technical stuff. But it is the kind of conversation that every fundraiser needs at least a cursory understanding of. The power of data analytics is as earth-moving as the power unleashed when our donor index cards turned into relational databases or the horse was replaced by the tractor. It is the kind of conversation that is deciding our future. And if I’m going to participate, or just eavesdrop, I’d prefer to do it with Kevin. And his cool guest bloggers like Peter Wylie too.

5-The Agitator

No, it’s not a washing machine cycle! This is another blog where I get practical, but a little more in-your-face, fundraising cents. What I really like is that it talks intelligently about direct response fundraising, which might just be the black sheep of the fundraising family. Yes, everyone loves major gifts, but getting broad support is more than money. It’s the community giving credibility to your mission and how you are performing. And if you do it well, it means you treat all of your donors well. That’s special in my book. Which brings us back to that great article in The Chronicle of Philanthropy about the Missouri Arts Center…

6-Well Planned Web

I have followed a lot of different marketing and social media and other technology blogs, but this one has been the most relevant to me. It’s not too technical. I get a good feel for a topic. It makes me feel smart and current instead of dumb and behind the curve. Most of us have to operate in a constantly evolving online world. At some point we all wind up being impacted by or responsible for at least a piece of our organization’s online face. The Well Planned Web will make you feel good about it.

7-Hootsuite

When data analytics guru, Audrey Geoffrey at the University of Florida Foundation first showed me this website at an APRA-FL board retreat I thought it looked like the most confusing, most complicated website that I would never use. I just couldn’t understand why I would want to keep track of things that way. Now I am a convert. I love being able to customize the way I view and participate in social media. I can narrow my focus to the topics and people who provide me with exactly the content I need to see.

I hope you found a gem among my 7 favorite resources, but I really hope you will share yours too!

The Shocking Truth About Prospect Research Consultants!

Go ahead and shock me!

Did you know that a prospect research consultant isn’t successful unless you, the front-line fundraisers, are successful? Shocking, but true! If I provide you with irrelevant data, or too much data, then you are less prepared and less strategic in your fundraising. You won’t raise as much money for your mission. I won’t get re-hired. And you won’t tell your friends good things about me.

I was reading an article in an excellent research magazine, Connections, published by the Association of Professional Researchers for Advancement. The provocative suggestion was that prospect researchers must move from “pushers to partners”. I never felt like I was an information pusher. But I have had front-line fundraisers tell me about their disappointing experiences with “pushers”.

When I founded Aspire Research Group, my goal was to bring professional prospect research to all sizes of organizations. We have been reaching that goal! And whenever I work with a client there is always some level of back and forth communication going on.

Whether it’s donor profiles, data mining, or prospect tracking, I need to understand who you are and what you want to achieve before I can provide you with information solutions that get you to your destination.

When you work with a prospect research consultant, be sure to make time for questions on both sides and for feedback after the work is delivered. If you do this, your consultant will be able to provide continually better services to you.

Consider the donor prospect profile as an example. You need more than house values and occupational titles. You need to understand what makes your prospect tick, why she has made gifts, and how her assets translate into wealth and possible gift opportunities. You need more than data – you need the information that will inform your fundraising.

Want to hear some shocking success stories? Want to find out how to improve your fundraising strategy with prospect research? Call Jen Filla at 727 231 0516 or email jen at aspireresearchgroup.com.

5 Steps to Fundraising Research Ethics

You wouldn’t slap your donor prospect in the face would you? Of course not!

Donor Trust: Don't Lose It!

Maintaining donor trust relies upon building professional and respectful relationships between your organization and the world. Without trust there would be no giving. Without giving, charitable missions would be unfulfilled. It’s that simple.

It’s also surprisingly easy to slip down the slippery ethical slope. And a donor could feel slapped in the face by some of the information you record. Why not use your personal email to request information? Does it really matter if you use those software subscriptions to look-up your annoying neighbor?

Here are 5 steps to keep you on the ethical track:

(1)  Always identify yourself
Whenever you are making requests for information you need to identify yourself. State your name, your role, and your organization. Like this: “Hello, my name is Jennifer Filla and I’m president of Aspire Research Group. I’d like to confirm the owner of a parcel of land in your county.” If this makes you uncomfortable, you probably shouldn’t be inquiring!

(2) Information recorded must deepen the donor prospect relationship
The whole point of researching donor prospects is to bring the organization and prospect closer together to further the mission – usually through a gift. So if the information found will not bring the two closer, don’t include it.That said, there are exceptions…

(3)  Discuss sensitive information verbally before documenting
When information about an arrest in the prospect’s family or some other sensitive information comes to light, it can be difficult to decide whether it is relevant to the relationship. Especially with naming rights, there is the possibility of a conflict of interest. Talking it over with leadership or the person building the donor relationship helps you confirm before documenting something embarrassing.

(4) Information must be exactly accurate
Be careful to use primary sources and to avoid using value-laden terms. For example, if a blog post says good or bad things about your prospect that you can not confirm elsewhere, don’t include it because it is an undocumented opinion. If a website claims it is a “leading” supplier or the “largest in the country”, either find the source to prove it or remove those words. If Wikipedia says it’s true, click through the footnotes at the bottom to read the original sources and be sure.

(5)  Treat researched information as confidential as donations
Just because you found all of this information in the public domain doesn’t mean it isn’t confidential in the form you have created. We don’t want our donors to feel creepy about the data we collect about them! That will not build trust. We want them to feel professionally handled, flattered and protected by us and our organizations.

Aspire Research Group is a member of the Association of Professional Researchers for Advancement (APRA), a member of the Association of Fundraising Professionals (AFP) and endorses the Code of Ethical Principles and Standards of both organizations.

If you would like to learn more, why not watch the fun 7-minute video on ethics and prospect research below?

Florida Prospect Research Conference

This year the APRA Florida conference will be in my hometown – Tampa! Click here for more info on the conference. Registration is now open! And none too soon as the conference is May 19 and 20, 2011. Our theme is: The New Philanthropists – Prospecting in the 21st Century.

The Association of Professional Researchers for Advancement (APRA) does an incredible job of keeping us prospect researchers well educated and it thrills me to have an active chapter here in Florida. This year I am serving as the chapter president and it has been a privilege to get chest deep in association waters. 

So I know it’s true when I say that our conference committee is going to bring you excellent speakers and fantastic networking and problem-solving opportunities. If you are in Florida, I sure hope to see you in Tampa in May!