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.
- 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
- Mention Volume: Daily Totals, Channel Shares, the Average Day and the Peak-to-Average RatioFree
- Spikes: a Rolling 7-Day Baseline, the Mentions-to-Baseline Ratio and a Spike Flag Locked
- Sentiment Coding: Counting Positive, Neutral and Negative Comments, Shares and Negative Share per Channel Locked
- Net Sentiment: (Positive − Negative) ÷ Total, the Variant Without Neutrals and the Positive-to-Negative Ratio Locked
- Sentiment Scores: a −2 to +2 Scale, the Simple Mean, a Reach-Weighted Mean and a 0–100 Index Locked
- Share of Voice: Brand Mentions ÷ Category Mentions, Ranks and Share of Voice per Channel Locked
- Share of Positive and Negative Voice: Who Owns the Praise, Who Owns the Complaints, and a Positive Index Locked
- Topic Coding: Counting Comments per Topic, Negative Share by Topic and the Topic That Drives Complaints Locked
- Keyword Rules: Pre-Coding Comments with SEARCH, a Flag Grid with Mixed References, Coverage and False Hits Locked
- Alert Thresholds: Baseline Mean, Standard Deviation, z-Scores and a Mean + k × SD Rule Locked
- Tuning Alerts on Past Incidents: Alerts Fired, False Alarms, Precision and Recall for Five Thresholds Locked
- Crisis Timeline: Hourly Negative Share, Cumulative Mentions, the Trigger Hour, the Peak Hour and Time to Peak Locked
- Response Time: Minutes from Post to First Reply, a Response Target, Median vs Mean and Channel Averages Locked
- Who Drives the Conversation: Engagements per Mention, Author Tiers, Ranks and the Top-3 Share Locked
- Quality Check: Tool vs Analyst Labels, Accuracy, Precision and Recall of the Negative Label, and a Confidence Cut-Off Locked
- How Exact Is a Sentiment Share? Margin of Error, Confidence Bounds, a Reporting Rule and the Sample to Code Locked
- Expected Volume: a Linear Trend with SLOPE and FORECAST.LINEAR, Deviation from Expected and an Unusual-Week Flag Locked
- Why Did Net Sentiment Move? Topic Contributions, Month-on-Month Change and the Topic That Dragged It Down Locked
- What-If Grid: Agents Needed by Spike Size and Negative Share, a Heat Map, Shift Capacity and the Backlog Locked
- Final Project: Monthly Listening Scorecard with Mentions, Net Sentiment, Share of Voice, a Review Flag and a Combo Chart Locked
Learner reviews
Be the first to review this course.