In fundraising, it is often difficult to calculate the probability that a given prospect will make a gift, or the likelihood that our organization will reach a specific fundraising dollar goal. The usual measures used in identifying probability don’t always work when it comes to… Read More »Chances Are—Understanding Probability of Giving and How to Improve the Odds
Liz Rejman, Principal of Liz Rejman + Co. lead this Water Cooler Chat on how to optimize your organization’s data by understanding the data life cycle. The chat will covered ideas such as developing a data governance policy, selecting data, onboarding data, performance management, and… Read More »Optimize Strategic Decisions by Maximizing Your Data’s Potential
By Dr. Greg Duke During our Water Cooler Chat, I presented some powerful Excel techniques— Watch the replay video for tips on: Ranking prospects using =RANK.EQ(), Adding up gifts to a specific campaign or fund using =SUMIFs and related “ifs” functions, Bringing in fresh data from… Read More »More Excel Tricks for Fundraisers
March is normally a quiet time in fundraising, but June is coming up fast. Join Greg Duke to discover more ways to ease your administrivia load with Greg’s latest Excel tricks and tips.
In our February Water Cooler Chat, we were asked if it were possible to do a word cloud from contact reports using Excel because it’s a tool that is familiar and used often.Although it is possible, the process is clunky. Since Excel wasn’t built to… Read More »How to Create Word Clouds from Your Contact Reports Using Excel
This article was first published as “Marianne’s Mining Minute” in the APRA Upstate New York chapter’s newsletter, 2012. The world around us is talking about Big Data and how to use it – see this Wikipedia article for the description http://en.wikipedia.org/wiki/Big_data. I keep talking to… Read More »Big Data? Little Data? Do I Have Data?
This article was first published as “Marianne’s Mining Minute” in the APRA Upstate New York chapter’s newsletter, 2009. What It Is Recency, frequency, and monetary value is a collection of measurements used by data mining firms to assess a customer’s potential. Called RFM, this tool… Read More »An Argument Against RFM for Major Gifts Modeling, and How to Use It, Anyway