Lapsed Member Mappera tiered win-back map for studio owners
Menu

Sort your lapsed list into three tiers, then a dated win-back

Grounded in the standards we hold, not invented. Every obligation Lapsed Member Mapper attaches is our statement of a held clause, cited to it, read from Australian Privacy Principles (APPs), Australia Spam Act 2003 and Australian Consumer Law (Competition and Consumer Act 2010 Schedule 2).

Grounded in the standards we hold95 held clauses citedCross-referenced to up to 137 other frameworksCited to its clause

Paste the lapsed and cancelled member list you already export, with the cancellation dates and the stated reasons, and get every member sorted into three tiers plus the still-paying silent lapse, then a dated win-back sequence with a different offer per tier.

First cut, before any offer: 1 member still on a live payment while they have stopped coming. That one is a billing fix and an apology, not a win-back.

14refusers12occasional users7unexplored

Paste your own list See the specimen map

No sign-in, no integration, no model: the map is built in your browser from the list you paste.

For the owner-operator of a gym, pilates or yoga studio

Lapsed Member Mapper is a free browser tool for the owner of an independent studio with 200 to 2,000 members. Paste the lapsed and cancelled member list, and every non-customer is sorted into three tiers (refusers, occasional users, unexplored) with a dated win-back sequence and a different offer per tier.

The tool classifies on what your own list proves. It cleans the reasons column before it tiers; it lifts out the still-paying silent lapse first, because a member still being billed is a billing fix and not a win-back; it holds a no-consent row back from every draft and lists it; and a row that cannot be tiered is listed with the field it is missing, never dropped. Every drafted message is edited and signed by you or the teacher.

Decision aidNot legal or marketing advice. The tool sorts and drafts; you decide and send, and the consent gate is applied, not advised on.
Three people in a bright pilates studio, working through a class on the floor and the reformers.
You get the whole list sorted before a single message goes, and the members who are still paying but have stopped coming are lifted out before anyone is offered a free week. Nowhere else does the reason-cleaning, the still-paying cut, the consent withhold, the dated per-tier sequence and the illustrative ranking sit on one screen over your own export.

Grounded in the standards we hold: the Australian Privacy Principles (APPs), 13 controls; the Australia Spam Act 2003, 12 controls; the Australian Consumer Law, 70 controls; the United States CAN-SPAM Act of 2003, 10 controls; CCPA/CPRA, 57 controls; and the Illinois Biometric Information Privacy Act (BIPA), 8 controls. Each obligation this tool attaches is stated in our own words and cited to its clause, and every framework is held and cross-referenced in the same library a compliance team uses.

The consent rules this tool applies are held for both jurisdictions: the Australian Privacy Principles (the Privacy Act 1988) and the Spam Act 2003, and the United States CAN-SPAM Act, the CCPA/CPRA and the Illinois Biometric Information Privacy Act. The rules page states, per framework, what applies. Terminology, currency and examples are not Australia-only: amounts are shown in AUD by default and can be read in your own currency because the ranking is a ratio.

Your lapsed list and the studio

Paste the export as it comes out of your studio software. Every column is mapped to a field the tool understands before any member is sorted. Nothing is uploaded while you look: the map is built in this browser.

One row per member. Columns this tool reads: first name, last name, email, mobile, membership, join date, last visit, cancellation date, status, stated reason, consent, payment state. Extra columns are kept and ignored.

The studio profile

The conversion assumptions behind the ranking (illustrative, editable)

Starting values, not promises. The ranking of tiers rarely changes when you move these; it is the figure that moves.

A single blended dues figure and a percent per tier are close enough for a ranking of where to spend your time, never for a budget.

Type a name and press Search to jump to that member and read their tier, consent flag and drafted message.

A blank studio name, a blank dues figure or a blank start date returns scope incomplete and names the field, so no member is sorted on a guess.

The at-risk scan, before the loss

The biggest drop is in January and February, so this mode runs in November and December on the regulars whose attendance has already started to slip, before they cancel. Paste the current member attendance sheet: one row per member with the visits in the last 30 days, the visits in the 30 days before, and the last visit date.

Anyone with no visits in the last 30 days but visits before is flagged as gone quiet; anyone at 60 percent of their usual frequency or less is flagged as slipping. That flag is the signal to act, not the cancellation.

What is it, and what is it not?

It is a sorter and a drafter for a lapsed-member list. You paste the list you already export, confirm the studio profile once, and it returns every non-customer in one of three tiers, the still-paying silent lapse as the first cut, the paused and the do-not-contact rows held apart, and every row that cannot be tiered listed with the field it is missing. It then writes a dated three-touch sequence with a different offer per tier, and shows an illustrative ranking of which tier to spend your time on first.

It does not send anything, buy a list, collect the reason at the point of cancelling, change your timetable or your pricing, or process a refund or a billing change. It does not pull your member list live from the studio software: the first value is the paste. The expected revenue is a ranking, never a plan, and no outcome is guaranteed.

How the map is built

Every row is read once and classified on the evidence the row carries. The reasons column is cleaned first, so the tiering does not inherit shorthand the front desk typed under pressure. A stated reason puts a member in the refuser tier; low or sporadic use with no clear refusal is an occasional user; little engagement and no reason is unexplored. A freeze or pause is held out as paused, not gone. A member still on a live payment who has stopped coming is the first cut, a billing fix. A reason that contradicts the attendance raises a question. A no-consent row is withheld from every draft and listed with the reason. A row with an unreadable date or an unclear reason is listed as unresolved with the field named, so tiered plus paused plus still-paying plus do-not-contact plus unresolved always equals the input count, and the same list always gives the same map.

Frequently asked questions

How does the tool decide a tier?

It cleans the stated reason first, then classifies on the evidence the row carries: a stated reason is a refuser, low or sporadic use with no refusal is an occasional user, and little engagement with no reason is unexplored. A blank reason is not treated as a refusal.

What is the still-paying silent lapse?

A member who has stopped coming but is still on a live payment. That is the first thing the map shows, because it is a billing fix and an apology, not a win-back. The offer sequence never goes to that member.

What happens to a member with no consent on record?

The row is withheld from every drafted message and listed separately with the reason, "no marketing consent on record". Consent is often a sentence in a note or absent, so an unclear consent is treated as no consent.

Why is the expected revenue called illustrative?

Because it is built from your own dues figure and conversion assumptions, both of which are yours to change. It ranks which tier to spend time on first. It is never a plan and never a promise, and no outcome is guaranteed.

Does the tool send the messages?

No. It drafts them and you send them through the studio's own platform, so the consent record and the sender identity stay with the studio. Every message is edited by you and signed by you or the teacher.

Is my member list uploaded?

No. The map is built in your browser from the list you paste. Nothing is stored unless you save the studio and the run to your own account on a paid plan.

Plans, as pass cards

Free

AUD0
no card needed
  • The whole map on this page
  • The three tiers and the still-paying cut
  • The dated sequence and the illustrative ranking
  • The tiered CSV and the offer sheet
  • No account and no sign-in

Campaign pack

AUD99
one payment, one campaign
  • Save the studio profile and the run and reopen it next week
  • The season's list kept against the studio record
  • Owner-scoped: only your account reads it
  • Everything in free
Unlock the campaign pack

Monthly

AUD49
a month, cancel any time
  • Everything in the campaign pack
  • A fresh map every month as the list changes
  • The at-risk scan kept for the season
  • Cancel any time from the account page
Choose Monthly
The pack suits one clean-out; the monthly plan suits the studio that runs the map every month and the at-risk scan in November.
What stays free, alwaysThe whole sort, the sequence and the ranking

Grounded in the standards we hold

This is not invented. Every obligation Lapsed Member Mapper attaches is our statement of a clause we already hold, read clause by clause and cited to it, and every standard it reads is held and cross-referenced in the same library a compliance team uses.

95 controls across 18 domains held in all. Cross-referenced to up to 137 other frameworks.

Open the standards themselves How this is built