Traditional club management systems act as passive databases—allowing typos, duplicate gala imports, orphaned records, and ghost accounts to quietly accumulate. The MyAthlete Member Governance Engine enforces continuous automated data hygiene, prevents roster corruption, and provides deep cohort retention intelligence.

Core Design Principle: Data hygiene must be proactive, non-destructive, and reversible. Admins are empowered to resolve data anomalies in bulk with complete confidence that merges can be rolled back in one click.

1. The Action Center (Proactive Data Hygiene)

The Action Center continuously scans active rosters and user accounts against strict data integrity rules, surfacing anomalies into prioritized operational worklists:

Missing Critical Demographics

Flags athletes missing Date of Birth or Gender before registration windows close or meet entries fail.

Dormant & Unassigned Roster Cleanup

Detects active memberships with no squad assignment or inactive members who joined >6 months ago. Provides 1-tap bulk deactivation.

Youth Safeguarding (Parentless Athletes)

Identifies minor athletes without a linked Family record, emergency contact, or active parent account.

Ghost User Account Deactivation

Identifies active users who have no staff roles, no swimmers, and no guardianship connections. Safely deactivates club memberships without destroying global user logins.

2. Multi-Tier Deduplication Engine

Duplicate athlete profiles typically arise during bulk CSV imports, HY-TEK / Meet Manager file ingestion, and multi-guardian registrations. The system uses multi-stage matching with configurable tolerance tiers:

  • Exact ID Match 100% Confidence: Identical names with matching birthdays — matched automatically.
  • Name + Birthday Match Probable Duplicate: Same name and birthday, or matching family contact where a birthday is missing — matched automatically or flagged for quick review.
  • Typo-Tolerant Match Fuzzy / Typo: Small spelling variations and nickname differences with matching birthday — left for review.
  • Historic Fix-Ups Date & Typo Tolerance: Catches old import date mix-ups and legacy record variations with matching family details — left for review.

3. Reversible Whitelisting ("Not a Duplicate")

To eliminate false positives between twin siblings, cousins, or same-name swimmers, admins can mark candidate pairs as "Not a Duplicate":

  • The system remembers dismissed pairs for that club only.
  • Dismissed pairs stay excluded across all sensitivity levels, including the widest checks.
  • 100% Reversible: Admins can review all dismissed pairs in the Whitelist tab and undo any dismissal with a single click.

4. Atomic Profile Merging & 1-Click Rollback

Merging duplicate records in MyAthlete is non-destructive, fully transactional, and completely reversible:

What Happens on Merge

  • Race results and relay legs are re-pointed to the kept profile.
  • Volunteer slots & attendance records are moved.
  • Unbilled & billed charges are transferred.
  • Old IDs are kept as aliases for seamless meet matching.
  • A full profile snapshot is saved for audit before merging.

1-Click Instant Rollback

  • Re-creates the removed profile with its original details.
  • Reactivates the club membership and squad links.
  • Moves race results, volunteer slots, and charges back to the restored profile.
  • Removes the old ID from the alias list.
  • Marks the audit entry as rolled back.

5. Predictive Retention & Membership Analytics

Going beyond simple registration tallies, the Members Analytics suite provides strategic retrospective insights into club stability:

  • Cohort Retention Survival Curves: Tracks the percentage of athletes retained across 1, 2, 3, 4, and 5+ years of membership.
  • Drop-Off Cliff Analysis: Pinpoints the exact age brackets where swimmers exit the club (e.g. high-school exam drop-offs at ages 15–16).
  • Intake & Departure Seasonality: Identifies monthly intake spikes (September/January) vs. end-of-season attrition.
  • Club Stability Index: Calculates the average tenure (in years) of active club members to measure long-term community health.

6. Squad Capacity & Headroom Governance

Uncontrolled roster growth leads to overcrowded lanes, deteriorated coaching quality, and safety violations. MyAthlete implements proactive Squad Capacity & Headroom Governance:

  • Hard Capacity Ceilings: Define maximum athlete capacities per squad (e.g. Senior Performance: 24, Junior Development: 18, or unlimited for open recreation tiers).
  • Real-Time Headroom Calculation: Squad listings and roster endpoints calculate live metrics instantly:
    • active_members_count: Verified active athletes in the training group.
    • available_spots: Headroom remaining before the squad reaches physical capacity limit.
    • occupancy_rate: Real-time percentage of capacity filled.
    • Dynamic Health Status: Automatically classifies each squad as AVAILABLE (<90%), NEAR_CAPACITY (90%–99%), AT_CAPACITY (100%), or OVER_CAPACITY (>100%).
  • Waitlist & Intake Protection: Integrates directly with the Admissions Pipeline, preventing admins from over-offering roster spots and automatically reserving vacancies for waitlisted trialists.
  • Athlete Squad Tenure: Every athlete on the squad roster is enriched with their exact date_joined_squad and running elapsed days_in_squad, giving coaches immediate visibility into athlete tenure.

7. Squad Progression & Dwell-Time Analytics

To ensure a healthy athlete development pathway, head coaches and club directors need visibility into how athletes flow between squads over time. The dedicated Squad Analytics engine surfaces macro-level movement metrics without statistical noise:

  • Dwell-Time & Tenure Curves: Calculates the median and average months athletes spend within each squad level—both for completed historical stays and the currently active cohort. This identifies squads where athletes stagnate or promotion criteria are misaligned.
  • Progression vs. Churn Balance: Evaluates cohort outcomes by measuring the percentage of athletes successfully promoted to the next squad level (promoted_pct) versus those who exit the club (left_club_pct).
  • 12-Month Movement Volume: A rolling 12-month timeline tracking squad transfers, intake promotions, and squad exits, providing committee boards with seasonal capacity forecasts.

8. Multi-Sport & Multi-Federation Architecture

Modern sports ecosystems require supporting athletes across multiple disciplines, clubs, and governing bodies without fragmenting their sporting history or leaking club-specific data:

  • Unified User Account, Multi-Sport Athletes: A single parent or athlete login holds distinct, sport-scoped performance profiles (e.g. Swimmer, Rugby Player) with isolated skill progression and results.
  • Modular Federation Licensing: Athletes hold national governing body licenses (e.g. Swim Ireland, Swim England) via dedicated AthleteLicense entities, eliminating international ID collisions and supporting dual-registered cross-border competitors.
  • Strict Club Tenant Isolation: While an athlete's lifetime performance records are unified per sport, club memberships (squads, monthly dues, financial ledgers, and duty rotas) remain 100% siloed and confidential between clubs.