Rolling Three Year Fundraising Trend Dashboard
A dashboard-format visualization of your rolling 12-month total giving across the last three years, smoothing out seasonality to reveal the true direction of revenue. Built on QX71.
How to use the Rolling Three Year Fundraising Trend Dashboard
This is a dashboard-format analytic that provides a clean visual representation of your rolling 12-month fundraising results over the last three years. It is built on the data from analysis QX71 (Rolling 12 Month Donor Count and Total Giving Analysis). Because every point on the line already contains a full year of giving, the month-to-month noise of seasonal appeals disappears and the underlying trend becomes clear.
The visualization shows the total of all gifts received over a rolling 12-month window as it moves through time. A rising line means your trailing-year revenue is growing; a falling line means it is contracting. Sharp spikes in either direction are typically the result of a small number of very large gifts entering or leaving the 12-month analysis period, which is useful context so you do not over-react to a jump that is really about one or two transformational gifts.
The strategic value is early, reliable signal. Monthly totals swing too much to steer by, and annual totals arrive too late to act on. A rolling 12-month line gives you the direction of travel in time to respond, and it is the single best high-level health check on whether the program is growing or shrinking.
You should refresh and review this monthly with your development director as a standing gauge of program health, and share the trend with leadership and the board. When the line bends downward, investigate whether it is a genuine erosion or the roll-off of a prior large gift before deciding how to respond.
Measure success by a rolling line that holds steady or trends upward over time, and by your team's ability to catch and explain inflection points promptly.
Analytic ID: QX193
Analytic Name: Rolling Three Year Fundraising Trend Dashboard
Focus: 0.1: Getting Started; 3.3: Dashboards; 1.1: Year-over-Year Donation Trends; 3.1: Health Checks
Type: Dashboard Style
Scope: Organization
Description: The Rolling Three Year Fundraising Trend Dashboard tracks your fundraising performance over the past three years, focusing on recent trends in donor behavior and contributions. Utilizing this analysis enables you to make informed decisions about donor engagement and fundraising strategies, ultimately enhancing your organization's financial growth and effectiveness.
Key Question: How is our overall fundraising program performing?
Action: Review regularly to track your rolling 12 month trend.