A member retention tracker you can trust.

01/ Start with a consistent record

Download the cohort tracker.

This original CSV is a blank reporting template. It records period dates, cohort name, starting members, retained starting members, departures, renewal eligibility, reasons and ownership. It contains no personal data, formulas or example results.

Use a cohort that fits the decision: members active at the start of a reporting period, or members whose subscriptions are due for renewal. Keep the two definitions separate.

For the calculation and worked methodology, use the membership retention rate guide. The retention calculator provides an interactive check; the tracker preserves the recurring reporting record.

02/ A small data dictionary

Agree what each field means.

Record the definition beside the number. Grace periods, paused accounts, reinstatements and corporate changes can affect who appears to have stayed. Decide the rules before comparing periods.

03/ Keep growth separate

Follow the original group.

For a starting-cohort measure, divide retained starting members by starting members and express the result as a percentage. New joiners belong in the growth report, rather than the retained starting group.

If your reporting system supplies only total members at the end, check its treatment of joins, reactivations, transfers and deletions before using an aggregate formula. Directly matching stable membership records is often easier to explain.

Use membership KPIs for the wider dashboard. Separate retention, recruitment, membership revenue and participation so an improvement in one does not hide a problem in another.

04/ Use the report

Turn a change into a question.

When the reason behind a change is unclear, use the engagement questionnaire rather than infer dissatisfaction from a status field. Where the findings suggest a change to audience or offer, use membership strategy; if the interpretation needs independent work, brief membership consultants.

Compare like-for-like periods and groups before interpreting a movement. A first-year cohort and a long-standing cohort can have different needs; a small group can show a large percentage change from a few membership decisions.

ASAE’s member needs-assessment guidance recommends drawing on existing behaviour and frontline knowledge when deciding what to investigate. This supports a combined evidence review, rather than assuming the tracker explains why someone left.

Use a member exit survey to ask former members about their experience. Distinguish observed departure, reported reason and your interpretation. Report unknown reasons as unknown.

The membership retention plan turns diagnosis into work. Keep the tracker’s action log connected to that plan and to the person responsible for the next review.