Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  1. Community Pulse: Active Ratio & Answer RateLabFree
  2. Member Growth: Joins, Leaves & Net GrowthLab Locked
  3. Defining Active: 30-Day Activity & StickinessLab Locked
  4. Contributor Segments: Lurkers, Occasional & RegularsLab Locked
  5. Questions: Answered Share & Time to First AnswerLab Locked
  6. Who Answers: Staff vs Member Answers by TimeLab Locked
  7. Topic Categories: Where Questions Stay UnansweredLab Locked
  8. Content Reuse: Views, Search & Evergreen ThreadsLab Locked
  9. Support Deflection: An Estimate with a RangeLab Locked
  10. Join Cohorts: Who Is Still Active After 1, 3 & 6 MonthsLab Locked
  11. Onboarding: Welcome Replies & First Post in 7 DaysLab Locked
  12. Live Events: Attendance & Post UpliftLab Locked
  13. Moderation Load: Flags, Removals & Hours per 1,000 PostsLab Locked
  14. Quality Signals: Accepted Answers & Helpful MarksLab Locked
  15. Members vs Non-Members: A Fair ComparisonLab Locked
  16. Programme Cost: Cost per Active MemberLab Locked
  17. Seasonality: Posting Index & a Content CalendarLab Locked
  18. Community Health Score: Weighted & Traffic-LitLab Locked
  19. Targets & Pacing: Year-to-Date vs Annual GoalsLab Locked
  20. Final Project: The Community DashboardLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy