Viewers: load a results.json or results.json.gz file from your admin, or place it next to this HTML and refresh. Admin: load the raw Excel to process fresh data, then use "Export results" to publish.
Overall Insights · NPS & CSAT
Q1 · Net Promoter Score
Likelihood to recommend (0–10)
–
Detractors (0–6)Passives (7–8)Promoters (9–10)
Q7 · Customer Satisfaction
% scoring 7–10 (satisfied)
–
NPS trend · year-on-year
This year overlaid on last year · Jan–Dec
CSAT trend · year-on-year
This year overlaid on last year · Jan–Dec
Key Drivers
Cleanliness · Staff · Classes · Community · Equipment
% scoring 4+ on each driver
Top-2 box agreement · mean score shown alongside
Driver trend
% scoring 4+ over time
Club distribution by driver
% of clubs where the share of members scoring 4+ falls in each band
Other Drivers
Remaining items in Q5 & Q6
Personal Best Insights – respondents
Members who answered Q10 = Yes
Q14 · NPS for Personal Best
–
Q11 · Experience agreement (% scoring 4+)
Aspects of the Personal Best appointment
Q12 · Motivations for booking a Personal Best appointment
% selecting each reason (multi-select)
Personal Training Insights – respondents
Members who answered Q19 = Yes
Q21 · NPS for Personal Training
–
Q20 · Experience agreement (% scoring 4+)
Aspects of the personal training experience
Swimming Insights – respondents
Members / families who answered Yes to Q23
Q25 · NPS for Swimming Lessons
–
Q24 · Experience agreement (% scoring 4+)
Aspects of the swim lesson experience
Q23 · Who takes lessons?
Club Leaderboard
Sort by any column — click the column header. "n" is the number of responses for that club in the relevant period. Cells are shaded by performance against the metric's healthy thresholds.
Leaderboard Snapshot · PPT-friendly
Ranked by YTD NPS. Clubs split into three roughly equal sections. Movement shows rank change from the previous month's YTD ranking.
On-device sentiment analysis
Classify every verbatim comment by sentiment (positive / neutral / negative) and auto-tag themes.
The model runs entirely in your browser via WebAssembly — text never leaves this device.
First load: ~30 MB model download (cached by browser after first run). Processing time: ~1–2 minutes for a typical monthly dataset. After analysis: use "Export results" in the top-right to publish the processed data for viewers.
Scope: Sentiment analysis covers only the latest month of verbatim responses to Q2 (the NPS follow-up question: "Please can you tell us why you gave that rating?"). The reference-month and view-mode filters in the top bar don't apply to this tab. Other verbatim fields (Q3A, Q9, Q16, Q22, Q26, Final_comments) are not analysed.
Verbatim Insights · Sentiment & Themes
Overall sentiment distribution
Across all verbatim responses in scope
–
NegativeNeutralPositive
Sentiment by NPS score (0–10)
Net sentiment (% pos − % neg) at each rating
Sentiment vs NPS segment
How sentiment aligns with Detractor / Passive / Promoter
Theme detection
Auto-tagged via keyword matching · a single comment may have multiple themes
Top 10 themes by volume
Share of comments mentioning each theme
Sentiment within top 10 themes
Net sentiment, ranked worst → best
Comment Explorer
Performance management data. This tab shows individually-named General Managers against agreed targets.
Use only for management discussions; do not share screenshots externally.
YTD NPS by General Manager
Total GMs
–
At or above target
–
Between threshold & target
–
Below threshold
–
RAG: Green = YTD at or above Target ·
Amber = YTD between Threshold and Target ·
Red = YTD below Threshold.
Asterisk (*) marks GMs with fewer than 30 YTD responses across their clubs — small samples produce statistically unreliable NPS values, treat with caution.
"Mth" and "3MR" columns are context only; RAG and target comparisons use YTD.
No GM mapping loaded
This tab requires GM Targets and RD Targets sheets. They are normally included in your main Excel — re-load the Excel, or use the button below to load a separate mapping file.
Performance management data. This tab shows individually-named Regional Directors against agreed targets.
Use only for management discussions; do not share screenshots externally.
YTD NPS by Regional Director
Total RDs
–
At or above target
–
Between threshold & target
–
Below threshold
–
RAG and target comparisons use YTD NPS pooled across every survey response from clubs in the RD's region.
Click any row to expand and see the GMs reporting to that RD.
"Mth" and "3MR" columns are context only.
No GM mapping loaded
This tab requires GM Targets and RD Targets sheets. They are normally included in your main Excel — re-load the Excel, or use the button below to load a separate mapping file.