How to Build a Membership Retention and Churn Report

For a membership business, retention is the number that quietly decides everything else. A studio can fill the top of the funnel with joins and still shrink if members leave a little faster than they arrive. A retention report makes that math visible early — while there is still time to act on it.

The report is easy to run on a schedule once you define churn precisely and fix where the numbers come from. This is a system for measuring retention and turning it into a recurring report you can act on, not just read.

Define churn before you measure it

Most disagreements about retention are really disagreements about definitions. Settle these first:

• Who counts as a member: active paying members only, or does a paused membership count?
• What counts as churn: a cancellation, a failed payment that lapses, or the end of a fixed term?
• The period: monthly churn is the standard read for a studio; keep it consistent.

Write the definitions down. The formula is simple once they are fixed: monthly churn is members lost during the month divided by members at the start of the month.

What belongs in a retention report

Keep it to a page that leads to action:

1. Headline churn: the month's churn rate, against the prior month and, if you have it, the same month last year.
2. Members lost: the count, split by reason where your notes support it (cancellation, failed payment, end of term).
3. At-risk members: a named list based on clear signals — declining attendance, an expiring commitment, or a failed payment.
4. Cohort view: how recent joiners are retaining compared with older members.
5. Actions: the two or three follow-ups the numbers justify this month, with an owner for each.

Build a source map first

Every figure needs a named home so the report can run without you rebuilding it.

Report item	Source	Owner	Freshness rule
Members and cancellations	Membership platform export	Owner or manager	Through month end
Failed or lapsed payments	Payment processor / platform	Bookkeeper	Reconciled at month end
Attendance signals	Booking platform export	Front desk	Through month end
Notes on why members left	Staff notes or exit messages	Manager	Updated within the month

Base the at-risk list on evidence, not instinct

The most useful part of a retention report is the at-risk list — but it is only useful if the signals are explicit. Define them: for example, "attended fewer than two classes in the last 30 days," "commitment ends within 30 days," or "a payment failed this month." Ask your assistant to build the list from those rules and to show which signal flagged each member, so your team knows why they are calling.

Keep interpretation separate from fact. "Attendance dropped" is a fact; "they are losing interest" is a guess. The report should surface the signal and leave the read to the person making the call.

A prompt for the retention report

Use this as a starting brief:

Prepare the monthly retention report for [month] using the membership export, payment records, and attendance data I select. Calculate churn as members lost divided by members at the start of the month, and show it against last month. Break losses down by reason where the notes support it. Build an at-risk list using these signals — fewer than two visits in 30 days, a commitment ending within 30 days, or a failed payment — and show which signal flagged each member. Never invent a member, reason, or signal. Deliver a one-page report and a supporting spreadsheet to me for review.

Make it recurring, keep the follow-up human

Set the report on a monthly cadence so it arrives with the person accountable for retention, early enough to act before at-risk members lapse. The report finds who to call; your team makes the call.

Deck's scheduled tasks send one consolidated email to you. Supported context can come from selected Deck Projects and read-only connections such as Notion, Granola, and calendars, and Deck can attach the report and workbook as PowerPoint, Excel, Word, PDF, or CSV. One note on how Deck runs: each scheduled run starts fresh and does not remember the last one, so ask it to rebuild the at-risk list from current data each month rather than to track changes since last time.

The same assistant works from its own email address between reports. Forward it a member's cancellation note or a landlord thread and a drafted reply in your voice comes back to you. By default it reads only what you send it, and it replies only to you. Growing studios can link several email addresses to one assistant and run it on their own domain, studio@yourgym.com instead of the default @agent.hellodeck.ai.

See business reporting automation for the product workflow. The monthly report template for gym and studio owners places churn inside the wider monthly view, and the KPI scorecard template helps you keep the metric set tight.

Get your Deck assistant and send last month's membership export with the definitions above. Your previous data is the fastest way to make the retention contract explicit.