Shopify to Looker Studio Connector

1. Click Get started above. Looker Studio opens SyncWith’s Shopify connector as a new data source.
2. In the connector’s setup, choose to connect a Shopify account. Shopify sends you to our listing on the Shopify App Store: click Install, log in to Shopify if asked, pick your store and confirm with Install app.
3. Go back to Looker Studio. Your store is now in the list of accounts. Pick it, connect, and create your report.

If it’s a client’s store, you’ll need permission to install apps on it.

Yes, as many as you like. Install our app on each store, one at a time, then report on them together or separately. If you’re an agency, give each client store its own report. It’s the simplest setup, and each client sees only their own numbers. If you do put several stores in one report, break the numbers out by store. Order numbers repeat across stores, so an order number alone won’t tell you which store sold it.

To share a report with a client, use owner’s credentials (Resource → Manage added data sources → Edit → Data Credentials). Your client sees what you see. With viewer’s credentials, every viewer needs their own SyncWith account.

Break your results down by hour, day, week, month, quarter, year or day of week. The full list, with how each field is calculated, is in our Shopify field reference. Not sure where to start? Try net sales by day, orders by UTM source and your top SKUs by net quantity.

For sessions and conversion rate, add Looker Studio’s free Google Analytics connector to the same report. To put ad spend next to sales, add our Facebook Ads connector and line up UTM campaign with campaign name by date.

Check these first:

• Date range and time zone. Two reports in different time zones put late-evening orders on different days.
• The store. In a report with several stores, check which ones the chart includes.
• The metric. Net sales is gross sales minus discounts and returns, so it won’t equal gross sales or total sales. Compare the same metric on both sides.
• The data delay. Our Looker Studio connectors update data every 12 hours, so the newest orders may not be in yet.
• Google Analytics revenue. Expect a gap. As Shopify puts it, Google “can only count visitors with JavaScript and cookies activated”, and browser extensions can block it from tracking purchases. For revenue, report Shopify’s orders.

A few, and each has a catch:

• Export a CSV. Export a report from your Shopify admin, put it in Google Sheets and connect the sheet with Looker Studio’s free Google Sheets connector. Shopify’s export is a manual download, so you’ll do it by hand every time.
• Google’s BigQuery transfer. Google’s Shopify transfer to BigQuery is in Preview, which “might have limited support”, and you create a custom Shopify app first.
• Google Analytics. Looker Studio’s Google Analytics connector is free, but it gives you tracked revenue, not Shopify’s orders.
• A scheduled Google Sheet. On our free Hobby plan, our Google Sheets add-on schedules a Shopify report into a sheet, and Looker Studio reads the sheet. The plan includes 35 refreshes a month, and each report stops after 35 refreshes, so a daily report runs for about five weeks and a weekly one for about eight months. It’s a good way to test before you pay.

For a direct connection with no sheet in between, start the 14-day free trial. After it, our Looker Studio plan is $24.99 a month. Our app in the Shopify App Store adds $4.99 a month after its own 7-day free trial, and it’s free for stores on Shopify’s Basic plan.

Is Data Studio the same as Looker Studio?

Yes. Google renamed Google Data Studio to Looker Studio. Older guides and many searches still use the old name, but it’s the same tool, and this is the same connector.

Does Looker Studio have a built-in Shopify connector?

Google’s free connectors cover data such as Google Sheets, Google Ads and Google Analytics. Shopify data comes in through a partner connector from the Looker Studio connector gallery, like ours. Google notes that partner connectors may cost money to use.

How much does the Shopify connector cost?

You pay for two things. Our Looker Studio plan starts with a 14-day free trial, then costs $24.99 a month. The SyncWith app you install from the Shopify App Store costs $4.99 a month after a 7-day free trial, and it’s free if your store is on Shopify’s Basic plan.