Hi,
I need to see in Breww a view of customers that haven’t ordered in the past 3 months. So I can retarget them. Is there a way I can see this report?
Sure! You can do this using BrewwQL and a customer list. Please have a look at our article on Customer lists. The BrewwQL you’d need in this case would be:
number_of_invoiced_orders > 0 and last_order_date < "3 months ago"
The ‘numbers_of_invoiced_orders’ part ensures that the list isn’t clogged with customers who have never ordered.
Depending on how you want to view the customers, you could also do this with a ‘Customers & suppliers’ report within the Reporting section of Breww (instead of a customer list).
Let me know if you need any further help.