blog post

How to export your marketing data from Microsoft Ads to Google Sheets

Florian Cabirol
September 11, 2024
How to export your marketing data from Microsoft Ads to Google Sheets

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.

The tutorial

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.

The tutorial

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 tutorial

If you're running a Search Engine Advertising (SEA) agency, you know that data is the lifeblood of your campaigns. Without the right data, you can't make informed decisions, optimize your ads, or track your results. One key source of this data is Microsoft Ads – a powerful marketing platform that can help you drive traffic, conversions, and sales. But to truly harness the power of Microsoft Ads data, you need to integrate it with a flexible, powerful tool like Google Sheets. In this blog post, we'll show you how to use the Catchr add-on for Google Sheets to export your Microsoft Ads data and unlock its full potential.

Create a new query

Open a new Google Sheet, click on "Add-ons" in the menu, and select "Catchr - Data Connector". Click on "Add new" to create a new query.

Open the Catchr add-on in Google Sheet.
Open the Catchr add-on in Google Sheet.

Select the source

In the query tab, choose Microsoft Ads as your source. If you haven't connected your Microsoft Ads account yet, click on the "+" button to add it.

Select the Bing Ads source from Google Sheets Add-on

Select your account(s)

Go to the "Select account(s)" tab and choose the Microsoft Ads account(s) you want to use. You can select multiple accounts if needed. 

Select accounts for Microsoft Ads from Google Sheets Add-on.

Choose the metrics

In the "metrics" tab, select the metrics you want to include in your report. Some examples of commonly used Microsoft Ads metrics are:

  • Clicks: The number of times users clicked on your ads.
  • Impressions: The number of times your ads were displayed on search results pages.
  • Cost: The total amount you spent on your ads.
Select metrics from Microsoft Ads

Choose the dimensions

In the "Dimensions" tab, select the dimensions you want to include in your report. Some examples of useful Microsoft Ads dimensions are:

  • Campaign Name: The name of the campaign your ads belong to
  • Ad Group Name: The name of the ad group your ads belong to
  • Device: The type of device users were on when they interacted with your ads (desktop, mobile, or tablet)
Select the dimension from Microsoft Ads
Select the dimension from Microsoft Ads

Set the date range

In the date range tab, choose the time period you want to analyze. You can use presets like "Last month" or "This year" or set custom date ranges.

Select the date range with preset from Microsoft Ads

Apply filters

If you want to focus on specific data points, you can use filters. For example, you might want to filter your report to only show data for ads with more than 500 impressions. To do this, select "Impressions" as the dimension, choose the ">" operator, and enter 500 as the value. 

Add a filter for Ads Impression greater than 100

Schedule automatic refreshes

In the options tab, you can set up automatic refreshes for your query. Click on "Schedule" and choose the frequency of updates. You can also enable options like "append rows" or "combine rows" to keep your data up-to-date.

Schedule automatic refreshes
Schedule automatic refreshes

Then, you just need to click on "Get data" and data. The data is fetched from Microsoft Ads API and pulled in Google Sheets Add-on. 

An example of a what you can build with Google Sheets and Catchr

Now that you've set up your Catchr query, let's explore what you can achieve with Google Sheets and Catchr. 

Organize your data: Start by organizing your data into a clear and easy-to-read format. You might want to sort your data by campaign or ad group, or group it by device type.


Calculate key metrics: Use Google Sheets formulas to calculate additional metrics, like CTR (click-through rate) or average CPC (cost per click). For example, to calculate CTR, you can create a new column and use the formula `=Clicks / Impressions`.


Visualize your data: Create charts and visualizations to help you understand your data at a glance. For example, you might create a pie chart to compare the performance of different campaigns or a bar chart to compare device performance.


Analyze your data: Use your custom metrics, visualizations, and organized data to identify trends, opportunities, and areas for improvement. This will help you make data-driven decisions about your Microsoft Ads campaigns.

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 Google Sheets

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

Start your free trial!
Keep an eye on your data

Connect your Microsoft Ads data to Power BI 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 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 Template Microsoft Ads - Overview - V2 dashboard template for Looker Studio from a collection of +50 stunning designs. Elevate your data visualization!

Get it for free

Bonus : Your free Template Microsoft Ads - Overview - V2 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