See who left and your churn rate

List the clients who left in a period, when and why, with your churn rate (attrition %), churned count and their average tenure.

Who can do this
Owners, team admins and trainers
Where in Strix
Reports

The churn report lists every client who left in the report period: when they left, the event that marks it, the reason they gave, how long they were with you and what they spent. Above the list, three tiles show how many clients churned, your churn rate for the period and their average tenure.

Steps

  1. Open Reports.
  2. Open Ready-made questions and click one under Churn: Who left last month?, Why are clients leaving? or Which coaches’ clients are leaving?. Or tap Report on in any report sentence and pick Churned clients.
  3. The report opens with its usual blocks already set, so it runs straight away. Tap a block to change it:
    • Churn event: which events count as leaving. A client counts when they have any of the events you pick.
    • The yes/no blocks: all of them must hold for a client to count, such as Has an active subscription is No.
  4. Tap the period to choose the dates. Tap + to narrow by Home location, Roster, Assigned coach or Client name.
  5. Click Run again after any change. Save the report to send it by email on a schedule, or export it like any other report.

Churn events

  • Subscription cancelled: one of the client’s subscriptions was cancelled.
  • Package ended: a session pack ran out, or was revoked or cancelled. Packs don’t expire on a date, so the day it ran out is the day its last session was used.
  • Marked inactive: you marked the client inactive.
  • Removed from a roster: staff took the client off a roster from their profile, or an automation did.

Conditions

The report starts with four of these set to No. Add the others to be stricter, or remove one to count more clients.

  • Has an active subscription: a subscription that is billing now, including past due.
  • Has an active package: a pack with sessions left.
  • Paid after leaving: a payment collected through Strix after the churn date, up to the end of the period.
  • Still a client: not marked inactive. Not part of the starting blocks.
  • In a roster: in any roster now. Not part of the starting blocks.
  • Visited or booked after leaving: a booked, confirmed, checked-in or completed visit after the churn date, in the period or still to come.

Columns

Client, First name, Last name, Email, Home location, Assigned coach, Churn date, Churn event, Reason, Tenure (months) and Lifetime spend. First name is the first word of the client’s name and Last name is the rest.

How churn rate is worked out

Churn rate = churned clients in the report ÷ clients at the start of the period × 100.

  • Clients at the start are your clients (not leads) whose start date, or the day they were added, is on or before the first day of the period, and who weren’t marked inactive before it.
  • The report’s location counts too. A top-level Assigned coach or Home location block narrows the clients at the start the same way, so one coach’s churn rate divides by that coach’s clients.
  • Average tenure is the months from each churned client’s start date, or the day they were added, to their churn date.

Good to know

  • Each client appears once per churn: their first churn event in the period is the trigger. If a client cancels their subscription and is marked inactive later the same month, the row says Subscription cancelled.
  • Paused clients are never counted as churned, whether their booking access is paused or their billing is paused.
  • Reason comes from the client’s latest cancellation request sent on or before the churn date. It’s empty when they didn’t send one.
  • The yes/no blocks look at the client as they are now, so a client who came back since won’t count.
  • Deleted clients aren’t included.
  • Show the report as A count to see how many left, with how it changed from the period before, such as ↓ 20% vs the month before. Fewer churned clients shows green.
  • Staff without access to billing and payment details see churn without the billing blocks and Lifetime spend.
  • To get the churn summary every month, save Who left last month?, share it with your team, then use the Monthly churn summary automation template, which emails it to the owner on the 1st. Emails show the churn rate beside the count.

Last updated

All help articles