Shopping Cart Sessions

This dataset provides granular insights into shopping cart abandonment sessions, including session timing, cart composition, abandonment reasons, and recovery efforts. It is ideal for analyzing user behavior, optimizing recovery strategies, and improving e-commerce conversion rates through targeted interventions.

  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Analyzing cart abandonment patterns to improve checkout conversion rates

Sample rows

preview · 8 of 200 rows · all 15 columns
session_idstringabandonment_reasonstringitem_countintegerrecovery_attemptedbooleanrecovery_methodstringuser_idstringsession_start_timedatetimesession_end_timedatetimesession_duration_secondsintegercart_valuefloatrecovery_successfulbooleanrecovery_timedatetimedevice_typestringbrowserstringcountrystring
sess_00001comparison_shopping0falseblankguest_1012024-04-01T09:14:22Z2024-04-01T09:17:30Z1880blankblankmobileSafariBR
sess_00002shipping_cost7truesmsuser_234512024-04-01T15:41:10Z2024-04-01T16:09:43Z1723164.25falseblankmobileOperaZA
sess_00003changed_mind4trueretargeting_aduser_120032024-04-02T12:09:15Z2024-04-02T12:19:21Z60682.99true2024-04-02T12:40:18ZmobileSafariAU
sess_00004comparison_shopping1falseblankguest_1022024-04-02T19:55:42Z2024-04-02T19:56:34Z520.99blankblanktabletFirefoxSG
sess_00005shipping_cost28trueemailuser_221912024-04-03T08:07:45Z2024-04-03T12:18:17Z151921456falseblankdesktopChromeUS
sess_00006changed_mind3falseblankuser_112032024-04-03T13:22:17Z2024-04-03T13:33:45Z68849.5blankblanktabletSafariDE
sess_00007payment_issue11truepush_notificationuser_204122024-04-04T10:24:02Z2024-04-04T12:07:52Z6230377.99true2024-04-04T12:35:41ZtabletFirefoxFR
sess_00008other0falseblankguest_1032024-04-04T18:55:39Z2024-04-04T18:55:40Z10blankblankdesktopBraveJP

What the 200 rows show

from the 200-row sample

Shipping_cost (abandonment reason) stands out: mean item_count is 19.0, against 4.4 for the rest.

  • 54%recovery_attempted = true
  • 4median item_count
  • 3device types
  • 6browsers
  • 18countries
  • 1,200median session_duration_seconds
Mean item_count by abandonment_reason200 rows
0102019.0shipp…46 rows12.1payme…38 rows0.70compa…33 rows0.72site_…18 rows4.2chang…43 rows0.09other22 rows
item_count200 rows, in bands of 5
0551101015119645612502550item_count →

Median 4, from 0 to 50.

recovery_method108 rows with a value · 92 left blank
  1. push_notification35
  2. email32
  3. sms23
  4. retargeting_ad18
15 columns by typefrom the column list below
  • string 7
  • integer 2
  • float 1
  • datetime 3
  • boolean 2

Columns

15 columns in four groups
blueprint · 15 columns
columntypedescriptionexample
Text 7 columns
session_idstringUnique identifier for the shopping cart sessionuniquesess_00001
user_idstringIdentifier for the user associated with the session (can be guest or registered)guest_101
abandonment_reasonstringPrimary reason for cart abandonment (e.g., shipping cost, payment issues, comparison shopping)6 values · optionalcomparison_shopping
recovery_methodstringType of recovery method used (e.g., email, SMS, push notification, retargeting ad)email · sms · push_notification · retargeting_ad · none · optionalsms
device_typestringType of device used during the session (e.g., desktop, mobile, tablet)desktop · mobile · tablet · optionalmobile
browserstringBrowser used during the session (e.g., Chrome, Firefox, Safari)6 browsers · optionalSafari
countrystringCountry from which the session originatedoptionalBR
Numbers 3 columns
session_duration_secondsintegerTotal duration of the session in seconds0 or more188
cart_valuefloatTotal monetary value of items in the cart at abandonment0 or more0
item_countintegerNumber of distinct items added to the cart during the session0 or more0
Dates and times 3 columns
session_start_timedatetimeTimestamp when the shopping cart session started2024-04-01T09:14:22Z
session_end_timedatetimeTimestamp when the shopping cart session ended or was abandoned2024-04-01T09:17:30Z
recovery_timedatetimeTimestamp when the recovery action was completed (if successful)optional2024-04-02T12:40:18Z
True or false 2 columns
recovery_attemptedbooleanIndicates whether a recovery attempt (e.g., email, retargeting ad) was made for this sessionfalse
recovery_successfulbooleanIndicates whether the recovery attempt resulted in a completed purchaseoptionalfalse

Use it for

  • recovery attem…54%108 of 200 rowsmean item count by ab…19.0ship…12.1paym…0.70comp…0.72site…

    An e-commerce dashboard

    The recovery_attempted rate, item_count by abandonment_reason and a breakdown of recovery_method. Excel, Power BI or Tableau.

  • Why do the 46 shipping_cost rows have a mean item_count of 19.0?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable sessions with user_id, session_start_time and session_end_time to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 15 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows15 columns
Yours1,000 rows15 columnscountry: UK only

blueprint · shopping-cart-sessions

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 15 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
  • Session ID unique per user session
  • Cart value sum of all items
  • Abandonment after 30 minutes inactivity
  • Recovery email sent if cart abandoned
  • Conversion tracked if purchase completed
Rows
Open the blueprint in Data Factory

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
shopping-cart-sessions

More in E-commerce

Browse all
Also in E-commerceE-Commerce Cart Abandonment DataE-Commerce Session Conversion DataE-Commerce Cart Abandonment PatternsAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.