E-Commerce Purchase Sequences Dataset
This dataset provides detailed, timestamped records of e-commerce user sessions, capturing every step of the shopper journey from browsing and searching to cart actions and purchases. Each event is linked to session, user, and product information, enabling comprehensive analysis for personalization, recommendation systems, and user behavior modeling. The dataset is ideal for developing and benchmarking algorithms that require sequential purchase and interaction data.
Sample rows
preview · 8 of 200 rows · all 24 columns| session_idstring | device_typestring | pricefloat | product_categorystring | user_idstring | session_start_timedatetime | session_end_timedatetime | browserstring | ip_addressstring | countrystring | event_timestampdatetime | event_typestring | page_urlstring | product_idstring | quantityinteger | order_idstring | order_totalfloat | payment_methodstring | shipping_street_addressstring | shipping_citystring | shipping_statestring | shipping_postal_codestring | shipping_countrystring | search_querystring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| sess_00001 | desktop | blank | blank | user_101 | 2023-04-01T09:08:21Z | 2023-04-01T10:21:15Z | Chrome | 192.168.1.11 | US | 2023-04-01T09:08:33Z | login | /login | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank |
| sess_00001 | desktop | blank | blank | user_101 | 2023-04-01T09:08:21Z | 2023-04-01T10:21:15Z | Chrome | 192.168.1.11 | US | 2023-04-01T09:09:05Z | search | /search | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | wireless headphones |
| sess_00001 | desktop | 129.99 | Electronics | user_101 | 2023-04-01T09:08:21Z | 2023-04-01T10:21:15Z | Chrome | 192.168.1.11 | US | 2023-04-01T09:10:10Z | add_to_cart | /product/elec104 | elec104 | 1 | blank | blank | blank | blank | blank | blank | blank | blank | blank |
| sess_00001 | desktop | 129.99 | Electronics | user_101 | 2023-04-01T09:08:21Z | 2023-04-01T10:21:15Z | Chrome | 192.168.1.11 | US | 2023-04-01T10:20:00Z | purchase | /checkout | elec104 | 1 | ord_1001 | 129.99 | credit_card | 123 Maple Ave | Boston | MA | 02118 | US | blank |
| sess_00001 | desktop | blank | blank | user_101 | 2023-04-01T09:08:21Z | 2023-04-01T10:21:15Z | Chrome | 192.168.1.11 | US | 2023-04-01T10:21:12Z | logout | /logout | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank |
| sess_00002 | mobile | blank | blank | user_235 | 2023-04-02T13:20:00Z | 2023-04-02T14:03:20Z | Safari | 10.0.0.21 | AU | 2023-04-02T13:20:33Z | search | /search | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | running shoes |
| sess_00002 | mobile | 79.99 | Fashion | user_235 | 2023-04-02T13:20:00Z | 2023-04-02T14:03:20Z | Safari | 10.0.0.21 | AU | 2023-04-02T13:22:01Z | add_to_cart | /product/fash007 | fash007 | 2 | blank | blank | blank | blank | blank | blank | blank | blank | blank |
| sess_00002 | mobile | 79.99 | Fashion | user_235 | 2023-04-02T13:20:00Z | 2023-04-02T14:03:20Z | Safari | 10.0.0.21 | AU | 2023-04-02T14:00:00Z | purchase | /checkout | fash007 | 2 | ord_1002 | 159.98 | paypal | 55 George St | Sydney | NSW | 2000 | AU | blank |
| sess_00003 | tablet | blank | blank | user_112 | 2023-04-03T20:55:12Z | 2023-04-03T23:10:30Z | Edge | 172.16.5.31 | GB | 2023-04-03T21:00:00Z | page_view | /product/toys045 | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank |
| sess_00003 | tablet | blank | blank | user_112 | 2023-04-03T20:55:12Z | 2023-04-03T23:10:30Z | Edge | 172.16.5.31 | GB | 2023-04-03T22:10:40Z | search | /search | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | board games |
| sess_00003 | tablet | 24.99 | Toys | user_112 | 2023-04-03T20:55:12Z | 2023-04-03T23:10:30Z | Edge | 172.16.5.31 | GB | 2023-04-03T23:05:54Z | add_to_cart | /product/toys045 | toys045 | 1 | blank | blank | blank | blank | blank | blank | blank | blank | blank |
| sess_00003 | tablet | 24.99 | Toys | user_112 | 2023-04-03T20:55:12Z | 2023-04-03T23:10:30Z | Edge | 172.16.5.31 | GB | 2023-04-03T23:09:50Z | purchase | /checkout | toys045 | 1 | ord_1003 | 24.99 | debit_card | 88 Kirkgate | Leeds | WYK | LS2 8BY | GB | blank |
| sess_00004 | mobile | blank | blank | user_321 | 2023-04-04T16:40:20Z | 2023-04-04T17:01:05Z | Chrome | 203.0.113.101 | SG | 2023-04-04T16:40:33Z | page_view | / | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank |
| sess_00005 | desktop | blank | blank | user_xyz | 2023-04-05T08:12:44Z | 2023-04-05T09:55:17Z | Opera | 198.51.100.150 | CA | 2023-04-05T08:13:01Z | search | /search | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | garden tools |
| sess_00005 | desktop | 35.5 | Garden | user_xyz | 2023-04-05T08:12:44Z | 2023-04-05T09:55:17Z | Opera | 198.51.100.150 | CA | 2023-04-05T09:54:22Z | add_to_cart | /product/gard202 | gard202 | 1 | blank | blank | blank | blank | blank | blank | blank | blank | blank |
| sess_00006 | tablet | blank | blank | user_223 | 2023-04-06T15:00:12Z | 2023-04-06T16:34:31Z | Firefox | 203.0.113.212 | DE | 2023-04-06T15:01:03Z | login | /login | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank |
| sess_00006 | tablet | blank | blank | user_223 | 2023-04-06T15:00:12Z | 2023-04-06T16:34:31Z | Firefox | 203.0.113.212 | DE | 2023-04-06T15:02:30Z | page_view | /product/books303 | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank |
| sess_00006 | tablet | 15.99 | Books | user_223 | 2023-04-06T15:00:12Z | 2023-04-06T16:34:31Z | Firefox | 203.0.113.212 | DE | 2023-04-06T15:05:55Z | add_to_cart | /product/books303 | books303 | 1 | blank | blank | blank | blank | blank | blank | blank | blank | blank |
| sess_00006 | tablet | 15.99 | Books | user_223 | 2023-04-06T15:00:12Z | 2023-04-06T16:34:31Z | Firefox | 203.0.113.212 | DE | 2023-04-06T16:30:00Z | purchase | /checkout | books303 | 1 | ord_1004 | 15.99 | credit_card | Berliner Allee 5 | Berlin | BE | 10115 | DE | blank |
| sess_00007 | other | blank | blank | user_404 | 2023-04-07T07:01:07Z | 2023-04-07T07:03:04Z | UC Browser | 203.0.113.34 | IN | 2023-04-07T07:01:10Z | page_view | /404 | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank |
What the 200 rows show
from the 200-row sample- 40.0median price
- 4payment methods
- 7event types
- 10browsers
- 13countries
- 1median quantity
Median 40.0, from 3.0 to 13,000.
- string 18
- integer 1
- float 2
- datetime 3
Columns
24 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 18 columns | |||
session_id | string | Unique identifier for each web session.unique | sess_00001 |
user_id | string | Unique identifier for the shopper (anonymized if necessary). | user_101 |
device_type | string | Type of device used during the session (e.g., desktop, mobile, tablet).desktop · mobile · tablet · other · optional | desktop |
browser | string | Web browser used during the session.10 browsers · optional | Chrome |
ip_address | string | IP address of the user during the session.optional | 192.168.1.11 |
country | string | Country from which the session originated.optional | US |
event_type | string | Type of event (e.g., page_view, add_to_cart, purchase, search, logout).8 values | login |
page_url | string | URL of the page where the event occurred.optional | /login |
product_id | string | Unique identifier for the product involved in the event (if applicable).optional | elec104 |
product_category | string | Category of the product involved in the event (if applicable).10 categories · optional | Electronics |
order_id | string | Unique identifier for the purchase order (if event_type is purchase).optional | ord_1001 |
payment_method | string | Payment method used for the purchase (if applicable).6 values · optional | credit_card |
shipping_street_address | string | Street address for shipping (if event_type is purchase).optional | 123 Maple Ave |
shipping_city | string | City for shipping (if event_type is purchase).optional | Boston |
shipping_state | string | State or province for shipping (if event_type is purchase).optional | MA |
shipping_postal_code | string | Postal code for shipping (if event_type is purchase).optional | 02118 |
shipping_country | string | Country for shipping (if event_type is purchase).11 countries · optional | US |
search_query | string | Search query entered by the user (if event_type is search).optional | wireless headphones |
| Numbers 3 columns | |||
quantity | integer | Quantity of the product involved in the event (if applicable).1 or more · optional | 1 |
price | float | Price of the product at the time of the event (if applicable).0 or more · optional | 129.99 |
order_total | float | Total amount for the order (if event_type is purchase).0 or more · optional | 129.99 |
| Dates and times 3 columns | |||
session_start_time | datetime | Timestamp when the web session started. | 2023-04-01T09:08:21Z |
session_end_time | datetime | Timestamp when the web session ended. | 2023-04-01T10:21:15Z |
event_timestamp | datetime | Timestamp of the event within the session. | 2023-04-01T09:08:33Z |
Use it for
An e-commerce dashboard
Price by device_
type and a breakdown of product_ category. Excel, Power BI or Tableau. What pattern can you find in 200 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
- Sessions200sess_00001desktopsess_00001desktopsess_00001129.99desktop
A software demo
Believable sessions with user_
id, session_ start_ time and session_ end_ time to fill a screen in front of a buyer.
blueprint · e-commerce-purchase-sequences-dataset
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 24 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 session linked to a unique customer ID
- Products purchaseable within multiple categories
- Cart abandonments are included as events
- Timestamps reflect realistic shopping hours
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
- e-commerce-purchase-sequences-dataset