Creating a Custom Metric

RichL2
Not applicable
1 0 0

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?

Replies 6 (6)
OS-Mitch
Shopify Partner
44 16 11

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!

At Oskar Studio, we help new and existing Shopify customers achieve sustainable success. We accompany you during the opening of your store or during the continuous optimization to make your store as unique as you are.
CloudlabSam
Shopify Partner
474 37 73

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
Shopify Partner
44 16 11

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

At Oskar Studio, we help new and existing Shopify customers achieve sustainable success. We accompany you during the opening of your store or during the continuous optimization to make your store as unique as you are.
CloudlabSam
Shopify Partner
474 37 73

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

Polar-Analytics
Shopify Partner
25 1 3

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

PolarAnalytics_0-1669398252919.gif

https://www.loom.com/share/e4bf5b025c854ec283885441e571f28b

 

 

 

Polar Analytics Team
Multichannel analytics software, no engineering required.
Try free for 14 days here: https://www.polaranalytics.co
Nati_Tede
New Member
6 0 0

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. 

 

Nati_Tede_0-1688633538432.png

 

I hope this helps.

 

Cheers,

Nati