Hi there, not sure how you can get it on Shopify Analytics as you would have to create custom rules.
It's however something you can easily get done on Polar Analytics as we integrate with Shopify and 15+ other apps like Facebook, GA, Google Ads, Tiktok, Pinterest, etc.
Feel free to schedule a demo so that we can show you: https://www.polaranalytics.co/contact
Hi @gypsy-beach ,
Tiia here from Better Reports support team.
Yes, I would recommend our app Better Reports for this. We can create a custom report that filters for a specified collection or product tag and lists the sales metrics by the products within that collection/tag along with their assigned SKU. Additionally, we can also create a report that lists the sales metrics by SKU. All of our reports can be exported directly as csv, pdf, or Excel.
You can also schedule a report to be sent automatically to your email or Google Drive at a regular cadence (say weekly/monthly/quarterly).
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.
Let me know how you go and feel free to reach out if you have any further questions.