Segment customers by amount spent within time frame

merchanter
Visitor
1 0 2

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?

Replies 7 (7)

Brendan-Optily
Shopify Partner
87 10 23

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

Optily - Supercharge your ROAS (App)
Get more sales from ads with daily ad spend optimization for Google, Instagram, Facebook, YouTube and TikTok. Install for free here.

brandonchaney
Shopify Partner
1 0 0

@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
Shopify Partner
39 0 2

Hello there,

 
Wonder if you would like to give a try of our tool.
 
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.
 

ShopAutomation1_0-1666940222597.png

 

Customized ChatGPT for your Shop - Chat with your store data & tools like your virtual assistant.
WorkGPT1
Shopify Partner
39 0 2

Attached an video to show how it works.

 

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

Customized ChatGPT for your Shop - Chat with your store data & tools like your virtual assistant.

AlexcJP
Visitor
1 0 0

Have you found a solution to this?

eganc
Shopify Staff
9 0 6

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.

eganc_0-1675837837636.png

 

 

Hope that helps!

Egan

To learn more visit the Shopify Help Center or the Community Blog.

rebrandskincare
Visitor
1 0 1

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!