How to Connect WooCommerce to Google Data Studio with PMA

WooCommerce has long been the go-to ecommerce platform for WordPress powered sites. It’s easy to use and integrates well with many WordPress templates, turning a website or a blog into a storefront. 

As expected, WooCommerce collects data about each purchase on the site. While some of this is also available in Google Analytics, provided you’ve set up that integration, relying on WooCommerce’s data reporting can be helpful and easy, especially when you leverage a third-party connector from Power My Analytics (PMA).

While there are other ways to get sales data into Data Studio, connecting WooCommerce directly via PMA has several advantages. First, because WooCommerce separates the data you’d want into separate reports. You need an export for products, another for sales per day, another for coupon usage. Second, some data isn’t even available for export, like information on your customers. The PMA connector, on the other hand, requires you to connect only once and pulls a wealth of data automatically. While you can get some sales data from Google, you would have to set up ecommerce tracking – not a simple task. Furthermore, WooCommerce contains your actual sales data. Getting it directly from the source is always better. If you use WooCommerce regularly and need better reporting, it’s worth the monthly cost. 

The steps we outline here ultimately prepare your data for the WooCommerce dashboard available in our store. It’s turnkey and ready for your data, but you could also create your own dashboard for the data you’ll pull. 

Check out these Woocommerce Looker Studio Templates below available to download

Step 1: Download the WooCommerce Template or Open a New Dashboard

Either use the WooCommerce dashboard or open a blank dashboard and add a data source. The quickest way to find the PMA WooCommerce connector is to search “WooCommerce.” It’s the only WooCommerce connector that should show up. Select it from the list of “Partner Connectors.”

Use the search bar to find the PMA WooCommerce connector quicker. 

Step 2: Follow the Setup Wizard

If you’ve connected data with PMA before, this should be really familiar. If not, don’t worry, it’s easy. First, make sure you actually have a PMA account. Data Studio will prompt you to sign in or create an account with PMA before you can proceed.

Once you have an account, select a hub (you probably only have one hub) and your user account. 

You’ll be prompted to add a currency before you can finalize the connection. 

Step 3: Create an API Key

PMA will then open a popup box and prompt you to input your site address and API keys. They give instructions on the popup, but we’ll repeat them here. 

1. Login to WordPress.
2. Select “Settings” from the WooCommerce menu.

3. Click “Advanced” from the menu bar across the top.
   
4. Click “Rest API” from the submenu above the “Page Setup” header.
   
5. Enter a description so you’ll remember later. Perhaps something like “PMA Connector.” It should recognize you as a user. Change the permissions to Read/Write and generate the key.
   
6. Finally, enter the details from the newly generated API key into the PMA popup. Your site address is the full URL of your site.
   

Next Steps

If you’re using the WooCommerce Template, just add your new data connector at the report level or onto each chart one by one.

Here are some metrics to be sure to utilize when looking into your WooCommerce data. 

Products

The most important metric is which products are selling and how much. And if you want to dive deeper, look at the net sales on each, not just total sales or gross sales. You may find areas to optimize, especially on shipping or otherwise. 

Customer Data

Who are your top customers? How often are they ordering? Where are they located in the world or your country? It may tell you where to focus more attention or give you a chance to reward your best customers. 

Inventory

Use the Data Studio connection to manage your WooCommerce inventory. Stay up to date with products that are running low and products that are slow to move off the shelves.