Net Sentiment from Social Mentions (COUNTIFS)
This lesson is part of the course
In this lesson
You count coded social mentions by brand and sentiment with COUNTIFS, then calculate net sentiment, each brand's share of the conversation and one drill-down.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Brand Funnel: Aware → Consider → Prefer → Buy Locked
- Share of Voice vs Share of Market: Excess SOV Locked
- Brand Lift Study: Exposed vs Control and a z-Test Locked
- Net Sentiment from Social Mentions (COUNTIFS) Locked
- Awareness Tracking Over Time: Moving Averages and a Trend Chart Locked
- Price Premium and Brand Equity Indicators Locked
- Brand Attribute Perception Map (Scatter Chart) Locked
- The Brand KPI Scorecard: % of Target, Colour Scale and Sparklines Locked