• E-commerce
  • 3 tables
  • 9,988 rows
  • 7 formats
  • synthetic data

Product Review Dataset

This ready-made product review dataset provides 9,988 entries for analysis. It includes product details, customer information, and review data, spanning from 2020-01-01 to 2023-12-31. A free sample is available, with the full download costing credits.

  • last updated 20 Oct 2026
  • version 2
  • by GoMask
  • Dataset contains 9,988 rows and 19 columns.
  • Includes 3 tables: products, customers, and reviews.
  • Covers a date range from 2020-01-01 to 2023-12-31.
  • Ratings are on a scale of 1 to 5 stars.
  • Available in CSV, Excel, and SQL formats.

At a glance

  • 3tables
  • 9,988rows
  • 19columns
  • Jan 2020 – Dec 2023date range

The 3 tables

preview and data dictionary per table

Products products · dimension table · 500 rows

Catalog of products available for review.

Preview

First 10 of 500 rows of the Products table
product_idintegerproduct_namestringcategorystringbrandstringpricedecimal
426The Secret Garden: A Classic NovelBooksHarperCollins10.27
427The Great Gatsby: Centennial EditionBooksSimon & Schuster46.02
428Pride and Prejudice: A Beloved RomanceBooksRandom House12.13
4291984: A Dystopian MasterpieceBooksPenguin30.03
430To Kill a Mockingbird: A Timeless StoryBooksHarperCollins24.59
431The Hobbit: An Adventure BeginsBooksPenguin10
432The Catcher in the Rye: A Coming-of-Age TaleBooksPenguin16.68
433Moby Dick: A Journey of ObsessionBooksSimon & Schuster22.22
434War and Peace: An Epic Historical NovelBooksRandom House42.47
435Jane Eyre: A Gothic RomanceBooksHarperCollins11.79
10 of 500 rows · 5 columns

Data dictionary

Data dictionary for the Products table
columntypedescriptionexamplenull %
product_idintegerUnique identifier for each product in the catalog.unique4260%
product_namestringDescriptive retail name of the product item.The Secret Garden: A Classic Novel0%
categorystringPrimary retail merchandise department category.Books0%
brandstringManufacturing or publishing brand name associated with the product.HarperCollins0%
pricedecimalStandard retail unit selling price in USD.10.270%

Customers customers · table · 2,500 rows

Information about the customers who submitted reviews.

Preview

First 10 of 2,500 rows of the Customers table
customer_idintegerfirst_namestringlast_namestringemailstringcitystringstatestringsignup_datedate
1851JavierPatel[email protected]San FranciscoCA2021-09-04
1852IsabellaPatel[email protected]San DiegoCA2021-08-19
1853EthanPatel[email protected]MiamiFL2023-07-31
1854SophiaPatel[email protected]New YorkNY2020-03-03
1855LiamPatel[email protected]Los AngelesCA2020-08-19
1856OliviaPatel[email protected]MiamiFL2020-10-25
1857NoahPatel[email protected]San FranciscoCA2021-11-15
1858AvaPatel[email protected]New YorkNY2020-06-15
1859ElijahPatel[email protected]MiamiFL2023-07-22
1860MiaPatel[email protected]San FranciscoCA2023-09-29
10 of 2,500 rows · 7 columns

Data dictionary

Data dictionary for the Customers table
columntypedescriptionexamplenull %
customer_idintegerPrimary key uniquely identifying each customer record.unique18510%
first_namestringCustomer given name.Javier0%
last_namestringCustomer family name.Patel0%
emailstringUnique email address for account authentication and notifications.unique[email protected]0%
citystringCity of residence of the customer.San Francisco0%
statestringTwo-letter US state code of customer residence.CA0%
signup_datedateCalendar date when the customer registered their marketplace account.2021-09-040%

Reviews reviews · fact table · 6,988 rows

Customer feedback and ratings for products.

Preview

First 10 of 6,988 rows of the Reviews table
review_idintegerratingintegerreview_titlestringreview_textstringreview_datedatecustomer_idintegerproduct_idinteger
15Absolutely Fantastic Samsung Phone!So pleased with how this turned out. A real winner.2023-09-25140369
25Beautiful Zara Dress, Perfect Fit!A fantastic product that lives up to its reputation.2020-09-111231240
35Apple Pencil 2nd Gen - A Must-Have for Creatives!A solid performer. I'm very impressed with its durability.2022-12-05123395
45Incredible Performance from MacBook Pro M3 Pro!This is fantastic! Works like a charm and is very durable.2022-10-2614951
55Sturdy and Stylish IKEA Pot Rack!Wonderful item. It's made my life so much easier.2023-12-281129283
65Fisher-Price Piano Gym: Hours of Fun for Baby!Five stars all the way. A truly excellent product.2021-12-31334459
75Wuthering Heights: A Classic Masterpiece!Brilliant! It functions flawlessly and looks great.2023-12-232285436
85Elegant Zara Midi Skirt, Highly Recommend!This is fantastic! Works like a charm and is very durable.2023-09-241060233
95Hot Wheels 5-Car Pack: Great Value for Little Ones!This is a standout product. Definitely worth the investment.2023-08-083465
105Iconic Adidas Superstar Sneakers - So Comfortable!This exceeded my wildest dreams. Truly remarkable.2023-08-312470222
10 of 6,988 rows · 7 columns

Data dictionary

Data dictionary for the Reviews table
columntypedescriptionexamplenull %
review_idintegerPrimary key identifier for the product review record.10%
ratingintegerProduct rating on a scale of 1 to 5 stars, skewed towards positive sentiment.50%
review_titlestringShort summary or headline of the product review.Absolutely Fantastic Samsung Phone!0%
review_textstringFull-text customer feedback and detailed thoughts on product quality and experience.So pleased with how this turned out. A real winner.0%
review_datedateCalendar date when the customer submitted the review.2023-09-250%
customer_idintegerForeign key to customers.customer_id.14030%
product_idintegerForeign key to products.product_id.690%

How the tables join

  • reviews.customer_id references customers.customer_idmany to one: each Reviews row points to one Customers row
  • reviews.product_id references products.product_idmany to one: each Reviews row points to one Products row

Questions to answer with it

  1. Calculate the average rating for each product category and identify the top 3 categories with the highest average ratings.

    Join products and reviews tables, group by category, and calculate the average rating.

    tables: products, reviews

  2. Analyze the distribution of ratings (count of 1-star, 2-star, etc.) for products from the 'Electronics' brand.

    Filter products for the 'Electronics' brand, join with reviews, and count ratings per star level.

    tables: products, reviews

  3. Find customers who have reviewed more than 5 products and list their names and the number of reviews they've submitted.

    Join customers and reviews, group by customer, and filter for counts greater than 5.

    tables: customers, reviews

  4. Determine the correlation between product price and the average rating received for products in the 'Apparel' category.

    Filter products for the 'Apparel' category, join with reviews, group by product, and calculate average rating, then analyze correlation with price.

    tables: products, reviews

Starter SQL

run against this data before publishing

Table names match the SQLite file and the SQL script.

Average Rating per Product Category

sql
SELECT p.category, AVG(r.rating) AS average_rating FROM products p JOIN reviews r ON p.product_id = r.product_id GROUP BY p.category ORDER BY average_rating DESC LIMIT 20;

Rating Distribution for Electronics Brand

sql
SELECT r.rating, COUNT(r.review_id) AS rating_count FROM products p JOIN reviews r ON p.product_id = r.product_id WHERE p.brand = 'Sony' GROUP BY r.rating ORDER BY r.rating DESC LIMIT 20;

Customers with More Than 5 Reviews

sql
SELECT c.customer_id, c.first_name, c.last_name, COUNT(r.review_id) AS review_count FROM customers c JOIN reviews r ON c.customer_id = r.customer_id GROUP BY c.customer_id, c.first_name, c.last_name HAVING review_count > 5 ORDER BY review_count DESC LIMIT 20;

Top 5 Most Reviewed Products

sql
SELECT p.product_name, COUNT(r.review_id) AS num_reviews FROM products p JOIN reviews r ON p.product_id = r.product_id GROUP BY p.product_name ORDER BY num_reviews DESC LIMIT 5;

Average Price and Rating for Apparel Category

sql
SELECT p.product_name, p.price, AVG(r.rating) AS average_rating FROM products p JOIN reviews r ON p.product_id = r.product_id WHERE p.category = 'Apparel' GROUP BY p.product_id, p.product_name, p.price ORDER BY p.price LIMIT 20;

Load it with pandas

python
import pandas as pd

# Unzip the CSV download first: one file per table
products = pd.read_csv("products.csv")
customers = pd.read_csv("customers.csv")
reviews = pd.read_csv("reviews.csv")

# Join reviews to customers
df = reviews.merge(customers, left_on="customer_id", right_on="customer_id", how="left", suffixes=("", "_customers"))
print(df.groupby("state").size().sort_values(ascending=False))

Using it in your tool

Excel
Load each table into a separate sheet. Use Power Query to join tables based on common IDs (e.g., product_id, customer_id). Create a PivotTable from the joined data to analyze ratings by category or brand.
Power BI
Load all three tables. Create relationships: reviews.product_id to products.product_id and reviews.customer_id to customers.customer_id. Create measures like Average Rating = AVERAGE(reviews[rating]) and Total Reviews = COUNT(reviews[review_id]).
SQL
Load the SQLite or SQL dump into your preferred database. Use JOIN clauses on customer_id and product_id to combine data from different tables. Primary keys are product_id, customer_id, and review_id.
Python
Use pandas to load CSV or SQL data. Merge tables using pd.merge(). Perform aggregations and analyses using DataFrame methods.

Formats available

  • CSV (zip)One CSV file per table, zipped
  • Excel workbookOne worksheet per table
  • SQLite databaseA ready-to-query database file with every table
  • Parquet (zip)One Parquet file per table, zipped
  • SQL scriptCREATE TABLE with primary and foreign keys, then INSERTs
  • CSVA single CSV file
  • JSONA single JSON file

How this data was generated

Synthetic data. Every row was generated: no real people, customers or companies are in this dataset.

Synthetic data generated by GoMask DataFactory from a relational blueprint: keys, links and rules are enforced in code, text columns are filled by a language model. No real people, companies or transactions.

  • Data is synthetically generated using GoMask DataFactory.
  • Customer and product data are fictional.
  • Review sentiment and ratings are procedurally generated.
  • Checked by an automated quality gate: unique keys, no orphan foreign keys, required columns filled, declared rules and date ranges (realism score 100).

Limitations

  • The data is synthetic and does not represent real-world customer behavior.
  • Review text may contain limited linguistic variation.
  • Product and customer IDs are artificial.
  • Distributions and correlations are modelled, not measured from real records.

Part of these collections

15 SQL practice questions for the Product Review Dataset

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY

    Cheapest Electronics products

    Return the product_name, brand and price of every product in the 'Electronics' category that costs less than 50. Sort the results by price ascending, then by product_id ascending.

    Tables: products · your result: 3 columns, 12 rows
  2. 02BeginnerFreeGROUP BY · COUNT · ORDER BY

    Customers per state

    Return each state and the number of customers in it as customer_count. Sort by customer_count descending, then by state ascending.

    Tables: customers · your result: 2 columns, 10 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Rating distribution

    Return each rating value (1 to 5) and the number of reviews with that rating as review_count. Sort by rating ascending.

    Tables: reviews · your result: 2 columns, 5 rows
  1. 04Average price by categoryBeginner
  2. 05Power BI: average rating by categoryPower BI
  3. 06Top reviewed brandsIntermediate
  4. 07Products with no reviewsIntermediate
  5. 08Sentiment buckets by stateIntermediate
  6. 09Reviews per year and categoryIntermediate
  7. 10Power BI: share of 5-star reviewsPower BI
  8. 11Top product per categoryAdvanced
  9. 12Monthly reviews and running totalAdvanced
  10. 13Month-over-month change in avg ratingAdvanced
  11. 14Reviews share by signup cohortAdvanced
  12. 15Power BI: products rated above category averagePower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

blueprint · customer-product-review-dataset

Scale this dataset

Same tables. As many rows as you need.

Open the blueprint behind these 3 tables in Data Factory: keep the relationships, change a column, and generate it at the size you need.

  • 200,000 rows
  • 1,000,000 rows
Scale this dataset in Data Factory
Tables
products, customers, reviews
Licence
yours to use, including commercially
API slug
customer-product-review-dataset

What should your data show?

Preview 20 rows free
No signup. No card.