E-commerce Shopping Cart Abandonment

This dataset provides granular insights into user shopping sessions, cart interactions, and abandonment behaviors on digital retail platforms. It includes session metadata, cart details, device and location information, and explicit abandonment reasons, enabling robust conversion rate analysis and personalized marketing strategies.

  • opened 10 times
  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Conversion rate optimization and abandonment analysis

Sample rows

preview · 8 of 200 rows · all 26 columns
session_idstringdevice_typestringcart_total_valuefloatabandonedbooleanabandonment_reasonstringuser_idstringsession_start_timedatetimesession_end_timedatetimecart_idstringcart_created_timedatetimecart_updated_timedatetimecart_total_itemsintegercart_currencystringabandonment_timedatetimebrowserstringosstringgeo_countrystringgeo_regionstringgeo_citystringentry_pagestringexit_pagestringtime_on_site_secondsintegercart_action_countintegercart_actions_last_actionstringpromo_code_usedbooleanpromo_codestring
sess0001desktop76.5falseblankuserA12342024-06-10T09:05:12Z2024-06-10T09:26:38Zcart1012024-06-10T09:06:08Z2024-06-10T09:25:55Z2USDblankChromeWindows 11USCaliforniaSan Francisco/category/electronics/order-confirmation12863addfalseblank
sess0002mobile0truejust_browsinganon_45392024-06-10T10:11:03Z2024-06-10T10:13:17Zcart1022024-06-10T10:12:01Z2024-06-10T10:12:59Z0USD2024-06-10T10:13:17ZSafariiOSUSTexasDallas/home/cart1340nonefalseblank
sess0003tablet245falseblankuserB56782024-06-09T15:23:14Z2024-06-09T15:55:09Zcart1032024-06-09T15:23:56Z2024-06-09T15:54:40Z8EURblankSafariiPadOSFRÎle-de-FranceParis/category/furniture/order-confirmation191510updatetruePARIS24
sess0004mobile0truejust_browsingguest_98812024-06-08T20:03:35Z2024-06-08T20:04:26Zcart1042024-06-08T20:03:49Zblank0GBP2024-06-08T20:04:26ZChromeAndroidGBGreater LondonLondon/home/cart510nonefalseblank
sess0005desktop3100falseblankuserC23452024-06-10T13:22:07Z2024-06-10T14:18:17Zcart1052024-06-10T13:22:41Z2024-06-10T14:17:59Z55USDblankEdgeWindows 10USNew YorkNew York/bulk-order/order-confirmation336022addtrueBULK2024
sess0006mobile0truejust_browsinganon_06092024-06-09T18:39:10Z2024-06-09T18:40:00Zcart1062024-06-09T18:39:35Zblank0INR2024-06-09T18:40:00ZChromeAndroidINMaharashtraMumbai/home/cart500nonefalseblank
sess0007tablet350.99falseblankuserD43212024-06-08T08:54:35Z2024-06-08T09:02:19Zcart1072024-06-08T08:55:13Z2024-06-08T09:02:00Z15EURblankChromeAndroidDEBavariaMunich/sale/order-confirmation4649updatetrueGERMANY24
sess0008mobile18.99truefound_better_priceguest_47612024-06-10T17:41:22Z2024-06-10T17:46:34Zcart1082024-06-10T17:42:07Zblank1USD2024-06-10T17:46:34ZSamsung InternetAndroidBRSão PauloSão Paulo/category/clothing/checkout/payment3121addfalseblank

What the 200 rows show

from the 200-row sample

Mobile (device type) stands out: 71 of its 74 rows have abandoned = true, against 10 of 126 for the rest.

  • 41%abandoned = true
  • 63.0median cart_total_value
  • 4cart actions last actions
  • 5exit pages
  • 8oses
  • 9browsers
Abandoned rate by device_typeabandoned = true
0%50%100%11%desktop10 of 8896%mobile71 of 740%tablet0 of 38
cart_total_value200 rows, in bands of 10k
095190181133100101050k90kcart_total_value →

Median 63.0, from 0.0 to 89,921.

abandonment_reason81 rows with a value · 119 left blank
  1. just_browsing54
  2. found_better_price9
  3. technical_error5
  4. other5
  5. complicated_checkout4
  6. high_shipping_cost3
  7. payment_issue1
26 columns by typefrom the column list below
  • string 15
  • integer 3
  • float 1
  • datetime 5
  • boolean 2

Columns

26 columns in four groups
blueprint · 26 columns
columntypedescriptionexample
Text 15 columns
session_idstringUnique identifier for each user session on the platformuniquesess0001
user_idstringUnique identifier for the user (can be anonymous or registered)userA1234
cart_idstringUnique identifier for the shopping cart associated with the sessionuniquecart101
cart_currencystringCurrency code for the cart value (e.g., USD, EUR)USD
abandonment_reasonstringReason for cart abandonment (if provided by user or inferred)7 values · optionaljust_browsing
device_typestringType of device used during the session (e.g., desktop, mobile, tablet)desktop · mobile · tablet · otherdesktop
browserstringBrowser used during the session (e.g., Chrome, Firefox, Safari)9 browsers · optionalChrome
osstringOperating system of the device used during the session8 oses · optionalWindows 11
geo_countrystringCountry of the user based on IP geolocationoptionalUS
geo_regionstringRegion or state of the user based on IP geolocationoptionalCalifornia
geo_citystringCity of the user based on IP geolocationoptionalSan Francisco
entry_pagestringURL or identifier of the first page visited in the session/category/electronics
exit_pagestringURL or identifier of the last page visited in the session5 pages · optional/order-confirmation
cart_actions_last_actionstringType of the last cart action performed (add, remove, update, none)add · remove · update · none · optionaladd
promo_codestringPromo code applied, if anyoptionalPARIS24
Numbers 4 columns
cart_total_itemsintegerTotal number of items in the cart at abandonment or session end0 or more2
cart_total_valuefloatTotal monetary value of the cart at abandonment or session end0 or more76.5
time_on_site_secondsintegerTotal time spent on the site during the session, in seconds0 or more1286
cart_action_countintegerNumber of distinct cart actions (add, remove, update) performed in the session0 or more3
Dates and times 5 columns
session_start_timedatetimeTimestamp when the user session started2024-06-10T09:05:12Z
session_end_timedatetimeTimestamp when the user session endedoptional2024-06-10T09:26:38Z
cart_created_timedatetimeTimestamp when the cart was created2024-06-10T09:06:08Z
cart_updated_timedatetimeTimestamp when the cart was last updatedoptional2024-06-10T09:25:55Z
abandonment_timedatetimeTimestamp when the cart was abandoned (if applicable)optional2024-06-10T10:13:17Z
True or false 2 columns
abandonedbooleanIndicates whether the cart was abandoned (true) or completed (false)false
promo_code_usedbooleanIndicates if a promo code was applied during the sessionfalse

Use it for

  • abandoned41%81 of 200 rowsmean cart total value…5.6kdesktop10.2mobile320.4tablet

    An e-commerce dashboard

    The abandoned rate, cart_total_value by device_type and a breakdown of abandonment_reason. Excel, Power BI or Tableau.

  • Why do 81 of 200 rows have abandoned = true?

    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 26 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 rows26 columns
Yours1,000 rows26 columnsgeo_country: UK only

blueprint · e-commerce-shopping-cart-abandonment

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 26 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-level timing and page sequence
  • Capture item type and price sensitivity
  • Include device/browser metadata
  • Flag user abandonment triggers
  • No personally identifiable information
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
e-commerce-shopping-cart-abandonment

More in E-commerce

Browse all
Also in E-commerceRetail Customer Journey SessionsE-commerce Packaging Sustainability IndexE-Commerce Cart Abandonment PatternsAll 1,954 datasets
In collectionsRetail and E-commerce Sales Datasets

What should your data show?

Preview 20 rows free
No signup. No card.