Community Health Scorer
When to activate
Weekly (recommended: Monday morning). You have member database with activity logs for the prior week and trailing 12 weeks for trend analysis. Activation requires: member list with timestamps for join, last activity, posts, comments, and sentiment scores.
When NOT to use
Not for real-time metrics (this is weekly snapshot). Not without at least 4 weeks of baseline data. Not as the only health metric — supplement with qualitative feedback and member interviews.
Health Metrics Framework
1. Growth Metrics
Member Growth Rate:
- Formula: (New members this week / Total members last week) × 100
- Target: 10% MoM for mature communities, 20% for early-stage
Segments Growth:
- How many new Advocates, Core, Contributors?
- Growth in high-value segments (Advocates) vs. low-value (Lurkers)?
2. Engagement Metrics
Monthly Active Rate (MAR):
- Formula: (Members with 1+ activity in past 30 days / Total members) × 100
- Target: >40%
Weekly Active Rate (WAR):
- Formula: (Members with 1+ activity in past 7 days / Total members) × 100
- Target: >15%
Post/Comment Volume:
- Total posts + comments this week
- Compare to trailing 4-week average
- Trend: increasing, stable, declining?
Engagement per Member:
- Average posts per active member
- Average comments per active member
- Lurker ratio (% read-only members)
3. Sentiment Metrics
Sentiment Distribution:
- % Very Positive (0.7 to 1.0)
- % Positive (0.3 to 0.6)
- % Neutral (-0.3 to 0.3)
- % Negative (-0.6 to -0.3)
- % Very Negative (-1.0 to -0.6)
- Target: 70%+ positive, <5% negative
Sentiment Trend:
- Week-over-week change in distribution
- Any spikes in negative sentiment (topic-driven)?
4. Churn & Retention Metrics
Churn Rate:
- Formula: (Members inactive 30+ days / Previous week total) × 100
- Target: <2% MoM
Retention by Cohort:
- % of 1-month-old members still active
- % of 3-month-old members still active
- % of 6-month-old members still active
- Target: 60%+ at 1m, 40%+ at 3m, 30%+ at 6m
Reactivation Success Rate:
- Formula: (Re-engaged members from orchestrator outreach / Total at-risk) × 100
- Target: >40%
5. Satisfaction Metrics
NPS (Net Promoter Score):
- Track from event surveys, community-wide survey
- Formula: (% Promoters (9–10) - % Detractors (0–6)) × 100
- Target: >50
Response Time (to questions/comments):
- Average time to first response from community (CM or peer)
- Target: <4 hours during business hours
Member Feedback Sentiment:
- Qualitative: themes from DMs, feedback, comments
- Look for: appreciation, frustration, feature requests, cultural fit
6. Content & Discussion Quality
Top Discussions (by engagement):
- Which threads had highest replies, reactions, views?
- What topics drive engagement? (signals community interests)
Top Performers:
- Which members posted most, received most engagement?
- Emerging Advocates from Contributor segment?
Content Gaps:
- Are members asking unanswered questions?
- Are there topics with high interest but low supply?
Output Format
## Community Health Report — Week of [Date]
---
## Executive Summary
**Overall Health Score:** [X/100]
- Green: 70+ | Yellow: 50–69 | Red: <50
**Key Status:** [THRIVING / HEALTHY / CAUTION / AT RISK]
**Top Priority Action:** [One sentence describing biggest opportunity or risk]
---
## Growth Metrics
**New Members:** [X] (+X% WoW)
- Advocates: [X] | Core: [X] | Contributors: [X] | Lurkers: [X]
- Trend: [↑ increasing / → stable / ↓ declining]
**Total Members:** [X] (+X% vs. last week)
---
## Engagement Metrics
**Monthly Active Rate:** [X%] (Target: 40%+)
**Weekly Active Rate:** [X%] (Target: 15%+)
**Activity Volume:**
- Posts: [X] (+X% WoW)
- Comments: [X] (+X% WoW)
- Total interactions: [X]
**Engagement per Member:** [X posts/comments per active member/week]
---
## Sentiment Distribution
| Sentiment | % | Target | Status |
|---|---|---|---|
| Very Positive | [X%] | 20%+ | [✓ / ⚠ / ✗] |
| Positive | [X%] | 50%+ | [✓ / ⚠ / ✗] |
| Neutral | [X%] | 20–40% | [✓ / ⚠ / ✗] |
| Negative | [X%] | <5% | [✓ / ⚠ / ✗] |
| Very Negative | [X%] | <1% | [✓ / ⚠ / ✗] |
**Sentiment Trend:** [↑ improving / → stable / ↓ declining]
**Notable:** [Any spikes? Causation?]
---
## Churn & Retention
**Churn Rate:** [X%] (Target: <2% MoM)
- At-risk members (14+ days inactive): [X]
- High-risk (Advocates with 21+ days inactive): [X]
**Retention by Cohort:**
- 1-month cohort: [X%] still active
- 3-month cohort: [X%] still active
- 6-month cohort: [X%] still active
**Reactivation Wins:** [X members] returned this week from orchestrator outreach
---
## NPS & Satisfaction
**NPS Score:** [X] (Target: 50+)
- Promoters: [X%] (9–10)
- Passives: [X%] (7–8)
- Detractors: [X%] (0–6)
**Feedback Themes:**
- [Positive]: [Theme 1], [Theme 2]
- [Negative]: [Theme 1], [Theme 2]
**Response Time:** [X hours avg.] (Target: <4h)
---
## Top Performers & Discussion
**Top 5 Posts (by engagement):**
1. [Title] — [Author] — [Replies, Reactions]
2. [Title] — [Author] — [Replies, Reactions]
[...]
**Emerging Advocates (Contributors climbing to Core):**
- [Member Name] — [trend, why notable]
**Content Gaps:**
- [Question asked multiple times but unanswered]: [Topic]
- [High interest but low supply]: [Topic]
---
## Action Items
**Immediate (This Week):**
- [ ] [Priority action 1]
- [ ] [Priority action 2]
**Short-Term (This Month):**
- [ ] [Action 1]
- [ ] [Action 2]
**Longer-Term (Next Quarter):**
- [ ] [Action 1]
---
## Notes & Context
[Anything unusual this week? External events? Campaigns? Learnings?]
Health Scoring Logic
Green (70+):
- MAR >40%, WAR >15%, Growth >5%
- Sentiment >65% positive, <5% negative
- Churn <2%, NPS >50
- Response time <4h
- Clear growth in Advocates, stable Core
Yellow (50–69):
- MAR 30–40%, WAR 10–15%, Growth 0–5%
- Sentiment 50–65% positive, 5–10% negative
- Churn 2–4%, NPS 30–50
- Response time 4–8h
- Core stable, Advocates slow growth
Red (<50):
- MAR <30%, WAR <10%, Growth negative
- Sentiment <50% positive, >10% negative
- Churn >4%, NPS <30
- Response time >8h
- Lurker ratio >50%, Advocate attrition
Example Report
Week of June 10–16, 2026
Executive Summary:
Overall Health: 78/100 (GREEN - THRIVING)
Growth: 18 new members (+2.1% WoW). Strong in Core segment.
Engagement: MAR 44%, WAR 18% — both above targets.
Sentiment: 74% positive — best week in June.
Churn: 1.2% — healthy. Reactivated 5 at-risk members.
NPS: 58 (up from 52) — members appreciating new event cadence.
Top Priority: Launch monthly AMA series (high demand signal) + create #product-feedback channel (request from 3+ members).
1---2name: community-health-scorer3description: Generates weekly community health report. Measures member growth, churn rate, engagement rate, sentiment distribution, NPS trend, and top performers. Surfaces action items and health indicators.4allowed-tools: Airtable API, Read5effort: high6metadata:7 source: https://skillmd.com/skills/uitbreidenos/community-health-scorer8---910# Community Health Scorer1112## When to activate1314Weekly (recommended: Monday morning). You have member database with activity logs for the prior week and trailing 12 weeks for trend analysis. Activation requires: member list with timestamps for join, last activity, posts, comments, and sentiment scores.1516## When NOT to use1718Not for real-time metrics (this is weekly snapshot). Not without at least 4 weeks of baseline data. Not as the only health metric — supplement with qualitative feedback and member interviews.1920## Health Metrics Framework2122### 1. Growth Metrics2324**Member Growth Rate:**25- Formula: (New members this week / Total members last week) × 10026- Target: 10% MoM for mature communities, 20% for early-stage2728**Segments Growth:**29- How many new Advocates, Core, Contributors?30- Growth in high-value segments (Advocates) vs. low-value (Lurkers)?3132### 2. Engagement Metrics3334**Monthly Active Rate (MAR):**35- Formula: (Members with 1+ activity in past 30 days / Total members) × 10036- Target: >40%3738**Weekly Active Rate (WAR):**39- Formula: (Members with 1+ activity in past 7 days / Total members) × 10040- Target: >15%4142**Post/Comment Volume:**43- Total posts + comments this week44- Compare to trailing 4-week average45- Trend: increasing, stable, declining?4647**Engagement per Member:**48- Average posts per active member49- Average comments per active member50- Lurker ratio (% read-only members)5152### 3. Sentiment Metrics5354**Sentiment Distribution:**55- % Very Positive (0.7 to 1.0)56- % Positive (0.3 to 0.6)57- % Neutral (-0.3 to 0.3)58- % Negative (-0.6 to -0.3)59- % Very Negative (-1.0 to -0.6)60- Target: 70%+ positive, <5% negative6162**Sentiment Trend:**63- Week-over-week change in distribution64- Any spikes in negative sentiment (topic-driven)?6566### 4. Churn & Retention Metrics6768**Churn Rate:**69- Formula: (Members inactive 30+ days / Previous week total) × 10070- Target: <2% MoM7172**Retention by Cohort:**73- % of 1-month-old members still active74- % of 3-month-old members still active75- % of 6-month-old members still active76- Target: 60%+ at 1m, 40%+ at 3m, 30%+ at 6m7778**Reactivation Success Rate:**79- Formula: (Re-engaged members from orchestrator outreach / Total at-risk) × 10080- Target: >40%8182### 5. Satisfaction Metrics8384**NPS (Net Promoter Score):**85- Track from event surveys, community-wide survey86- Formula: (% Promoters (9–10) - % Detractors (0–6)) × 10087- Target: >508889**Response Time (to questions/comments):**90- Average time to first response from community (CM or peer)91- Target: <4 hours during business hours9293**Member Feedback Sentiment:**94- Qualitative: themes from DMs, feedback, comments95- Look for: appreciation, frustration, feature requests, cultural fit9697### 6. Content & Discussion Quality9899**Top Discussions (by engagement):**100- Which threads had highest replies, reactions, views?101- What topics drive engagement? (signals community interests)102103**Top Performers:**104- Which members posted most, received most engagement?105- Emerging Advocates from Contributor segment?106107**Content Gaps:**108- Are members asking unanswered questions?109- Are there topics with high interest but low supply?110111## Output Format112113```114## Community Health Report — Week of [Date]115116---117118## Executive Summary119120**Overall Health Score:** [X/100]121- Green: 70+ | Yellow: 50–69 | Red: <50122123**Key Status:** [THRIVING / HEALTHY / CAUTION / AT RISK]124125**Top Priority Action:** [One sentence describing biggest opportunity or risk]126127---128129## Growth Metrics130131**New Members:** [X] (+X% WoW)132- Advocates: [X] | Core: [X] | Contributors: [X] | Lurkers: [X]133- Trend: [↑ increasing / → stable / ↓ declining]134135**Total Members:** [X] (+X% vs. last week)136137---138139## Engagement Metrics140141**Monthly Active Rate:** [X%] (Target: 40%+)142**Weekly Active Rate:** [X%] (Target: 15%+)143144**Activity Volume:**145- Posts: [X] (+X% WoW)146- Comments: [X] (+X% WoW)147- Total interactions: [X]148149**Engagement per Member:** [X posts/comments per active member/week]150151---152153## Sentiment Distribution154155| Sentiment | % | Target | Status |156|---|---|---|---|157| Very Positive | [X%] | 20%+ | [✓ / ⚠ / ✗] |158| Positive | [X%] | 50%+ | [✓ / ⚠ / ✗] |159| Neutral | [X%] | 20–40% | [✓ / ⚠ / ✗] |160| Negative | [X%] | <5% | [✓ / ⚠ / ✗] |161| Very Negative | [X%] | <1% | [✓ / ⚠ / ✗] |162163**Sentiment Trend:** [↑ improving / → stable / ↓ declining]164165**Notable:** [Any spikes? Causation?]166167---168169## Churn & Retention170171**Churn Rate:** [X%] (Target: <2% MoM)172- At-risk members (14+ days inactive): [X]173- High-risk (Advocates with 21+ days inactive): [X]174175**Retention by Cohort:**176- 1-month cohort: [X%] still active177- 3-month cohort: [X%] still active178- 6-month cohort: [X%] still active179180**Reactivation Wins:** [X members] returned this week from orchestrator outreach181182---183184## NPS & Satisfaction185186**NPS Score:** [X] (Target: 50+)187- Promoters: [X%] (9–10)188- Passives: [X%] (7–8)189- Detractors: [X%] (0–6)190191**Feedback Themes:**192- [Positive]: [Theme 1], [Theme 2]193- [Negative]: [Theme 1], [Theme 2]194195**Response Time:** [X hours avg.] (Target: <4h)196197---198199## Top Performers & Discussion200201**Top 5 Posts (by engagement):**2021. [Title] — [Author] — [Replies, Reactions]2032. [Title] — [Author] — [Replies, Reactions]204[...]205206**Emerging Advocates (Contributors climbing to Core):**207- [Member Name] — [trend, why notable]208209**Content Gaps:**210- [Question asked multiple times but unanswered]: [Topic]211- [High interest but low supply]: [Topic]212213---214215## Action Items216217**Immediate (This Week):**218- [ ] [Priority action 1]219- [ ] [Priority action 2]220221**Short-Term (This Month):**222- [ ] [Action 1]223- [ ] [Action 2]224225**Longer-Term (Next Quarter):**226- [ ] [Action 1]227228---229230## Notes & Context231232[Anything unusual this week? External events? Campaigns? Learnings?]233```234235## Health Scoring Logic236237**Green (70+):**238- MAR >40%, WAR >15%, Growth >5%239- Sentiment >65% positive, <5% negative240- Churn <2%, NPS >50241- Response time <4h242- Clear growth in Advocates, stable Core243244**Yellow (50–69):**245- MAR 30–40%, WAR 10–15%, Growth 0–5%246- Sentiment 50–65% positive, 5–10% negative247- Churn 2–4%, NPS 30–50248- Response time 4–8h249- Core stable, Advocates slow growth250251**Red (<50):**252- MAR <30%, WAR <10%, Growth negative253- Sentiment <50% positive, >10% negative254- Churn >4%, NPS <30255- Response time >8h256- Lurker ratio >50%, Advocate attrition257258## Example Report259260**Week of June 10–16, 2026**261262**Executive Summary:**263Overall Health: 78/100 (GREEN - THRIVING)264265**Growth:** 18 new members (+2.1% WoW). Strong in Core segment.266**Engagement:** MAR 44%, WAR 18% — both above targets.267**Sentiment:** 74% positive — best week in June.268**Churn:** 1.2% — healthy. Reactivated 5 at-risk members.269**NPS:** 58 (up from 52) — members appreciating new event cadence.270271**Top Priority:** Launch monthly AMA series (high demand signal) + create #product-feedback channel (request from 3+ members).272273---