Claudia here from Better Reports.
Have you been able to find a solution to this? If not, I would recommend our app Better Reports.
We can use metafields to filter reports, and can absolutely create sales report based on the various customer segments.
In addition to this, 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?