# Community Health Scorer

> 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.

- Skill: `uitbreidenos/community-health-scorer` (Agent Skill)
- Install (CLI): `npx skillmds@latest add uitbreidenos/community-health-scorer`
- Raw SKILL.md: https://api.skillmd.com/api/skills/uitbreidenos/community-health-scorer/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Marketing & Growth
- Author: UitbreidenOS (https://skillmd.com/u/uitbreidenos)
- Updated: 2026-09-22
- Page: https://skillmd.com/skills/uitbreidenos/community-health-scorer

---


# 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).

---