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.
At a glance
- 3tables
- 9,988rows
- 19columns
- Jan 2020 – Dec 2023date range
The 3 tables
preview and data dictionary per tableProducts products · dimension table · 500 rows
Catalog of products available for review.
Preview
| product_idinteger | product_namestring | categorystring | brandstring | pricedecimal |
|---|---|---|---|---|
| 426 | The Secret Garden: A Classic Novel | Books | HarperCollins | 10.27 |
| 427 | The Great Gatsby: Centennial Edition | Books | Simon & Schuster | 46.02 |
| 428 | Pride and Prejudice: A Beloved Romance | Books | Random House | 12.13 |
| 429 | 1984: A Dystopian Masterpiece | Books | Penguin | 30.03 |
| 430 | To Kill a Mockingbird: A Timeless Story | Books | HarperCollins | 24.59 |
| 431 | The Hobbit: An Adventure Begins | Books | Penguin | 10 |
| 432 | The Catcher in the Rye: A Coming-of-Age Tale | Books | Penguin | 16.68 |
| 433 | Moby Dick: A Journey of Obsession | Books | Simon & Schuster | 22.22 |
| 434 | War and Peace: An Epic Historical Novel | Books | Random House | 42.47 |
| 435 | Jane Eyre: A Gothic Romance | Books | HarperCollins | 11.79 |
Data dictionary
| column | type | description | example | null % |
|---|---|---|---|---|
product_ | integer | Unique identifier for each product in the catalog.unique | 426 | 0% |
product_ | string | Descriptive retail name of the product item. | The Secret Garden: A Classic Novel | 0% |
category | string | Primary retail merchandise department category. | Books | 0% |
brand | string | Manufacturing or publishing brand name associated with the product. | HarperCollins | 0% |
price | decimal | Standard retail unit selling price in USD. | 10.27 | 0% |
Customers customers · table · 2,500 rows
Information about the customers who submitted reviews.
Preview
| customer_idinteger | first_namestring | last_namestring | emailstring | citystring | statestring | signup_datedate |
|---|---|---|---|---|---|---|
| 1851 | Javier | Patel | [email protected] | San Francisco | CA | 2021-09-04 |
| 1852 | Isabella | Patel | [email protected] | San Diego | CA | 2021-08-19 |
| 1853 | Ethan | Patel | [email protected] | Miami | FL | 2023-07-31 |
| 1854 | Sophia | Patel | [email protected] | New York | NY | 2020-03-03 |
| 1855 | Liam | Patel | [email protected] | Los Angeles | CA | 2020-08-19 |
| 1856 | Olivia | Patel | [email protected] | Miami | FL | 2020-10-25 |
| 1857 | Noah | Patel | [email protected] | San Francisco | CA | 2021-11-15 |
| 1858 | Ava | Patel | [email protected] | New York | NY | 2020-06-15 |
| 1859 | Elijah | Patel | [email protected] | Miami | FL | 2023-07-22 |
| 1860 | Mia | Patel | [email protected] | San Francisco | CA | 2023-09-29 |
Data dictionary
| column | type | description | example | null % |
|---|---|---|---|---|
customer_ | integer | Primary key uniquely identifying each customer record.unique | 1851 | 0% |
first_ | string | Customer given name. | Javier | 0% |
last_ | string | Customer family name. | Patel | 0% |
email | string | Unique email address for account authentication and notifications.unique | [email protected] | 0% |
city | string | City of residence of the customer. | San Francisco | 0% |
state | string | Two-letter US state code of customer residence. | CA | 0% |
signup_ | date | Calendar date when the customer registered their marketplace account. | 2021-09-04 | 0% |
Reviews reviews · fact table · 6,988 rows
Customer feedback and ratings for products.
Preview
| review_idinteger | ratinginteger | review_titlestring | review_textstring | review_datedate | customer_idinteger | product_idinteger |
|---|---|---|---|---|---|---|
| 1 | 5 | Absolutely Fantastic Samsung Phone! | So pleased with how this turned out. A real winner. | 2023-09-25 | 1403 | 69 |
| 2 | 5 | Beautiful Zara Dress, Perfect Fit! | A fantastic product that lives up to its reputation. | 2020-09-11 | 1231 | 240 |
| 3 | 5 | Apple Pencil 2nd Gen - A Must-Have for Creatives! | A solid performer. I'm very impressed with its durability. | 2022-12-05 | 1233 | 95 |
| 4 | 5 | Incredible Performance from MacBook Pro M3 Pro! | This is fantastic! Works like a charm and is very durable. | 2022-10-26 | 149 | 51 |
| 5 | 5 | Sturdy and Stylish IKEA Pot Rack! | Wonderful item. It's made my life so much easier. | 2023-12-28 | 1129 | 283 |
| 6 | 5 | Fisher-Price Piano Gym: Hours of Fun for Baby! | Five stars all the way. A truly excellent product. | 2021-12-31 | 334 | 459 |
| 7 | 5 | Wuthering Heights: A Classic Masterpiece! | Brilliant! It functions flawlessly and looks great. | 2023-12-23 | 2285 | 436 |
| 8 | 5 | Elegant Zara Midi Skirt, Highly Recommend! | This is fantastic! Works like a charm and is very durable. | 2023-09-24 | 1060 | 233 |
| 9 | 5 | Hot Wheels 5-Car Pack: Great Value for Little Ones! | This is a standout product. Definitely worth the investment. | 2023-08-08 | 3 | 465 |
| 10 | 5 | Iconic Adidas Superstar Sneakers - So Comfortable! | This exceeded my wildest dreams. Truly remarkable. | 2023-08-31 | 2470 | 222 |
Data dictionary
| column | type | description | example | null % |
|---|---|---|---|---|
review_ | integer | Primary key identifier for the product review record. | 1 | 0% |
rating | integer | Product rating on a scale of 1 to 5 stars, skewed towards positive sentiment. | 5 | 0% |
review_ | string | Short summary or headline of the product review. | Absolutely Fantastic Samsung Phone! | 0% |
review_ | string | Full-text customer feedback and detailed thoughts on product quality and experience. | So pleased with how this turned out. A real winner. | 0% |
review_ | date | Calendar date when the customer submitted the review. | 2023-09-25 | 0% |
customer_ | integer | Foreign key to customers.customer_id. | 1403 | 0% |
product_ | integer | Foreign key to products.product_id. | 69 | 0% |
How the tables join
reviews.customer_id references customers.customer_idmany to one: each Reviews row points to one Customers rowreviews.product_id references products.product_idmany to one: each Reviews row points to one Products row
Questions to answer with it
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
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
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
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 publishingTable names match the SQLite file and the SQL script.
Average Rating per Product Category
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
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
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
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
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
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.
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 rowsCustomers 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 rowsRating 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
- 04Average price by categoryBeginner
- 05Power BI: average rating by categoryPower BI
- 06Top reviewed brandsIntermediate
- 07Products with no reviewsIntermediate
- 08Sentiment buckets by stateIntermediate
- 09Reviews per year and categoryIntermediate
- 10Power BI: share of 5-star reviewsPower BI
- 11Top product per categoryAdvanced
- 12Monthly reviews and running totalAdvanced
- 13Month-over-month change in avg ratingAdvanced
- 14Reviews share by signup cohortAdvanced
- 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.99blueprint · 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
- Tables
- products, customers, reviews
- Licence
- yours to use, including commercially
- API slug
- customer-product-review-dataset