How to filter your WooCommerce data by dates in Looker Studio

How to filter your WooCommerce data by dates in Looker Studio

Resolving Date Range Limitations in WooCommerce Connector for Looker Studio

Introduction

The WooCommerce connector allows you to get your orders, coupons, products, and shipping data into various platforms. However, it currently lacks a date range filter. This can make data management cumbersome when you need to analyze specific periods in Looker Studio. Fortunately, there is a workaround. In this guide, we will explain how to use Google Sheets or BigQuery as preferred destinations to filter your data by date range before importing it into Looker Studio.

The Workaround

The workaround involves the following steps:

  1. Connect your WooCommerce using the Windsor.ai connector
  2. Define and visualize your data in Windsor.ai
  3. Select Google Sheets or BigQuery as destinations
  4. Apply date range filters in Google Sheets or BigQuery.
  5. Import the filtered data into Looker Studio.

Method 1: Using Google Sheets

Step 1: Set Up the WooCommerce Windsor.ai Connector 

  1. Connect WooCommerce to Windsor.ai: Set up the Windsor.ai connector to fetch your WooCommerce data. https://onboard.windsor.ai/app/woocommerce

Step 2: In https://onboard.windsor.ai/ go to Preview and Destinations and select your destination

  1. Select Google Sheets as your destination and follow the steps to install the Windsor.ai Google Sheets Extension.
  2. Connect to Windsor.ai: Open Google Sheets, go to the Windsor.ai add-on, and connect your Windsor.ai account.
  3. Import Data: Use the Windsor.ai extension to import your WooCommerce data into Google Sheets. Specify the date column and schedule the intervals you want to get your data refreshed

Step 3: Connect Google Sheets to Looker Studio

  1. Open Looker Studio: Go to Looker Studio and create a new report.
  2. Add Data Source: Select Google Sheets as your data source and connect to the sheet containing your filtered data.
  3. Build Your Report: Use the filtered data to create your desired visualizations and reports in Looker Studio.

Method 2: Using BigQuery

Step 1: Set Up WooCommerce Windsor.ai Connector

  1. Connect WooCommerce to Windsor.ai: (https://onboard.windsor.ai/app/woocommerce) Set up the Windsor.ai connector to fetch your WooCommerce data.

Step 2: Load Data into BigQuery

  1. In https://onboard.windsor.ai/ go to Preview and Destination and select the data you need to use for the WooCommerce reporting
  2. Select BigQuery as your destination and configure your task to push data at regular intervals.

Step 3: Connect BigQuery to Looker Studio

  1. Open Looker Studio: Go to Looker Studio and create a new report.
  2. Add Data Source: Select BigQuery as your data source and connect to the table containing your filtered data.
  3. Build Your Report: Use the filtered data to create your desired visualizations and reports in Looker Studio.

Conclusion

By using Google Sheets or BigQuery in conjunction with Windsor.ai, you can effectively work around the date range limitation in the WooCommerce connector. This method allows you to manage your data more efficiently and ensures that only the necessary data is imported into Looker Studio. We hope this guide helps you streamline your WooCommerce data integration process.

If you have any questions or need further assistance, feel free to reach out to our support team at Windsor.ai using our Livechat.