Can you query against nested event properties?

edparry

With data coming into Amplitude from Segment, I have an event that tracks orders that looks like the below example.

analytics.track('user@email.com', 'Order Completed', {<br />    'email': 'user@email.com',<br />    'order_id': '12345',<br />    'platform': 'Website',<br />    'products': [<br />        {<br />            'category': 'Soap',<br />            'price': 4.99,<br />            'sku': 'SP-SML'<br />        }<br />    ],<br />    'sales_channel': 'Website',<br />    'shipping': 0.0,<br />    'total': 4.99<br />})

Is it possible to create a chart that can then track the different Category values here? Bearing in mind it is possible for one of these events to have multiple products in it.

belinda.chiu

Hi edparry ! Welcome to the Amplitude Community!

I noticed you mentioned you are sending this data from Segment in which I found that “All event properties, except products, are sent as event_properties of the Amplitude “Order Completed” event. Information about each product is present only on the individual “Product Purchased” events.” https://segment.com/docs/connections/destinations/catalog/amplitude/#order-completed

Since the “category” property that you are referring to is under the “products” field, this “category” property should then be found under the Products Purchased events in which you can then create a chart looking at the category values for Products Purchased!