I am trying to create a customer segment of people who purchased between a specific date range and purchased a specific product. My ShopifyQL query is returning customers who purchased the product within that range and some, not all, who purchased outside that range.
Here’s the query:
FROM customers
SHOW customer_name, note, subscription_status, location, orders, amount_spent
WHERE orders_placed MATCHES (
date BETWEEN 2024-11-01 AND 2025-04-22
) AND products_purchased MATCHES (
id = 4817182851
) OR products_purchased MATCHES (
id = 7802296172780
)
I ONLY want to see customers who purchased those 2 products between those 2 dates.