WooCommerce is one of the top platforms to create an ecommerce business around. It has a robust system that allows anyone to build a a thriving online business. As such, it comes with a multitude of metrics to report on sales, unit prices, and average order values.
With that many metrics, ecommerce owners and marketers need to report these metrics in Looker Studio. Two Minute Reports solves this problem. With TMR, you can connect WooCommerce to Looker Studio, importing the data, so you can easily reduce your time creating reports.
Generate the API Key and Secret Key from WooCommerce
It’s required for WooCommerce to enter an access token to connect to Two Minute Reports. The API key provided by WooCommerce is entered in Two Minute Reports interface.
What is an API key?
- To get started with this process, you will need to log in to your WooCommerce account and navigate to the Settings page. From there, click on the Advanced tab and then select the REST API option.
- This will take you to the WooCommerce REST API settings page.
- On this page, you’ll see a section labeled Keys/Apps. This is where you can create and manage API keys for your WooCommerce store. To create a new key, click the Create an API key button.
- Here, you would first need to specify the description for the purpose of requesting the API key then followed by adding the user who is requesting the key and finally Specify the permissions for the key, which can be Read, Write or Read and write. Finally click on Generate API key.
- Now, you would be able to view the API key and API secret for once.
Make sure to copy the API secret key and save it somewhere secure. You’ll need this key to authenticate your requests when using the WooCommerce API.
Now, use this in place of API key and API secret in our Two Minute Reports configuration section and add your store URL to create your new TMR’s WooCommerce Data Source later.
Select WooCommerce in the TMR Portal
The first thing to do is to go through our portal and select the data source you want to add.
- Go to apps.gox.ai and Login to your account.
- Choose Two Minute Reports for Looker Studio (the blue one).
- Select your team. If you only have one team, you skip this and TMR automatically redirects you to the connectors page.
You will now see the connectors page.
- In the connectors page, find and select WooCommerce.
Authorize Your WooCommerce Account
The next series of steps is to configure your WooCommerce account with TMR.
Connect to Your WooCommerce Account
In this section, you need to login to your WooCommerce account for authentication making sure it connects with TMR and Looker Studio.
- Under Data Sources, click +Add New button.
- Enter the API Key and API Secret you acquired from the previous section.
- Name your data source and click the blue Test Connection button.
- Also enter the your Store URL.
- If test connection successful, Two Minute Reports gives a prompt “Signed in! You may close this tab now.“
Configuring Your WooCommerce Account with TMR
- In the Query Configs section, click + Add New button. Choose the data source you added earlier. Click Next.
The next following steps is where you configure your WooCom\merce settings to TMR so that you can create reports in Looker Studio. You may configure the following parameters depending on your preference as TMR has imported them.
- Name your query config.
- Data Options whether you want to Include missing time values or Replace blank metrics with zeros. This means metrics are still being reported as zero values.
- Click Save.
Once everything is finished, click Create Report. The next section is creating reports in Looker Studio.
Create a WooCommerce Report with TMR in Looker Studio
After connecting WooCommerce, you can create your own custom dashboard with TMR in Looker Studio. Looker Studio is a powerful data visualization tool that contains many features to help you reduce time creating reports.
- After clicking Create Report from the previous section, click Create Report from scratch blue button.
- You are redirected to Looker Studio. In Looker Studio, under Select Query Config, choose the one you created (it should be the name you gave it earlier). Select your team as well if the teams dropdown is showed to you.
- Click Connect blue button in the upper right side of the page.
- You can now view the WooCommerce schema on Looker Studio. Click Create Report in the right side of the page.
Once everything is loaded, you are presented with a blank canvas. You can now create custom reports (adding dates and charts) in Looker Studio with your WooCommerce data.
If you want to learn about creating your own report, like adding dates and charts, read How to Create a Report in Looker Studio.