Customer churn report for nonprofits and charities
Track lapsed donors, volunteers and program members in one customer churn report built for nonprofits and charities.
Updated 2026-05-24
Why Nonprofits and charities need a customer churn report
A donor who gave every year may simply stop after an appeal, and a volunteer who once covered two shifts a month may drift away without a word. Because most supporters give freely, a missed renewal can look like ordinary variation until year-end figures arrive. A churn report gives a development or volunteer lead a standing list of supporters who have gone quiet, measured against the window they usually follow. Charities often keep this information in separate places: a donation platform, a volunteer sign-in sheet, a program attendance register and a mailing list. Bringing those together shows whether lapses cluster after a campaign, a change in program schedule or a staff handover. The list tells the team where its limited follow-up time will do the most good first.
Customer churn report: Nonprofits and charities in plain language
A customer churn report is a running list of people who once engaged with an organisation and then stopped. For a retailer, that means shoppers who no longer buy. Churn is usually expressed as a count or share of people who have gone past a chosen window without a purchase, visit or contribution. Choosing the window is the key decision, since a monthly donor and an occasional volunteer keep to very different rhythms. Measuring lapses against each group's usual pattern tells apart someone who is simply busy from someone who has quietly drifted away.
In charities the same logic applies, with donors, volunteers and program members in place of customers. The method runs in three stages. First, the organisation agrees what counts as active for each group. Second, records from separate systems are matched so each person appears once. Third, the lapsed group is reviewed on a regular cycle and set beside what the organisation did during that period, such as an appeal, a roster change or a new session timetable.
Features for this industry
- Lapse list of donors who have not given since the last appeal or renewal date
- Volunteer activity view counting shifts taken across the chosen window
- Program attendance summary highlighting participants who have stopped coming
- Recurring gift tracking that flags a missed monthly payment
- Monthly summary of lapsed supporters grouped by campaign or program
At a glance
| Build | Customer churn report |
|---|---|
| Industry | Nonprofits and charities |
| Complexity | moderate |
| Tools | Metabase, Microsoft Power BI, Airtable |
| First release |
|
Examples
Donor who stopped giving after an appeal
A supporter who gave every year but made no gift after the spring appeal appears on the lapse list. The development lead checks the appeal timing and the thank-you message, then decides whether a personal call or a gentle letter fits best, so the next step is clear.
Volunteer who has stopped taking shifts
A volunteer who used to cover two weekly shifts has not signed in for most of the season. The volunteer coordinator sees the drop in the report, checks whether a roster change or a scheduling clash may be the cause, and invites the volunteer to talk about what would make the role work.
Program participant who stops attending
Imagine a participant in a weekly literacy or wellbeing group who attended steadily for several months and then stopped. The program team opens the attendance history and notes whether a timetable shift or a finished referral lines up with the drop. It then chooses between a phone call and a reminder about the next session.
Customer churn report: Nonprofits and charities in practice
In a small organisation the report tends to sit with whoever holds the most supporter data, often a development officer, a volunteer coordinator or an operations lead. Setup begins with one short meeting to agree the rules. The team sets the window for each group, lists the fields it wants to see and chooses which exports feed the table. After that, each month is largely a matter of loading fresh exports and reading the results.
Reading the results is where the value sits. Staff look at the lapsed group first, then at people just beyond the window, since a short call may still reach them. Notes are kept against each name so the next review shows what was tried and what followed. Over several cycles the team can see whether lapses cluster around a particular appeal, a timetable change or a handover between staff, and adjust the rules to suit. Keeping the list small and purposeful helps too, so the view carries only the fields needed for follow up and everyone knows which rule produced it.
The local angle
MILabs is a Sydney agency that works remotely with organisations beyond the city and runs sessions by video call. For a churn report, where supporters live and travel from matters more than where the agency sits. Many Sydney charities serve people across several suburbs and council areas, so the lapse list may benefit from a location field that shows whether a drop is confined to one catchment or spread across the whole service area. A volunteer pool drawn from a wide region, or a program run from several community centres, benefits from the same grouping. A simple location tag at import lets the team test whether travel, rather than disengagement, explains a fall in attendance. A video session then gives staff a shared place to read the list together.
Frequently asked questions
- Can a customer churn report for nonprofits and charities be changed later?
- Yes. As the organisation learns more, the team can adjust the window used to judge a lapse, the rule for who counts as an active supporter and the columns shown in the list. A donor who gives twice a year follows a different rhythm from a volunteer on weekly shifts, so each group can have its own rule. Staff can see which rule produced each list.
- What can be added later to a customer churn report for nonprofits and charities?
- Once the core lapse list runs smoothly, the team could add an automatic monthly refresh with a short summary sent to the inbox. Staff might also tag the reason a supporter stepped back after a conversation, which makes later reviews sharper. Drafted thank-you or reactivation messages can sit beside each name, ready to send, and the list can link to the customer relationship system the team uses for follow up.
- How does a customer churn report stay accurate for nonprofits and charities?
- Accuracy comes from complete source exports and from recognising the same supporter across systems. A donation record and a mailing list entry for one person can share an identifier, which keeps the count honest. Checking totals against the accounting figures each month and reading a sample of lapse entries by hand builds confidence in the list. Keeping only the fields needed for follow up keeps the view focused.
- How does a customer churn report for nonprofits and charities start?
- The easiest first step is to say hello through the MILabs enquiry form, and we'll take it from there. Describe which records the organisation already keeps and which groups matter most, such as donors, volunteers or program members. From that starting point, the team can look at exports from existing tools so the window and the definition of an active supporter are settled before any report is drawn up.
- Why does a nonprofit or charity need a customer churn report?
- Supporter loss in a charity is often quiet. A lapsed donor seldom announces a pause, and a volunteer may stop turning up without explanation. A report that counts lapses against a normal window turns that quiet loss into a list the team can act on before year-end figures reveal the gap. It also helps the team focus follow-up time and spot whether a campaign or program change lines up with more lapses.
Related
read these nextUp a level
Customer churn report for other industries
Other builds for Nonprofits and charities
- Case notes tracker for nonprofits and charities
- Council service request app for nonprofits and charities
- Donor and grant report for nonprofits and charities
- Grant application drafter for nonprofits and charities
- Meeting notes to actions assistant for nonprofits and charities
- Membership app for nonprofits and charities
- Newsletter drafting automation for nonprofits and charities
- Payroll preparation automation for nonprofits and charities
- Staff knowledge assistant for nonprofits and charities
