community-health-scorer

name	community-health-scorer
description	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.
allowed-tools	Airtable API, Read
effort	high

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

---