Get Shopify Data onto Google Data Studio

You can now get key sales, orders, and online store visitor data of your Shopify store right inside Google Data Studio. This makes it easier to glance at how your store is performing—across all of your sales channels, and for any date range.

Keeping track of all your Shopify metrics can be tedious, as the data keeps changing dynamically. Creating a custom report in Google Data Studio makes it easier to retain the data you need to make a consistent analysis of your store across different dates and dimensions.

Store managers can

  • check recent sales and compare them to a previous time period
  • check how well different sales channels are performing
  • track average order value, order count, etc over time
  • monitor the trends over time
  • more..

All these are possible without writing a single line of code in Google Data Studio. Let me show you how.

Step 1 : Connect your Shopify store to Google Data Studio

Install Two Minute Reports (TMR) for Google Data Studio, if you have not done it already.

Select Shopify from the data sources listed here.

Navigate to the Data Sources section. We need to create a Custom App in your Shopify Store and add the credentials inside TMR.

There are two place from where you can create a Custom App.

  1. Creating the App from the Shopify admin portal. (If you have the admin access to the store)
  2. Creating the App from the Shopify partners portal.

1. Creating the App from the Shopify admin portal

Login to the shopify admin portal and go to Apps on the left sidebar. Then scroll down and click on the Develop apps for your store.


Click on Create an app at the top right corner and give your app a friendly name. And then click on Create app.

Once the app has been created. You need to configure the Admin API scopes to get the right credentials to use in TMR. Click on Configure Admin API scopes and select following scopes and then click on save.
Scopes: read_analytics, read_customers, read_draft_orders, read_fulfillments, read_inventory, read_marketing_events, read_orders, read_products.

Now go to the API credentials tab and click on the Install app to install your app on your store.

Once you have installed the app, you will get an Admin API access token. Click on Reveal token and save your token somewhere safe.

Now, go back to the Data Source section in Two Minute Reports sidebar

Select Custom App (Method 2) in the App type field. Fill in the access token you got from shopify admin and your shop name and then save the data source.

2. Creating the App from the Shopify partners portal

Login to your partners dashboard, go to Apps on the left sidebar.
Then click on Create App, it should ask you to choose a type of app. Click on the Custom App and give it a friendly name and paste this URL (https://www.gox.ai/two-minute-reports) in the App URL field. And then you need to add our redirect URL (https://www.gox.ai/rmtipa/auth/callback) in the Allowed redirection URL(s) section. Then click save.

Please note down the API key and the secret key that you get in this section, we will need it later.
Note:
1. These custom apps can only be installed on a single Shopify store. Shopify Plus service partners can install the same custom app on multiple Plus stores for a single Shopify Plus merchant.
For non shopify plus services, another app need to be created for a different store. Or you can uninstall an existing app from a store and reuse that app.
2. You can only access last 60 days of orders. To get more than that, you have to request for the access. You can do that from App setup -> Read all orders -> Request Access.

Now, lets get back to our Data source section inside Two Minutue Reports sidebar.

Select the Custom App (Method 1) and feed in the API Key and Secret along with the name of your store in the Add Data Source section. Once saved you can now access your Shopify store data from Google Data Studio and monitor your store. Lets see how.

Step 2 : Fetch Data onto Google Data Studio

Now that your data source has been connected, you can write your own Shopify queries and start fetching data onto the Google Data Studio

  • Go to the Query Config section and press Add
  • Select your newly added Data Source and select the fields that you need
  • Once a query runs successfully, you should see the data populate on your report.

You can then freely select the metrics and dimensions you need for your Shopify Store. If you think your required metrics or dimensions are missing, please don’t hesitate to contact our support. We will make sure to add your field within a week.

Was this helpful?