WooCommerce Looker Studio (Data Studio) Connector
Connect WooCommerce to Google Looker Studio (formerly Data Studio) to automate your reporting and create insightful and actionable dashboards.
What Is The WooCommerce Looker Studio Connector?
The WooCommerce Looker Studio connector (Data Studio connector) allows you to get data from WooCommerce into Looker Studio. Including:
Customers, Orders, Products and Subscriptions
How Does The WooCommerce Looker Studio Connector Work?
- Sign Up To Solo Plan
- Create API Credentials in WooCommerce
- Connect Looker Studio to WooCommerce Using API Credentials
- Start Creating Dashboards & Reporting!
See below for details.
Pricing To Suit The Stage Your Business
Connector prices are based on the plan you choose/have
No credit card required!
How To Get Started?
First Sign Up to a Plan
Choose a Google Account to Sign-Up
Sign up and access to the connector is based on the Google Account used. Make sure you are signed in to the Google account you want to use in the same browser before you click try.
For users that use many Google Accounts in chrome however, it can be tricky to select the account you want to use, if it is not the default account. This is because the current behaviour of Data Studio sends the user to the home screen when they attempt to change their account from the default, using the selector to the top right. The easiest way around this is to make sure to set up a Profile in Chrome for the Google Account you want to use, and switch to that Profile
Click the Authorise Button
For the connector to work, it must be allowed by your Google Account. Clicking the Authorisation button shown will present dialogues in order to achieve this.
Authorise the Connector With Your Google Account
Ensure the Google Account you want to use is presented. Select the account and then allow the permissions.
Select a Plan
Select the free Solo Plan to get started. The connector will be added as an add-on to the plan, with a 14 day free trial, in a later step.
Review the order.
Enter Your Name & Email
Enter your first and last name. The email should be the Google Account you intend to use Data Studio with and will be the main email associated the subscription.
By default the email of the Google Account you used with Looker Studio is populated (if changed it must me an email of a Google Account you intend to use with Looker Studio).
No billing information is required to get started!
Click the subscribe button to get the Solo Plan.
Add WooCommerce Connector To Plan
Select yes from the dropdown, then click Next to add the connector to your plan for a 14 day trial.
Connect WooCommerce to Looker Studio
Generate WooCommerce API Keys
- Log into WordPress
- Go to WooCommerce -> Settings
- Click the Advanced tab and then the REST API sub-tab
- Click the Create an API Key button
- Input Description
- Select User
- Select Permissions as Read
- Click the Generate API key button
- Copy Consumer key and store safely (to be used in Looker Studio)
- Copy Consumer secret and store safely (to be used in Looker Studio)
Add An Account
- Select Add an Account from Connector Management
- Click Next until the Credentials screen is shown
- Enter WordPress Domain into the Path field
- Enter Consumer key into the Username field
- Enter Consumer secret into the Password
- Click the SUBMIT button
WooCommerce is a free open-source plugin for WordPress that allows users to create an online store, sell physical and digital products, manage inventory and shipping, and accept various payment methods.
About Looker Studio (Data Studio)
Looker Studio (formerly Data Studio) is a visualisation and reporting to offered by Google. With Looker Studio, users can connect, transform and visualise data from various sources, creating dynamic and interactive reports and dashboards.