Creating a Custom Metric

[RichL2]

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?

[OS-Mitch]

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!

[CloudlabSam]

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.

[OS-Mitch]

Technically net sales should be gross sales - discounts - returns - taxes, so not sure if the net sales report will do the trick here.

[CloudlabSam]

Gross sales doesn't include taxes unless they're in a region where taxes are included in the price of the product.

[Polar-Analytics]

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