AbandonmentProductsViewed
Lists products viewed by a customer during an abandoned visit, providing insight into browsing interest.
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.
- 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 unique identifier of the abandonment record linked to the viewed product activity. |
| AbandonedCheckoutPayloadId [KEY] | String | The unique identifier connecting this product view to its related abandoned checkout payload. | |
| ProductId [KEY] | String | A unique identifier for the product that the customer viewed during the browsing session. | |
| VariantId [KEY] | String | A unique identifier for the specific variant of the viewed product, if applicable. | |
| Quantity | Int | The number of units of the viewed product variant that the customer expressed interest in or interacted with during the session. |