Club Analytics & Data-Driven Decisions — GoClubPro
Training Module 109 | Turning Platform Data into Committee Decisions: Retention, Revenue, Participation, and Engagement
What This Guide Covers
GoClubPro accumulates a season's worth of behavioural data as a by-product of normal use: who RSVPs and how fast, who pays and how late, which grades are growing, which members are drifting. Most clubs never look at it. This module shows the committee how to read that data — which numbers to track, where each one lives, what "good" looks like, and how to turn a trend into a decision. It builds on the four standing committee numbers from Module 106 and goes deeper.
Primary audience: Presidents, Club Admins, Treasurers — anyone preparing committee reports or making season strategy decisions See also: 106 Member Search, Filtering & Reporting · 48 Member Retention · 66 Club Financial Budgeting · 61 Player Statistics
SECTION 1: THE DATA YOU ALREADY HAVE
Where Each Signal Lives
| Question | Data Source | Where |
|---|---|---|
| Are we growing or shrinking? | Season registrations year over year | Admin Panel, season filter (Module 106) |
| Is money coming in on time? | Aging report, payment dates | Treasurer → Aging (Module 07) |
| Are members engaged? | RSVP speed, Noticeboard activity, Fantasy participation | Squad Builder, Noticeboard, Fantasy leaderboard |
| Are we selecting fairly? | Games played per member | Player profiles / match records (Module 61) |
| Which grades are healthy? | Squad fill rates, fill-in frequency | Squad Builder history per grade |
| Where does our money go? | Accounting entries by prefix | Treasurer → Accounting export (Module 07) |
The principle: none of this requires new data entry. If the club uses the platform normally — squads confirmed, results entered, fees issued, entries prefixed — the analytics are a free by-product. Clubs with sloppy data entry get sloppy analytics; this is another reason the hygiene habits in Modules 102 and 106 matter.
SECTION 2: RETENTION — THE NUMBER THAT DECIDES YOUR FUTURE
Measuring Retention Properly
Season-over-season retention rate = members registered this season who were also registered last season ÷ last season's total.
How to compute it: export both seasons' member lists (Module 106), match on email, count the overlap. Ten minutes in a spreadsheet.
Benchmarks for community sport:
- 80%+ — excellent; your club is sticky
- 65–80% — normal; expected churn from relocations, aging out, life changes
- Below 65% — a problem worth diagnosing, not just noting
Diagnosing Poor Retention
Don't stop at the rate — segment the leavers:
| Segment the Leavers By | What It Reveals |
|---|---|
| Grade | One grade bleeding = coach, culture, or grading issue in that grade (Module 64) |
| Tenure (first-season vs. long-term) | First-season churn = onboarding/welcome failure (Module 65); veteran churn = deeper culture issue |
| Fee status at departure | Left owing money = fees may be the barrier (Modules 68, 92) |
| Junior vs. senior | Juniors aging out with no pathway = transition program gap (Module 50) |
First-season retention deserves its own line in the AGM report. New members who don't return are the most preventable loss — Module 48 covers the interventions; this module tells you where to aim them.
SECTION 3: REVENUE ANALYTICS FOR THE TREASURER
Beyond the Balance: Three Revenue Views
1. Collection speed — from the Aging report over time: what percentage of issued fees are paid within 30 days? Falling collection speed predicts cash-flow trouble months before the balance shows it (Module 92's early-warning line: aging above ~25% of expected season revenue).
2. Revenue mix — from Accounting prefixes: what proportion of income is fees vs. canteen vs. fundraising vs. sponsorship? A club that is 90% fee-funded is fragile — one bad-weather season hits both participation and revenue at once. Committees use this number to set fundraising targets (Module 89).
3. Season Plan uptake — what share of eligible players bought a Season Plan? High uptake = predictable upfront revenue and fewer weekly collection chores; low uptake with high match-fee aging = the plan is priced or communicated wrong (Module 44).
The Cost Side
Filter Accounting exports by prefix ("Grounds —", "Equipment —", "Umpire —", "Tournament —") and total each category for the year. Two decisions this feeds:
- Fee setting for next season — cost per player per game is a real number, not a guess: total variable costs ÷ total player-games. If the match fee is below it, the gap must be covered by something deliberate (sponsorship, canteen), not by hope.
- Budget lines for the AGM — last year's actuals by category are the only honest starting point for next year's budget (Module 66).
SECTION 4: PARTICIPATION AND ENGAGEMENT SIGNALS
Games-Played Distribution
From match records: how are games distributed across the playing list? A healthy senior grade has most players in a broad middle band. Two red flags:
- A long tail of 1–3-game players — fringe players not getting games are next season's non-returners; this is the retention link (Section 2)
- The same fill-ins every week — a grade structurally short of players, masked by goodwill from the grade below (Module 105's playing-up data makes this visible)
Junior sport: many associations mandate minimum playing time. The distribution is your compliance evidence as well as a fairness check.
RSVP Behaviour as an Early-Warning System
RSVP speed is the cheapest engagement signal the platform gives you:
- Squad-wide slowdown — confirmation rates dropping across a team mid-season signals fatigue or morale trouble; worth a coach conversation before it becomes forfeit risk
- Individual drift — a member whose RSVPs go from same-day to chased-twice is disengaging; Module 77's 3–6 week window applies, and the coach noticing this in week 2 beats the admin noticing at re-registration time
Feature Engagement
Quick pulse checks, each 2 minutes:
- Noticeboard — are posts getting comments/reactions, or broadcasting into silence? Silence usually means the content mix is wrong (all admin, no celebration — Module 85's culture calendar is the fix)
- Fantasy League — participation rate among members; a mid-season leaderboard post typically revives a flagging competition (Module 54)
- Notification reach — spot-check that members are actually receiving pushes (Module 23); engagement data is meaningless if half the club never sees the prompts
SECTION 5: THE COMMITTEE DASHBOARD
The Monthly One-Pager
Extend Module 106's four standing numbers into a monthly one-page report. Same numbers, every month, so trends are visible:
[CLUB] — MONTHLY NUMBERS — [MONTH YEAR]
MEMBERSHIP
Active members: [n] ([+/-] vs last month)
New this month: [n] Pending queue: [n]
Watch: [e.g., "U16s down 3 — aging-out transition"]
MONEY
Outstanding fees: $[n] ([n]% of expected season revenue)
Paid within 30 days: [n]%
Balance: $[n] Month's biggest cost: [category $n]
ENGAGEMENT
Avg squad confirmation: [n]% by Thursday
Noticeboard: [n] posts / [n] reactions
Fantasy participants: [n]% of members
FLAGS
[1–3 bullet items needing a committee decision]
The FLAGS section is the point. Numbers without a proposed decision are trivia. "Aging hit 27% — recommend pausing discretionary spend and running the Module 07 chase sequence" is a committee item; "aging is 27%" is not.
The Annual Deep Dive
Once a year, pre-AGM, run the full set: retention rate with segments, revenue mix, cost per player-game, games-played distribution, Season Plan uptake. These populate the AGM report (Module 34) and set next season's fees, budget, and recruitment targets. Two to three hours of work, mostly exports and a spreadsheet — schedule it in the annual calendar (Module 74).
VISUAL: From Data to Decision
PLATFORM BY-PRODUCT DATA
(registrations · payments · RSVPs · match records · accounting)
│
▼
MONTHLY: one-pager
membership / money / engagement + FLAGS
trend vs last month is the signal
│
▼
FLAG RAISED ──► segment it
WHO is affected? (grade / tenure / fee status)
WHEN did it start? (compare months)
│
▼
DECISION with an owner and a module
e.g. first-season churn → welcome program (65)
aging > 25% → chase sequence + spend pause (07, 92)
one grade bleeding → coach conversation (64)
│
▼
NEXT MONTH: did the number move?
TOOLTIPS & HINTS
- Trends beat snapshots — the same one-pager every month; the delta is the signal
- Retention benchmark: 65–80% is normal — below that, segment the leavers before acting
- First-season retention is its own number — the most preventable churn, so track it separately
- Cost per player-game — total variable costs ÷ player-games; the honest floor for next season's match fee
- RSVP slowdown = early warning — squad-wide means morale; individual means disengagement (Module 77)
- Every flag gets an owner and a module — numbers without decisions are trivia
FAQ
Q: This looks like hours of work. What's the minimum viable version? A: The monthly one-pager is ~20 minutes once the habit exists: four exports you already do, plus reading three screens. The annual deep dive is one afternoon. If you can only do one thing, do the monthly aging percentage and season-over-season retention — money and members are the two numbers clubs die from ignoring.
Q: Our data is patchy — results weren't entered for half the season. Can we still do this? A: Financial and membership analytics still work (they come from payments and registrations, which are usually complete). Participation analytics won't — backfill the match records first (Module 102 confirms there's no time lock on result entry), and treat this season as the baseline year.
Q: Should we share these numbers with members or keep them to the committee? A: Share the good-news layer (membership growth, Fantasy participation, funds raised) on the Noticeboard — transparency builds trust and Module 85's culture engine runs on it. Keep the diagnostic layer (individual disengagement, grade-level churn, members in fee difficulty) strictly within the committee; those numbers describe identifiable people (Module 33).
Q: A number looks bad but we don't know why. What now? A: Segment, then ask. Data tells you where to look, not why — the why comes from a conversation with the affected group. A grade with poor retention gets a coffee with three leavers, not a committee theory. Their answers usually point straight at one of the modules in this library.
COMMON MISTAKES
| Mistake | Consequence | Prevention |
|---|---|---|
| Reporting snapshots without last month's number | No trend, no signal, no decision | Same template every month; always show the delta |
| Tracking everything | Report nobody reads; effort abandoned by June | One page, ~10 numbers, FLAGS section |
| Numbers with no owner | "Noted" at committee; nothing changes | Every flag: an owner, a module, a next-month check |
| Diagnosing from data alone | Wrong fix for a real problem | Segment with data, confirm with conversations |
| Sharing diagnostic data club-wide | Privacy breach; members feel surveilled | Good news public, diagnostics committee-only |
SHORT ONBOARDING SCRIPT
"The platform already collects everything you need to run the club on evidence instead of vibes — registrations, payments, RSVPs, match records. Build a monthly one-pager: membership, money, engagement, and a FLAGS section proposing decisions, not just noting numbers. Watch trends, not snapshots — 27% aging matters because last month it was 19%. Once a year, go deep: retention rate segmented by grade and tenure, revenue mix, cost per player-game — those set your fees, budget, and recruitment targets at the AGM. Two rules keep it honest: every flag gets an owner and a target, and data only tells you where to look — the why always comes from talking to the people behind the number."
MICRO-TRAINING QUICK TIPS
- Monthly one-pager: membership / money / engagement / FLAGS — ~20 minutes
- Retention = this season's returners ÷ last season's total; 65–80% is normal
- Segment leavers by grade, tenure, fee status before choosing a fix
- Aging above ~25% of expected season revenue = act now (Module 92)
- Cost per player-game = variable costs ÷ player-games = match-fee floor
- RSVP speed dropping = earliest disengagement signal you get
- Good news → Noticeboard; diagnostics → committee only
- Annual deep dive pre-AGM: one afternoon, feeds fees, budget, and targets
Training Module 109 | See also: 106 Member Search & Reporting · 48 Member Retention · 66 Club Financial Budgeting · 92 Financial Difficulty · 34 AGM Financial Reporting · 74 Annual Planning Calendar