Segment customers by amount spent within time frame

[merchanter]

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?

[Brendan-Optily]

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...

[brandonchaney]

@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. 

[WorkGPT1]

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.

[WorkGPT1]

Attached an video to show how it works.

 https://www.youtube.com/watch?v=D-COln8nrHQ

[AlexcJP]

Have you found a solution to this?

[eganc]

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

[rebrandskincare]

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!

[marin · Accepted solution]

You can do it with the following expression: `orders_placed(sum_amount_at_least: 1000, since: -60d) = true`