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!
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.
1 Like