Churn Analysis

Entering and leaving players by year and age category

21
2026 entering
16
2026 leaving
+5
2026 net

Player turnover by year and age category

Entering:
<19
19
20-29
30-39
40-49
50-59
60-69
Over 70
Age unknown
Leaving:
<19
19
20-29
30-39
40-49
50-59
60-69
Over 70
Age unknown

About the data

What it shows

This chart displays player turnover over time, with two stacked bars per year:

  • Entering players (green bars): New players who got their first licence ever in that year
  • Leaving players (red bars): Players who left the sport (inactive status) with their last licence ending in that year

Each bar is segmented by age category to understand which demographic groups are joining or leaving the sport.

Definitions

  • Entering player: A player whose first licence (yearly or free) was issued in year N
  • Leaving player: A player marked as inactive (status_id = 'I') whose last licence ended in year N

Age categories

  • <19: Juniors aged 0-18 years
  • 19: Players aged exactly 19 years
  • 20-29, 30-39, 40-49, 50-59, 60-69, Over 70: Adult age brackets
  • Age unknown: Players without birth date (shown with hatched pattern)

Data scope

Exclusions:

  • International players
  • Federation clubs (Swiss Squash, PSA)

Special rules:

  • Adults (18+): both yearly and free licences are counted
  • Juniors (<18): yearly licences are always counted; free licences only count if the player attended more than 1 course (to exclude trial participants)

Last updated: 2026-02-19 02:22:36