All things Shopify and commerce
Hi, this may be a silly question, but I can't find this anywhere. I just want to create a field in Shopify Analytics called Gross Sales Less Discount (GSLD) that is simply (Gross Sales) - (Discounts), so I don't have to keep exporting data and doing this manually. Is this possible?
Hi @RichL2 ,
there's actually a pre-made report just like that (if I understand you correctly).
If you're on Shopify Advanced or Plus, simple go to Reports and search for the sales/revenue after discounts report.
Hope that helps!
Net sales is actually Gross - Discounts - Returns. So if you ran a sales report excluding returns it would return the number you're looking for.
Technically net sales should be gross sales - discounts - returns - taxes, so not sure if the net sales report will do the trick here.
Gross sales doesn't include taxes unless they're in a region where taxes are included in the price of the product.
Hi @RichL2 , if you find yourself limited by Shopify Analytics. You can try out Polar Analytics which has a dedicated Custom Metrics function. This can be done by anyone, without any SQL skills.
Here is how it looks:
Gross Sales Less Discount (GSLD) | Polar Analytics - 25 November 2022 - Watch Video
https://www.loom.com/share/e4bf5b025c854ec283885441e571f28b
User | RANK |
---|---|
69 | |
49 | |
37 | |
34 | |
29 |
Learn these 5 things I had to learn the hard way with starting and running my own business
By Kitana Jan 27, 2023Would you love to unleash the unbridled power of the Google Shopping Channel into your sho...
By Gabe Jan 6, 2023How can you turn a hobby into a career? That’s what Emmanuel did while working as a wa...
By Skye Dec 30, 2022