I'm trying to create a dynamic customer group and want to create different groups based on the amount a customer spends in a year.
The issue at the moment is that the search for dynamic customer grouping isn't allowed to use grouping on the results, so I'm not sure how to create the search I need for this.
The only possible way I could think of was to do a customer search with a summary critera (as summary on criteria is allowed for dynamic group search) for transaction amount and then put a criteria of last year. This however is still returning all of my customers, I'm only able to get an accurate list of customers when grouping the results.
Any ideas how I can achieve this? For this first example, I'm hoping the search will only return customers that spent less that £5000 with us last year.
I'm thinking I may instead need to create a scheduled script that uses a search with grouping and updates the total yearly customer spend to a field on the customer record.
I've tried to create a script but am having difficulty updating the group with new customers because 1. Can't interact with a static group and 2. Can't create a Dynamic Group without a saved search. I'm going to try creating a dynamic group but with a bogus saved search.
The results I get:
If I change the name result to group I get an accurate result, as I imagine it is now grouping the amounts properly in the background. This is what I would hope to get: