Middle Segment Trends
How to use the Middle Segment Trends analysis
This analysis lays out the year-by-year performance of your Middle giving segment in a single line per fiscal year and presents multiple visualization/charts to help you see patterns more easily. It draws on your Gifts and Constituents data, applies your segment thresholds, classifies each donor's status in each year (retained, promoted to Top, demoted to Bottom, lapsed, first-time, recaptured, or moved in from another segment), and combines donor counts with revenue, gift-size distribution, and retention rates into one continuous trend view. Built-in inflow and outflow reconciliation columns confirm that every Middle donor in each fiscal year is fully accounted for, so you can rely on the numbers when you present them.
The key metrics are middle-segment donor count and year-over-year change, Middle revenue and year-over-year change, retained donor count, the movement counts and revenue (promoted to Top, demoted to Bottom, lapsed, first-time, recaptured), per-donor and per-gift distribution measures including median annual giving and median gift count, in-segment retention and overall retention rates, and the inflow and outflow reconciliation checks that should each equal zero. These metrics matter because the Middle is structurally the most volatile segment - donors move in and out of it from both directions - and a single revenue total hides those flows. The movement counts make the volatility visible.
Strategically you should use this as the Middle's annual scorecard and planning document. Run it at the close of every fiscal year and review it with your mid-level giving leadership before setting the next year's plan. Use the retention rates and the promoted/demoted columns to set realistic goals for in-segment retention and upward movement, and use the gift-size distribution to decide whether your mid-level appeals are sized to your actual donor behavior. When a single fiscal year shows an unusual spike or drop, the movement breakdown tells you immediately whether the cause is retention, acquisition, recapture, or segment crossing.
Measure your impact by tracking improvement in overall retention and in-segment retention year over year, growth in the promoted-to-Top count and revenue, and stability in median annual giving per donor. The reconciliation checks should remain at zero in every reviewed row; any non-zero value is a data quality flag worth investigating before drawing strategic conclusions from the rest of the line.
Analytics Reference: QX205