Product Recommendations Clickstream
This dataset records detailed user interactions with product recommendations on e-commerce platforms, including click events, session information, device context, and recommendation metadata. It enables businesses to analyze user behavior, optimize recommendation algorithms, and improve conversion rates by understanding which products and placements drive engagement.
Sample rows
preview · 8 of 200 rows · all 13 columns| event_idstring | device_typestring | position_in_recommendationinteger | clickedboolean | countrystring | user_idstring | session_idstring | event_timestampdatetime | product_idstring | recommendation_idstring | referrer_urlstring | user_agentstring | page_urlstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| evt_00001 | desktop | 1 | true | US | user_101 | sess_a1 | 2022-12-31T23:59:59Z | prod_ZX01 | rec_set_01 | https://www.google.com/search?q=shoes | Mozilla/5.0 (Windows NT 10.0; Win64; x64) | https://shop.example.com/product/ZX01 |
| evt_00002 | mobile | 2 | false | IN | user_102 | sess_b1 | 2023-06-30T00:00:00Z | prod_YQ77 | rec_algo_alpha | https://facebook.com | Mozilla/5.0 (Linux; Android 11; Pixel 5) | https://shop.example.com/recommendations?cat=summer |
| evt_00003 | tablet | 3 | true | DE | user_103 | sess_c1 | 2024-02-29T23:59:59Z | prod_KL22 | rec_set_02 | blank | Mozilla/5.0 (iPad; CPU OS 14_2 like Mac OS X) | https://shop.example.com/product/KL22 |
| evt_00004 | desktop | blank | false | GB | user_104 | sess_d1 | 2023-01-01T00:00:01Z | prod_MN88 | blank | blank | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) | https://shop.example.com/error |
| evt_00005 | mobile | 5 | true | JP | user_105 | sess_e2 | 2023-03-15T16:45:00Z | prod_BC35 | rec_set_03 | https://instagram.com | Mozilla/5.0 (iPhone; CPU iPhone OS 14_2 like Mac OS X) | https://shop.example.com/recommendations?cat=spring |
| evt_00006 | tablet | 10 | false | RU | user_106 | sess_f1 | 2022-11-11T11:11:11Z | prod_TT09 | rec_algo_beta | https://twitter.com | Mozilla/5.0 (Android 10; Tablet; rv:68.0) | https://shop.example.com/product/TT09 |
| evt_00007 | desktop | 1 | true | US | user_101 | sess_a2 | 2022-12-25T08:00:00Z | prod_QW51 | rec_set_04 | https://www.bing.com | Mozilla/5.0 (Windows NT 10.0; Win64; x64) | https://shop.example.com/product/QW51 |
| evt_00008 | mobile | blank | false | AR | user_107 | sess_g1 | 2023-02-14T14:14:14Z | prod_LV21 | blank | blank | Mozilla/5.0 (Linux; Android 10; SM-G970F) | https://shop.example.com/specials/valentine |
| evt_00009 | desktop | 99 | false | CA | user_108 | sess_h1 | 2023-12-31T23:59:59Z | prod_JJ78 | rec_algo_gamma | https://shop.example.com/home | Mozilla/5.0 (X11; Linux x86_64) | https://shop.example.com/product/JJ78 |
| evt_00010 | mobile | 2 | true | NG | user_109 | sess_i1 | 2023-04-01T09:05:00Z | prod_HH19 | rec_set_05 | https://whatsapp.com | Mozilla/5.0 (Linux; Android 12; Redmi Note 9) | https://shop.example.com/recommendations?cat=april |
| evt_00011 | desktop | blank | false | SE | user_110 | sess_j1 | 2023-05-05T05:05:05Z | prod_UU31 | blank | blank | Mozilla/5.0 (Macintosh; Intel Mac OS X 11_6) | https://shop.example.com/error |
| evt_00012 | mobile | 1 | true | KR | user_111 | sess_k1 | 2022-08-01T12:00:00Z | prod_WW63 | rec_algo_delta | https://pinterest.com | Mozilla/5.0 (Linux; Android 10; SM-A505F) | https://shop.example.com/product/WW63 |
| evt_00013 | tablet | 50 | false | SG | user_112 | sess_l1 | 2023-11-11T11:11:11Z | prod_EE44 | rec_set_06 | blank | Mozilla/5.0 (Android 9; Tablet; rv:60.0) | https://shop.example.com/product/EE44 |
| evt_00014 | desktop | 2 | true | GB | user_113 | sess_m1 | 2024-01-01T00:00:00Z | prod_VV27 | rec_set_07 | https://www.yahoo.com | Mozilla/5.0 (Windows NT 10.0; Win64; x64) | https://shop.example.com/product/VV27 |
| evt_00015 | mobile | 5 | true | AU | user_114 | sess_n1 | 2023-08-15T18:30:00Z | prod_RR52 | rec_algo_epsilon | https://shop.example.com/home | Mozilla/5.0 (Linux; Android 13; OnePlus 9) | https://shop.example.com/recommendations?cat=fall |
| evt_00016 | blank | blank | false | blank | user_115 | sess_o1 | 2022-05-01T15:00:00Z | prod_SS75 | blank | blank | blank | https://shop.example.com/error |
| evt_00017 | desktop | 3 | true | RU | user_116 | sess_p1 | 2023-09-09T09:09:09Z | prod_AA90 | rec_set_08 | https://reddit.com | Mozilla/5.0 (X11; Linux x86_64) | https://shop.example.com/product/AA90 |
| evt_00018 | tablet | 100 | false | NG | user_117 | sess_q1 | 2022-07-07T07:07:07Z | prod_DD58 | rec_algo_zeta | blank | Mozilla/5.0 (iPad; CPU OS 13_6 like Mac OS X) | https://shop.example.com/product/DD58 |
| evt_00019 | desktop | 1 | true | US | user_118 | sess_r1 | 2023-10-10T10:10:10Z | prod_GG40 | rec_set_09 | https://www.google.com/search?q=watches | Mozilla/5.0 (Windows NT 10.0; Win64; x64) | https://shop.example.com/product/GG40 |
| evt_00020 | mobile | blank | false | EG | user_119 | sess_s1 | 2023-12-01T12:30:00Z | prod_FF83 | blank | blank | Mozilla/5.0 (Linux; Android 10; SM-J730F) | https://shop.example.com/specials/december |
What the 200 rows show
from the 200-row sampleTablet (device type) stands out: mean position_
- 50%clicked = true
- 3median position_
in_ recommendation
Median 3, from 1 to 100.
- string 10
- integer 1
- datetime 1
- boolean 1
Columns
13 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 10 columns | |||
event_id | string | Unique identifier for each clickstream eventunique | evt_00001 |
user_id | string | Unique identifier for the user who generated the event | user_101 |
session_id | string | Identifier for the user's browsing session | sess_a1 |
product_id | string | Unique identifier for the product that was recommended or clicked | prod_ZX01 |
recommendation_id | string | Identifier for the recommendation set or algorithm that generated the product recommendationoptional | rec_set_01 |
device_type | string | Type of device used by the user (e.g., desktop, mobile, tablet)desktop · mobile · tablet · optional | desktop |
user_agent | string | Browser or app user agent string for the sessionoptional | Mozilla/5.0 (Windows NT 1… |
referrer_url | string | URL from which the user navigated to the recommendationoptional | https://facebook.com |
page_url | string | URL of the page where the recommendation was displayed | https://shop.example.com/… |
country | string | Country of the user at the time of the event (if available)optional | US |
| Numbers 1 column | |||
position_in_recommendation | integer | Position of the product in the recommended list (e.g., 1 for top recommendation)1 or more · optional | 1 |
| Dates and times 1 column | |||
event_timestamp | datetime | Date and time when the click event occurred | 2022-12-31T23:59:59Z |
| True or false 1 column | |||
clicked | boolean | Indicates whether the recommended product was clicked by the user | true |
Use it for
An e-commerce dashboard
The clicked rate, position_
in_ recommendation by device_ type and a breakdown of country. Excel, Power BI or Tableau. Why do the 33 tablet rows have a mean position_
in_ recommendation of 46.8? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Events200evt_000011desktopevt_000022mobileevt_000033tablet
A software demo
Believable events with user_
id, session_ id and event_ timestamp to fill a screen in front of a buyer.
blueprint · product-recommendations-clickstream
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.
- Track user clicks on recommendations
- Include session length and device type
- Exclude non-product page views
- Label successful conversions
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-recommendations-clickstream