Abandonment
Summarizes visit-level abandonment metrics and context for unfinished checkouts.
View-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.
- Id supports the '=, IN' comparison operators.
- AbandonedCheckoutPayloadId supports the '=, IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM Abandonment WHERE Id = 'Val1'
SELECT * FROM Abandonment WHERE AbandonedCheckoutPayloadId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The globally unique identifier of the abandonment event. | |
| AppId | String | The globally unique identifier of the app that recorded or triggered this abandonment. | |
| CustomerId | String | The globally unique identifier of the customer associated with this abandonment. | |
| AbandonmentType | String | The type of abandonment event, such as browse, cart, or checkout. | |
| EmailState | String | The current status of abandonment recovery emails, such as sent or not sent. | |
| InventoryAvailable | Bool | Indicates whether the products linked to the abandonment are still in stock. | |
| EmailSentAt | Datetime | The date and time when the abandonment recovery email was sent, if applicable. | |
| MostRecentStep | String | The most recent customer action or step type recorded before the abandonment. | |
| VisitStartedAt | Datetime | The date and time when the customer's visit that led to abandonment began. | |
| IsFromOnlineStore | Bool | Indicates whether the abandonment originated from the Online Store sales channel. | |
| IsFromShopApp | Bool | Indicates whether the abandonment originated from the Shop app sales channel. | |
| IsFromShopPay | Bool | Indicates whether the abandonment originated from the Shop Pay channel. | |
| IsMostSignificantAbandonment | Bool | Indicates whether this abandonment is the customer's most significant one, meaning no more critical step has been abandoned since. | |
| LastBrowseAbandonmentDate | Datetime | The date and time of the customer's most recent browse abandonment. | |
| LastCartAbandonmentDate | Datetime | The date and time of the customer's most recent cart abandonment. | |
| LastCheckoutAbandonmentDate | Datetime | The date and time of the customer's most recent checkout abandonment. | |
| DaysSinceLastAbandonmentEmail | Int | The number of days since the customer last received an abandonment recovery email. | |
| HoursSinceLastAbandonedCheckout | Double | The number of hours since the customer last abandoned a checkout. | |
| CustomerHasNoOrderSinceAbandonment | Bool | Indicates whether the customer has placed an order since this checkout was abandoned. | |
| CreatedAt | Datetime | The date and time when the abandonment record was created. | |
| IsFromCustomStorefront | Bool | Indicates whether the abandonment originated from a custom storefront sales channel. | |
| AbandonedCheckoutPayloadId | String | The globally unique identifier of the abandoned checkout payload linked to this abandonment. | |
| AbandonedCheckoutPayloadDefaultCursor | String | A default cursor that returns the next abandoned-checkout payload record in ascending order by Id. | |
| AbandonedCheckoutPayloadAbandonedCheckoutUrl | String | The recovery URL the buyer can use to return to their abandoned checkout. |