This banner can be used to inform vistors of something important.
Learn more
You can easiliy create a Microsoft Ads report following this step :
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:
Option B: Directly within a Google Sheets:
Once you have installed the add-on, you can start making requests.
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.
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.
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.
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.
In the "metrics" tab, select the metrics you want to include in your report. Some examples of commonly used Microsoft Ads metrics are:
In the "Dimensions" tab, select the dimensions you want to include in your report. Some examples of useful Microsoft Ads dimensions are:
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.
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.
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.
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.
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.
.png)
