Add Insight data information to your Liquid markup block:
Use Liquid to select a specific collection:
{% assign orders_data = contact.insight.orders | sort: 'purchase_date' %}
This snippet uses the contact scope, selecting Insight data for the orders collection:
contact.insight.orders
This sorts it by the purchase date:
sort: 'purchase_date'
Add orders_data:
{% for orders in orders_data | limit:10 %} ...{% endfor %}
orders_data is a list of orders ordered by purchase_date.
Learn more in Filter Liquid outputs.
Enter the products field:
{% assign products_data = orders.products | sort: 'price' | reverse %}
The products field is another list, so it needs to be looped through:
{% for products in products_data %} ... {% endfor %}
Show specific products data:
<p>product price: ##{{ products.price }}</p>
Full code snippet example
{% assign orders_data = contact.insight.orders | sort: 'purchase_date' %}
{% for orders in orders_data | limit:10 %}
{% assign products_data = orders.products | sort: 'price' | reverse %}
{% for products in products_data %}
<p>product name: ##{{ products.name }}</p>
<p>product price: ##{{ products.price }}</p>
{% endfor %}
{% endfor %}You can also include:
<p>##{{ orders.purchase_date | date }}</p>
{% assign orders_data = contact.insight.orders | sort: 'purchase_date' %}
{% for orders in orders_data | limit:10 %}
<p>##{{ orders.purchase_date | date }}</p>
{% assign products_data = orders.products | sort: 'price' | reverse %}
{% for products in products_data %}
<p>product name: ##{{ products.name }}</p>
<p>product price: ##{{ products.price }}</p>
{% endfor %}
{% endfor %}
