There are many factors in how and why your donors behave the way they do. For example, you may have noticed a decline in donations one quarter and over-performance in another. Or, you may have had a surge in new donors resulting from a direct mail acquisition campaign or a favorable local event.
How do you determine certain giving trends or gift motivation when there are countless variables that could affect a donor’s giving patterns?
The answer can be found right in your database. Learning to interpret and visualize your nonprofit’s data is an important and, albeit, necessary process that will help your organization determine who your donors are and how you can strategize moving forward.
Data is the key to understanding the direction your nonprofit is heading. Not sure where to start? Not to worry. Here are a few tips to get you going. Let’s dive in!
Prepping your data is the first step toward understanding it. It’s very rare that your data would be ready for an accurate analysis direct from export. The first step to prepping your data is to review for several discrepancies. It’s important to remove any inaccuracies that might hinder the outcome of the report. Some common discrepancies include the following:
- Unnormalized fields
- Incorrect Dates
There are a handful of common suppressions such as $0 donations – these are usually the result of an in-kind donation, unpaid pledges or volunteer work. Large gifts that could skew an analysis are also disregarded such as capital campaigns, bequests, endowment and grant donations. Soft credits and anonymous gifts are two outliers that have the potential to skew data, so they need to be approached with care.
Gifts from corporate foundations, organizations and charitable foundations are also considered but most are suppressed because, like capital campaigns, the donations are large, and the donors do not reflect most of the donor base. In a few cases we may keep a business in the analysis. If the gift can be attributed to a direct mail piece and the name of the company happens to be the same as the contact name in your database, there’s a good chance this came from an individual.
Other scenarios include donor advised funds – these donors are usually defined as funds or foundations, so we then look at the name description of the fund. If the fund name belongs to a family, we know it’s not affiliated with an organization or company but with a household, therefore we include the donor.
Once the data has been fully cleansed, you can begin your analysis. Be sure to focus on statistics that are crucial to depicting the most accurate picture of how your donor database is performing.
It’s best if you can present key metrics in display format rather than show all the data. Resist the urge to over-analyze and provide so much information that it’s unable to register with your audience. Instead, use charts and graphs to show the donor activity visually rather than just looking at raw numbers.
Typically, you’ll want to restrict the data to a 10-year time frame by calendar year. It’s best to use calendar year rather than fiscal because donors tend to make financial decisions based on the calendar year and it gives you a better picture of donor behavior trends.
The following are key indicators to take into consideration when analyzing donor behavior:
- Annual Donor count and gift count
- Annual count of donors who are new, renewed or active
- Revenue raised by all donors and the largest gift
- Average gift for calendar year, how many gifts per donor
- Retention rate:
- Multiyear – those who have given in both the current and previous year
- New donor – new donor the previous year and gave again in the current year
- Correlation between total revenue and how many gifts were made of $1000+ each year
- Giving levels and how much each level contributes to total income
- Long term donor value – a formula that calculates the dollar value for a donor over time, based on the count of donors, gifts, average gift, and cumulative dollar amount.
- A movement report to measure the variation in dollars and percentage between upgrades, downgrades, new, renewed and lapsed donors. This also measures the rate at which donors have upgraded and the overall growth of the donor base.
- New donor motivation analysis to show where your donors are coming from and what motivates them. Is the best source of new donors for you through direct mail acquisition? Or maybe a local event or emergency food drive? When you know what motivated a new donor, you can make sure to cultivate them the way they were acquired so they’ll stick around.
Analyzing these key indicators over a 10-year period will give you enough historical evidence to review what has worked in the past and create an outlook for the year to come.
It can also be helpful to compare your organization to other similar organizations to create benchmarks for what a healthy donor base looks like for you. For example, we consider a donor base healthy for a social service organization if at least 80% of income is from no more than the top 20% of donors. That means the organization has a good major gift program but also isn’t too dependent on large donations, or on an unsustainable volume of small gifts.
There are similar benchmarks for each area of donor analysis.
At Brad Cecil & Associates, we’re highly driven by data and analysis. We want to know how donors behave, and to do that, we have to look back to see how and why they donated. We want to know the inspiration that led to making the gift so we can assist our clients in formulating the best strategies that will in turn further their important missions.