Unable to filter by Item properties

Question

I have a custom integration, and for the Placed Order event, there is an array of Items. The data seems to be coming through ok (see example below), but I’m unable to see “Item” as a filter option.

My specific use case, is I want to be able to filter by by the Item.ProductID property of the items purchase in the event.

Example event (blurred some URLs):

As you can see in the above event, there is an array of Items that include ProductID, ImageURL, and other properties.

Trigger filter is missing “Item” filters, I can only filter by top level properties. Is this expected behavior? If not, how can I troubleshoot this?

saulblum · Accepted Answer

You can only segment and filter ontop-levelproperties of the JSON block.https://developers.klaviyo.com/en/docs/guide_to_integrating_a_platform_without_a_pre_built_klaviyo_integration#added-to-cart-tracking-snippetYou can add as many key/value pairs as you’d like to the JSON payload, with one restriction: you can only use top-level properties in the JSON when addingfilters to segmentsbased on this event (Added to Cartin this case). That is why there is a top-level propertyAddedItemCategoriesin the below example that is the union of uniqueProductCategoriesvalues of each of the products in the Items array. With this top-level property, you can create a segment of profiles who have viewed products in specific categories.

retention · Answer

Hi ​@cwdev, following up on what ​@saulblumstated, since Klaviyo only lets you filter on the root node of an event’s payload (and not into nested arrays), you can break out andcreate a separate “ProductIDs” with just an array of the various product IDs similar to how you did it with “ItemNames.” That should let you then filter by the specific ProductID. Let us know if that worked!

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials

Scanning file for viruses.

This file cannot be downloaded