By integrating Shopify store data with Looker Studio, you can visualize store insights via engaging dashboards, enabling faster decision-making. However, as a store admin, you’ll need to create a custom app in your Shopify store and input app credentials into TMR to connect your store accounts.
Before connecting your Shopify store data to Looker Studio, ensure you have the following permissions:
Required permissions
You must have the store owner access or staff access with all permissions to establish a connection and access the Shopify store data.
How to grant permission?
- Go to Shopify Admin > Settings > Users and permissions.
- Select the user you want to update.
- Click on the Staff member’s name (or “Add Staff” to create a new one).
- Scroll to the Permissions section.
- Check the following boxes:
- App development
- Manage and install apps and channels
Permissions needed:
1. App development
2. Manage and install apps and channels
Once you confirm these prerequisites, follow the steps below to connect your Shopify store with Looker Studio through TMR.
Step 1: Streamline your Shopify store accounts in Looker Studio
- Go to https://hub.twominutereports.com/. Choose Two Minute Reports for Looker Studio.
- Select Shopify from the list of connectors.
- Next, connect your Shopify store data. Click New Connection to start creating your Connection in Looker Studio.
- In the first step of the Add new connection dialog, please provide the following details:
- Enter a name for your Shopify connection
- Select Public app as the app type
- Enter your Shopify store name in the Store name field
Note: Your shop name is the subtext in your Shopify URL. For example, in the following URL, “https://thisismyshop.myshopify.com,” the shop name is “thisismyshop.”
- Once you have filled in the required details, click Save. A new window will open asking you to authorize and install the Two Minute Reports. Review the requested permissions and click Install to continue. After the authorization is complete, you can safely close the window.
Your Shopify store will now be authenticated. As shown below, you can proceed with selecting the respective store accounts to analyze performance data.
Enable the accounts for which you want to run queries. Once enabled, Speedboost will be automatically activated, performing two critical functions:
- Warm up – Prepares your account for faster data retrieval by caching your historical data.
- Periodic sync – Ensures your data stays updated automatically at regular intervals.
Please note that you can extract data from relevant store accounts only after the warm-up (approx. 2 to 24 hours). Additionally, you cannot run queries for disabled accounts.
Step 2: Configure your Shopify store account with TMR
- In the Query Configs section, click + Add New.
| Query Config lets you group multiple accounts, making it easier to view centralized insights in your Looker Studio dashboard. |
- The Adding New Query Configuration dialog box appears. Name the query config, select (from the list of enabled) store accounts from the dropdown, and configure your Shopify store report. Once done, click Save.
You’ve successfully created a new configuration. Now you can use this Query Config to extract data from your Looker Studio reports.
Step 3: Create Shopify reports with TMR in Looker Studio
After creating the Query Config, click Create Report at the top-right corner, as shown below:
Select the Query Config that you’ve created (in our case, “Shopify report”) from the list of options. Click Next and choose ‘Create report from scratch’ to open the Looker Studio dashboard.
- Once the Looker Studio dashboard opens, select your team and the required Query Config from the dropdown. Next, click Connect at the top-right corner.
- Once you click Create Report, you’ll be directed to the Looker Studio dashboard. Here, you can drag and drop the associated Shopify metrics and dimensions to analyze store performance insights faster.
- To make your Looker Studio report compelling, use charts and visualizations. Click Add a chart and choose relevant chart types to configure your dashboard.
For example, you can use bar charts to showcase your store’s sales trends and scorecards to highlight crucial KPIs. You can also add a date range control to visualize the performance of your Shopify campaigns for a specific period.
Note: We’ve also listed some common issues marketers face while running reports on Looker Studio and practical solutions to fix them. Read the full article here.
We hope you found this article helpful. If you have any questions, please contact our support team via [email protected].