Ratings & Reviews Analytics: Star Distributions, Fair Average Ratings, Confidence-Adjusted Rankings, Review Velocity & Response Rates
Read customer reviews like an analyst: star distributions, averages that are fair to products with few reviews, rankings adjusted for confidence, review velocity and how fast you respond, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you analyse the reviews of a fictional homeware brand with spreadsheet formulas. You count reviews per star and compare mean and median, give products with few reviews a fair Bayesian average, rank products by the Wilson lower bound of their positive share, measure review velocity, freshness and the monthly trend, tag review texts by keywords to find what critical reviews talk about, calculate response times, response rates and the median wait, relate ratings to conversion by rating band, and finish with a reputation dashboard with traffic-light status and a chart. Everything is about reading genuine reviews honestly.
Lessons
- Star Distributions: Counts per Star, Shares, Mean vs Median Pro
- Fair Averages: Bayesian Ratings for Products with Few Reviews Pro
- Confidence-Adjusted Rankings: the Wilson Lower Bound for Positive Shares Pro
- Review Velocity: Reviews per Week, Trend and Days Since the Last Review Pro
- Themes from Review Text: Keyword Flags, Stars per Theme and Complaint Shares Pro
- Response Management: Response Times, Response Rates and the Median Pro
- Rating vs Sales: Conversion by Rating Band and What a Star Might Be Worth Pro
- Capstone: Reputation Dashboard with Fair Ratings, Response Rates and Traffic Lights Pro