AbandonmentProductsViewed
Returns products viewed during sessions that later resulted in an abandoned checkout.
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.
- AbandonmentId supports the '=, IN' comparison operators.
- AbandonedCheckoutPayloadId supports the '=, IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM AbandonmentProductsViewed WHERE AbandonmentId = 'Val1'
SELECT * FROM AbandonmentProductsViewed WHERE AbandonedCheckoutPayloadId = 'Val1'
Columns
| Name | Type | References | Description |
| AbandonmentId | String |
Abandonment.Id | The globally unique identifier of the abandonment event in which the product was viewed. |
| AbandonedCheckoutPayloadId [KEY] | String | The globally unique identifier of the abandoned checkout payload linked to this product view. | |
| ProductId [KEY] | String | The globally unique identifier of the product that the customer viewed. | |
| VariantId [KEY] | String | The globally unique identifier of the specific product variant that the customer viewed. | |
| Quantity | Int | The number of product units displayed to the customer during the view event, typically representing the default or available quantity rather than a requested amount. |