Tag Orders Based On Customer Lifetime Duration

[jordanmaskell]

Hello!

For customer segmentation purposes, I would like to be able to tag orders based on the lifetime duration of the customer at the point the order is placed.

I have tried creating a flow based on order creation and then using the get order data action with the below advanced query.

{{order.customer.createdAt}}:< {{ "now" | date_minus: "29 days" }}

To test the process I am then setting an action to send myself an email with the order ID of orders that were retrieved. The issue I am facing though is that it returning all orders wether they meet the intended criteria or not.

Does anyone know how this can be achieved?

[Kalen_Jordan]

Do you see the order.customer.createdAt value in the logs for when it runs? If that field were to be empty, then it would pass that condition for all orders.

[BetterReports-C]

Hi @jordanmaskell 

Claudia here from Better Reports.

Have you been able to find a solution for this? If not, I would recommend our app Better Reports.

We can create a custom field using the existing data to pull orders that were placed within a specific time frame since the customer was created.

In addition, Better Reports has more than 60 built-in reports available out of the box that cover many common use cases for merchants. You can schedule reports to run at set frequencies to your email or Google Drive or export the reports in CSV, Excel or PDF format.

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.

What do you think?