Skip to content
Workflow · Finance close · Opening soon

Lapsed donors (LYBUNT and SYBUNT)

Export your Bloomerang transactions data and upload it to Mammoth. The workflow finds donors who gave before this year, then lists the ones who did not give this year, including last gift date and last year’s total.

Early access opens shortly. Check back soon.

Someone typed

“list donors who gave last year but not this year, and donors who gave in an earlier year but not this year, with their last gift date and last year's total”

The agent read it as

List donors who gave last year but not this year, and donors who gave in an earlier year but not this year, with their last gift date and last year's total from Bloomerang transactions export.

What the agent built

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

  1. File
    Bloomerang transactions export
    CSV export · 45 rows
  2. Step
    Find donors who gave before this year
    Step 1
  3. Result
    Lapsed donor list
    12 rows
  4. Schedule
    Runs when you say
    Proposed

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

What you get back

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

Lapsed donor listSample data12 rows
Donor IDDonorGiving statusLast gift dateLast year's total
10012Lena MoralesGave in an earlier year2024-12-270
10013Marcus GrantGave in an earlier year2024-12-290
10015Omar EllisGave in an earlier year2024-10-180
10002Ben OkaforGave last year2025-03-1975
10004Diego RuizGave last year2025-05-1650
10006Farah KhanGave last year2025-07-11300
10007Gavin LeeGave last year2025-08-0660
10008Hannah BrooksGave last year2025-09-18100
10009Ivan NovakGave last year2025-10-07250
10010Jada ThompsonGave last year2025-11-2180
10011Kyle ChenGave last year2025-12-04200
10014Nina PatelGave last year2025-12-30500
12 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Lapsed donor list 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.

Lapsed donor list: questions

How do you find SYBUNT donors and other lapsed donors?
Export your Bloomerang transactions data and upload it to Mammoth. The workflow finds donors who gave before this year, then lists the ones who did not give this year, including last gift date and last year’s total.
What export should you use?
Use a Bloomerang transactions export. It should include the donor and gift details needed to work out who gave last year, who gave in an earlier year, and who gave this year.
What happens to rows that do not match the rule?
Rows that do not match stay out of the result. Only donors who fit the lapsed donor rule appear in the output.
How do you change the rule in words?
Change the rule by describing who should be included or excluded, such as a different date range or a different giving pattern. The workflow follows the words you give it and applies them to the exported rows.

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 →