Sentiment Coding: Counting Positive, Neutral and Negative Comments, Shares and Negative Share per Channel
Lessons in this course
- 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