Abandoned Cart Recovery Patterns

This dataset provides detailed records of abandoned shopping carts in an e-commerce environment, including user identifiers, cart contents, abandonment timing, recovery outreach, and user response. It enables analysis of abandonment patterns, effectiveness of recovery campaigns, and identification of high-value recovery opportunities, supporting data-driven strategies for revenue recovery and customer re-engagement.

  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Analyze cart abandonment patterns to optimize checkout flows

Sample rows

preview · 8 of 100 rows · all 21 columns
cart_idstringrecovery_action_typestringtotal_cart_valuefloatrecovery_email_sentbooleanuser_countrystringuser_idstringuser_emailstringcart_created_atdatetimecart_last_updated_atdatetimecart_abandoned_atdatetimecart_statusstringcurrencystringnumber_of_itemsintegerproduct_idsstringdevice_typestringuser_citystringrecovery_email_sent_atdatetimerecovery_email_openedbooleanrecovery_email_opened_atdatetimerecovery_action_takenbooleanrecovery_action_atdatetime
CART10001blank78.45trueUSU835jessica.garcia@gmail.com2024-03-07T10:21:13Z2024-03-07T10:29:08Z2024-03-07T11:01:11ZabandonedUSD3P1032,P2047,P1099mobileChicago2024-03-07T12:03:51Ztrue2024-03-07T12:12:23Zfalseblank
CART10002blank129.99falseESU922sergio.martin@yahoo.com2024-02-15T14:03:10Z2024-02-15T14:40:53Z2024-02-15T15:23:31ZabandonedEUR2P2051,P3090desktopBarcelonablankblankblankblankblank
CART10003returned_to_cart42.5trueGBU834samuel.carter@outlook.com2024-01-22T09:41:56Z2024-01-22T09:58:43Z2024-01-22T10:25:34ZrecoveredGBP1P1120desktopManchester2024-01-22T11:01:17Ztrue2024-01-22T11:10:48Ztrue2024-01-22T12:32:11Z
CART10004blank23.99trueDEU903viktoria.schmidt@mail.de2024-04-10T17:32:48Z2024-04-10T17:54:14Z2024-04-10T18:11:15ZabandonedEUR2P1150,P1318tabletMunich2024-04-10T19:01:04Zfalseblankblankblank
CART10005purchased310trueUSU810natalie.lee@live.com2024-03-11T11:03:40Z2024-03-11T11:44:51Z2024-03-11T12:00:09ZabandonedUSD5P1320,P2011,P2100,P1756,P1203mobileHouston2024-03-11T13:10:07Ztrue2024-03-11T13:41:12Ztrue2024-03-11T13:55:00Z
CART10006blank64.99falseBRU799lucas.rossi@gmail.com2024-04-02T16:11:41Z2024-04-02T16:23:17Z2024-04-02T16:39:30ZabandonedBRL2P1632,P1461desktopSão Pauloblankblankblankblankblank
CART10007blank12.5falseCNU880zhang.xiao@163.com2024-01-28T07:00:30Z2024-01-28T07:12:15Z2024-01-28T07:34:41ZactiveCNY1P1101mobileShenzhenblankblankblankblankblank
CART10008blank89trueFRU833amelie.dupont@orange.fr2024-02-19T21:10:56Z2024-02-19T21:53:44Z2024-02-19T23:04:17ZabandonedEUR3P1471,P2103,P1825desktopLille2024-02-20T08:14:09Zfalseblankblankblank

What the 100 rows show

from the 100-row sample
  • 62%recovery_email_sent = true
  • 63.6median total_cart_value
  • 4cart statuses
  • 4device types
  • 18currencies
  • 2median number_of_items
recovery_action_type17 rows by value
05109returned_to_…9%7purchased7%1ignored1%
total_cart_value100 rows, in bands of 50
0204035401453210200350total_cart_value →

Median 63.6, from 11.0 to 310.0.

user_country100 rows · top 10 of 23 values
  1. US40
  2. ES6
  3. DE6
  4. BR5
  5. GB4
  6. FR4
  7. SE4
  8. CN3
  9. IT3
  10. CA3
21 columns by typefrom the column list below
  • string 10
  • integer 1
  • float 1
  • datetime 6
  • boolean 3

Columns

21 columns in four groups
blueprint · 21 columns
columntypedescriptionexample
Text 10 columns
cart_idstringUnique identifier for the shopping cart session.uniqueCART10001
user_idstringUnique identifier for the user who created the cart.U835
user_emailstringEmail address of the user (if available).optionaljessica.garcia@gmail.com
cart_statusstringCurrent status of the cart (abandoned, recovered, purchased, active).abandoned · recovered · purchased · activeabandoned
currencystringISO currency code for the cart value (e.g., USD, EUR).USD
product_idsstringComma-separated list of product IDs in the cart at the time of abandonment.P1032,P2047,P1099
device_typestringType of device used to create the cart (desktop, mobile, tablet, other).desktop · mobile · tablet · other · optionalmobile
user_countrystringCountry of the user at the time of cart creation (ISO 2-letter code).optionalUS
user_citystringCity of the user at the time of cart creation.optionalChicago
recovery_action_typestringType of action taken after recovery outreach (returned_to_cart, purchased, ignored, other).returned_to_cart · purchased · ignored · other · optionalreturned_to_cart
Numbers 2 columns
total_cart_valuefloatTotal monetary value of the items in the cart at abandonment.0 or more78.45
number_of_itemsintegerTotal number of distinct items in the cart.1 or more3
Dates and times 6 columns
cart_created_atdatetimeTimestamp when the cart was created.2024-03-07T10:21:13Z
cart_last_updated_atdatetimeTimestamp when the cart was last updated.2024-03-07T10:29:08Z
cart_abandoned_atdatetimeTimestamp when the cart was considered abandoned (no activity for a defined period).2024-03-07T11:01:11Z
recovery_email_sent_atdatetimeTimestamp when the recovery email was sent (if applicable).optional2024-03-07T12:03:51Z
recovery_email_opened_atdatetimeTimestamp when the recovery email was opened (if applicable).optional2024-03-07T12:12:23Z
recovery_action_atdatetimeTimestamp of the user's recovery action (if any).optional2024-01-22T12:32:11Z
True or false 3 columns
recovery_email_sentbooleanIndicates whether a recovery email was sent to the user.true
recovery_email_openedbooleanIndicates whether the recovery email was opened by the user.optionaltrue
recovery_action_takenbooleanIndicates whether the user took any action (e.g., returned to cart, purchased) after recovery outreach.optionalfalse

Use it for

  • recovery email…62%62 of 100 rowsmean total cart value…98.0return…182.9purcha…132.0ignored

    An e-commerce dashboard

    The recovery_email_sent rate, total_cart_value by recovery_action_type and a breakdown of user_country. Excel, Power BI or Tableau.

  • Why do 62 of 100 rows have recovery_email_sent = true?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 100 rows.

  • A software demo

    Believable carts with user_id, user_email and cart_created_at 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 dataset100 rows21 columns
Yours1,000 rows21 columnsuser_country: UK only

blueprint · abandoned-cart-recovery-patterns

Behind this dataset

Same schema. As many rows as you need.

These 100 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
  • Include user ID, cart value, and abandonment timestamp.
  • Mark recovery status if a purchase is completed within 7 days.
  • Capture product categories for each cart.
  • Segment by first-time vs. repeat visitors.
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
abandoned-cart-recovery-patterns

More in E-commerce

Browse all
Also in E-commerceShopping Cart SessionsE-Commerce Reviews Sentiment DatasetE-commerce Shopping Cart AbandonmentAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.