What’s new in Shopify

We've added MATCHES to the ShopifyQL editor in Analytics so you can filter your reports by what customers did, not just who they are. You can now use MATCHES in the WHERE clause to filter by customer behavior.

For example, you may want to see customers who purchased at least 2 products in the last 30 days.

sql
FROM customers
SHOW customer_id, email
WHERE products_purchased MATCHES (quantity >= 2, date >= -30d)
GROUP BY customer_id


The same MATCHES logic you use in Customer Segmentation works in Analytics, so your segments and reports stay consistent.

For syntax, examples, and limitations, see the Shopify Help Center.