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
Nearly year ago, many nonprofit organizations in the United States were scrambling to meet the now passed deadline for GDPR implementation. Last spring, when I spoke with several advancement services and prospect research professionals, there was a great deal of confusion about what GDPR would… Read More »Introduction to the DPR
During this time of year, many of us start to make plans about what we’re hoping to get done next year. If you’re in charge of maintaining a nonprofit database, one of those plans should be to clean up and improve the data about your… Read More »Best Practices for Your Next Database Clean Up
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
