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 :

1. Get informations from the data integration from our connector.
2. Create a source on catchr.io.
3. Download our Google Sheets extensions.
4. 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:

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

‍

Option B: Directly within a Google Sheets:

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

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 :

1. Get informations from the data integration from our connector.
2. Create a datasource and new report on Looker Studio.
3. Choose your metrics and dimensions.
4. 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 :

1. Get informations from the data integration from our connector.
2. Create a source on catchr.io.
3. Configure your request on the PowerBI request manager.
4. 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

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

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