Customer segment reference guide
The ShopifyQL query editor represents the customer segment as a database query using ShopifyQL, or Shopify Query Language. To customize your customer segment, you must update the values in the WHERE
clause to include the filters that you want to use. The default query is formatted as follows, with the [filters, operators, values]
representing the space where you add your custom segment content:
FROM customers
SHOW customer_name, note, subscription_status, location, orders, amount_spent
WHERE [filters, operators, values]
ORDER BY updated_at
Use this reference guide to understand the filter names, operators, and values that are used to build customer segments.