Skip to content

Retention audit · a working method

Membership retention review: how to audit why members leave

A membership retention review is a structured audit of who renews, who lapses and why. Pull five years of member data, analyse it by joining cohort, code lapse reasons, walk the member journey and the renewal process, then score each finding by impact and effort. The output is a short report that feeds a retention plan.

This page is the audit. The 12-month plan that follows it is our membership retention plan; a review of the whole model, pricing and categories included, is a membership review.

Retention review

01/ When to run a retention review

Review when the rate moves, or nobody can explain it.

Run one when renewal falls for two years running, when first-year members lapse faster than you expected, before a fee increase, or when a new chief executive asks why the number is what it is and nobody can answer.

For charities, it is also governance. The Charity Commission reminds trustees that they have “independent control over, and legal responsibility for, a charity’s management and administration” (Charity Commission, CC3). Members are often the income and the purpose at once.

A retention review is narrower than a full membership review. It does not question your categories or fees; it asks why the members you already have stop paying.

Signs you need a retention review · 0/5 in place

Tick any that apply.

02/ What data to pull

Five years of records, one row per membership year.

Export every membership record for at least five years, one row per member per year: join date, category, fee paid, payment method, renewal outcome, lapse date and any lapse reason recorded.

Add what explains behaviour: event attendance, CPD logged, email engagement, portal log-ins, service use. Even partial engagement data lets you test whether active members renew more.

Clean before you analyse. The ICO’s accuracy principle requires “every reasonable step” to keep personal data accurate and, where necessary, up to date (ICO, accuracy). Duplicate records and stale emails also distort the lapse count.

Check retention too. The ICO expects organisations to document standard retention periods and review them (ICO, storage limitation); old lapsed-member records you keep for analysis need a reason and a period.

Membership record

  • Join date and source
  • Category and fee paid
  • Payment method
  • Renewal outcome by year
  • Lapse date and reason

03/ Cohort analysis

Group members by the year they joined.

An overall renewal rate blends members who joined last year with members of twenty years. Split them into joining cohorts and follow each one forward.

Most reviews find the steepest drop between year one and year two. That is consistent with the US benchmark: MGI’s 2024 report put median first-year renewal at 75% (n=333) (MGI 2024), while the 2026 edition put median renewal for all members at 82% (MGI 2026). Different editions, both US surveys.

Then cut each cohort by category, acquisition source and payment method. A cohort recruited through a discount, or paying by invoice rather than direct debit, often renews very differently.

Keep the analysis running after the review with the member retention tracker. The formula behind the rate is on membership retention rate.

JoinedYear 1Year 2Year 3Year 4
2022100%your figureyour figureyour figure
2023100%your figureyour figure—
2024100%your figure——
2025100%———

Layout only. Fill each cell with the share of that cohort still in membership; read down a column to compare cohorts at the same age.

04/ Lapse reasons

Code every lapse, and chase the unknowns.

Sort lapses into a short fixed code list: cost, value, career or life change, moved to a rival, employer stopped paying, payment failed, contact lost, and unknown.

Separate voluntary from involuntary. Payment failure and lost contact are process problems; the rest are value problems. The distinction is set out on membership churn rate.

If unknown is the biggest code, that is the first finding. Fill the gap with a short call programme or survey to a sample of recent lapsers; question sets are on member exit survey and member retention survey.

CodeWhere to look
CostFee level, payment options
ValueBenefit use, engagement
Life changeRetired, left sector
RivalCompeting body or free alternative

05/ Journey touchpoints

Walk the member journey as a new joiner.

Join as a member yourself, or shadow a recent joiner. Record every message, login, charge and silence across the first year.

Look for the gaps: weeks with no contact after the welcome, benefits nobody explains, a portal that asks for a password reset on first visit, an event invitation that arrives after the event.

Map what you find against the stages in member journey and the first 90 days in member onboarding.

  1. 01
    Day 0

    Join

    Confirmation, receipt, login.

  2. 02
    Weeks 1–4

    Welcome

    First value delivered?

  3. 03
    Months 2–9

    Use

    Engagement or silence?

  4. 04
    Months 10–12

    Renew

    Reminders, payment, thanks.

06/ Renewal process audit

Test the renewal cycle from the member’s side.

List every reminder: when it goes, through which channel, from which sender, and what it asks the member to do. Then renew a test account through each payment route.

Check the failure paths. What happens when a card is declined, a direct debit bounces or the invoice contact has left? Is there a grace period, and does anyone call before a long-standing member lapses?

Good practice for reminders, grace periods and win-back is on membership renewals.

Renewal process audit

  1. 01Do reminders start at least 60 days before expiry?

  2. 02Is a failed payment followed up within a week?

  3. 03Is there a defined grace period?

  4. 04Does one person own renewal end to end?

Answer the 4 questions to see where you stand.

Our audit prompts, not a benchmark.

07/ Retention self-audit

Score your retention in eight questions.

Our self-audit, not a benchmark. Answer for your organisation as it is today.

Membership retention self-audit · 0/8 answered

  1. 01We know our renewal rate for each of the last five years

  2. 02We report first-year renewal separately

  3. 03We track retention by joining cohort

  4. 04Every lapse has a coded reason

  5. 05We separate voluntary from involuntary churn

  6. 06We can link engagement to renewal

  7. 07Failed payments are chased automatically

  8. 08One person owns retention end to end

Answer all 8 to see your result.

Scoring and bands are ours.

08/ Scoring findings and the report

Rank findings by impact and effort.

Score each finding twice, from one to five: how many members or how much income it affects, and how hard it is to fix. Quick, high-impact fixes go first; they are often involuntary churn.

Keep the report short: a one-page summary, the cohort grid, lapse reasons by code, the journey gaps, the renewal audit and a ranked list of actions with owners.

That ranked list is the input to the membership retention plan, which turns it into twelve months of work.

Retention review report contents

  1. 01Summary and the three biggest findings
  2. 02Renewal and churn by cohort
  3. 03Lapse reasons by code
  4. 04Journey and renewal gaps
  5. 05Ranked actions with owners

09/ An independent retention review

Fresh eyes on your own data.

We run retention reviews for membership organisations: we pull and clean the data, build the cohorts, code the lapses and hand over a ranked report. If you want the work that follows too, it sits in our membership retention service.

Book a call →
Dan Keegan, Founder, Membership Quest and GTM Quest

Written by Dan KeeganFounder, Membership Quest and GTM Quest · GTM Quest ↗

10/ questions

Membership retention review FAQs.

What is a membership retention review?

A structured audit of who renews, who lapses and why, using your own member data, lapse reasons, the member journey and the renewal process. It ends in a ranked list of actions.

What is a retention audit?

The same thing under another name: a review of retention data and processes that identifies why members leave and what to fix first.

How long does a retention review take?

It depends mostly on the state of the data. Clean, exportable records shorten it; scattered spreadsheets and missing lapse reasons lengthen it.

What data do I need for a membership retention review?

At least five years of membership records with join date, category, fee, payment method, renewal outcome and lapse reason, plus whatever engagement data you hold.

What is cohort analysis in membership?

Grouping members by the year they joined and following each group forward, so you compare members at the same stage rather than blending new and long-standing members.

How is a retention review different from a membership review?

A retention review looks only at why existing members stop paying. A membership review looks at the whole model, including categories, fees and benefits.

What comes after a retention review?

A retention plan: twelve months of prioritised actions, owners and measures built from the review’s findings.

Evidence before action

Find the real reasons, then fix the right things.

A retention review turns a single renewal number into causes you can act on.