Tabellab

Spikes: a Rolling 7-Day Baseline, the Mentions-to-Baseline Ratio and a Spike Flag

Lesson 2 of 20 Lab 🔒 Locked

Lessons in this course

  1. Mention Volume: Daily Totals, Channel Shares, the Average Day and the Peak-to-Average RatioLabFree
  2. Spikes: a Rolling 7-Day Baseline, the Mentions-to-Baseline Ratio and a Spike FlagLab Locked
  3. Sentiment Coding: Counting Positive, Neutral and Negative Comments, Shares and Negative Share per ChannelLab Locked
  4. Net Sentiment: (Positive − Negative) ÷ Total, the Variant Without Neutrals and the Positive-to-Negative RatioLab Locked
  5. Sentiment Scores: a −2 to +2 Scale, the Simple Mean, a Reach-Weighted Mean and a 0–100 IndexLab Locked
  6. Share of Voice: Brand Mentions ÷ Category Mentions, Ranks and Share of Voice per ChannelLab Locked
  7. Share of Positive and Negative Voice: Who Owns the Praise, Who Owns the Complaints, and a Positive IndexLab Locked
  8. Topic Coding: Counting Comments per Topic, Negative Share by Topic and the Topic That Drives ComplaintsLab Locked
  9. Keyword Rules: Pre-Coding Comments with SEARCH, a Flag Grid with Mixed References, Coverage and False HitsLab Locked
  10. Alert Thresholds: Baseline Mean, Standard Deviation, z-Scores and a Mean + k × SD RuleLab Locked
  11. Tuning Alerts on Past Incidents: Alerts Fired, False Alarms, Precision and Recall for Five ThresholdsLab Locked
  12. Crisis Timeline: Hourly Negative Share, Cumulative Mentions, the Trigger Hour, the Peak Hour and Time to PeakLab Locked
  13. Response Time: Minutes from Post to First Reply, a Response Target, Median vs Mean and Channel AveragesLab Locked
  14. Who Drives the Conversation: Engagements per Mention, Author Tiers, Ranks and the Top-3 ShareLab Locked
  15. Quality Check: Tool vs Analyst Labels, Accuracy, Precision and Recall of the Negative Label, and a Confidence Cut-OffLab Locked
  16. How Exact Is a Sentiment Share? Margin of Error, Confidence Bounds, a Reporting Rule and the Sample to CodeLab Locked
  17. Expected Volume: a Linear Trend with SLOPE and FORECAST.LINEAR, Deviation from Expected and an Unusual-Week FlagLab Locked
  18. Why Did Net Sentiment Move? Topic Contributions, Month-on-Month Change and the Topic That Dragged It DownLab Locked
  19. What-If Grid: Agents Needed by Spike Size and Negative Share, a Heat Map, Shift Capacity and the BacklogLab Locked
  20. Final Project: Monthly Listening Scorecard with Mentions, Net Sentiment, Share of Voice, a Review Flag and a Combo ChartLab Locked