Returns abandonment.

View-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators:

• Id supports the '=' comparison operator.
• AbandonedCheckoutPayloadId supports the '=' comparison operator.

The connector processes other filters client-side within the connector.

For example, the following queries are processed server-side:

SELECT * FROM Abandonment WHERE Id='VALUE'

SELECT * FROM Abandonment WHERE AbandonedCheckoutPayloadId='VALUE'

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.