How to compare investment Facebook Ads vs. Google Ads in a pie chart Looker Studio ?

How to compare investment Facebook Ads vs. Google Ads in a pie chart Looker Studio ?

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.

‍

The tutorial

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.

The tutorial

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.

The tutorial

Looker Studio is an amazing tool to display your data, but it can be a bit of a pain when you need to merge data from different platforms.

Here is a 2-steps tutorial to compare spend on 2 platforms with a blended data sources and a chart pie :

1 - Create a blended data source

2 - Create a custom fields to merge accounts and spends.

Create your blended data sources :

Go to Resource → Manage blends → Add a new blend.

Select both data sources required, put the Account Name in dimension and Spend in metrics then save.

Your blended data source should look like this :

Join should look like this :

Create a custom fields :

In a pie chart, you need to create a new dimension and a new metric :

New dimension :

Formula :

if(CONTAINS_TEXT( Account Descriptive Name,"GAds"),"Google Ads", if(CONTAINS_TEXT(Account Name,"pub"),"Facebook Ads","N/A"))

Thanks to this formula, I aggregate and rename my Google Ads account name to "Google Ads" and my Facebook Ads account name to "Facebook Ads"

(you will need to change "GAds" and "pub" by text include in your Google Ads and Facebook Ads accounts names).

‍

New metric :

Formula :

IFNULL(Investment (Google Ads),Investment (Facebook Ads))

Final Pie Chart :

‍

‍

‍

This tutorial in video :

‍

Do you need help in Looker Studio ?

Contact us on the chat or at johan@catchr.io, we can help you design great reports !

‍

Empower your Marketing data analysis

Discover +50 connectors to import your Marketing data into your favorite dashboard tool! Unlock instant data integration with Catchr's no-code feature – no IT team required!

Start your free trial!

All your marketing data on

Build dashboard with your different marketing data and track all the essential KPIs.

Start your free trial!

Keep an eye on your data

No items found.

Need a clearer view of your marketing data?

Unlock your free Looker Studio dashboard template for from a collection of +50 stunning designs. Elevate your data visualization!

Get it for free

Need a clearer view of your marketing data?

Unlock your free Power BI dashboard template from a collection of stunning designs. Elevate your data visualization!

Get it for free

Need a clearer view of your marketing data?

No items found.

No items found.

Need a clearer view of your marketing data?

No items found.

No items found.

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.

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.