Product Reviews
This dataset provides detailed customer product reviews, including star ratings, review text, helpfulness votes, verified purchase status, and tracked responses from sellers or support teams. It enables comprehensive sentiment analysis, product feedback evaluation, and customer engagement tracking for e-commerce platforms.
Sample rows
preview · 8 of 200 rows · all 13 columns| review_idstring | response_authorstring | star_ratinginteger | verified_purchaseboolean | product_idstring | customer_idstring | review_datedate | review_titlestring | helpful_votesinteger | response_idstring | response_datedate | review_textstring | response_textstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R0001 | SupportTeam | 5 | true | P-EL1001 | C-US0001 | 2020-01-01 | Absolutely fantastic! | 102 | RES0001 | 2020-01-03 | Exceeded my expectations in every way. Will buy again. | Thank you for your feedback! We're thrilled you loved it. |
| R0002 | blank | 4 | true | P-EL1002 | C-UK0002 | 2019-12-31 | Works as expected | 38 | blank | blank | Solid product, no issues so far. Happy with purchase. | blank |
| R0003 | QA_Manager | 2 | true | P-EL1001 | C-DE0003 | 2021-02-28 | Not worth the price | 54 | RES0002 | 2021-03-02 | Disappointed with the quality, not what I expected. | Sorry for your experience. Please contact support for help. |
| R0004 | ProductExpert | 5 | true | P-EL1003 | C-IN0004 | 2022-12-31 | Best purchase of the year | 210 | RES0003 | 2023-01-02 | Amazing performance and sleek design. Highly recommended! | Thanks for your review! Glad to hear you're enjoying it. |
| R0005 | blank | 3 | false | P-EL1004 | C-US0005 | 2023-07-04 | Average experience | 5 | blank | blank | Product is fine but shipping was delayed. | blank |
| R0006 | blank | 4 | true | P-EL1002 | C-FR0006 | 2018-11-23 | Good value | 16 | blank | blank | Decent quality for the price, would recommend. | blank |
| R0007 | CustomerCare | 1 | true | P-EL1001 | C-JP0007 | 2024-02-29 | Does not work | 1347 | RES0004 | 2024-03-02 | Stopped working after a week. Very disappointed. | We're sorry for the inconvenience. Please reach out to our team. |
| R0008 | blank | 5 | true | P-EL1005 | C-AU0008 | 2022-01-01 | Perfect for my needs | 14 | blank | blank | Really happy with this product, fits my requirements. | blank |
| R0009 | blank | 4 | true | P-EL1003 | C-BR0009 | 2021-12-25 | Nice gift! | 20 | blank | blank | Gave it as a present and they loved it. | blank |
| R0010 | blank | 3 | false | P-EL1001 | C-DE0010 | 2020-03-15 | Could be better | 2 | blank | blank | Not bad, but expected more features. | blank |
| R0011 | blank | 5 | true | P-EL1004 | C-IN0011 | 2023-05-10 | Fantastic performance | 35 | blank | blank | Runs smoothly and looks great. Highly satisfied. | blank |
| R0012 | blank | 4 | true | P-EL1002 | C-US0012 | 2022-07-04 | Pretty good | 7 | blank | blank | Met my expectations. Happy with the purchase. | blank |
| R0013 | blank | 2 | false | P-EL1005 | C-UK0013 | 2019-01-01 | Lacking features | 11 | blank | blank | Basic product, missing some important features. | blank |
| R0014 | blank | 5 | true | P-EL1001 | C-DE0014 | 2021-11-11 | Excellent! | 59 | blank | blank | Top-notch quality and fast shipment. | blank |
| R0015 | SupportTeam | 1 | true | P-EL1003 | C-IN0015 | 2024-01-01 | Very poor | 10000 | RES0005 | 2024-01-02 | Stopped working after a month. Waste of money. | We apologize for the issue. Please contact us for a replacement. |
| R0016 | blank | 4 | true | P-EL1005 | C-JP0016 | 2020-12-31 | Nice design | 10 | blank | blank | Looks great and works well so far. | blank |
| R0017 | blank | 5 | true | P-EL1002 | C-US0017 | 2023-02-14 | Love it! | 23 | blank | blank | Amazing product, arrived just in time for Valentine's. | blank |
| R0018 | blank | 3 | false | P-EL1001 | C-FR0018 | 2021-07-14 | blank | 0 | blank | blank | It's okay, not the best but not the worst. | blank |
| R0019 | blank | 2 | true | P-EL1003 | C-DE0019 | 2018-05-01 | Disappointing | 3 | blank | blank | Expected better quality, not satisfied. | blank |
| R0020 | blank | 5 | true | P-EL1005 | C-IN0020 | 2022-10-05 | Very impressed | 31 | blank | blank | Exceeded expectations, will recommend to friends. | blank |
What the 200 rows show
from the 200-row sample- 69%verified_
purchase = true - 4median star_
rating - 19.5median helpful_
votes
Median 4, from 1 to 5.
- string 8
- integer 2
- date 2
- boolean 1
Columns
13 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 8 columns | |||
review_id | string | Unique identifier for each product reviewunique | R0001 |
product_id | string | Unique identifier for the product being reviewed | P-EL1001 |
customer_id | string | Unique identifier for the customer who wrote the review | C-US0001 |
review_title | string | Short title summarizing the reviewup to 200 · optional | Absolutely fantastic! |
review_text | string | Full text of the customer's review | Exceeded my expectations … |
response_id | string | Unique identifier for the response to the review (if any)optional | RES0001 |
response_text | string | Text of the response to the review (if any)optional | Thank you for your feedba… |
response_author | string | Name or identifier of the person or entity responding to the review6 authors · optional | SupportTeam |
| Numbers 2 columns | |||
star_rating | integer | Star rating given by the customer (typically 1-5)1 to 5 | 5 |
helpful_votes | integer | Number of helpfulness votes received by the review0 or more | 102 |
| Dates and times 2 columns | |||
review_date | date | Date when the review was submitted | 2020-01-01 |
response_date | date | Date when the response was posted (if any)optional | 2020-01-03 |
| True or false 1 column | |||
verified_purchase | boolean | Indicates if the review is from a verified purchase | true |
Use it for
An e-commerce dashboard
The verified_
purchase rate, star_ rating by response_ author and a breakdown of product_ id. Excel, Power BI or Tableau. Why do 138 of 200 rows have verified_
purchase = true? A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
- Reviews200R00015SupportT…R00024—R00053—
A software demo
Believable reviews with product_
id, customer_ id and review_ date to fill a screen in front of a buyer.
This dataset200 rows13 columns
Yours1,000 rows13 columns
blueprint · product-reviews
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 13 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Star rating between 1-5
- Review date after purchase date for verified
- Helpfulness votes: helpful, not helpful
- Moderation status: pending, approved, rejected
- Seller response optional
Open the blueprint in Data Factory
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- product-reviews