Skip to content
Workflow · Finance close · Opening soon

Donor retention rate

Export your donations from Bloomerang, then group donors by year. Match donors who gave in the next year, divide returning donors by prior-year donors, and show the retention rate for each year.

Early access opens shortly. Check back soon.

Someone typed

“show each donor cohort from the bloomerang donations export, match donors who gave again the next year, calculate next-year retention as returning donors divided by prior-year donors, and show year, retention, status Agrees when it's 40% or higher, Low retention otherwise”

The agent read it as

show each donor cohort from the Bloomerang donations export, match donors who gave again the next year, calculate next-year retention as returning donors divided by prior-year donors, and show year, retention, status Agrees when it's 40% or higher, Low retention otherwise

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

  1. File
    Bloomerang donations export
    CSV export · 45 rows
  2. Step
    Calculate next-year retention
    Step 1
  3. Result
    Donor Retention
    4 rows · 1 flagged
  4. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 4 rows came out.

What you get back

The result of that run, the rows to look at first.

Donor RetentionSample data4 rows
3 agrees1 low retention
YearReturning donorsPrior-year donorsNext-year retention (%)Status
2,026070Low retention
2,02381080Agrees
2,02471163.6Agrees
2,02561154.5Agrees
4 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Donor Retention workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Donor Retention: questions

How do you calculate donor retention rate by year?
Export your donations from Bloomerang, then group donors by year. Match donors who gave in the next year, divide returning donors by prior-year donors, and show the retention rate for each year. This workflow labels a year as Agrees when retention is 40% or higher, and Low retention otherwise.
What export should you use?
Use a donations export from Bloomerang. The file needs the donation date and a donor identifier so each donor can be matched across years.
What happens to rows that do not match a next-year gift?
They count as non-returning donors for that year. They stay in the prior-year cohort, but they do not count in the returning donor total.
How do you change the retention rule?
Change the rule in words, then update the workflow steps to match it. For example, you can use a different threshold, a different year pairing, or a different status label.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →