I generally don’t find Shopify reporting (inside the Shopify platform) to provide insights which are always useful. In my view, the Shopify connector is a pretty improtant tool to gain access to the data points and present them in ways which are more useful to my clients.
Sample Use Case
As an example, our clients sometimes struggle with reporting on product sales in hierarchy or based on other item attributes. Depending on the Shopify build, the data points for category, subcategory, etc. doesn’t often exist and therefore reporting isn’t possible within the platform. A solution which we found works is to extract the item sales data from Shopify (using the SM shopify connector) and joining it with a GSheet table (SKU level definitions of category, subcategory, and anything else useful for reporting) which defines hierarchy and other product attributes enables the ability for slicing and dicing the sales data in a lot of new, useful ways.
This keeps reporting real time and interactive so that clients don’t need to process the data outside of whichever visualization tool they prefer (Looker Studio in most cases for us).
I generally don’t find Shopify reporting (inside the Shopify platform) to provide insights which are always useful. In my view, the Shopify connector is a pretty improtant tool to gain access to the data points and present them in ways which are more useful to my clients.
Sample Use Case
As an example, our clients sometimes struggle with reporting on product sales in hierarchy or based on other item attributes. Depending on the Shopify build, the data points for category, subcategory, etc. doesn’t often exist and therefore reporting isn’t possible within the platform. A solution which we found works is to extract the item sales data from Shopify (using the SM shopify connector) and joining it with a GSheet table (SKU level definitions of category, subcategory, and anything else useful for reporting) which defines hierarchy and other product attributes enables the ability for slicing and dicing the sales data in a lot of new, useful ways.
This keeps reporting real time and interactive so that clients don’t need to process the data outside of whichever visualization tool they prefer (Looker Studio in most cases for us).
That’s great @RickM - I really appreciate the input! 
Thank you!
Do you then use this more granular data in optimising marketing spend? Are there some decisions that you’re then able to make based on this data?
