Before
Donor records documented what had happened. Totals, averages, and last gifts offered only a partial view of each relationship.
Case Study · Regional health nonprofit
From donor records → donor intelligence
The nonprofit already had donor history. The opportunity was to turn that history into information its communications and development teams could use.
CRM Integration layer Email platform
Before / After
After
The nonprofit could surface patterns inside those histories and identify the records that deserved closer human review.
The Job
Make the integration useful beyond list synchronization.
The communications director needed more than data moving between systems. The integration needed to preserve enough donor history to support better communication, reporting, and fundraising decisions.
See the pattern
Find meaningful variation that totals and averages flatten.
Choose the next move
Give staff a reason to review a donor before sending another automated appeal.
Share the evidence
Turn donor history into a clear account of what the organization can now know and act on.
“There’s a lot of actionable intelligence contained inside these people.”
Director of Communications · Regional health nonprofit
The Artifact
The Donor Consistency Index
The index compares each donor’s largest recorded gift with the smallest. It reveals how widely a donor has already moved and identifies histories that a single average gift would misrepresent.
Holy Gusto Marketing
Donor History → Hidden Range
Most fundraising reports reduce a donor to a total, an average, or a last gift. The Donor Consistency Index shows how widely that donor has already moved.
Why the Index Is Useful
An average can describe the arithmetic and still misrepresent the relationship.
A donor whose largest recorded gift is 50 times the smallest is not adequately described by one average. The index restores the movement that the average removes.
Rank donor histories by the spread between the smallest and largest recorded gifts.
Find the records where a flat metric may be hiding a more complex giving history.
Give staff a defensible reason to use human judgment before the next automated appeal.
Observed range
3.8×–50.0×
Median index
10.8×
Top quartile begins
20.0×
Records at 20×+
7
Donor Consistency Index
The full range makes the hidden variation visible.
Index = largest recorded gift ÷ smallest recorded gift. A higher index means a wider demonstrated giving range. It is a signal to review the history, not a prediction of the next gift.
| Anonymized record | Consistency index |
|---|---|
| Record 01 |
50.0×
Consistency index 50.0 times |
| Record 02 |
38.0×
Consistency index 38.0 times |
| Record 03 |
34.0×
Consistency index 34.0 times |
| Record 04 |
30.0×
Consistency index 30.0 times |
| Record 05 |
25.0×
Consistency index 25.0 times |
| Record 06 |
20.0×
Consistency index 20.0 times |
| Record 07 |
20.0×
Consistency index 20.0 times |
| Record 08 |
17.5×
Consistency index 17.5 times |
| Record 09 |
15.2×
Consistency index 15.2 times |
| Record 10 |
12.9×
Consistency index 12.9 times |
| Record 11 |
12.1×
Consistency index 12.1 times |
| Record 12 |
11.1×
Consistency index 11.1 times |
| Record 13 |
10.8×
Consistency index 10.8 times |
| Record 14 |
10.0×
Consistency index 10.0 times |
| Record 15 |
6.5×
Consistency index 6.5 times |
| Record 16 |
6.2×
Consistency index 6.2 times |
| Record 17 |
6.0×
Consistency index 6.0 times |
| Record 18 |
6.0×
Consistency index 6.0 times |
| Record 19 |
5.0×
Consistency index 5.0 times |
| Record 20 |
5.0×
Consistency index 5.0 times |
| Record 21 |
4.1×
Consistency index 4.1 times |
| Record 22 |
4.1×
Consistency index 4.1 times |
| Record 23 |
4.0×
Consistency index 4.0 times |
| Record 24 |
4.0×
Consistency index 4.0 times |
| Record 25 |
3.8×
Consistency index 3.8 times |
Donor names and donation amounts are withheld.
From Index to Action
Surface
Sort records by giving range instead of relying only on totals and averages.
Verify
Review what produced the high and low gifts: an event, a memorial, an appeal, or a change in the relationship.
Choose
Decide whether the next move should be personal stewardship, a specific ask, or continued automated communication.
The Result
The integration could now support a decision instead of merely completing a transfer.
The nonprofit could use donor history to identify records worth reviewing, preserve meaningful distinctions between donors, and connect communications activity with the information already held in its CRM.
Want to find what your own data is hiding? Work with Holy Gusto →