WooCommerce & Looker Studio: setup guide

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.

• Name your new Key, select a user, and select the Read permission. Click Generate API Key

• 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.

‍

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.

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".

• Next, opt for the choice labeled "Report".

• Then, navigate through the data sources gallery and search for Catchr's WooCommerce data 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.

• Select the Google Account you wish to link with Looker Studio.

• Peruse the necessary authorizations for Looker Studio, then navigate to the bottom of the page.

• Grant the required access by clicking on "Allow".

• 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.

• 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.

• After a brief loading period, you will be redirected back. Scroll down to continue.

• 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.

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.

‍