Blog post

Microsoft Ads & Looker Studio: setup guide

Catchr

Microsoft Ads

November 16, 2023
| Lastest update
July 1, 2025

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

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

  1. Get informations from the data integration from our Microsoft 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 Microsoft 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.

Quick steps to create a Microsoft Ads report with Looker Studio:

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

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

Quick steps to create a Microsoft Ads report with PowerBI:

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

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

The intent of this tutorial is to empower marketing professionals to seamlessly integrate their Microsoft Ads account into Looker Studio (formerly Google Data Studio), enabling them to visualize and draw insights from their marketing data. By following this guide, users will understand how to create a data source within Looker Studio and harness the full suite of metrics available from the Microsoft Ads platform.

How to connect your Microsoft Ads account to Looker Studio

Create an Account on Looker Studio

Starting your journey with Looker Studio is straightforward—if you haven't yet, sign up for an account. For those with Google accounts, the process is even smoother: simply use your existing Google credentials to sign in.

Looker Studio sign-up page

Connect Microsoft Ads to Looker Studio

Let's dive into the connection details. With a step-by-step approach, these instructions will guide you thoroughly through the process:

  1. Navigate to your Looker Studio homepage and select "Create" to begin the process of set-up for a new report.
Start by creating a new report
  1. On the new screen, opt for "Report" to proceed toward data integration.
Selecting 'Report' option
  1. Look for the Catchr Microsoft Ads data connector in the 'data sources' gallery in Looker Studio.
Looking up the Catchr data connector

Step-by-step guide on the authorization step

If this is your first time connecting, there will be a few authorization steps needed:

For first-time authorization:

  1. A window will request authorization for the community connector to interface with Looker Studio.
Authorizing Looker Studio community connector
  1. Select the Google Account that you wish to link with Looker Studio.
Choosing your Google Account
  1. Review the permissions required by Looker Studio, then scroll down.
Permissions overview for Looker Studio
  1. Click "Allow" to grant access to your Google Account.
Allowing access to Looker Studio

That covers Google's part. Now, let's set up the connection to Microsoft Ads through Catchr:

  1. Below the Looker Studio authorization, you'll find another 'Authorize' button for connecting Catchr to your Microsoft Ads account.
Authorization button for connecting Catchr to Microsoft Ads
  1. A pop-up will appear with instructions to authorize the connection. Follow them closely.
Pop-up instructions for Catchr-Microsoft Ads authorization
  1. Once you authorize this connection, you will see a loading notification. Once it completes, proceed further on the same page.
Loading indication after authorization
  1. Select the Microsoft Ads account you wish to connect, then click "Add". If there's no "Add" button, it might be labeled "Create Report" or simply "Report" in some instances.
Adding the Microsoft Ads account

And just like that, you've connected your Microsoft Ads account to Looker Studio! Begin crafting custom reports to visualize your data how you see fit.

Experience Advanced Analytics with Microsoft Ads Metrics in Looker Studio

Utilize Microsoft Ads metrics in Looker Studio to uncover the subtleties and trends in your marketing campaigns. Analyzing pivotal factors such as click-through rates (CTR), conversion metrics, and return on ad spend (ROAS) help in optimizing the campaign performance. Moreover, Looker Studio's ability to display real-time data ensures immediate feedback on any implemented changes.

Envisage your CTR rates ascending favorably on your dashboard as you tweak ad copy or shift focus to higher performing keywords. Or, perhaps, detect how conversion rates vary across different demographics and regions, fueling a more targeted marketing approach. Not to forget, ROAS metrics allow for a granular analysis of your spending efficacy. Delve deeper into these capabilities and more by accessing the extensive fields listing provided by Catchr at Catchr's Bing Ads Metric Resource.

Bring creativity to your reports by deploying Looker Studio's visually appealing charts, tables, and diagrams, making data not only informative but also engaging for stakeholders. Whichever metrics resonate with your business goals, Looker Studio and Catchr pave the way for insightful, actionable marketing data visualization.

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?

Unlock your free Microsoft 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 Ads Performance dashboard template for Looker Studio from a collection of +50 stunning designs. Elevate your data visualization!

Get it for free

Bonus: Your free Ads Performance Template

In this Microsoft 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 Microsoft Ads OverviewTemplate for PowerBI

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