How to combine Google Extract Data connector and Dataslayer in Looker Studio - Pros & Cons

In this article we'll explain in more details how to work with Google Extract Data.

What is Google Extract Data?

The Extract Data connector is a data source that acts as a data warehouse developed by Google. It allows you to extract data from any Looker Studio connector by selecting the specific fields, date ranges, and filters you want. It also allows you to refresh the query stored at any given moment. This connector specifically helps you to make your reports load faster and be more responsive.

You can learn more about it at this Google link.

 

How can I use Google Extract Data with Dataslayer?

1. Add data to one report and select the connector Google Extract Data.

Browser template (9)-Jul-17-2024-06-37-11-8119-AM

2. Select the Dataslayer connector of your choice and the dimensions and metrics that you want to extract.

Browser template (10)-Jul-17-2024-06-42-17-9822-AM

3. And also the date range, and any filters you want. 

Browser template (11)-Jul-17-2024-06-49-05-6551-AM

4. After setting up the configuration of the query you want to extract, you can set up a schedule to refresh the data at any given moment.

This schedule will consume your Dataslayer for Looker Studio API calls. You can learn more about API calls in Looker Studio here.

Browser template (12)-Jul-17-2024-06-50-33-9538-AM

5. Click on Save and Extract.

Browser template (13)-2Done! Now you can add charts and controls to that report and send it to your clients.

Learn more about charts on this FAQ and controls of Looker Studio on this one.

 

Pros & Cons of using Google Extract Data

Pros

It can make your reports faster to load and offer better performance.

You can share the report with your clients without wasting your Dataslayer API Calls.

Cons

A maximum of only 100 MB of data can be extracted.

The information from the extracted data sources is static. It only refreshes at the scheduled hours.

 

As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!