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.
This tutorial will guide you through the process of linking your Microsoft Ads account with Looker Studio (formerly Google Data Studio), enabling you to create rich, dynamic, and customizable marketing reports. By following these steps, you'll be able to visualize your advertising data in real time, uncover actionable insights, and make data-driven decisions to optimize your Microsoft Ads campaigns. Let's get started on simplifying your reporting workflow.
Embarking on your data visualization journey begins with setting up an account on Looker Studio. If you're leveraging Google's ecosystem, the process is streamlined for you. Simply use your existing Google account to access Looker Studio.
Let's dive into the specifics of integrating your Microsoft Ads data. Follow these instructions carefully, and you'll be analyzing your data in no time.
When it's your first time using a connector, there are a couple of authorization steps you need to follow:
If you don't see the "Add" button at the bottom right, it may be labeled as "Create Report" at the top right of the screen.
In conclusion, by linking Microsoft Ads data with Looker Studio using the Catchr connector, you're now ready to build powerful marketing reports that will empower you to make strategic decisions based on up-to-date and comprehensive data.
The integration of Microsoft Ads with Looker Studio presents a palette of detailed metrics, enabling you to analyze and visualize data in unprecedented ways. You can track campaign performances, understand demographic insights, assess search query trends, and much more. These metrics can be woven into engaging reports that tell the story of your ads' success and areas for optimization.
Visualizing performance data, such as Click-Through Rate (CTR) in conjunction with Cost Per Click (CPC) and Conversion Rate, allows marketers to gauge which campaigns and keywords are driving the most valuable traffic. Advanced metrics like Quality Score and Impression Share provide deeper insight into how efficiently your ads are reaching the intended audience.
Utilizing demographic data such as Age Group or Gender can help tailor your creative messaging and bidding strategies for specific audience segments, thus enhancing relevancy and likely improving performance.
For an extensive list of all metrics you can track and analyze with Catchr for Microsoft Ads in Looker Studio, refer to the detailed fields listing at Microsoft Ads Metrics on Catchr.io.
Take the power of data analytics into your own hands by incorporating these comprehensive metrics into Looker Studio, and transform raw data into visually compelling and insightful reports that drive actionable marketing decisions.
Ok, all the configuration steps are done. We can now start to create your dashboard.
If you have clicked Create Report, you are now in front of a blank report with just your data source. To learn what is each section of this page, check this short article.
We will create this dashboard so you can use it as a template for other accounts.
For a Microsoft Ads account, we want to follow each step, from when your ads have been seen to when a customer purchases on your website, passing by your number of clicks and your percentage of people that visit your ads and click on them.
Here's the list of KPIs:
And here is how to display them (sometimes a gif is better than a long story) :
Now, we want to add some breakdowns to our KPIs. That way, we can identify give more insight to our viewers.
To do so, create a new table and choose "Campaign Name" as the dimensions and add some metrics :
You can do the same with the following dimensions :
Do not hesitate to explore the fields in the right column. You can find more exciting dimensions that can help you present your results.
You know how to display your information through charts. But your report must still be more beautiful, even with more cards or tables.
To create a visually pleasing dashboard, we will change the dimension and add a header, a square behind the cards, and colors on our table.
From the menu Theme and Layout, then Layout, search for the Canvas Size section and change the height to 2000 :
You now have enough place for all the tables.
Please note that you change the canvas dimension for all the reports in Theme and Layout. So if you add a new page, they will also have these dimensions.
But you can override this configuration in the Page -> Current Page Settings menu, then Style and Canvas Size. All settings chosen here will only apply to the current page.
In Looker Studio, you can natively add two shapes: Rectangle and circle. It's easy to use :
We will start by adding a square at the top of the page, enlarge it to take the full width, and finally, change its color in the Style menu :
Then create a new text field to give a title to your report :
You can also add images in PNG format, for example, your logo or clients logo:
You know how to add a rectangle. We will now add one behind the card. To do so, place a rectangle. Then Right Clicks on it. Then choose Order -> Send to back :
We will also change the table header. You can check on the Style tab for every component to modify the visual appearance.
Table is no exception. We can change the color of the header, the font size and color, the interline color, etc.
Tips: you can apply only the style of an element to the other: copy one component you want to re-use the style, the right clicks on other components, Paste Special -> Paste style only
Alignment tips: if you select multiple elements and right-click on them, you have three options that will become your best friends if you like when everything is pixel-perfect:
Shape tips: Looker Studio can only draw two shapes but will accept all PNG. You can use Google Draw to create forms that suit your needs and download them to PNG for your reports.
There are multiple ways to customize your report. For example, you can filter your data by date or campaign or compare KPIs to a previous period.
And you can let your viewer play with dynamic filters to let him dig into the data.
In the shortcut bar, click on Add a control. Then select the Drop-down list. Place it on the page and add the Campaign Name dimension.
Now, the viewer can filter the entire report by campaign name.
You can also use the Fixed-size list and the Advanced filter to have the same result with a different appearance.
On every component, you can find a section called Comparison date range. Looker Studio will compare the data to the previously selected period if you activate it.
To do so :
.png)
