E-Commerce Cart Abandonment Data

This dataset provides detailed records of e-commerce cart abandonment events, including user and session identifiers, cart contents, device and location data, timing, and follow-up actions. It enables retailers to analyze abandonment patterns, optimize recovery strategies, and personalize user experiences to improve conversion rates.

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

Analyzing cart abandonment patterns and conversion bottlenecks

Sample rows

preview · 8 of 200 rows · all 21 columns
cart_abandonment_idstringuser_segmentstringnumber_of_itemsintegerfollow_up_sentbooleanbrowserstringuser_idstringsession_idstringcart_created_datetimedatetimecart_abandoned_datetimedatetimetotal_cart_valuefloatproduct_idsstringcart_category_summarystringuser_emailstringdevice_typestringoperating_systemstringcart_duration_secondsintegeruser_countrystringuser_citystringexit_page_urlstringabandonment_reasonstringfollow_up_responsestring
CA000001returning3trueChromeU1234S100012024-04-22T14:51:23Z2024-04-22T15:00:05Z59.99PRX12,PRY88,PRB23electronics:2,apparel:1julia.roberts@shopmail.commobileAndroid522USChicagohttps://shopsite.com/cart/checkoutshipping costpending
CA000002guest2falseEdgeU2345S100022024-04-16T10:05:11Z2024-04-16T10:09:33Z12PRA67,PRB99books:1,apparel:1blankdesktopWindows262INMumbaihttps://shopsite.com/product/viewunknownnot sent
CA000003new2trueSafariU3456S100032024-04-20T16:30:00Z2024-04-20T16:33:20Z26.99PRC21,PRD44home:1,beauty:1lucas.wang@ecomail.cntabletiPadOS200CNShanghaihttps://shopsite.com/checkout/startsite errorignored
CA000004VIP4trueChromeU4567S100042024-04-15T09:18:47Z2024-04-15T09:26:32Z139.9PRE42,PRF23,PRG90,PRH12electronics:2,home:2ana.garcia@shopmail.esdesktopWindows465ESMadridhttps://shopsite.com/cart/reviewpayment failurerecovered
CA000005other1falseblankU5678S100052024-04-14T22:45:10Z2024-04-14T22:45:15Z0PRI11blankblankotherblank5blankblankblankothernot sent
CA000006VIP5trueEdgeU6789S100062024-04-21T08:25:37Z2024-04-21T08:28:00Z74.95PRJ22,PRK37,PRL88,PRM54,PRN65electronics:3,apparel:2daniel.riley@shopmail.comdesktopWindows143USDallashttps://shopsite.com/checkout/paymentpayment failureignored
CA000007returning4trueSafariU7890S100072024-04-18T06:20:00Z2024-04-18T06:25:40Z62PRO33,PRP77,PRQ18,PRR21home:2,apparel:2hannah.stevens@shopmail.demobileiOS340DEBerlinhttps://shopsite.com/cart/viewshipping costpending
CA000008guest2falseOperaU8901S100082024-04-17T13:10:54Z2024-04-17T13:13:10Z15.99PRS77,PRT89beauty:2blankmobileAndroid136ESBarcelonahttps://shopsite.com/product/viewcomparison shoppingnot sent

What the 200 rows show

from the 200-row sample

VIP (user segment) stands out: mean number_of_items is 9.5, against 2.2 for the rest.

  • 60%follow_up_sent = true
  • 3median number_of_items
  • 4device types
  • 5follow up responses
  • 6abandonment reasons
  • 9operating systems
Mean number_of_items by user_segment200 rows
05102.7new19 rows3.5return…44 rows9.5VIP57 rows1.5guest53 rows1.3other27 rows
number_of_items200 rows, in bands of 2.5
05010094423661223203012.525number_of_items →

Median 3, from 1 to 25.

browser187 rows with a value · 13 left blank
  1. Chrome70
  2. Safari26
  3. Edge19
  4. Opera17
  5. Brave17
  6. Firefox15
  7. Yandex13
  8. IE10
21 columns by typefrom the column list below
  • string 15
  • integer 2
  • float 1
  • datetime 2
  • boolean 1

Columns

21 columns in four groups
blueprint · 21 columns
columntypedescriptionexample
Text 15 columns
cart_abandonment_idstringUnique identifier for each cart abandonment eventuniqueCA000001
user_idstringUnique identifier for the user who abandoned the cartU1234
session_idstringUnique identifier for the user's browsing sessionS10001
product_idsstringList of product IDs present in the cart at abandonmentPRX12,PRY88,PRB23
cart_category_summarystringSummary of product categories and counts in the cart (e.g., {'electronics':2,'apparel':1})optionalelectronics:2,apparel:1
user_emailstringEmail address of the user, if availableoptionallucas.wang@ecomail.cn
user_segmentstringUser segment or type (e.g., 'new', 'returning', 'VIP')new · returning · VIP · guest · other · optionalreturning
device_typestringType of device used during the session (e.g., 'mobile', 'desktop', 'tablet')mobile · desktop · tablet · other · optionalmobile
browserstringBrowser used during the session8 browsers · optionalChrome
operating_systemstringOperating system of the device used9 systems · optionalAndroid
user_countrystringCountry of the user, if availableoptionalUS
user_citystringCity of the user, if availableoptionalChicago
exit_page_urlstringURL of the last page visited before cart abandonmentoptionalhttps://shopsite.com/cart…
abandonment_reasonstringKnown or inferred reason for cart abandonment (e.g., 'shipping cost', 'payment failure', 'comparison shopping')6 values · optionalshipping cost
follow_up_responsestringResponse to follow-up communication (e.g., 'recovered', 'ignored', 'unsubscribed')recovered · ignored · unsubscribed · pending · not sent · optionalpending
Numbers 3 columns
total_cart_valuefloatTotal monetary value of items in the cart at abandonment0 or more59.99
number_of_itemsintegerTotal number of items in the cart at abandonment1 or more3
cart_duration_secondsintegerDuration in seconds between cart creation and abandonment0 or more522
Dates and times 2 columns
cart_created_datetimedatetimeTimestamp when the cart was created2024-04-22T14:51:23Z
cart_abandoned_datetimedatetimeTimestamp when the cart was abandoned2024-04-22T15:00:05Z
True or false 1 column
follow_up_sentbooleanIndicates whether a follow-up communication (e.g., email) was sent after abandonmentoptionaltrue

Use it for

  • follow up sent60%120 of 200 rowsmean number of items …2.7new3.5retu…9.5VIP1.5guest

    An e-commerce dashboard

    The follow_up_sent rate, number_of_items by user_segment and a breakdown of browser. Excel, Power BI or Tableau.

  • Why do the 57 VIP rows have a mean number_of_items of 9.5?

    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 cart abandonments with user_id, session_id and cart_created_datetime to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 21 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 rows21 columns
Yours1,000 rows21 columnsuser_country: UK only

blueprint · e-commerce-cart-abandonment-data

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 21 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
  • Record user actions and cart value
  • Track abandonment timing
  • Include device and browser info
  • Exclude completed purchases
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-cart-abandonment-data

More in E-commerce

Browse all
Also in E-commerceE-Commerce Session Conversion DataSales TransactionsE-Commerce Cart Abandonment PatternsAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.