blog post

Connect WooCommerce to Looker Studio using Catchr

Johan Chemin
November 24, 2023
Connect WooCommerce to Looker Studio using Catchr

Quick steps to create a WooCommerce report with Google Sheets:

You can easiliy create a WooCommerce report following this step :

  1. Get informations from the data integration from our WooCommerce connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your WooCommerce data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a WooCommerce report with Looker Studio:

You can easiliy create a WooCommerce report following this step :

  1. Get informations from the data integration from our WooCommerce connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for WooCommerce at the end of the page.

The tutorial

Quick steps to create a WooCommerce report with PowerBI:

You can easiliy create a WooCommerce report following this step :

  1. Get informations from the data integration from our WooCommerce connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for WooCommerce at the end of the page.

The tutorial

WooCommerce is a powerful platform to manage your online store, but when it comes to in-depth analytics, it's time to level up. With Looker Studio and the Catchr connector, you can unleash the potential of your WooCommerce data like never before!

Why Connect WooCommerce to Looker Studio?

While WooCommerce provides basic reports, Looker Studio allows you to go beyond standard statistics. You can create custom reports, track business-specific metrics, and gain deep visibility into your sales performance.

How to Connect WooCommerce to Looker Studio with Catchr:

Get your API Key in WooCommerce 

  • Log in to your WooCommerce
  • Go to WooCommerce -> Settings -> Advanced -> Rest API. Then click on Add Key.
Find the API Key menu in WooCommerce.
  • Name your new Key, select a user, and select the Read permission. Click Generate API Key
Create your key to connect your WooCommerce account.
Create your key to connect your WooCommerce account.
  • Copy the API Key; we will use it at the end of the next step.

Create a Source on Catchr:

  • Go to Catchr.
  • Add a new source by going to Source -> Add a Source
  • Select the WooCommerce integration.
  • Paste your website URL and your API Key (the URL must be like https://yourwebsite.com)
  • Click Connect.

Your WooCommerce account should appear on the page like this: 

Use your WooCommerce account on Looker Studio

  • Once the source is set up, you can click here to go to Looker Studio and open our WooCommerce connector. 
  • If it's the first time you open Looker Studio, click the authorize button two times and follow the identification steps.
  • Select your WooCommerce account in the list.
Create your WooCommerce data source on Looker Studio
Create your WooCommerce data source on Looker Studi

How to connect your WooCommerce account to Looker Studio

Create an Account on Looker Studio

If this is your first encounter with Looker Studio, your initial step will be to create a Looker Studio account. Existing Google users can streamline this process by connecting their standard Google account credentials for seamless access.

Creating a Looker Studio Account

Connect WooCommerce to Looker Studio

To establish a connection between WooCommerce and Looker Studio, here's a detailed guide for your convenience:

  • In your Looker Studio dashboard, begin by clicking on "Create".
Looker Studio Dashboard - Create
  • Next, opt for the choice labeled "Report".
Looker Studio - Create Report
  • Then, navigate through the data sources gallery and search for Catchr's WooCommerce data connector.
Looker Studio - Search for Catchr WooCommerce Connector

Step-by-step guide on the authorization step:

For first-time authorizations with this connector, you'll need to undergo a dual authorization process—both for Looker Studio and WooCommerce via Catchr:

  • The authorization prompt for Looker Studio will appear, requesting permission to operate with community connectors.
Authorize Looker Studio Connector
  • Select the Google Account you wish to link with Looker Studio.
Select Google Account
  • Peruse the necessary authorizations for Looker Studio, then navigate to the bottom of the page.
Review Looker Studio Authorization
  • Grant the required access by clicking on "Allow".
Allow Access to Looker Studio
  • Your Google Account is now authorized for Looker Studio use. Immediately following, you must authorize WooCommerce connection; press the second 'Authorize' button which is associated with WooCommerce's need for Looker Studio data access.
Authorize WooCommerce Connector
  • A popup with further instructions will materialize—follow these steps to authorize Catchr's connection to your WooCommerce account. Upon task completion, this confirmation will be displayed.
Confirmation of WooCommerce Authorization
  • After a brief loading period, you will be redirected back. Scroll down to continue.
Redirected Authorization Page
  • Select the specific WooCommerce account for Catchr access and click on the "Add" or sometimes referred to as "Create Report" in the top-right corner of the interface.
Select WooCommerce Account and Add to Looker Studio

And with that, you've established a bridge between WooCommerce and Looker Studio. You're now ready to visualize and make the most of your marketing data.

Example of metrics you can use with the Looker Studio Integration for WooCommerce

Integrating WooCommerce with Looker Studio affords you the ability to transform vast amounts of raw data into readable, actionable insights. With access to a plethora of metrics—from Product IDs and sales data to customer information and order details—the analytical possibilities are extensive. Here are just a few examples of how you can leverage these metrics:

Imagine crafting a report that showcases your top-selling products, measured by their Total Sales, alongside customer reviews and ratings. Picture the ability to monitor and assess the effectiveness of marketing campaigns by tracking Coupon Usage and correlating it with spikes in new customer acquisitions or total order values.

In Looker Studio, you can create custom dashboards that highlight stock levels and backorder statuses, helping to manage inventory more effectively. Financial oversight becomes more manageable, too, as you can design visualizations that capture order totals and revenue trends over time.

Visit Catchr's WooCommerce metrics fields listing for a comprehensive view of all the data points available for reporting and analytics.

By tapping into the combined power of WooCommerce and Looker Studio, you stand at the ready to delve deeply into your marketing performance, customer habits, and overall ecommerce health. This integration not only simplifies the process but elevates your data analysis, enabling smarter, data-driven decision-making for your business.

No items found.

In this WooCommerce template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this WooCommerce template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about WooCommerce

Explore your Woocomerce e-commerce KPI with PowerBI : How-to, templates and metrics

Master the art of integrating WooCommerce data into PowerBI with our step-by-step guide. Learn to create dynamic dashboards for enhanced marketing analysis and data-driven decision-making.

Florian Cabirol

Connect WooCommerce to Looker Studio using Catchr

Connect your WooCommerce account to Looker Studio with the Catchr's connector and start creating your custom dashboard easily!

Johan Chemin

A Comprehensive Guide to WooCommerce KPIs

If you're striving to achieve unparalleled success in your online sales business through KPI tracking, look no further. Learn everything about WooCommerce KPIs in this guide.

Florian Cabirol

How to Move Woocommerce Ecommerce Data to Google Sheets Quickly and Easily

Learn how to move your Woocommerce ecommerce data to Google Sheets with Catchr.io's easy-to-use Add-on. Analyze and visualize your data with ease!

Florian Cabirol