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

[Nati_Tede]

Hi, I'm Nati from the team at BeProfit (profit analysis for Shopify).

This would be possible with BeProfit, in addition to our dedicated Discounts analytics page which really gives you insights into discount performance, including sales , gross profits & margins, and more. 

I hope this helps.

Cheers,

Nati