Shopify-based customer segment filters

• Today:= today
• Yesterday:= yesterday
• In the last 7 days:>= 7_days_ago
• In the last 30 days:>= 30_days_ago
• In the last 90 days:>= 90_days_ago
• In the last 12 months:>= 12_months_ago

Include customers who last abandoned their cart within the last week:abandoned_checkout_date >= 7_days_ago

Include customers who last abandoned their cart within the last eight months:abandoned_checkout_date > -8m

• Today:= today
• In the next 7 days:BETWEEN today AND +7d
• In the next 30 days:BETWEEN today AND +30d

Include customers with a birthday in the next 30 days:
anniversary(date: 'metafields.facts.birth_date') BETWEEN today AND +30d

• The year is is not used to segment when using absolute dates.
• Date values are based on entire days and depend on which time zone your store is in.
• To filter on birth dates, you need to either enable thefacts.birth_datestandard metafield or create your own custom metafield. Learn more aboutadding standard metafieldsorcreating custom metafield definitions.

• The currency that is used is based on the currency that is selected for your store. Don't specify which currency is used by entering a currency symbol.
• BETWEENincludes both the start and the end values. For example,amount_spent BETWEEN 1 AND 100includes customers who have spent at least 1 and as much as 100.

• When you create the customer segment, you can select the company by its name from the list that's displayed. Alternatively, you can start typing the title of the company, and then select it from the list.
• The company ID, not the company name, is entered into the code. When you hover your cursor over the company ID, the company name is displayed.

• When you create the customer segment, you can select an app by its name from the list that's displayed. Alternatively, you can start typing the name of the app, and then select it from the list.
• The app ID, not the app name, is entered into the code. When you hover your cursor over the app ID, the app name is displayed.

• Today:= today
• Yesterday:= yesterday
• In the last 7 days:>= 7_days_ago
• In the last 30 days:>= 30_days_ago
• In the last 90 days:>= 90_days_ago
• In the last 12 months:>= 12_months_ago

Include customers who were added within the last week:
customer_added_date >= 7_days_ago

Include customers who were added within the last eight months:
customer_added_date > -8m

Include customers who were added during a specific date range:
customer_added_date BETWEEN 2022-12-01 AND 2022-12-31

The following domain names are offered as suggestions. You're not limited to these domain names. You can manually enter any other valid domain names.

The following values are examples of some common ISO language codes. Your data isn't limited to these language codes. You can manually enter any other valid language codes, but the values that are offered to you as suggested values in the editor are the only ones that are available in your customer data.

Include customers who communicate with your store in English:
customer_language = 'en'

Exclude customers who communicate with your store in Canadian English:
customer_language != 'en‑CA'

• You can add the locale ISO code to the value to specify a dialect for that language. For example, you can use'en‑US'for the United States and'en‑GB'for the United Kingdom, or'pt‑PT'for Portugal and'pt‑BR'for Brazil.
• The filter value acts as a wildcard if only the language prefix is specified. For example, if the filter value is'en', then your results include customers whose language is set to'en'and customers whose language is set to'en‑GB',“en - CA”, and so on.

Tags are not case sensitive.

Learn more about tags and their considerations.

• When you create a customer segment using theactivity_idparameter, you can select the marketing activity by its name from the list that's displayed.
• Due to data retention, the absence of bothsinceanduntilparameters means that results will be filtered for the last 26 months, with no set start or end date.
• Absence ofactivity_idmeans that your filter includes all Shopify email activities.

• Today:= today
• Yesterday:= yesterday
• In the last 7 days:>= 7_days_ago
• In the last 30 days:>= 30_days_ago
• In the last 90 days:>= 90_days_ago
• In the last 12 months:>= 12_months_ago

Include customers whose last order was placed since last week:
last_order_date >= 7_days_ago

Include customers whose last order was placed since eight months ago:
last_order_date > -8m

count_at_least(可选):使用该参数指定迷你mum number of times an order was placed.

count_at_most(optional): Use this parameter to specify the maximum number of times an order was placed.

count(可选):使用该参数指定exact number of times an order was placed.

amount_at_least(可选):使用该参数指定迷你mum amount spent on an order.

amount_at_most(optional): Use this parameter to specify the maximum amount spent on an order.

amount(可选):使用该参数指定exact amount spent on an order.

sum_amount_at_least(可选):使用该参数指定迷你mum amount spent on all orders.

sum_amount_at_most(optional): Use this parameter to specify the maximum amount spent on all orders.

sum_amount(optional): Use this parameter to specify the amount spent on all orders.

since(optional): Use this parameter to specify a start date for the event.

until(optional): Use this parameter to specify an end date for the event.

Is equal to:=

Is not equal to:!=

Supported formats forcount_at_least,count_at_most,count:
Number:#

Supported formats foramount_at_least,amount_at_most,amount:
Number:#

Supported formats forsum_amount_at_least,sum_amount_at_most,sum_amount:
Number:#

SupportedDateformats forsinceanduntil:
Absolute date:YYY-MM-DD
Date offset examples:

7 days ago::-7d
4 weeks ago::-4w
3 months ago::-3m
1 year ago::-1y

Named date:

• Today::today
• Yesterday::yesterday

The named dates are default values and can't be changed.

orders_placed() = true

orders_placed() = false

Filter customers that placed more than 3 orders (inclusive) in the last 6 months:

orders_placed(count_at_least:3, since:-6m) = true

Filter customers that spent more than $1000 (inclusive) in the last 3 months:

orders_placed(sum_amount_at_least: 1000, since:-90d) = true

Filter customers that spent less than $100 (inclusive) last week:

orders_placed(sum_amount_at_most: 100, since:-7d) = true

Filter customers that spent more than $1000 (inclusive) and placed more than 3 orders (inclusive) since January 1, 2023:

orders_placed(sum_amount_at_least: 1000, count_at_least: 3, since: 2023-01-01) = true

In date ranges, the order of thesinceanduntilparameters doesn't matter. You can express between January 1, 2023 and June 1, 2023 (inclusive) in either of the following ways:

Between January 1, 2023 and June 1, 2023 (inclusive):

orders_placed(count_at_least:3, since: 2023-01-01, until: 2023-06-01) = true

Between January 1, 2023 and June 1, 2023 (inclusive):

orders_placed(count_at_least:3, until: 2023-06-01, since: 2023-01-01) = true

• When you hover your cursor over the amount, the currency used to filter your customers is displayed.
• When you hover your cursor over the following syntax:
  amount_at_least,amount_at_mostamount,sum_amount_at_least,sum_amount_at_mostsum_amountthe description of the syntax is displayed.
• Absence ofparametersmeans that your filter includes all orders placed for all time.

In date ranges, the order of thesinceanduntilparameters doesn't matter. You can express between January 1, 2022 and June 1, 2022 (inclusive) in either of the following ways:

• When you create the customer segment using theidparameter, you can select the product by its name or image from the list that's displayed. Alternatively, you can start typing the title of the product, and then select it from the list.
• The product ID, not the product title, is entered into the code. When you hover your cursor over the product ID, the product title and image are displayed.
• Absence of bothsinceanduntilparameters means that results will be filtered for all time, with no set start or end date.
• Absence ofparametersmeans that your filter includes all products purchased for all time

In date ranges, the order of thesinceanduntilparameters doesn't matter. You can express between January 1, 2023 and June 1, 2023 (inclusive) in either of the following ways:

• When you create the customer segment using theidparameter, you can select the product or collection by its name or image from the list that's displayed. Alternatively, you can start typing the title of the product or collection, and then select it from the list.
• The product or collection ID, not the title, is entered into the code. When you hover your cursor over the ID, the product or collection title and image are displayed.
• 使用图像保存为集合集合thumbnail, if applicable. If not, a generic image placeholder will be displayed.
• Due to data retention, the absence of bothsinceanduntilparameters means that results will be filtered for the last 26 months, with no set start or end date.
• Absence ofidmeans that your filter includes all products.