How to use the 3-Year Consecutive Donor Value -Needs Work analysis
This analysis identifies donors who have given for three consecutive fiscal years prior to the most recently completed fiscal year, allowing you to understand patterns of consistent giving and predict future retention potential. Drawing on your Gifts and Thresholds data, it calculates each qualifying donor's total and average giving for those three baseline years, then tracks whether they continued giving in the most recent year. By segmenting donors into tiers based on your organization's own giving thresholds, you can highlight both the average and median annual giving to pinpoint which donors are trending toward higher value or may require more attention to retain.
You gain a clear view of key metrics, including the number of consecutive donors in each giving segment, their average and median annual giving, retention rates through the latest fiscal year, and total giving from those retained. This helps you compare the performance of different donor cohorts—such as those whose average or median giving meets or falls short of your Top Tier threshold—so you can prioritize stewardship efforts. For donors who continued giving, you can also view their average giving in the last year, making it easier to spot upgrades or declines.
This analysis is most valuable when reviewed by your fundraising directors, annual giving teams, and major gifts officers as part of your Constituent Intelligence routines. Use it to identify loyal donors with high upgrade potential, flag those at risk of lapsing, and refine your segmentation for appeals or stewardship campaigns. For example, if you see strong retention but stagnant giving in a segment, you might introduce tailored upgrade asks; if retention drops among mid-level donors, consider enhanced recognition or personal outreach. Assign responsibility for reviewing these trends and following up with targeted strategies for each cohort.
To measure success, track changes in retention rates, average annual giving, and the proportion of donors advancing to higher giving tiers over time. You should see improved retention and increased giving in your most engaged segments if you use these insights to focus your efforts and personalize your approach.