Sales Report Metrics

The Sales report dashboard in Shopify's UI contains a few key metrics about your store (Gross Sales, Net Sales, Returns, Discounts, etc). These metrics are not available through the Shopify API that we are using – they are however sometimes possible to recreate using the raw values available in Funnel. You can view Shopify's own description of the metrics here.


Why do I have to do this, why are the metrics not just added to the connector out of the box?

That's a good question. We have discovered that different Shopify setups seem to produce different calculations for these metrics.

But by reading Shopify's article about the sales report metrics and creating calculations using the raw values in Funnel, one can almost always get a matching report but not every time.


How to create a metric

This is how Shopify describes the metric Gross Sales in their article above:

"Gross sales Equates to product price x quantity (before taxes, shipping, discounts, and returns) for a collection of sales. Canceled, pending, and unpaid orders are included. Test and deleted orders are not included."

Product price is available in Funnel (in the product report), hence we make a new custom metric like this:

Here are a few calculations that previously worked for our clients:

Total Sales

  • Order Price - Refunded Line Item Amount - Order Refunded Shipping Amount − Order Tax Amount Refunded

  • Order Price - Order Amount Refunded

Net Sales

  • Total sales - Shipping - Taxes + Order Refunded Shipping Amount

Gross Sales

  • Product Original Price (as seen in the example above)

  • Net sales + Discounts + Refunded Line Item Amount

We have noticed that Shopify does not always include gift cards in their calculation of Gross Sales. If there are mismatches between Shopify and Funnel it may help to filter out gift card products, e.g. by using the SKU-dimension.

Discounts

  • Order Discount

  • Order Discount + Product Discount

Returns

  • Order Amount Refunded - Order Tax Amount Refunded

Shipping

  • Order Shipping Price

  • Order Shipping Price - Order Refunded Shipping Amount

Taxes

  • Order Tax - Order Tax Amount Refunded

Net Quantity

  • Product Quantity - Product Refund Quantity

Read more about creating custom metrics here

Final Thoughts

Matching UI metrics exactly can be difficult and hard to do without intimate knowledge of how the shop was set up, how returns are handled, how shipping and taxes are calculated, etc.

Read more about Shopify

Did this answer your question?