Add "total_order_value" field to BrewwQL for Customers

[mark-kelly]

I’d like to lists in Breww which report customers by order value in the last full calendar month.

I have tried to do this using the current BrewwQL tags but I don’t think it’s possible. Basically I’d like the list to take customers that ordered £1000+ for March 2023. Another one for Customer who’s orders total between 500-100, 250-500 and so on. This will automatically segment our customers for us.

We can do this in bulk currently by reporting totals for the month and then running a bulk update by changing tags. It just takes longer to complete and replies on excel functions that add tags correctly.

Would be keen to know if this is possible to automate or whether I just have to do it the hard way once per month

[luke]

Thanks for the suggestion, Mark.

I’m afraid this isn’t possible right now, but this is the right place to be requesting it

@mark-kelly

… Customer who’s orders total between 500-100, 250-500 and so on.

It should be possible to add a field to the BrewwQL filter for the customer’s total order value.

@mark-kelly

Basically I’d like the list to take customers that ordered £1000+ for March 2023.

To support this, it would be a very substantial change, so in all honestly, I think this isn’t something that’s likely to be added to BrewwQL in the short term. The issue is that each of the variables that you can filter on are evaluated independently, so while we could add a the total order value field, this would always be treated as a total order value and not just the total in any given month. I’ve explained this in more detail in this thread:

Breww QL & 'within range' query

I’m just after a bit of help with a Breww QL query - I am trying to create a dynamic customer list using an average value within a period, but can’t seem to figure it out. Using a combination of Number of Orders, Average Spend & Last Order narrows the range, but still picks up outliers. This is the part of the query that I’m struggling with: or (type != "Distributor" and (average_order_value >= "X" and number_of_invoiced_orders >= "X" and last_order_date > "X months ago")) Ideally we are loo…

I hope this makes sense. We’ll keep the feature request thread open, as hopefully we’ll be able to support this better in the future, but it’s a long way from how the filtering works at the moment. Thank you.