Advanced Query Help

[caretucker]

Hello, 

Since there is a 90 day limitation on the wait function in Flow, I'm trying to find a work around to tag customers as "Abandoned" if they haven't placed an order in 120 days. 

My idea is to create a scheduled flow that runs daily and pulls customer data for customers with no order in the last 120 days and are not already tagged "Abandoned".  However, when I test this its not pulling any data. Which it should, because we definitely have customers who haven't ordered in the last 120 days and no customers were manually tagged Abandoned. 

See below screenshots:

TIA!

[tim]

Consider trigger "Customer joined a segment" and create a segment 

[caretucker]

Thanks for the suggestion!

[caretucker · Accepted solution]

I kept playing with it and got it to work. Below is the working coding in case anyone else is having similar issues.

@tim offered a great workaround as well