Return management just got easier! We’ve launched Customer Self-Serve Returns to all Shopify merchants. Click here to learn more!

Creating a Custom Metric

RichL2
New Member
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 5 (5)
OS-Mitch
Shopify Partner
37 12 10

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
394 27 54

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
37 12 10

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
394 27 54

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