Blog post

Apply report-wide filters in Looker Studio: How-to guide

Looker Studio

Johan Chemin

December 7, 2022

| Lastest update

July 1, 2025

Quick steps to create a report with Google Sheets:

You can easiliy create a report following this step :

Get informations from the data integration from our connector.
Create a source on catchr.io.
Download our Google Sheets extensions.
Configure and run your request

If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
Grant the necessary permissions for the add-on.
Upon successful installation, open a Google Sheets to proceed.

Connect Google Sheet to Facebook Ads — Install Catchr Google Sheets Add-on

‍

Option B: Directly within a Google Sheets:

Open a new Google Sheets.
In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
Search for "Catchr" and choose "Catchr - data connector."
Click "Install" and grant the required permissions.
Close the installation pop-up when completed.
Start using the Catchr add-on.

Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

‍

Quick steps to create a report with Looker Studio:

You can easiliy create a report following this step :

Get informations from the data integration from our connector.
Create a datasource and new report on Looker Studio.
Choose your metrics and dimensions.
Use charts with your metrics and dimensions.

If you need more informations, you can follow the tutorial. You can also find a template for at the end of the page.

Quick steps to create a report with PowerBI:

You can easiliy create a report following this step :

Get informations from the data integration from our connector.
Create a source on catchr.io.
Configure your request on the PowerBI request manager.
Copy the given URL in PowerBI

If you need more informations, you can follow the tutorial. You can also find a template for at the end of the page.

How to apply filters on every page in a report Looker Studio ?

‍
First create your filter :

• Go to Resource -> Manage Filter -> Click to Add Filter and configure one.

Then apply it to the entire report :

• Go to File -> Report settings.
• On the Filter section, click Add Filter and select the one you just created.
‍
Bonus : You can prevent a specific component from inheriting filters from the page or report by checking the Inherit filter option in the filter configuration of a component.

In video :

Check this tutorial to know how to apply filter on a page level instead of report !

No items found.

In this template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Start analyzing your data with a Looker Studio template

Catchr provides free dashboard templates to help you start analyzing your data on Looker Studio — 100+ available templates!

See all the Looker Studio templates

Start analyzing your data with a Looker Studio template

Catchr provides free dashboard templates to help you start analyzing your data on Looker Studio — 100+ available templates!

See all the Looker Studio templates

Start analyzing your data with a Power BI template

Catchr provides free dashboard templates to help you start analyzing your data on Power BI — 20+ available templates!

See all the Power BI templates

Start analyzing your data with a Power BI template

Catchr provides free dashboard templates to help you start analyzing your data on Power BI — 20+ available templates!

See all the Power BI templates

Start analyzing your data with a Google Sheets template

Catchr provides free dashboard templates to help you start analyzing your data on Google Sheets — 20+ available templates!

See all the Google Sheets templates

Start analyzing your data with a Google Sheets template

Catchr provides free dashboard templates to help you start analyzing your data on Google Sheets — 20+ available templates!

See all the Google Sheets templates

Connect all your Marketing data to Looker Studio

Simplify your data extraction with 75+ marketing data connectors to easily move your data to Looker Studio. No-code integration!

Start your free trial

✔ 14 days free trial — No credit-card required

Easily connect your to Looker Studio

Move your data from to Looker Studio with Catchr's no-code integration. Easy to set up, always up-to-date. Automate your data extract now!

Connect your data to multiple destinations

Easily integrate your data thanks to Catchr's no-code connector. Move your data to dashboard tools, spreadsheets, database and more... 20+ destiantions available

Start your free trial

✔ 14 days free trial — No credit-card required

Move your Marketing data to your favorite tools

Simplify your data extraction and move all your Marketing data to dashboard tools, spreadsheets, database and more... No code required!
75+ connectors | 20+ destinations

Start your free trial

✔ 14 days free trial — No credit-card required

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!

Build your first report

14 days free-trial - No credit card required 🎉

More blog post about

No items found.