Use MATCHES in ShopifyQL to filter by what customers did
- Topic
- Analytics
- Source
- Shopify Changelog
- Published
This summary was written by ShopDigest AI from Shopify Changelog’s report. Read the full story ↗
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 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.
Overview
Shopify added MATCHES to the ShopifyQL editor in Analytics, letting merchants filter reports by customer behavior rather than just customer attributes. The same MATCHES logic used in Customer Segmentation now works in Analytics, keeping segments and reports consistent.
Key Details
- MATCHES can be used in the WHERE clause to filter by what customers did.
- Example: show customers who purchased at least 2 products in the last 30 days.
- Syntax, examples, and limitations are documented in the Shopify Help Center.

