Tabellab

Community Effort ROI: Labour Cost, Gross Profit, Net Result, ROI and Where the Time Did Not Pay

Lesson 12 of 20 Lab 🔒 Locked

Lessons in this course

  1. Community Fit Scoring: Activity per 1,000 Members, a Weighted Fit Score, Rank and Priority TierLabFree
  2. Community Rules Compliance: a Rule Matrix, Rule Breaks per Planned Post, Verdicts and Promotional LoadLab Locked
  3. Upvote Ratio: Estimating Total Votes, Upvotes and Downvotes from Score, Flagging Contested Posts and a Vote-Weighted RatioLab Locked
  4. Comment Performance: Comments, Average Score, Helpful Share and Help-Thread Averages per Team AccountLab Locked
  5. Best Time to Post: Posts and Average Score by Weekday, an Enough-Data Check and Time Slots with AVERAGEIFSLab Locked
  6. Post Format Mix: Average Score by Format, the Share of Top Posts with LARGE and an Index against the Overall AverageLab Locked
  7. Title Length and Score: CORREL, SLOPE, R-squared and a Cautious FORECAST.LINEAR PredictionLab Locked
  8. Participation Balance: Weekly Promo Share, a Cap Check, Extra Helpful Items Needed and the Cumulative ShareLab Locked
  9. Referral Traffic Quality: Engaged Rate, Conversion Rate, Revenue per Session and a Strong-Mixed-Weak Tier per CommunityLab Locked
  10. Tracking Hygiene: Cleaning UTM Source Tags, Mapping Channel Groups, Completeness Checks and the Share of Untrusted TrafficLab Locked
  11. Traffic Decay After a Post: Cumulative Share by Day, Daily Retention, Compound Decay and the Expected TailLab Locked
  12. Community Effort ROI: Labour Cost, Gross Profit, Net Result, ROI and Where the Time Did Not PayLab Locked
  13. AMA Planning: Forecasting Questions, Host Capacity, Hosts Needed and a Run-of-Show TimelineLab Locked
  14. AMA Results: Hourly Answer Rate, Open Questions, the Peak Hour and Sessions per AnswerLab Locked
  15. Removals and Moderator Relations: Submissions, Removal Rate per Community and a Pause RuleLab Locked
  16. Weekly Participation Plan: Hours in Proportion to Fit, Caps per Community, Expected Comments and Hours Above the CapsLab Locked
  17. Is the Difference Real? Comparing Two Title Styles with the Standard Error, the t Statistic and T.TESTLab Locked
  18. Comment Sentiment and Themes: Mentions, Negative Counts, Net Sentiment and the Theme to Fix FirstLab Locked
  19. Integrity Check: First-Hour Share, z-Scores of Early Votes, a Review Flag and the Zero-Tolerance CountLab Locked
  20. Final Project: a Quarterly Community Marketing Dashboard with Conversion, Revenue per Hour, Rank, a Combo Chart and Conditional FormattingLab Locked