Help Needed: Complex Customer Segmentation (Without Paid Apps)

I’m trying to segment customers in my store based on specific criteria, without using paid apps. Here’s what I need to do:

  • Identify customers who have:
    1. Spent more than €600 in the last 6 months
    2. Made at least 3 orders in this period

The challenges:

  • Can’t figure out how to do this with Shopify Flow
  • Customer segmentation doesn’t seem to offer this level of detail
  • Don’t want to use paid apps or external services

Questions:

  1. Is there a way to create this segment using native Shopify features?
  2. If not, what’s the simplest free method to achieve this?
  3. Are there any free apps or workarounds that could help with this type of segmentation?

Any advice or alternative approaches would be greatly appreciated. Thanks!

It should be OK if you set it up like this.

Yep.. bbut the problem is that 600 in the last 6 months.. not total

I set the wrong conditions. You can change the filter conditions yourself.

wo_0-1722216749827.png

Create a new segment with the following:

orders_placed(sum_amount_at_least: 600, since: -60d ) =TRUE AND orders_placed( count_at_least: 3, since: -60d ) = true

This might do it.