Most store owners check their reviews when they remember to. Maybe once a week, maybe when a customer complains. But the products getting the most reviews right now are telling you something important about where your store is heading, and by the time you notice, the trend is already old news.
A review velocity tracker shows you which products are gaining reviews fastest week over week. It takes about 45 minutes to build with tools you already have, and it flags the products that are quietly becoming your best sellers before your sales dashboard catches up.
What You Need
- A Shopify store (or any platform with a review app that exports data)
- Google Sheets or Airtable (free tier is fine)
- Your review app’s export function (Judge.me, Loox, Yotpo all have this)
- 15 minutes per week to check the numbers
Step 1: Export Your Reviews Weekly
Open your review app and export all reviews as a CSV. You need three columns: product name, product ID, and review date. Most apps let you filter by date range, so grab the last 30 days to start.
Save the file as reviews-week-1.csv. Do the same thing next week and save it as reviews-week-2.csv.
Step 2: Set Up Your Tracker Sheet
Create a new Google Sheet with three tabs:
- Raw Data where you paste each weekly export
- Weekly Counts where you calculate review counts per product per week
- Velocity Dashboard where you see which products are accelerating
In the Weekly Counts tab, create a simple pivot table. Put product names in rows, week numbers in columns, and count the number of reviews. Most spreadsheet tools do this automatically with Insert then Pivot Table.
Step 3: Calculate Review Velocity
Add a column called Velocity that subtracts last week’s count from this week’s count. A positive number means the product is gaining reviews faster. A negative number means it’s slowing down.
Add another column called Velocity Change that compares this week’s velocity to last week’s velocity. This tells you whether a product is accelerating or decelerating. A product that went from 2 reviews per week to 5 reviews per week has a velocity change of +3. That is your early signal.
Step 4: Flag the Movers
In your Velocity Dashboard tab, pull through the top 10 products by velocity change. Add conditional formatting: green for positive velocity change, red for negative. Now you can see at a glance which products are heating up and which are cooling down.
Set up a simple filter that only shows products with velocity above 3. These are your products to watch. They are getting more social proof, which usually means more sales are coming.
Step 5: Set a Weekly Reminder
Add a calendar reminder for the same day each week to export your reviews and update the sheet. Monday morning works well because it captures the weekend’s review activity, which is often when shoppers leave feedback after receiving Friday orders.
The whole process takes about 10 minutes once you have the sheet set up. The insight is worth far more than the effort.
What to Do With the Data
When a product shows up as a velocity mover for two weeks in a row, take action:
- Feature it on your homepage if it is not already there. Products with rising review counts convert better because the social proof is fresh.
- Boost its ad spend if you are running ads. Rising reviews usually mean rising word of mouth, which lowers your cost per acquisition.
- Check inventory levels before the sales spike hits. Review velocity often leads sales velocity by one to two weeks.
- Reach out to the reviewers and ask if they would be willing to be featured in a case study or social post.
Why This Works Better Than Checking Sales
Sales data tells you what already happened. Review velocity tells you what is about to happen. When customers start leaving reviews for a product without being prompted, it means the product is generating genuine enthusiasm. That enthusiasm translates into referrals, repeat purchases, and organic social mentions over the following weeks.
By the time your sales dashboard shows the spike, you are already playing catch up on inventory and ad spend. The review velocity tracker gives you a one to two week head start.
Common Mistakes to Avoid
Do not include incentivised reviews. If you ran a review-for-discount campaign, those reviews do not reflect organic enthusiasm. Filter them out or mark them separately so they do not skew your velocity numbers.
Do not ignore products with low total reviews but high velocity. A product that went from 0 to 3 reviews this week is more interesting than a product that went from 100 to 103. Percentage growth matters more than absolute numbers for spotting emerging winners.
Do not refresh daily. Review velocity is a weekly metric. Daily counts are too noisy and will make you react to single reviews instead of patterns.
Want more like this? Join MOKU Club for free. Weekly resources, early access to new guides, and occasional templates you can actually use. Join below.
