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.

In this section

Can’t find the answers you’re looking for? We’re here to help.