Supermetrics includes two fields that make it simple to add a Shopify store’s profitability data to your reporting.
Combine these fields to start analyzing profits:
- Cost of goods sold
- The total cost of all the units sold
- Gross profit
- The total profit, calculated by subtracting the cost of goods sold from net sales
Example setup
Let’s say a Shopify store records these sales in the past 7 days:
- 2 pairs of sunglasses with a unit cost of $25 and a sales price of $30
- 1 shirt with a unit cost of $100 and a sales price of $120
- 3 hats with a unit cost of $50 and a sales price of $60
To find out the profitability for that month, you'd create a Supermetrics query covering the past 7 days, and select Cost of goods sold and Net sales as your metrics.
In this case, the Cost of goods sold metric would return a value of $300, while Net sales would return $360.
By creating a cell or report that subtracts these two values from each other, you’ll be able to include a profitability value that will automatically update each time you run your query. For the example store’s month, that field would contain a value of $60.
