Tabellab
Marketing Analytics Intermediate

Social Listening & Sentiment Analysis: Mention Volume, Spikes, Net Sentiment, Share of Voice, Topic Coding, Alerts & Crisis Timelines

Turn what people say about a brand into numbers a team can act on. You will count mentions per day and channel, build a rolling baseline and flag spikes, code comments as positive, neutral or negative, calculate net sentiment and a reach-weighted sentiment score, measure share of voice and share of positive voice against competitors, code comments by topic and pre-code them with keyword rules, then set alert thresholds from the mean and standard deviation, tune them with precision and recall, reconstruct an hour-by-hour crisis timeline, measure response times, find the authors who drive the conversation, audit an automatic sentiment tool, put a margin of error on every share, compare weeks with a trend forecast, explain a sentiment drop by topic, staff a spike with a what-if grid and finish with a monthly listening scorecard. 20 hands-on labs, fictional tea brand, 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

This course teaches the working arithmetic of social listening with nothing but a spreadsheet. In 20 interactive labs you analyse the public conversation about Quillhaven Tea Co., a fictional tea brand: you count mentions per day and channel, build a rolling baseline and flag spikes, count hand-coded sentiment labels, calculate net sentiment and a reach-weighted score, and compare the brand with four competitors on share of voice and share of positive voice. You code comments by topic, write keyword rules with SEARCH, set alert thresholds from the mean and standard deviation and test them with precision and recall. Later labs rebuild a crisis hour by hour, measure response times, audit an automatic sentiment tool, add a margin of error to every share, compare weeks with a trend forecast, explain a sentiment drop by topic and plan staffing with a what-if grid. The final project is a monthly scorecard with a chart. A grader checks every formula at once. Listening tools and platforms change, so the course teaches the durable logic; all companies, posts and numbers are fictional.

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

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