SEO, AdWords, affiliates, advertising, and promotions
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?
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,
Attached an video to show how it works.
https://www.youtube.com/watch?v=D-COln8nrHQ
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
To learn more visit the Shopify Help Center or the Community Blog.
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!
We recently spoke with Zopi developers @Zopi about how dropshipping businesses can enha...
By JasonH Oct 23, 2024A big shout out to all of the merchants who participated in our AMA with 2H Media: Holi...
By Jacqui Oct 21, 2024We want to take a moment to celebrate the incredible ways you all engage with the Shopi...
By JasonH Oct 15, 2024