Linchpin Individual Donors -Analysis Year

This shows the individual donors who make up each category in the Linchpin Report. It compares their giving in the last full fiscal year to their giving in the year prior to that.

By RaiseTellMarch 18, 20263 min read

Linchpin Individual Donors -Analysis Year

How to use the Linchpin Individual Donors -Analysis Year analytic

The Linchpin Individual Donors - Analysis Year is designed to help you identify and understand the behavior of key individual donors by segmenting them based on their donation patterns over two fiscal years. This analysis uses donation data, including the amounts and dates of gifts, to categorize donors into segments such as Top, Middle, and Bottom based on their contribution levels. It also tracks changes in their giving patterns, identifying whether donors have increased, decreased, or maintained their support, or if they are new, recaptured, or lapsed donors.

The analysis focuses on several important metrics: the total amount donated by each constituent in the current and prior fiscal years, and the movement category that highlights changes in donor behavior. These metrics are critical because they enable you to see not just the amount of revenue generated by a donor, but also how their giving is evolving. Such insights help in identifying potential risks, like donors who may lapse, as well as opportunities to strengthen relationships with those who are increasing their contributions.

This analysis is strategically valuable because it allows you to tailor your engagement strategies based on donor behavior. For instance, you can prioritize outreach to top donors who have decreased their giving to understand the cause and potentially reverse the trend. Similarly, recognizing new or recaptured donors allows you to nurture these relationships early on, potentially increasing their lifetime value.

You should run this analysis annually, ideally at the end of your fiscal year, to review donor performance and plan engagement strategies for the upcoming year. Fundraising directors and development officers should review the results to ensure that engagement strategies are aligned with donor behavior. The insights can be applied by developing targeted communication strategies for each donor segment, such as personalized thank-you notes for increased donors or special recognition for top donors.

To measure the success of using this analysis, track the retention rate of donors identified as at-risk of lapsing and the increase in donations from new and recaptured donors. Additionally, monitor changes in donor segment sizes over time to evaluate if your engagement strategies are effectively moving donors up the giving ladder. This will help ensure that your strategic adjustments are positively impacting donor relationships and overall fundraising performance.


Analytic ID: QX171

Analytic Name: Linchpin Individual Donors -Analysis Year

Focus: 1.1: Year-over-Year Donation Trends

Type: Standard Analytic

Segments: Top, Middle, Bottom | Scope: Segment, Individual Donor

Description: The Linchpin Individual Donors - Analysis Year is designed to help you identify and understand the behavior of key individual donors by segmenting them based on their donation patterns over two fiscal years. This analysis uses donation data, including the amounts and dates of gifts, to categorize donors into segments such as Top, Middle, and Bottom based on their contribution levels. It also tracks changes in their giving patterns, identifying whether donors have increased, decreased, or maintained their support, or if they are new, recaptured, or lapsed donors. To measure the success of using this analysis, track the retention rate of donors identified as at-risk of lapsing and the increase in donations from new and recaptured donors. This analytic also feeds to worksheets in QX192.

Key Question: Who are the donors whose activity is reflected in the waterfall analysis?

Action: Take a quick look for outliers or donors whose activity is different from what you thought/expected.

Columns included in this analytic: Constituent ID, Donor Name, Deceased, Prior Segment, Analysis Segment, Bridge Movement, Prior Year Revenue, Analysis Year Revenue, Analysis Year Rank, Revenue Change, Analysis Year Same Period YTD, Current Year YTD, YTD Change ($), YTD Status, First Gift Fiscal Year, Total Fiscal Years Giving, Consecutive Years Giving, Lifetime Total Giving, Avg Annual (Last 3 FY with Gifts), Constituency, Assigned Fundraiser, Lifetime Total Writeoffs, Net Lifetime Giving, Pledge Payments CFY, Pledge Payments LFY, Last Pledge Payment Date