How do you spot a member who is about to leave?
Watch for a drop in a member’s attended visits against their own recent pattern. A member who used to come three times a week and now comes once is at risk, even if they still beat the studio average. Expiry and cancellation dates are the wrong signal for autopay members, because they keep paying while they stop coming.
Why does expiry come too late?
Autopay members never reach an end date. They pay every month until they cancel, so an expiry-based list only reaches them after they have already decided to leave. The attendance drop usually shows up weeks earlier.
| Trigger | Who it catches | How early | What it misses |
|---|---|---|---|
| Membership expiry | Class-pack and fixed-term members who run out | At the end date, often too late | Autopay members who stop attending but keep paying |
| Cancellation or freeze request | Members who have already decided to leave | After the decision | Anyone who drifts away without telling you |
| Attendance drop against the member’s own baseline | Members whose visits have fallen, e.g. 3 a week to 1 | Typically weeks before they cancel | Needs attended-visit data and suppression rules for freezes, new members and future bookings |
What counts as lapsed?
There is no universal cut-off. In practice, a member is lapsed when their attended visits over a recent window fall well below their own earlier pattern, or when they have gone a set number of days without a visit. Set the cut-off to fit your class rhythm. A weekly pilates regular and a daily cycling rider need different lines.
For unlimited autopay memberships, compare their recent frequency against their prior monthly baseline. For class-pack and drop-in clients, a different signal is needed: track remaining pack credits combined with days since their last visit, because there is no recurring billing cycle prompting them to cancel.
Count attended visits, not bookings. Late cancels, no-shows and waitlist drops make booked numbers look healthy. A member who books three classes and attends one looks fine on a booking count and is not.
How do you find lapsed members manually in Mindbody or Booker?
In Mindbody, start with the Retention report. It lists new clients and regular attendees over a date range and shows retention trends. Mindbody positions it for judging promotions and loyalty programs, and for seeing which staff members attract returning clients. It is a studio-level view, so use it to read overall trends, not to trigger outreach to individual members.
To find individual drops, build the comparison yourself:
- Save the report you use, following Mindbody’s Save This Report article, so you can rerun it on the same date ranges.
- Export your active clients using Mindbody’s guide to creating a mailing list of all active clients, so you have a contact list to work from.
- Pull attended visits per client for the last four weeks and the four weeks before that, into a spreadsheet.
- Flag members whose recent count is well under their earlier count. Remove anyone frozen, anyone with a booking coming up and anyone you messaged recently.
- Upload the remaining list to your email tool and send.
In Booker, use its client visit or attendance reporting, export the data to a spreadsheet and run the same two-window comparison. The logic is identical. Only the export process differs.
Where does the manual way break?
- It is a weekly chore. It slips exactly when the studio is busiest.
- Booked and attended counts disagree. Unless you pull attendance separately, the spreadsheet cannot tell a no-show from a visit.
- The Retention report is a cohort view. It will not tell you that one specific member dropped off this week.
- There is no suppression. Frozen members, brand-new members with no established baseline, and people messaged last week get emailed again. Most awkward or annoying win-back emails happen because of missing suppression checks.
- Exports go stale. The list is out of date the moment it is downloaded, and nothing records who was already contacted or whether they came back.
What messages bring members back?
Keep the first touch personal and free of offers. A message from a named instructor or the studio owner reads as a genuine check-in, whereas an instant discount blast reads as promotional marketing.
- Touch 1, within days of the drop: a short check-in from the owner or the member’s usual instructor. Mention something specific, such as their usual class time. No discount.
- Touch 2, about a week later if they still haven’t returned: an easy way back, such as a class they have attended before that has open spots, or a guest pass. This is where an offer belongs.
- Touch 3, optional: a last, low-pressure note asking whether a freeze or a schedule change would help. Then stop.
Two or three touches is a judgment call, not a measured benchmark. Stop the sequence the moment the member books or attends. Offering a discount at the first touch trains members to lapse whenever they want a deal.
For your highest-value members, skip the automated email. Send a staff alert so someone on your team can text or call them personally.
This is an illustrative setup, not a customer story. A pilates studio on Mindbody flags any member whose attended visits over the last two weeks fall under half of their previous four-week pace. It emails a check-in unless the member is frozen, has a booking coming up or was messaged in the last 14 days, and sends a staff alert for its longest-standing members.
How do you automate it with Pandaflow?
Pandaflow lets you keep Mindbody and Booker while connecting the rest of your business. Pandaflow is free to start. You connect your apps, describe the outcome in plain English, review a few records and go live. There are no workflows, templates or settings to configure. Pandaflow’s AI sets up the sync and keeps it running, and repairs it when something changes.
- Start free and connect Mindbody (or Booker) and HubSpot. The Mindbody integrations page covers the available connections.
- Describe what you want. For example: “When a member’s attended visits over the last two weeks drop to under half of their previous four weeks, email them a check-in unless they are frozen, have a booking coming up, or were messaged in the last 14 days.”
- Review a few records. Check that flagged members really did drop, and that anyone on a freeze or hold is excluded from the list.
- Go live.
What the owner sees: visit counts and an at-risk status updated on each HubSpot contact, the check-in sent from HubSpot, the sequence stopping when the member books or attends, and a Slack alert for members you want to call yourself. Pandaflow can also send text messages through Twilio, but only when the member’s text opt-in is recorded in Mindbody or Booker and carried into HubSpot. If consent is not stored, stick to email.
Plan details are available to see pricing. Pandaflow is free to start, with paid plans at Lite $79, Silver $299 and Gold $499 a month. It can be deployed in Pandaflow’s cloud or your own.
What can go wrong?
- The threshold is too tight. Summer holidays and school breaks can flag half the roster. Widen the comparison window or exclude known quiet weeks.
- Bookings are used instead of attended visits. Check which count the trigger reads, so late cancels and no-shows do not mask an attendance drop.
- Text consent is missing. Do not text members whose SMS opt-in is not recorded in your system.
- The first touch includes a discount. It trains members to wait for offers instead of building regular habits.
- Recent joiners are flagged. They do not have an established baseline yet, so exclude them until their pattern settles.
- Results are never reviewed. Check each month who came back and adjust your attendance cut-off accordingly.
For more retention playbooks and strategies, explore our retention guides.