Connect Shopify to Looker Studio: Tutorial & Free Templates (2024)

Sep 20, 2024

By Two minute reports

10 min read

Connecting Shopify data to Google Looker Studio and Automate It

We will discover the step-by-step guide to pull data from Shopify and add it to your Google Data Studio and how you can visualize Shopify data like custom metrics, sales data, marketing data, store’s performance, and so on. Our state-of-the-art solution will not only help you automate and extract and add Shopify to Looker Studio but help you save time. Our holistic Shopify reports will analyze all aspects of your Shopify account performance in detail, visualize Shopify data and add to your Google Looker Studio and create reports, so you don't have to write any code. Here's how our Shopify Studio integration works.

  1. Use the Two Minute Reports and search for our Shopify connector.
  2. Then connect Shopify to Google Data Studio and complete building Shopify reports. 

This can be done in two ways.  

Method 1: Use Two Minute Reports for Shopify Data Studio  

OR

Method 2: Choose from our thoughtfully designed built-in Templates to create a report.

Method 1: Connect Shopify to Looker Studio Using Two Minute Reports

  • Click on Products -> Two Minute Reports for Looker Studio. It will redirect you to the Two Minute Reports page. Now click on the Accounts option.1.png
  • You will see the names of all the teams you can collaborate with. Click on the team from the list to work with.2.png
  • You will be redirected to the Data connectors page. You will see connectors for various channels and platforms. Select Shopify from the list.3.png
  • You will now see options to fill in data sources. Click on Add New.4.png
  • Fill in the details for connection name, select app type, mention access token, and give the Shopify stores you wish to build a report for. Click here to learn on, How to generate access token. Now click on Save and authorize access.5.png
  • Once you have successfully connected to your Shopify store, move to the Query configs tab and click on Add New.6.png
  • Select the Data Source you would like to use for Query Config from the drop down menu and click on Next.7.png
  • Now set a configuration for your data source, and click on Save.8.png
  • Click on Create Report.9.png
  • Select the Query Configuration you would like to use and click on Next.10.png
  • Once you are done setting your Data Sources and configurations, click on Create Report From Scratch.11.png
  • Select the team and click on next.12.png
  • Verify your configurations and click on Connect.13.png
  • Check all the fields and parameters you want to add to your Shopify report. You can add or eliminate any parameter based on your requirement. Now click on Create Report.14.png
  • You will be routed to Google Looker Studio where you will find a sidebar for all your fields and parameters.15.png
  • Select date range control under Date filter. You can either select a range or click on the duration given in the drop down menu.16.png 
  • Under Dimensions, you will get various options for average order value, customers count, new customer, order count, returning customers, etc. Click on the ones you wish to add to your report.17.png
  • You will see your IDs for stores, date and similar data in your table.18.png
  • Under Metrics, you will have numerous fields for discount, traffic source, customer details, line items, product, total sales, customer returns, bounce rate, etc. There are two ways you can add metrics and dimensions.19.png
  • You can either choose to drag and drop from the data sidebar column. Or like shown below, you can pick anything related to sales or order and drag it to the metrics or dimension field.20.png
  • Or, you can pick one from the list in the drop down.21.png 

Now just sit back and wait for Google Data Studio to visualize Shopify Data and create detailed reports for you.  

Method 2: Connect Shopify to Looker Studio Using Templates

The initial steps of this method will remain the same. For a quick recap - You would need to go to Products -> Two Minute Reports for Looker Studio. Access Accounts, choose a team, and proceed to Data Connectors. 

  • Once done, now click on Create Report.22.png
  • Select Shopify-> add connection details-> save and authorize. In Query Configs, add a configuration and set all your Data Source and then click on Next. 23.png
  • You will have all the built-in templates specifically designed for Shopify data studio. Select the report template that best fits your needs and connect Shopify to Google data studio.24.png 
  • Select the team you want to collaborate with and click on Next. 25.png
  • Now choose your query configurations and click on Connect.26.png
  • You will see all the parameters and fields for your Shopify reporting. Eliminate or add fields and parameters as per your need and click on Create Report.27.png
  • A Google Data Studio doc for Shopify data will open up. You will see graphs and reports for various Shopify metrics like stores transactions, conversion rates, average order value, etc. 28 (1).png
  • Choose dates from the drop down menu on the doc. You can either select the date range manually, customize the duration or choose from the variety of date ranges available. 29.png
  • Now set your table with preset metrics and dimensions available in the sidebar. You can choose order name, customer data, return customers, sales insights, other Shopify data you wish to add to your report template. 
  • Note that for both Dimensions and Metrics, there are two ways to add them - drag and drop from the data sidebar column or pick one from the drop-down list.30.png
  • Now watch your Looker Studio arrange all the Shopify metrics and Shopify data to create meaningful reports and help you analyze essential insights. 
youtube play button

Use our quick templates for Looker Studio

1. Shopify E-Commerce Report

Shopify E-Commerce Report
This is a sophisticated single-page Shopify e-commerce template that allows you to view Store Sales
View Template
Shopify E-Commerce Report

This is a sophisticated single-page Shopify e-commerce template that allows you to view Store Sales Overview, Store Sales Transactions, and Product Performance all from a single page. To see an exact representation of the template, click on preview.

2. Shopify Overview Report

Shopify Overview Report
This is a unique and interactive template on Shopify. You get Descriptive scorecards with comparison
View Template
Shopify Overview Report

This is a unique and interactive template on Shopify. You get Descriptive scorecards with comparison data and graphs of the respective date ranges for Gross Sales Amount, Orders Confirmed, New Customers and Returning Customers. There are also tables to see top products by sales and an overview of sales. You also get a country chart to show net sales amount in different regions All of these metrics can be controlled using the date filter at the top. Click on preview to get an idea of this sophisticated Template.

Why Connect Shopify to Looker Studio?

While standard marketing tools give you straightforward performance analytics, you won’t get in-depth understanding unless you apply customized filters and evaluate performance from a 360-degree perspective. This is where Two Minute Reports helps - by automating data extraction on a customized schedule and consolidating it in one place. Here’s why you should get your Shopify data to Looker Studio. 

Easily visualize your Shopify data

Looker Studio empowers you to gain comprehensive visual insights into your Shopify data. Through direct connections to Shopify data, users can swiftly generate interactive, real-time dashboards and reports. This facilitates seamless monitoring of crucial indicators like total sales, returns, and customers behavior.

Refines your marketing strategies

Importing Shopify data into Looker Studio allows you to seamlessly integrate sales data with marketing reports. This integration enables you to identify the most effective marketing channels for driving traffic and sales. Consequently, it empowers you to optimize marketing tactics and enhance your return on ad spend.

Increased data accessibility and collaboration

Looker Studio facilitates effortless sharing of Shopify reports throughout your organization. Its collaborative features allow multiple users to access and edit the same report simultaneously, promoting data-driven decision-making across all departments.

Major KPIs to have in your Shopify Looker Studio Report

Thoughtful use of Shopify data in Looker Studio will not only help you unlock data driven decisions for your business but also save time by providing all essential data required for reporting at one place. Here are a few things you can explore while analyzing the Shopify data on Looker Studio.

Order 

Analyze total sales, gross sales, discounts, and tax amounts in Shopify reports to identify areas for improvement in operations. Use insights from this data to adjust pricing strategies, discount offerings, and tax calculations for more profitable sales.

TitleDescription
OrdersThe total number of orders placed.
Ordered quantityThe quantity of a product or item that has been ordered
Returned quantityThe quantity of a product or item that has been returned by a customer
Net quantityThe quantity of a product or item that remains after accounting for both ordered and returned quantities

Sales

Examine total sales, gross sales, discounts, and tax amounts in Shopify reports to pinpoint operational improvement areas. Utilize insights to refine pricing strategies, discount offerings, and tax calculations, enhancing sales profitability.

TitleDescription
Total sales amountThe total sales of order amount
Discount amountThe total amount of discounts applied on the order and line
Refund amountThe total amount refunded for the order
Tax amountThe total amount of tax for the order & line. Takes returns into account

Product

Assess product title, SKU, sales and inventory quantity, product ID, variant title, product type, price, inventory value, and cost of goods sold on Shopify to optimize operations.

TitleDescription
Inventory valueThe sell value of the product inventory
Inventory quantityThe product quantity in inventory
Cost of goods soldThe total cost of all the units of goods sold.

Customer Geo 

Examine customer geo data to discern their origins. Tailor marketing campaigns and personalize product offerings based on customer location. Enhance operations by identifying areas with a high concentration of customers, potentially requiring additional resources.

Store

Identify store names and IDs to segment sales and customer behavior across stores. Compare performance across locations, determine best sellers, and assess promotional tactics to enhance operations. Utilize this information to pinpoint profitable stores and streamline inventory quantity.

TitleDescription
Store nameThis is the count of impressions for Direct Ads and Sponsored Updates and sends for InMails.
Store IDThe unique identifier for the shopify store.

Traffic source

Examine customer behavior and refine marketing strategies by utilizing Shopify's first and last visit sources, dates, and types. Enhance operations by generating targeted reports based on these insights to elevate conversion rates and increase revenue.

TitleDescription
FV: DateThe first visit date
FV: SourceThe First visit Source from which the customer visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown.
LV: SourceThe source from which the customer last visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown.
LV: UTM mediumThe AD medium of a marketing campaign from which the customer last visited the store.

Customer Insights

Evaluate customer behavior using email, names, unique IDs, customer types, and tags. Create detailed customer profiles, personalize outreach, optimize websites, update inventory, and enhance customer experience for improved marketing and data-driven decisions.

TitleDescription
Customer first nameThe first name of the customer
Customer emailThe email of the customer
Customer typeWhether the customer a Returing customer (Customers whose order history includes two or more orders) or a First-time customer.
Account created dateThe date the customer was added to the online store

Get Shopify data in Google Sheets too!

Two Minute Reports is also available as a Google Sheets add-on. This add-on is designed to simplify complex data analysis and visualisation, making the best use of Google Sheets’ tools and features.

This add-on allows the creation of detailed reports and dashboards using insights from LinkedIn Ads without the complexity of manual data entry. TMR for Google Sheets also enables users to develop custom formulae in a user-friendly interface. 

With seamless Shopify to Google Sheets integration, comprehensive analytical capabilities, and automated workflows, strategic business intelligence has just become quicker and more accessible.

Increase your Client's ROI by 2x
Reports done in two minutes
ctaStart your Free trial now

Frequently Asked Questions

How To Display Shopify Sessions On Google Looker Studio?

You can use our Two Minute Reports. It will Analyze customer behavior and optimize marketing strategies using Shopify's first and last visit sources, dates, and types.
 

Can I connect Looker Studio to multiple Shopify stores?

Yes, most connectors allow you to connect multiple stores of Shopify to Looker Studio. Our personalized templates like Shopify Overview will consolidate all data and give you a holistic overview of all your stores. 
 

What kind of Shopify data can I explore in Looker Studio?

You can explore sales, order, product, customer details, time, line items, and more