blog post

Optimizing Analytics: A Step-by-Step Guide to Connect Shopify and Looker Studio

Johan Chemin
July 19, 2023
Optimizing Analytics: A Step-by-Step Guide to Connect Shopify and Looker Studio

Running an e-commerce store through Shopify is a great idea, and keeping an eye on every KPI quickly can help you identify failures and opportunities for your business. That's why you need to use one of the many reporting tools available on the internet.

One of these tools is Looker Studio. Google develops it, allowing you to use your store data to build your reports or use already-made templates.

Connecting Shopify to Looker Studio might seem complicated, but following this tutorial, we'll go through every step individually.

How to connect Shopify to Catchr?

Looker Studio is free-to-use, but you need Connectors to bring data from every platform like Shopify, Facebook Ads, Google Ads, etc.

Most connectors required an abonnement. Only connectors developed by Google are free. You can find the complete list of connectors here

We will see how to connect Shopify to Looker Studio using the Catchr connector here.

How to connect Shopify and Catchr:

First, go to app.catchr.io and log in to your account. If you do not have one already, follow this link.

Once on Catchr, go to:

  • Sources, then Add a new Source and select the Shopify card.
  • Give a name to your new Catchr Source and click Connect.
Add a Shopify Source on Catchr
Add a Shopify Source on Catchr

You will need two things to connect your Shopify account:

  • Your Store name.
  • The API Key.

You can find your Store name on your admin's store homepage:

Find my store name in Shopify
Find my store name in Shopify

My Store name here is catchr-test.myshopify.com

The API Key needs to be generated from a new App. You can create a new App following these steps:

  • From your admin store's homepage, click on App, then App and sales channel settings.
  • Clicks on the grey button Develop apps, then the green button Create an app.
  • Choose your app name, for example, "Catchr app to Looker Studio", so you know what it is used for.
  • Choose the App developer. It will be the owner of this App in your organization.
  • Then click Create App.
Create a new App in order to get a Shopify API key.
Create a new App in order to get a Shopify API key.

Now, we need to configure the scopes and generate the API key:

  • Click on API Credential in the top menu. Then Configure Admin API scopes.
  • You must give Catchr a read-access on three entities: read_orders, read_product, and read_customer. Check these and click on Save at the top right.
Configure scopes for your Shopify API key.
Configure scopes for your Shopify API key.

  • Then in Overview, click on Install App, then Install.
  • Your API key is there under Admin API access token. Reveal and copy it (warning: once you refresh the page, this key won't be accessible anymore for security reasons).
Get your Shopify admin API key.
Get your Shopify admin API key.

Paste this API key:

Store name and API key Shopify
Store name and API key Shopify

Once your Catchr Source is created, you should see your store like this:

Your Shopify account on Catchr
Your Shopify account on Catchr

Activate it and click Save.

How to connect Catchr and Looker Studio:

Now that Shopify and Catchr have been linked, we can connect Catchr and Looker Studio. This will allow your data to be brought into a Looker Studio report.

To do so, you need to use the Shopify connector for Looker Studio:

  • Follow this link to access the connector.
  • Click Authorize 3 times. If you do not create your Catchr account or link your Shopify store to Catchr, you will be asked to do it here. Every steps is describe above.
  • Select your store to create your Looker Studio data source.
  • Click connect.
Create your Shopify Looker Studio data source
Create your Shopify Looker Studio data source

Ok, you just created your Looker Studio data source. This data source is linked to your Shopify store thanks to the Catchr connector.

Now that you have linked Catchr, Shopify and Looker Studio, you can start creating your report by clicking the button Create report at the top right.

QuickStep to link Shopify to Looker Studio:

You can easily link Shopify to Looker Studio by following these steps:

  • Locate your Store name and create a new API Key with read access to Customers, Orders, and Products.
  • Use the Catchr connector to make your Looker Studio data source.
  • Create a new report with this data source.
  • Share it with others! 

If you need help using our connector or Looker Studio, please ask for help in our chat!

Start your free-trial now

Get all your marketing data in your favorite data activation, database or reporting tools.

Move your

Data

 with Catchr