E-Commerce Session Conversion Data
This dataset provides granular session-level logs for e-commerce platforms, detailing user interactions, cart activity, conversion outcomes, and behavioral events. It enables retailers and analysts to identify conversion drivers, measure abandonment, and optimize the online shopping experience through actionable insights and predictive modeling.
Sample rows
preview · 8 of 200 rows · all 24 columns| session_idstring | osstring | session_valuefloat | abandoned_cartboolean | payment_methodstring | user_idstring | session_start_timedatetime | session_end_timedatetime | session_duration_secondsinteger | device_typestring | browserstring | countrystring | citystring | entry_page_urlstring | total_pageviewsinteger | product_viewsinteger | cart_additionsinteger | cart_removalsinteger | checkout_initiatedboolean | conversionboolean | coupon_usedboolean | referrer_urlstring | exit_page_urlstring | interaction_eventsstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| sess_00001 | Windows | 1422.5 | false | credit_card | user_39241 | 2024-06-03T09:12:21Z | 2024-06-03T10:04:12Z | 3101 | desktop | Chrome | US | San Francisco | https://shop.example.com/home | 19 | 12 | 7 | 1 | true | true | true | https://www.google.com/search?q=mens+shoes | https://shop.example.com/checkout/success | {"events":[{"ts":"2024-06-03T09:13:02Z","type":"click"},{"ts":"2024-06-03T09:20:12Z","type":"add_to_cart"},{"ts":"2024-06-03T09:40:15Z","type":"checkout"},{"ts":"2024-06-03T09:54:39Z","type":"click"}]} |
| sess_00002 | Android | 0 | false | blank | anonymous | 2024-06-02T21:15:30Z | 2024-06-02T21:16:01Z | 31 | mobile | Samsung Internet | KR | Seoul | https://shop.example.com/home | 1 | 0 | 0 | 0 | false | false | blank | blank | blank | {"events":[{"ts":"2024-06-02T21:15:35Z","type":"scroll"}]} |
| sess_00003 | iPadOS | 0 | false | blank | user_17620 | 2024-06-04T16:42:10Z | 2024-06-04T16:54:25Z | 735 | tablet | Firefox | GB | London | https://shop.example.com/deals | 5 | 3 | 0 | 0 | false | false | blank | https://affiliate.example.com/lp | https://shop.example.com/products/3482 | {"events":[{"ts":"2024-06-04T16:44:08Z","type":"click"},{"ts":"2024-06-04T16:53:21Z","type":"scroll"}]} |
| sess_00004 | Linux | 3180.8 | false | paypal | user_58217 | 2024-06-03T12:31:10Z | 2024-06-03T17:21:15Z | 17645 | desktop | Opera | IN | Mumbai | https://shop.example.com/home | 27 | 14 | 11 | 3 | true | true | true | https://newsletter.example.com/june | https://shop.example.com/checkout/success | {"events":[{"ts":"2024-06-03T13:12:44Z","type":"add_to_cart"},{"ts":"2024-06-03T13:50:31Z","type":"click"},{"ts":"2024-06-03T15:10:14Z","type":"checkout"}]} |
| sess_00005 | iPadOS | 0 | true | blank | user_81240 | 2024-06-04T09:10:02Z | 2024-06-04T09:32:14Z | 1332 | tablet | Safari | AE | Dubai | https://shop.example.com/sale | 8 | 5 | 2 | 1 | true | false | false | https://www.facebook.com/promo | https://shop.example.com/products/9814 | {"events":[{"ts":"2024-06-04T09:15:36Z","type":"add_to_cart"},{"ts":"2024-06-04T09:20:28Z","type":"remove_from_cart"},{"ts":"2024-06-04T09:30:12Z","type":"checkout"}]} |
| sess_00006 | Android | 0 | false | blank | user_61034 | 2024-06-05T13:01:03Z | 2024-06-05T13:01:20Z | 17 | mobile | Opera Mini | NG | Lagos | https://shop.example.com/home | 1 | 0 | 0 | 0 | false | false | blank | blank | blank | blank |
| sess_00007 | Unknown | 0 | false | blank | anonymous | 2024-06-03T18:11:13Z | 2024-06-03T18:12:18Z | 65 | mobile | Unknown | BR | São Paulo | https://shop.example.com/home | 1 | 0 | 0 | 0 | false | false | blank | blank | blank | {"events":[{"ts":"2024-06-03T18:11:40Z","type":"scroll"}]} |
| sess_00008 | Windows | 0 | true | blank | user_27412 | 2024-06-04T20:43:00Z | 2024-06-04T21:02:21Z | 1161 | desktop | Edge | US | Dallas | https://shop.example.com/sale | 10 | 7 | 2 | 0 | true | false | false | https://www.bing.com/search?q=summer+sale | https://shop.example.com/products/2832 | {"events":[{"ts":"2024-06-04T20:44:15Z","type":"click"},{"ts":"2024-06-04T20:50:36Z","type":"add_to_cart"},{"ts":"2024-06-04T20:59:19Z","type":"checkout"}]} |
| sess_00009 | macOS | 2450 | false | debit_card | user_40392 | 2024-06-02T15:05:14Z | 2024-06-02T17:23:52Z | 8268 | desktop | Chrome | CA | Toronto | https://shop.example.com/home | 23 | 13 | 8 | 2 | true | true | false | https://www.reddit.com/r/deals | https://shop.example.com/checkout/success | {"events":[{"ts":"2024-06-02T15:10:11Z","type":"add_to_cart"},{"ts":"2024-06-02T16:02:47Z","type":"checkout"},{"ts":"2024-06-02T16:45:28Z","type":"click"}]} |
| sess_00010 | Android | 0 | false | blank | anonymous | 2024-06-05T07:14:42Z | 2024-06-05T07:15:10Z | 28 | other | Brave | NZ | Auckland | https://shop.example.com/home | 1 | 0 | 0 | 0 | false | false | blank | blank | blank | blank |
| sess_00011 | Windows | 720.4 | false | paypal | user_19024 | 2024-06-02T12:41:09Z | 2024-06-02T12:58:13Z | 1084 | desktop | Vivaldi | FR | Paris | https://shop.example.com/home | 13 | 8 | 5 | 1 | true | true | false | https://newsletter.example.com/june | https://shop.example.com/checkout/success | {"events":[{"ts":"2024-06-02T12:43:45Z","type":"add_to_cart"},{"ts":"2024-06-02T12:47:10Z","type":"click"},{"ts":"2024-06-02T12:57:00Z","type":"checkout"}]} |
| sess_00012 | iPadOS | 0 | true | blank | user_23109 | 2024-06-03T08:14:42Z | 2024-06-03T08:45:54Z | 1872 | tablet | Safari | AU | Sydney | https://shop.example.com/sale | 11 | 6 | 3 | 2 | true | false | false | https://promo.example.com/campaign | https://shop.example.com/products/6728 | {"events":[{"ts":"2024-06-03T08:20:22Z","type":"add_to_cart"},{"ts":"2024-06-03T08:41:33Z","type":"remove_from_cart"},{"ts":"2024-06-03T08:44:50Z","type":"checkout"}]} |
| sess_00013 | Android | 0 | false | blank | user_82469 | 2024-06-04T15:32:19Z | 2024-06-04T15:32:49Z | 30 | mobile | Opera Mini | RU | Moscow | https://shop.example.com/home | 1 | 1 | 0 | 0 | false | false | blank | blank | blank | {"events":[{"ts":"2024-06-04T15:32:22Z","type":"click"}]} |
| sess_00014 | Windows | 0 | false | blank | user_98324 | 2024-06-03T13:18:11Z | 2024-06-03T13:31:53Z | 822 | desktop | Edge | US | New York | https://shop.example.com/deals | 6 | 2 | 0 | 0 | false | false | blank | https://www.google.com/search?q=kitchen+appliances | https://shop.example.com/products/2245 | {"events":[{"ts":"2024-06-03T13:19:02Z","type":"click"},{"ts":"2024-06-03T13:21:12Z","type":"scroll"}]} |
| sess_00015 | Windows | 2310.9 | false | apple_pay | user_45028 | 2024-06-05T19:23:41Z | 2024-06-05T21:12:10Z | 6529 | desktop | Chrome | DE | Berlin | https://shop.example.com/home | 24 | 13 | 9 | 2 | true | true | true | https://affiliate.example.com/lp | https://shop.example.com/checkout/success | {"events":[{"ts":"2024-06-05T19:31:44Z","type":"add_to_cart"},{"ts":"2024-06-05T20:17:12Z","type":"checkout"},{"ts":"2024-06-05T20:58:33Z","type":"click"}]} |
| sess_00016 | Android | 0 | false | blank | anonymous | 2024-06-05T13:12:01Z | 2024-06-05T13:13:11Z | 70 | other | Brave | ZA | Cape Town | https://shop.example.com/home | 1 | 0 | 0 | 0 | false | false | blank | blank | blank | blank |
| sess_00017 | iPadOS | 0 | true | blank | user_51236 | 2024-06-04T11:21:03Z | 2024-06-04T11:44:40Z | 1427 | tablet | Safari | JP | Tokyo | https://shop.example.com/sale | 9 | 6 | 3 | 2 | true | false | false | https://www.instagram.com/ad | https://shop.example.com/products/7402 | {"events":[{"ts":"2024-06-04T11:25:21Z","type":"add_to_cart"},{"ts":"2024-06-04T11:40:58Z","type":"remove_from_cart"},{"ts":"2024-06-04T11:43:33Z","type":"checkout"}]} |
| sess_00018 | Android | 0 | false | blank | user_78509 | 2024-06-03T16:17:24Z | 2024-06-03T16:17:54Z | 30 | mobile | Samsung Internet | NG | Abuja | https://shop.example.com/home | 1 | 0 | 0 | 0 | false | false | blank | blank | blank | blank |
| sess_00019 | Windows | 0 | false | blank | user_97012 | 2024-06-02T23:51:02Z | 2024-06-03T00:04:41Z | 819 | desktop | Chrome | US | Seattle | https://shop.example.com/deals | 7 | 3 | 0 | 0 | false | false | blank | https://www.google.com/search?q=electronics | https://shop.example.com/products/5348 | {"events":[{"ts":"2024-06-03T00:00:15Z","type":"click"}]} |
| sess_00020 | Unknown | 0 | false | blank | anonymous | 2024-06-05T18:01:02Z | 2024-06-05T18:01:40Z | 38 | mobile | Unknown | IN | Delhi | https://shop.example.com/home | 1 | 0 | 0 | 0 | false | false | blank | blank | blank | {"events":[{"ts":"2024-06-05T18:01:25Z","type":"scroll"}]} |
What the 200 rows show
from the 200-row sampleIPadOS os stands out: 28 of its 34 rows have abandoned_
- 21%abandoned_
cart = true - 0.0median session_
value - 4device types
- 10browsers
- 17countries
- 60cities
Median 0.0, from 0.0 to 4,060.
- string 12
- integer 5
- float 1
- datetime 2
- boolean 4
Columns
24 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
session_id | string | Unique identifier for each user session on the e-commerce platformunique | sess_00001 |
user_id | string | Unique identifier for the user associated with the session (can be anonymous or registered)optional | user_39241 |
device_type | string | Type of device used during the session (e.g., desktop, mobile, tablet)desktop · mobile · tablet · other | desktop |
browser | string | Browser used during the session10 browsers · optional | Chrome |
os | string | Operating system of the device used7 oses · optional | Windows |
country | string | Country from which the session originatedoptional | US |
city | string | City from which the session originatedoptional | San Francisco |
referrer_url | string | URL that referred the user to the session (e.g., search engine, ad, direct)optional | https://www.google.com/se… |
entry_page_url | string | URL of the first page visited in the session | https://shop.example.com/… |
exit_page_url | string | URL of the last page visited in the sessionoptional | https://shop.example.com/… |
interaction_events | string | Flat JSON string containing a list of key interaction events (e.g., clicks, scrolls, hovers) with timestamps and event typesoptional | {"events":[{"ts":"2024-06… |
payment_method | string | Payment method used for completed purchases (if any)6 values · optional | credit_card |
| Numbers 6 columns | |||
session_duration_seconds | integer | Total duration of the session in seconds0 or more | 3101 |
total_pageviews | integer | Total number of pages viewed during the session1 or more | 19 |
product_views | integer | Number of product detail pages viewed during the session0 or more | 12 |
cart_additions | integer | Number of times products were added to the cart during the session0 or more | 7 |
cart_removals | integer | Number of times products were removed from the cart during the session0 or more | 1 |
session_value | float | Total monetary value of purchases made during the session (0 if no purchase)0 or more | 1422.5 |
| Dates and times 2 columns | |||
session_start_time | datetime | Timestamp when the session began | 2024-06-03T09:12:21Z |
session_end_time | datetime | Timestamp when the session ended | 2024-06-03T10:04:12Z |
| True or false 4 columns | |||
checkout_initiated | boolean | Indicates whether the checkout process was started during the session | true |
conversion | boolean | Indicates whether a purchase was completed during the session | true |
abandoned_cart | boolean | Indicates whether the session ended with items left in the cart but no purchase | false |
coupon_used | boolean | Indicates whether a coupon or discount code was applied during the sessionoptional | true |
Use it for
An e-commerce dashboard
The abandoned_
cart rate, session_ value by os and a breakdown of payment_ method. Excel, Power BI or Tableau. Why do 42 of 200 rows have abandoned_
cart = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Sessions200sess_000011422.5Windowssess_000050iPadOSsess_000080Windows
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-session-conversion-data
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.
- Session ID and user demographics anonymized
- Page views and actions tracked
- Conversion outcome labeled
- Product category and price range included
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- e-commerce-session-conversion-data