Abandonment
Tracks abandonment sessions that capture customer behavior during incomplete checkouts.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- 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 | A unique identifier for the abandonment record. | |
| AppId | String | The unique identifier of the app or integration that detected or created this abandonment event. | |
| CustomerId | String | The unique identifier for the customer associated with this abandonment instance. | |
| AbandonmentType | String | Specifies the type of abandonment, such as browse, cart, or checkout, based on where the customer left the session. | |
| EmailState | String | Indicates the status of the abandonment recovery email, such as sent or unsent. | |
| InventoryAvailable | Bool | Indicates whether the products involved in the abandonment are still available in inventory. | |
| EmailSentAt | Datetime | The timestamp showing when the abandonment recovery email was sent, if applicable. | |
| MostRecentStep | String | The most recent step the customer reached before abandoning their session, such as viewing a product or adding to cart. | |
| VisitStartedAt | Datetime | The date and time when the customer's browsing session 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 occurred during a checkout using Shop Pay. | |
| IsMostSignificantAbandonment | Bool | Indicates whether this abandonment represents the most significant incomplete interaction, with no subsequent higher-value actions completed. | |
| LastBrowseAbandonmentDate | Datetime | The timestamp of the customer's most recent browse abandonment event. | |
| LastCartAbandonmentDate | Datetime | The timestamp of the customer's most recent cart abandonment event. | |
| LastCheckoutAbandonmentDate | Datetime | The timestamp of the customer's most recent checkout abandonment event. | |
| DaysSinceLastAbandonmentEmail | Int | The number of days since the customer last received an abandonment recovery email. | |
| HoursSinceLastAbandonedCheckout | Double | The number of hours since the customer most recently abandoned a checkout session. | |
| CustomerHasNoOrderSinceAbandonment | Bool | Indicates whether the customer has not completed a purchase since this abandonment event occurred. | |
| CreatedAt | Datetime | The date and time when the abandonment record was created in Shopify. | |
| IsFromCustomStorefront | Bool | Indicates whether the abandonment originated from a custom storefront built through Shopify's Storefront API. | |
| AbandonedCheckoutPayloadId | String | A unique identifier linking to the payload record associated with the abandoned checkout. | |
| AbandonedCheckoutPayloadDefaultCursor | String | A cursor used to sequentially retrieve the next available abandoned checkout record in ascending order by ID. | |
| AbandonedCheckoutPayloadAbandonedCheckoutUrl | String | The recovery URL provided to the buyer to resume and complete their abandoned checkout. |