Losing seven out of every ten online donors each year is a symptom of a broken relationship strategy.
How to calculate donor retention rate involves dividing the number of donors who gave in both the current and previous year by the total number of donors from the previous year, then multiplying by 100. This formula provides a clear percentage that represents your ability to keep supporters engaged over time. According to academic research on donor behavior, online attrition rates can exceed 70 percent. This makes the metric vital for long-term growth. By tracking this figure, your nonprofit can shift focus from costly acquisition to nurturing the 1-to-1 relationships that build a stable donor pipeline. This rate helps you find which communication channels, like social direct messaging, are most effective at turning one-time givers into lifelong supporters who sustain your mission.
What is a Donor Retention Rate?
A donor retention rate is a key metric that shows how well your nonprofit keeps its supporters. This figure measures the percentage of donors who gave in a past year and returned to give again in the next year. For most fundraising teams, tracking this number is the best way to judge the health of their donor base and the strength of their relationship building.
Defining Donor Churn and Attrition
When you start measuring donor retention as a KPI, you will also hear about donor churn and attrition. These terms describe the loss of supporters over time. Donor churn happens when someone who once gave to your cause stops making gifts. High donor attrition rates, which can top 70 percent in online crowdfunding, pose a major challenge for both online platforms and traditional nonprofits.
The Value of Keeping Donors
A high retention rate means you are keeping your supporters happy. It shows that your team is successfully turning one-time givers into long-term partners. Since finding new donors is often much more costly than keeping old ones, this rate helps you plan for the future. By knowing your rate, you can find gaps in your donor journey, adjust your donor engagement strategies, and work to fix them before more people leave.
By focusing on these numbers, you can move from a simple sales model to one that values real human bonds. This shift is key to building a stable and growing source of funds for your mission.
How to Calculate Donor Retention Rate: The Step-by-Step Formula
To keep your nonprofit healthy, you must know how many supporters stick with you. Your donor retention rate shows the percentage of people who gave last year and returned to give again this year. Use this simple guide to find your score and see where you stand.
Gather your donor data
Before you start, you need two groups of data from your database. First, count every unique person who gave a gift during the previous calendar year. Next, find the names in that group who also made a gift during the current year. You can use donor analytics to pull these lists quickly from your CRM.
Apply the retention formula
Once you have your numbers, use the basic formula to find the result. Take the count of donors who gave in both years and divide it by the total number of donors from the previous year. Multiply that final number by 100 to get your percentage. This donor retention rate formula is the industry standard for tracking loyalty.
- Identify last year's donors. Find the total number of unique people who gave a gift in the previous year. For this example, let's say you had 1,000 unique donors last year.
- Count returning donors. Look at that same list of 1,000 people and see how many of them gave again this year. In our case, 600 of those original donors returned to support your cause again.
- Divide the numbers. Divide the number of returning donors by the total from last year. Using our example: 600 divided by 1,000 equals 0.6.
- Calculate the percentage. Multiply your result by 100 to find the rate. A result of 0.6 becomes a 60% donor retention rate, which shows strong supporter loyalty.
Analyze your results
A high rate means your team is doing a great job at building relationships. If your rate is low, it may be time to improve your donor retention rate through better follow-up. Many groups find that donor attrition rates can top 70% in online spaces, so every gain helps your mission grow.
Overall vs. First-Time Donor Retention
Tracking the health of your donor base starts with broad numbers. But true insight comes from looking at different donor groups. Most nonprofits track their overall donor retention rate to see how many people return each year. But this big number often hides a big problem: the steep drop in new donors after their first gift.
Understand the first-time donor gap
First-time donor retention tracks the share of new donors who give a second gift. This metric is a key way to check how well you welcome new people to your cause. While stable donors might return at high rates, new donor attrition can often top 70% for online giving. This means only a small group of new fans will stay long enough to become loyal supporters. If you are wondering what is a good donor retention rate for your organization, starting with first-time donors is a great place to focus.
Focusing on this gap helps you see if your first thank-you note or follow-up worked. If you know measuring donor retention as a KPI is vital, you must split these groups. A high overall rate can look good. But it might just mean you have a loyal core while all your new donors are leaving.
Use cohort analysis for deeper data
To fix these gaps, you can use retention cohort analysis. This method groups donors by the month or year they first gave. By watching these groups over time, you can find the exact point when they stop giving. This data lets you change your plan to keep people engaged before they walk away.
| Metric Type | Focus Area | Typical Rate | Key Goal |
|---|---|---|---|
| Overall Retention | All past donors | 40% to 50% | Broad stability |
| First-Time Retention | New supporters only | 20% to 30% | Onboarding success |
| Repeat Retention | Multi-year donors | 60% or higher | Loyalty growth |
Understanding these differences helps you spend your time and budget where it counts. While you must keep your loyal core happy, fixing the first-time donor leak is often the best way to grow. When you use donor analytics to spot these trends, you can build a more stable financial future for your mission.
Why Tracking Donor Retention Rate is Crucial for Nonprofits
Most nonprofit leaders know that finding new donors is hard work. It takes time, money, and staff energy to reach new people. But keeping the donors you already have is even more vital. When you know how to calculate donor retention rate, you can see if your work pays off. This number shows how many people give to your cause over time. A low rate means you lose supporters faster than you can find them.
Build long term financial health
Tracking this rate is the best way to ensure your group stays stable. High donor loss can create a big gap in your budget. In fact, research shows that donor attrition rates can exceed 70% in online giving. If you do not watch this metric, you may face sudden shortfalls that stop your growth. Groups that focus on retention can plan for the future with more trust. This leads to long term financial stability for the whole team and sets the foundation for sustainable nonprofit fundraising.
Lower costs and higher value
It is far cheaper to keep an old donor than to get a new one. Using smart donor retention strategies helps you save money on ads and outreach. When donors stay for years, their total value to your mission grows. This significantly lowers your overall donor acquisition cost, allowing you to spend less on ads or mail and more on your actual work. This shift makes your fundraising much more efficient. You can then use those extra funds to reach even more people in need.
Improve the donor experience
Low retention often shows a lack of deep connection. Many donors leave because they do not feel seen or heard. Modern tools like direct messaging can help bridge this gap by starting real talks. Personalized flows let you thank donors and show them their impact in real time. This lowers the friction that often stops people from giving a second time. When supporters feel like partners, they are much more likely to stay active for years to come.
How to Calculate Donor Retention Rate in Excel
Many nonprofit teams use spreadsheets to track their fundraising numbers. Excel is a great tool to help you find your score without spending money on new software. By organizing your donor lists, you can run a quick check to see how many people gave in back-to-back years.
Step 1: Export your donor lists
To start, you need to pull two reports from your donor database. Export every unique donor who gave a gift in Year 1 (like last year) into a single sheet. Then, export a second list of everyone who gave in Year 2 (this year). Make sure both lists include a unique ID, like a donor ID or email address, to make matching easy.
Step 2: Set up your Excel sheet
Open a new workbook and paste your Year 1 list into Sheet 1. Next, paste your Year 2 list into Sheet 2. In both sheets, put the unique donor ID or email address in Column A. This keeps your data clean and ready for using donor analytics to spot trends.
Step 3: Use the COUNTIF formula to find matches
Now, you need to find which donors from Year 1 came back in Year 2. Go to Sheet 1, where your Year 1 donors are listed. In the first empty column (Column B), type this formula in cell B2: =COUNTIF(Sheet2!A:A, A2). This formula looks at the donor ID in cell A2 and checks if it also appears on Sheet 2.
- Drag the formula down. Copy the formula down Column B for every donor in your Year 1 list. Excel will show a "1" if the donor returned in Year 2, or a "0" if they did not.
- Sum the returning donors. Go to the bottom of Column B and use the SUM function (like
=SUM(B2:B1001)) to add all the ones. This final sum is your count of returning supporters. For this guide, let's say your sum is 450. - Find your total Year 1 count. Count the total number of donors in your Year 1 list. Let's say Sheet 1 has 1,000 unique donor rows.
- Calculate your retention rate. Divide your sum of returning donors by your Year 1 total count, then multiply by 100. In our example, 450 divided by 1,000 equals 0.45. Multiply by 100 to get a 45% donor retention rate.
Step 4: Filter and group your data
Once you have your rate, you can use Excel filters to learn more. Filter Column B to show only "0" values to see who stopped giving. This list shows your lost supporters, which is key for building better donor retention strategies. You can target these people with a special message to win them back.
How Direct Messaging Transforms Donor Retention
Calculating your numbers is only the first step. Knowing your score tells you where your program stands today, but it does not change the future. To improve your donor retention rate, your nonprofit must focus on how you connect with people. If supporters only hear from you when you ask for money, they will likely stop giving. True retention requires building real, 1-to-1 relationships at scale.
Move beyond generic chatbots
Many groups try to solve this with simple automated tools. But a basic chatbot often feels cold and robotic. GoodUnited is different. It is a conversational direct messaging platform built specifically to help nonprofits turn anonymous social media followers into named, engaged donors. By using personalized messaging in channels where your audience is already active, you can build a successful nonprofit direct messaging strategy that starts genuine, two-way talks that feel like a teammate is reaching out.
Reduce friction with direct support
One of the biggest reasons supporters leave is friction in the donation process. If a donor has to jump through many steps or visit multiple sites to make a gift, they may give up. Direct messaging helps solve this. By using automated flows in Facebook Messenger or Instagram direct messages, you can guide supporters through events like Facebook Challenges and Birthday Fundraisers. This reduces donation friction and makes giving a natural part of their social media experience.
Nurture relationships for long term growth
The key to keeping donors is ongoing engagement. After a supporter makes a gift or joins a challenge, the conversation must continue. With GoodUnited, you can send automated, personalized follow-ups that thank supporters, share impact stories, and ask for feedback. This continuous contact helps turn a one-time social media participant into a dedicated recurring donor. By focusing on the relationship first, you can build a sustainable pipeline of support for your mission.
Frequently Asked Questions (FAQ)
What is a good donor retention rate for a nonprofit?
A good donor retention rate for a nonprofit typically ranges between 40% and 45%. However, this varies by donor segment. First-time donor retention is often much lower, hovering around 20%, while repeat donor retention can easily exceed 60% with consistent stewardship.
How often should a nonprofit calculate donor retention?
Nonprofits should calculate donor retention at least once a year. However, tracking this metric monthly or quarterly allows you to spot donor churn early, adjust your communications, and save relationships before supporters drift away.
What is the difference between donor retention and donor attrition?
Donor retention is the percentage of supporters who give again during a given period. Donor attrition (also known as donor churn) is the opposite: it measures the percentage of donors who stop giving to your cause.
How do you calculate donor retention in Excel?
To calculate donor retention in Excel, export your unique donor lists for two consecutive years. Use the formula =COUNTIF(Year2_Range, Year1_Cell) to identify which Year 1 donors gave again in Year 2, sum those matches, and divide by the total number of Year 1 donors.
How can social direct messaging improve donor retention?
Social direct messaging improves retention by turning impersonal social media engagement into personal, one-to-one conversations. It welcomes new donors instantly, shares immediate impact updates, and reduces donation friction by keeping actions native to social platforms.
Ready to turn your anonymous social followers into named, active donors? Book a free strategy session with GoodUnited today. See how our direct messaging solutions can improve retention and grow your fundraising revenue.