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