Common issues when looking at Shopify data
Understanding Referrer Source
Our connector has a couple of different Referrer source dimensions, they all come in two versions, e.g. First Visit Source and Last Visit Source.
One thing that may not be obvious about them is that if an order was made on the first visit, it will have no value on the last visit source. It will only be attributed to the first visit source.
You can make your own custom dimension to solve this problem, here is a quick example of how that may look:
Joining different report types
You can setup both an Order report and a Line Item report for the same Shopify account if you want to be able to see all metrics. One order is one line in the Order report and each item in that report exists as a row in the Product report. These two reports can be mapped together by the Order ID that exists in both.
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 calculated on our end based on Shopify’s instructions.. You can view Shopify's own description of the metrics here, and you can see how we calculate them by inspecting each one in the metrics tab.
Note: Depending on how your Shopify store is setup, the metrics in the group “Shopify UI” may have slightly different values from what you see in Shopify’s UI.
To fix this we advice you to make your own custom metrics using our raw values and Shopify's description of how they should be calculated.
Reach out to us if you need any help!