Product Recommendation Dataset
This dataset provides a detailed, transaction-level view of customer shopping behavior, including customer profiles, product details, session context, and the impact of personalized product recommendations. It is ideal for developing and evaluating recommendation systems, analyzing sales conversion, and understanding the effectiveness of targeted offers in retail environments.
Sample rows
preview · 8 of 120 rows · all 32 columns| customer_idstring | customer_loyalty_tierstring | discount_amountfloat | is_discount_appliedboolean | shipping_countrystring | customer_emailstring | customer_first_namestring | customer_last_namestring | customer_genderstring | customer_birthdatedate | customer_registration_datedate | product_idstring | product_namestring | product_categorystring | product_brandstring | product_pricefloat | transaction_idstring | transaction_datetimedatetime | quantityinteger | total_amountfloat | payment_methodstring | recommendation_shownboolean | recommended_product_idstring | recommendation_acceptedboolean | session_idstring | device_typestring | session_start_datetimedatetime | session_end_datetimedatetime | shipping_street_addressstring | shipping_citystring | shipping_statestring | shipping_postal_codestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CUST0001 | gold | 20 | true | USA | alex.jones_01@ | Alex | Jones | male | 1986-03-14 | 2019-07-21 | PROD1001 | Smart Fitness Watch | Electronics | FitPro | 199.99 | TXN00000001 | 2023-04-14T10:08:23 | 1 | 179.99 | credit_card | true | PROD1002 | false | SID202304141008 | desktop | 2023-04-14T10:02:51 | 2023-04-14T10:17:06 | 123 Park Ave | New York | NY | 10016 |
| CUST0002 | silver | 0 | false | USA | carla.mendez+shop@ | Carla | Mendez | female | 1990-06-25 | 2021-02-03 | PROD1013 | Resistance Bands Set | Fitness | ActivePlus | 35 | TXN00000002 | 2023-02-16T19:45:00 | 2 | 70 | debit_card | false | blank | blank | SID202302161944 | mobile | 2023-02-16T19:40:12 | 2023-02-16T19:54:38 | 742 Parkside Drive | San Diego | CA | 92103 |
| CUST0003 | platinum | 34.5 | true | Netherlands | stefan.van.der.berg@ | Stefan | van der Berg | male | 1974-02-18 | 2017-11-10 | PROD1022 | Espresso Coffee Maker | Home Appliances | BrewMaster | 179.5 | TXN00000003 | 2023-01-28T13:32:14 | 1 | 145 | bank_transfer | false | blank | blank | SID202301281331 | desktop | 2023-01-28T13:24:00 | 2023-01-28T13:38:45 | Grote Markt 88 | Amsterdam | blank | 1012EZ |
| CUST0004 | none | 0 | false | India | priya.singh1997@ | Priya | Singh | female | 1997-11-10 | 2022-06-28 | PROD1017 | Wireless Earbuds | Electronics | SoundFlex | 89.99 | TXN00000004 | 2023-05-09T21:06:19 | 1 | 89.99 | paypal | true | PROD1020 | false | SID202305092105 | mobile | 2023-05-09T20:58:01 | 2023-05-09T21:14:34 | B-19 DLF Phase 1 | Gurgaon | Haryana | 122002 |
| CUST0005 | gold | 25 | true | UK | hannah_smith@ | Hannah | Smith | female | 1983-04-22 | 2018-05-14 | PROD1007 | Premium Yoga Mat | Fitness | ActivePlus | 55 | TXN00000005 | 2023-03-19T07:21:46 | 2 | 85 | credit_card | false | blank | blank | SID202303190720 | tablet | 2023-03-19T07:19:10 | 2023-03-19T07:35:59 | 24 Oxford St | London | blank | W1D1LT |
| CUST0006 | silver | 5 | true | Mexico | gustav.herrera@ | Gustav | Herrera | male | 1996-09-11 | 2020-11-02 | PROD1012 | Gaming Mouse X9 | Gaming | GameTech | 49.99 | TXN00000006 | 2023-04-01T17:44:10 | 1 | 44.99 | debit_card | true | PROD1018 | false | SID202304011743 | desktop | 2023-04-01T17:40:00 | 2023-04-01T17:55:13 | Av. Insurgentes 123 | Mexico City | CDMX | 01020 |
| CUST0007 | none | 0 | false | blank | lucy.brown+shopper@ | Lucy | Brown | female | blank | 2022-12-09 | PROD1025 | Gift Card - $50 | Gift Cards | blank | 50 | TXN00000007 | 2023-05-01T16:12:14 | 1 | 50 | other | false | blank | blank | SID202305011611 | desktop | 2023-05-01T16:09:00 | 2023-05-01T16:14:20 | blank | blank | blank | blank |
| CUST0008 | platinum | 100 | true | Saudi Arabia | ahmad.al.saud@ | Ahmad | Al Saud | male | 1970-10-04 | 2015-10-22 | PROD1006 | 4K LED TV 55 inch | Electronics | LuxVision | 849.99 | TXN00000008 | 2023-04-27T15:30:11 | 1 | 749.99 | bank_transfer | false | blank | blank | SID202304271529 | desktop | 2023-04-27T15:18:09 | 2023-04-27T15:33:40 | King Fahd Rd 77 | Riyadh | blank | 11564 |
| CUST0009 | silver | 0 | false | Singapore | emily_chen@ | Emily | Chen | female | 1998-02-19 | 2022-09-06 | PROD1011 | Bluetooth Headphones | Electronics | SoundFlex | 65 | TXN00000009 | 2023-03-05T21:22:14 | 1 | 65 | paypal | true | PROD1015 | false | SID202303052121 | mobile | 2023-03-05T21:15:10 | 2023-03-05T21:26:40 | 98 Orchard Rd | Singapore | blank | 238839 |
| CUST0010 | gold | 12 | true | China | li.wei_88@ | Li | Wei | male | 1989-07-29 | 2020-03-03 | PROD1029 | Automatic Rice Cooker | Home Appliances | CookEasy | 120 | TXN00000010 | 2023-03-14T12:10:01 | 1 | 108 | credit_card | false | blank | blank | SID202303141209 | desktop | 2023-03-14T12:02:18 | 2023-03-14T12:19:17 | 77 Nanjing Rd | Shanghai | blank | 200001 |
| CUST0011 | gold | 24 | true | Colombia | jose.garcia@ | Jose | Garcia | male | 1979-05-10 | 2016-08-29 | PROD1014 | Men's Sports Watch | Accessories | Timeless | 120 | TXN00000011 | 2023-03-31T08:24:23 | 1 | 96 | credit_card | true | PROD1013 | false | SID202303310823 | desktop | 2023-03-31T08:13:00 | 2023-03-31T08:28:19 | Av. Caracas 102 | Bogotá | Distrito Capital | 110111 |
| CUST0012 | platinum | 12 | true | France | mary.lambert@ | Mary | Lambert | female | 1968-12-02 | 2010-02-17 | PROD1019 | French Press Coffee Maker | Home & Kitchen | BrewMaster | 39.99 | TXN00000012 | 2023-04-06T09:18:12 | 2 | 67.98 | credit_card | false | blank | blank | SID202304060917 | desktop | 2023-04-06T09:03:10 | 2023-04-06T09:20:44 | 8 Rue de Rivoli | Paris | blank | 75004 |
| CUST0013 | none | 0 | false | Colombia | andrea.vasquez23@ | Andrea | Vasquez | female | 1999-01-15 | 2021-10-08 | PROD1027 | Canvas Tote Bag | Bags & Luggage | UrbanStyle | 23 | TXN00000013 | 2023-02-01T14:42:14 | 1 | 23 | paypal | false | blank | blank | SID202302011441 | mobile | 2023-02-01T14:39:00 | 2023-02-01T14:49:30 | Calle 45 #10-11 | Medellín | Antioquia | 050021 |
| CUST0014 | gold | 8 | true | Iran | mohammad.faraji@ | Mohammad | Faraji | male | 1980-07-03 | 2015-06-19 | PROD1031 | Stainless Steel Tool Set | Tools | ToolMaster | 75 | TXN00000014 | 2023-03-17T11:07:44 | 1 | 67 | bank_transfer | false | blank | blank | SID202303171106 | desktop | 2023-03-17T11:03:00 | 2023-03-17T11:15:30 | 45 Azadi St | Tehran | blank | 11369 |
| CUST0015 | silver | 0 | false | France | marie.aubert@ | Marie | Aubert | female | 1995-12-10 | 2021-03-25 | PROD1003 | Silicone Phone Case | Accessories | UrbanStyle | 18 | TXN00000015 | 2023-01-22T16:31:59 | 2 | 36 | credit_card | true | PROD1027 | false | SID202301221630 | mobile | 2023-01-22T16:26:09 | 2023-01-22T16:39:21 | 12 Rue Victor Hugo | Lyon | blank | 69002 |
| CUST0016 | platinum | 9 | true | Germany | bruno.schmidt@ | Bruno | Schmidt | male | 1971-11-23 | 2013-09-11 | PROD1026 | Digital Blood Pressure Monitor | Healthcare | Meditech | 89.99 | TXN00000016 | 2023-02-22T09:04:01 | 1 | 80.99 | credit_card | false | blank | blank | SID202302220903 | desktop | 2023-02-22T08:57:00 | 2023-02-22T09:11:50 | Musterstraße 5 | Berlin | blank | 10115 |
| CUST0017 | none | 0 | false | Argentina | maria.gomez_2022@ | Maria | Gomez | female | 2000-05-05 | 2022-04-21 | PROD1028 | Travel Duffel Bag | Bags & Luggage | UrbanStyle | 45 | TXN00000017 | 2023-03-04T12:46:37 | 1 | 45 | paypal | false | blank | blank | SID202303041245 | mobile | 2023-03-04T12:41:00 | 2023-03-04T12:53:11 | Calle 60 #22-33 | Buenos Aires | CABA | C1414 |
| CUST0018 | gold | 0 | false | Canada | john.wilson@ | John | Wilson | male | 1987-02-12 | 2019-08-12 | PROD1002 | Smartphone 256GB | Electronics | LuxVision | 699.99 | TXN00000018 | 2023-03-28T15:43:22 | 1 | 699.99 | credit_card | true | PROD1001 | false | SID202303281543 | desktop | 2023-03-28T15:39:12 | 2023-03-28T15:56:01 | 1000 Queen St W | Toronto | ON | M6J1H6 |
| CUST0019 | silver | 6 | true | France | sophie.martin@ | Sophie | Martin | female | 1993-10-15 | 2021-01-19 | PROD1030 | Bamboo Kitchen Utensil Set | Home & Kitchen | BrewMaster | 29.95 | TXN00000019 | 2023-04-10T10:56:11 | 2 | 53.9 | paypal | false | blank | blank | SID202304101055 | tablet | 2023-04-10T10:49:00 | 2023-04-10T11:03:41 | 22 Rue de la Paix | Paris | blank | 75002 |
| CUST0020 | gold | 0 | false | UK | samuel_lee_uk@ | Samuel | Lee | male | 1978-04-17 | 2016-03-13 | PROD1015 | Wireless Keyboard | Office Supplies | OfficePro | 29.99 | TXN00000020 | 2023-04-15T11:22:12 | 1 | 29.99 | debit_card | false | blank | blank | SID202304151121 | desktop | 2023-04-15T11:18:00 | 2023-04-15T11:25:51 | 77 Queen Victoria St | London | blank | EC4N4TY |
What the 120 rows show
from the 120-row samplePlatinum (customer loyalty tier) stands out: mean discount_
- 44%is_
discount_ applied = true - 0.0median discount_
amount - 3customer genders
- 3device types
- 5payment methods
- 13product categories
Median 0.0, from 0.0 to 120.0.
- string 20
- integer 1
- float 3
- date 2
- datetime 3
- boolean 3
Columns
32 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 20 columns | |||
customer_id | string | Unique identifier for each customerunique | CUST0001 |
customer_email | string | Email address of the customerunique | alex.jones_01@ |
customer_first_name | string | First name of the customer | Alex |
customer_last_name | string | Last name of the customer | Jones |
customer_gender | string | Gender of the customermale · female · other · prefer_not_to_say · optional | male |
customer_loyalty_tier | string | Loyalty program tier for the customernone · silver · gold · platinum · optional | gold |
product_id | string | Unique identifier for each product | PROD1001 |
product_name | string | Name of the product | Smart Fitness Watch |
product_category | string | Category to which the product belongs | Electronics |
product_brand | string | Brand of the productoptional | FitPro |
transaction_id | string | Unique identifier for each transactionunique | TXN00000001 |
payment_method | string | Payment method used for the transaction6 values | credit_card |
recommended_product_id | string | Product ID of the recommended product (if any) shown to the customeroptional | PROD1002 |
session_id | string | Unique identifier for the customer's shopping session | SID202304141008 |
device_type | string | Type of device used during the shopping sessiondesktop · mobile · tablet · other · optional | desktop |
shipping_street_address | string | Street address for shippingoptional | 123 Park Ave |
shipping_city | string | City for shipping addressoptional | New York |
shipping_state | string | State or region for shipping addressoptional | NY |
shipping_postal_code | string | Postal code for shipping addressoptional | 10016 |
shipping_country | string | Country for shipping addressoptional | USA |
| Numbers 4 columns | |||
product_price | float | Unit price of the product at the time of transaction0 or more | 199.99 |
quantity | integer | Number of units of the product purchased in the transaction1 or more | 1 |
total_amount | float | Total amount paid for the transaction (quantity x product_price)0 or more | 179.99 |
discount_amount | float | Amount of discount applied to the transaction0 or more · optional | 20 |
| Dates and times 5 columns | |||
customer_birthdate | date | Birthdate of the customeroptional | 1986-03-14 |
customer_registration_date | date | Date the customer registered on the platform | 2019-07-21 |
transaction_datetime | datetime | Date and time when the transaction occurred | 2023-04-14T10:08:23 |
session_start_datetime | datetime | Start date and time of the shopping sessionoptional | 2023-04-14T10:02:51 |
session_end_datetime | datetime | End date and time of the shopping sessionoptional | 2023-04-14T10:17:06 |
| True or false 3 columns | |||
is_discount_applied | boolean | Indicates if a discount was applied to the transaction | true |
recommendation_shown | boolean | Indicates if a product recommendation was shown to the customer during the shopping session | true |
recommendation_accepted | boolean | Indicates if the customer accepted the recommendation and purchased the recommended productoptional | false |
Use it for
An e-commerce dashboard
The is_
discount_ applied rate, discount_ amount by customer_ loyalty_ tier and a breakdown of shipping_ country. Excel, Power BI or Tableau. Why do the 14 platinum rows have a mean discount_
amount of 25.8? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Customers120CUST000120goldCUST00020silverCUST000334.5platinum
A software demo
Believable customers with customer_
email, customer_ first_ name and customer_ last_ name to fill a screen in front of a buyer.
blueprint · product-recommendation-dataset
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 32 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.
- Each user must have at least 3 purchase records
- Products must have a minimum of 2 reviews
- Transactions over $100 flagged for loyalty points
- Out-of-stock products are not recommended
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-recommendation-dataset