Abandoned Cart Recovery

This dataset provides detailed records of abandoned shopping carts from an e-commerce platform, including customer identifiers, cart contents, timestamps, recovery attempts, and outcomes. It enables in-depth analysis of cart abandonment patterns, campaign effectiveness, and customer behavior to optimize checkout processes and boost conversion rates.

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

Analyzing cart abandonment trends and identifying drop-off points in the checkout process

Sample rows

preview · 8 of 80 rows · all 18 columns
cart_idstringdevice_typestringcart_total_valuefloatrecovery_email_sentbooleancustomer_countrystringcustomer_idstringcustomer_emailstringcart_created_atdatetimecart_abandoned_atdatetimecurrencystringitem_countintegerproduct_idsstringbrowserstringrecovery_email_sent_atdatetimerecoveredbooleanrecovered_atdatetimerecovery_channelstringrecovery_campaign_idstring
CART10001mobile87.45trueUSCUS9001lisa.martin@gmail.com2023-09-21T13:48:15Z2023-09-21T14:18:21ZUSD3PROD1001,PROD1005,PROD1012Safari2023-09-21T15:07:00ZfalseblankemailCAMPAIGN_A
CART10002desktop154.98trueUSCUS9002andrews_lee@hotmail.com2023-10-03T18:22:07Z2023-10-03T18:57:42ZUSD5PROD1003,PROD1004,PROD1020,PROD1002,PROD1018Chrome2023-10-03T19:10:00Ztrue2023-10-03T20:03:18ZemailCAMPAIGN_B
CART10003tablet41.2falseFRCUS9003sophie.dupont@yahoo.fr2023-11-15T10:46:32Z2023-11-15T11:35:14ZEUR2PROD1010,PROD1023Firefoxblankfalseblankblankblank
CART10004mobile319.87trueCNCUS9004kevin.zhao@163.com2023-11-05T08:17:12Z2023-11-05T09:10:44ZCNY7PROD1016,PROD1017,PROD1025,PROD1011,PROD1009,PROD1022,PROD1027Chrome2023-11-05T09:30:00ZfalseblanksmsCAMPAIGN_D
CART10005desktop58trueBRCUS9005maria.silva@gmail.com2023-10-29T17:55:23Z2023-10-29T18:41:58ZBRL1PROD1019Edge2023-10-29T19:15:00Ztrue2023-10-29T20:10:07ZemailCAMPAIGN_A
CART10006desktop79.99falsePLCUS9006peter.kowalski@onet.pl2023-11-12T12:01:09Z2023-11-12T12:45:50ZPLN2PROD1006,PROD1021Chromeblankfalseblankblankblank
CART10007mobile121.5falseKRCUS9007julia.kim@naver.com2023-10-03T04:30:11Z2023-10-03T05:15:24ZKRW3PROD1014,PROD1028,PROD1020Samsung Internetblankfalseblankblankblank
CART10008desktop33.5falseUSCUS9002andrews_lee@hotmail.com2023-11-09T19:10:52Z2023-11-09T19:44:33ZUSD1PROD1008Chromeblankfalseblankblankblank

What the 80 rows show

from the 80-row sample
  • 53%recovery_email_sent = true
  • 88.7median cart_total_value
  • 3recovery channels
  • 7browsers
  • 20currencies
  • 3median item_count
device_type80 rows by value
0204033desktop41%28mobile35%19tablet24%
cart_total_value80 rows, in bands of 50
020401236149404010250450cart_total_value →

Median 88.7, from 25.0 to 410.6.

customer_country80 rows · top 10 of 36 values
  1. US12
  2. United States8
  3. Sweden5
  4. France4
  5. BR3
  6. PL3
  7. United Kingdom3
  8. Japan3
  9. FR2
  10. DE2
18 columns by typefrom the column list below
  • string 10
  • integer 1
  • float 1
  • datetime 4
  • boolean 2

Columns

18 columns in four groups
blueprint · 18 columns
columntypedescriptionexample
Text 10 columns
cart_idstringUnique identifier for the abandoned cart session.uniqueCART10001
customer_idstringUnique identifier for the customer who created the cart.CUS9001
customer_emailstringEmail address of the customer associated with the abandoned cart.lisa.martin@gmail.com
currencystringCurrency code for the cart's total value (e.g., USD, EUR).USD
product_idsstringComma-separated list of product IDs included in the abandoned cart.PROD1010,PROD1023
device_typestringType of device used to create the cart (e.g., desktop, mobile, tablet).desktop · mobile · tablet · optionalmobile
browserstringBrowser used by the customer during the cart session.7 browsers · optionalSafari
customer_countrystringCountry of the customer at the time of cart creation.optionalUS
recovery_channelstringChannel used for recovery attempt (e.g., email, SMS, push_notification).email · sms · push_notification · optionalemail
recovery_campaign_idstringIdentifier of the marketing campaign used for cart recovery.optionalCAMPAIGN_A
Numbers 2 columns
cart_total_valuefloatTotal monetary value of all items in the abandoned cart.0 or more87.45
item_countintegerTotal number of items in the abandoned cart.1 or more3
Dates and times 4 columns
cart_created_atdatetimeTimestamp when the cart was initially created.2023-09-21T13:48:15Z
cart_abandoned_atdatetimeTimestamp when the cart was considered abandoned (e.g., after inactivity).2023-09-21T14:18:21Z
recovery_email_sent_atdatetimeTimestamp when the recovery email was sent (if applicable).optional2023-09-21T15:07:00Z
recovered_atdatetimeTimestamp when the cart was recovered (if applicable).optional2023-10-03T20:03:18Z
True or false 2 columns
recovery_email_sentbooleanIndicates whether a recovery email was sent for this abandoned cart.true
recoveredbooleanIndicates whether the abandoned cart was recovered (i.e., customer completed the purchase).false

Use it for

  • recovery email…53%42 of 80 rowsmean cart total value…101.0desktop116.3mobile124.5tablet

    An e-commerce dashboard

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

  • Why do 42 of 80 rows have recovery_email_sent = true?

    A class exercise

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

  • A software demo

    Believable carts with customer_id, customer_email and cart_created_at to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 18 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 dataset80 rows18 columns
Yours1,000 rows18 columnscustomer_country: UK only

blueprint · abandoned-cart-recovery

Behind this dataset

Same schema. As many rows as you need.

These 80 rows came out of a blueprint — 18 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
  • Carts abandoned over 24 hours notified
  • Abandoned carts must have at least one item
  • Repeat abandoners flagged for special offers
  • Notification open rate tracked per campaign
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

More in E-commerce

Browse all
Also in E-commerceShopping Cart SessionsE-commerce Packaging Sustainability IndexE-Commerce Reviews Sentiment DatasetAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.