How to Connect Shopify to Looker Studio

Shopify is a leading e-commerce platform that enables businesses to create and manage their online stores. Enterprise companies benefit from using Shopify due to its scalability, vast customization options, and robust integrations with various marketing, sales, and analytics tools. It simplifies the process of setting up and managing an online store, allowing enterprises to focus on other aspects of their business.

Improvado reads Shopify through its GraphQL connector. Orders come from the Order and Customer Journey object graph, but store traffic is not part of it. Orders describe purchases, not visits, so traffic has its own report types: Sessions ShopifyQL and Campaign Sessions ShopifyQL. Shopify's own sales figures sit in Sales ShopifyQL.

For Looker Studio, load the recipe data into a database it supports first. The eCommerce row of the recipe guide, Ecommerce Paid Ads Orders Recipe, gives a data source template and a dashboard template to copy. On BigQuery you pick the Project, Dataset and Table when you reconnect the copy.

One trap: Sales Agreement by Order holds raw agreement amounts only. It has no gross sales, net sales or returns field. A Looker Studio sum of it will not match the Sales report in the Shopify admin, so build sales charts from Sales ShopifyQL instead.