Hi @DaveMcV , thank you for your reply. I am already using segment to filter out this list of customers and tagging them manually.
Would you be able to guide me on how to use the query within Flow. This is the part that I’m having a real tough time with. It feels silly but I don’t seem to be able to use order_date correctly.
Can you define what order_date is? I’ve tried using it but I cannot get the following queries with the right result.
I’ve tried " query: “order_date:‘2024-02-10’” sortKey: LAST_ORDER_DATE" within GraphiQL App but it shows far more customers than the customers who ordered on 2024-02-10.
I’ve also tried “query: “order_date:<‘2024-02-10’” sortKey: LAST_ORDER_DATE” and I get a list of customers who’s last order is before 2024-02-10.
The only query I’ve had success is " query: “order_date:>‘2024-02-10’” sortKey: LAST_ORDER_DATE" and I get a list of customers who’s last order is after 2024-02-10.
Much appreciated for your help!