blog post

Explore your Google Ads Marketing data with powerBi : How-to, templates and metrics

Florian Cabirol
September 11, 2024
Explore your Google Ads Marketing data with powerBi : How-to, templates and metrics

Quick steps to create a Google Ads report with Google Sheets:

You can easiliy create a Google Ads report following this step :

  1. Get informations from the data integration from our Google Ads 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 Google Ads 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.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

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.
Install Catchr Add-on for Google Sheets
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 Google Ads report with Looker Studio:

You can easiliy create a Google Ads report following this step :

  1. Get informations from the data integration from our Google Ads 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 Google Ads at the end of the page.

The tutorial

Quick steps to create a Google Ads report with PowerBI:

You can easiliy create a Google Ads report following this step :

  1. Get informations from the data integration from our Google Ads 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 Google Ads at the end of the page.

The tutorial

This detailed tutorial aims to empower marketers to easily integrate their Google Ads data directly into PowerBI. By connecting Google Ads to PowerBI, marketers will be equipped to visualize complex campaign data more clearly, combine it with other business data, and unlock valuable insights for strategic decision-making. Once you complete this guide, you will have a comprehensive dashboard at your fingertips, bringing Google Ads statistics into sharp focus through PowerBI's robust analysis tools.

How to connect your Google Ads account to PowerBI

Add a source on Catchr

Begin by accessing the Catchr platform. On the homepage, navigate towards the left-side menu and click on 'Source,' then position your cursor to the upper right and select 'Add a Source'.

Pick Google Ads from the lineup of platforms available and proceed through the identification process to establish a seamless connection between Catchr and Google Ads.

Connecting Google Ads as Data Source on Catchr

Create the request to transfer Google Ads data to PowerBI

  • Within Catchr, locate and click on 'API' from the menu on the left.
API option on Catchr's left-side menu
  • Start by setting the export format to "PowerBI."
Export format selection in Catchr
  • In the "Source" tab, choose 'Google Ads' as the platform from which you wish to export the data.
Platform source selection in Catchr
  • Select the Google Ads account(s) from which data should be extracted. You have the option to include multiple accounts if necessary.
Google Ads account selection in Catchr
  • Choose which metrics and dimensions you want in the data request. Feel free to select multiple options here.
Metrics and dimensions selection in Catchr
Additional metrics and dimensions selection in Catchr

Warning: If you're using one of Catchr's templates, ensure that you select all the necessary dimensions and metrics as listed on the template's page within Catchr. This action triggers the template to automatically load with all pertinent data, after which you can tailor it to your specific requirements.

  • Determine the time frame for Google Ads data extraction - this can be a predefined or a custom period.
Time period selection in Catchr
  • Apply filters to your request as needed, which you can stack for more targeted data extraction.
Filter application in Catchr
  • At this stage, you may also modify your request with available platform-specific options.
Adding options to request in Catchr
  • Once finalized, a URL will materialize in the top bar. This is your data's direct line to PowerBI—'Preview' to see an immediate representation of your data.
Data preview
  • If the preview aligns with expectations, simply copy the URL—you'll input this into PowerBI momentarily.
Data preview on Catchr
Copying URL for PowerBI

Import the Google Ads data and KPI to PowerBI

PowerBI Desktop:
PowerBI Desktop allows for versatile data import from a host of sources, including web pages. For our purposes, we'll pivot to a web data source to assimilate the Google Ads data.

  • Go to 'Get Data' and select 'Web'.
Selecting Web data source in PowerBI
  • Paste the previously copied URL into the 'Basics' input field.
Pasting request URL in PowerBI
  • Choose 'OK' to finalize.

PowerBI may take a short period to import your data fully. Once that's accomplished, harness PowerBI Query to refine your data, and commence constructing a dashboard to put your Google Ads statistics into perspective. You can then proceed to publish and disseminate your newly minted dashboard to requisite parties.

PowerBI Web App:
To utilize a data set in PowerBI's web app, push it through from PowerBI Desktop and then activate it on the browser-based app. Revisiting prior steps will be instructive in publishing your web data source from PowerBI Desktop.

Subsequently, opt for 'New Report' and select an uploaded data set to form the basis of your report. Here, you'll encounter all your data sets, ready to be leveraged into compelling visual reports.

In short, by following this guide, you've unlocked the power to meld Google Ads data with PowerBI, allowing for an enhanced analytical perspective on your marketing campaigns' data.

Example of metrics you can use with the PowerBI Integration for Google Ads

PowerBI is a dominant force in the visualization and manipulation of complex data sets. When connected with Google Ads, a plethora of actionable metrics are put at your fingertips, fostering data-driven insights. Metrics such as Clicks, Impressions, and Cost per Click (CPC) serve as foundational elements of data analysis.

These metrics can be extrapolated to illuminate trends over time, draw comparisons between campaigns, or grant granularity down to the keyword level, providing a multidimensional view of your marketing endeavors. The integration permits custom queries and filters, allowing tailoring of data to align with unique organizational goals. With the capacity to visualize data through custom dashboards and report templates, PowerBI accelerates understanding, sharing, and application of insights drawn from A data.

Here is an example of how these capabilities could be employed: A marketer could use the integration to splice cost data across different campaigns to determine ROI, combine it with conversion rate to assess the efficiency of ad spend, or overlay it with session data to comprehend wider customer engagement trends.

To explore the full spectrum of metrics available through Catchr's Google Ads metrics for PowerBI, visit the comprehensive fields listing at Catchr's Google Ads Metrics for an extensive overview.

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 Power BI

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

Start your free trial!
Keep an eye on your data

Connect your Google Ads data to Google Sheets thanks to Catchr's no code connector!

Start your free trial!
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?

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

Get it for free
Need a clearer view of your marketing data?

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

Get it for free

Bonus : Your free Google Ads KPIs Template

In this Google Ads 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.

Bonus : Your free Google Ads Overview Template for PowerBI

In this Google Ads 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 Google Ads