I’d like to segment my customers into categories that are filtered in such a way as this one.
Select all customers where the amount_spent > 1000 within the last 60 days.
Does anyone know how to filter such customers?
Topic summary
A merchant seeks to segment customers who spent over $1,000 within the last 60 days. Several solutions and workarounds are proposed:
Native Shopify Options:
- Shopify’s customer segmentation components were referenced as a starting point
- An initial workaround suggested combining
amount_spent > 1000withproducts_purchased(since: -60d) = true, though this doesn’t perfectly isolate spending within the 60-day window (it could include historical spending) - A more precise solution emerged:
orders_placed(sum_amount_at_least: 1000, since: -60d) = trueappears to properly filter by amount spent within the timeframe
Alternative Tools:
- Email service providers like Drip can handle this segmentation natively
- Third-party automation tools (ShopAutomation/ShopFlex) were suggested, with demo materials showing customer segmentation by spending and automated email marketing integration
Use Cases Mentioned:
- Syncing valuable customer segments to Facebook and Google for remarketing and lookalike audiences, reportedly delivering higher return on ad spend
- Identifying most loyal customers within specific periods rather than lifetime totals
Status: The discussion appears resolved with the final expression providing the needed functionality, though feature enhancement requests were noted for native Shopify filters.
2 Likes
Hi @merchanter
I think everything you need is here: Components of a customer segment · Shopify Help Center
This is a really useful thing to do, especially if you set up a connection with your CRM or email system. We also see a lot of Shopify merchants now automatically populating Facebook and Google audiences with their most valuable customer segments for both remarketing and creating lookalikes. It understandably delivers a much higher return on ad spend than nearly any other audience segment.
I hope this helps…
@merchanter
Hope all is well! I am just curious as to how you will use that segment once you have created it? BTW you can usually do this within your ESP…Drip is built really well to handle this type of segmentation FWIW.
Hello there,
Wonder if you would like to give a try of our tool.
https://ap.shopflex.io/use-cases
You can segment the customer by their spending amount, purchase products or any specific tag.
And then you can automatically send them to specific email marketing content.
Attached an video to show how it works.
Have you found a solution to this?
Hi Merchanter
Today the amount_spent filter cannot give you the amount within a date range, but I will pass on that feedback. In the meantime, this filter can get you to something similar:
amount_spent > 1000 AND products_purchased(since: -60d) = true
This gives you customers where the amount spent is >1000 AND has an order in the last 60 days. But, it could be that they spent $900 last year, and $200 on an order in the last 60 days, so it’s not perfectly what you are looking for.
Hope that helps!
Egan
I would also benefit from an update to these filters! I’d really like to see how many customers spent X within a time frame in order to determine my most loyal customers for the year (not of all time). Thanks for passing on the suggestion!
1 Like
You can do it with the following expression: orders_placed(sum_amount_at_least: 1000, since: -60d) = true