Online Community Metrics: Member Growth, Active Ratios, Posts & Replies, Answer Rates & Time to Answer, Contributor Segments, Support Deflection, Events, Moderation Load & a Dashboard
Measure a fictional knitting brand's member forum in 20 hands-on labs – growth, active ratios, contributor segments, answer rates and speed, topics, support deflection, cohorts, onboarding, events, moderation, cost per active member, a health score and a final dashboard – with every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
In 20 hands-on labs you measure a fictional knitting brand's member forum with real spreadsheet formulas. You calculate member growth from joins and leaves, define an active member with a 30-day rule and work out active ratios and stickiness. You sort members into lurker, occasional and regular segments, measure answer rates, the median hours to a first answer and the share answered within 24 hours. You compare staff and member answers, find unanswered topics, estimate support deflection as a range, build cohort retention triangles, check onboarding, events and moderation load, and finish with a cost per active member, a weighted health score, goal pacing and a dashboard.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
Lessons
- Community Pulse: Active Ratio & Answer RateFree
- Member Growth: Joins, Leaves & Net Growth Locked
- Defining Active: 30-Day Activity & Stickiness Locked
- Contributor Segments: Lurkers, Occasional & Regulars Locked
- Questions: Answered Share & Time to First Answer Locked
- Who Answers: Staff vs Member Answers by Time Locked
- Topic Categories: Where Questions Stay Unanswered Locked
- Content Reuse: Views, Search & Evergreen Threads Locked
- Support Deflection: An Estimate with a Range Locked
- Join Cohorts: Who Is Still Active After 1, 3 & 6 Months Locked
- Onboarding: Welcome Replies & First Post in 7 Days Locked
- Live Events: Attendance & Post Uplift Locked
- Moderation Load: Flags, Removals & Hours per 1,000 Posts Locked
- Quality Signals: Accepted Answers & Helpful Marks Locked
- Members vs Non-Members: A Fair Comparison Locked
- Programme Cost: Cost per Active Member Locked
- Seasonality: Posting Index & a Content Calendar Locked
- Community Health Score: Weighted & Traffic-Lit Locked
- Targets & Pacing: Year-to-Date vs Annual Goals Locked
- Final Project: The Community Dashboard Locked
Learner reviews
Be the first to review this course.