Abandonment
Returns abandonment.
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
SELECT * FROM Abandonment WHERE Id = 'Val1'
SELECT * FROM Abandonment WHERE AbandonedCheckoutPayloadId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally-unique ID. | |
| AppId | String | A globally-unique ID. | |
| CustomerId | String | A globally-unique ID. | |
| AbandonmentType | String | The abandonment type. | |
| EmailState | String | The email state (e.g., sent or not sent). | |
| InventoryAvailable | Bool | Whether the products in abandonment are available. | |
| EmailSentAt | Datetime | When the email was sent, if that is the case. | |
| MostRecentStep | String | The most recent step type. | |
| VisitStartedAt | Datetime | The date and time when the visit started. | |
| IsFromOnlineStore | Bool | Whether the abandonment event comes from the Online Store sales channel. | |
| IsFromShopApp | Bool | Whether the abandonment event comes from the Shop app sales channel. | |
| IsFromShopPay | Bool | Whether the abandonment event comes from Shop Pay. | |
| IsMostSignificantAbandonment | Bool | Whether the customer did not complete another most significant step since this abandonment. | |
| LastBrowseAbandonmentDate | Datetime | The date for the latest browse abandonment. | |
| LastCartAbandonmentDate | Datetime | The date for the latest cart abandonment. | |
| LastCheckoutAbandonmentDate | Datetime | The date for the latest checkout abandonment. | |
| DaysSinceLastAbandonmentEmail | Int | The number of days since the last abandonment email was sent to the customer. | |
| HoursSinceLastAbandonedCheckout | Double | The number of hours since the customer has last abandoned a checkout. | |
| CustomerHasNoOrderSinceAbandonment | Bool | Whether the customer has completed an order since this checkout has been abandoned. | |
| CreatedAt | Datetime | The date and time when the abandonment was created. | |
| AbandonedCheckoutPayloadId | String | A globally-unique ID. | |
| AbandonedCheckoutPayloadDefaultCursor | String | A default cursor that returns the single next record, sorted ascending by ID. | |
| AbandonedCheckoutPayloadAbandonedCheckoutUrl | String | The URL for the buyer to recover their checkout. | |
| AbandonedCheckoutPayloadLineItemsQuantity | Int | The number of products in the checkout. |