FF-ME Report Proposition
Fictive data
FF ME Dashboard
Hover the i icons to see Data + Formula for each KPI.
Members & Growth
Total Active Members
i
Data
1,250+3% MoM
Active members at month end
FormulaCOUNT(active_members)
PT Conversion Rate
i
Data
54%+1 pp MoM
PT clients; eligible members
FormulaPT ÷ Eligible
Trainer Assignment Rate
i
Data
95%=
Assigned trainers; active members
FormulaAssigned ÷ Members
Total Bookings
i
Data
4,280+7% MoM
Booking and booking date
FormulaCOUNT(booked in month)
Sessions
Attendance Rate
i
Data
82%+2 pp MoM
Attended vs Booked
FormulaAttended ÷ Booked
No-Show Rate
i
Data
18%-1 pp MoM
No-show vs Booked
FormulaNo_show ÷ Booked
Sessions / Trainer
i
Data
38+3 MoM
Attended sessions; active trainers
FormulaAttended ÷ Trainers
Programs
Program Coverage
i
Data
68%+2 pp MoM
Members with program; active members
FormulaWith_program ÷ Members
Avg Days to Issue
i
Data
5.5-0.4 d MoM
Eval date; issue date
FormulaAVG(issue − eval)
Shared with Member
i
Data
88%+1 pp MoM
Shared flag/date; issued programs
FormulaShared ÷ Issued
Program Type Most used
i
Data
60%+2 pp MoM
Program type field
FormulaEvolving ÷ All_programs
Onboarding & Compliance
Evaluation Completion (Eval 1)
i
Data
72%+3 pp MoM
NJM cohort; eval 1 status
FormulaEval1 ÷ NJM
Health Q Completion
i
Data
81%+1 pp MoM
NJM cohort; questionnaire status
FormulaCompleted ÷ NJM
Evaluation No-Show
i
Data
12%-1 pp MoM
Eval bookings; eval no-shows
FormulaNo_show ÷ Eval_booked
Time to Eval
i
Data
3.2d-0.3 d MoM
Join date; first eval date
FormulaMEDIAN(eval − join)
Sessions by Club
DHL
520
AFA
310
BGD
210
KWT
190
DXB
160
Program Types
60%
| Type | Count | Share |
|---|---|---|
| Evolving | 95 | 60% |
| Multi-week | 62 | 40% |
Sessions by Trainer
| Trainer | Booked | Attended | No-Show |
|---|---|---|---|
| Ivana Sargic | 120 | 110 | 10 |
| Ali Rahman | 68 | 54 | 14 |
| Mary Bento | 52 | 42 | 10 |
| Mohamed Abdul | 41 | 36 | 5 |
| Sakina Ibrahim | 30 | 24 | 6 |