Microsoft Ads
The Microsoft Ads connector gets your Microsoft Ads data into Google Sheets and Google Data Studio. Use it to track your key metrics in a spreadsheet or a Google Data Studio report.
What you can report on
- Campaign, ad group, and keyword performance on Bing
- Impressions, clicks, CTR, and average CPC
- Conversions, conversion rate, and cost per conversion
- Audience targeting and demographic breakdowns
- Impression share and competitive auction insights
Prerequisites
- A Microsoft Advertising (Bing Ads) account
- Advertiser Campaign Manager access or higher on the accounts you want to report on
- Multi-factor authentication (MFA) enabled on your Microsoft account. Microsoft's API requires it, and you can't skip it
- If you sign in with a work or school Microsoft account, your organization's Microsoft Entra tenant needs the Advertising API enabled. If Microsoft declines the sign-in, see Microsoft Ads: organization hasn't enabled the Advertising API
How to create a connection
- In the Hub, open Connections & accounts.
- Select Create connection.
- Select Microsoft Ads in the connector list.
- Select Next.
- In Name the connection, enter a name.
- Sign in with Microsoft. Then allow Two Minute Reports access.
- Enable the accounts you want to report on.
- Select Done.
How to get Microsoft Ads data into Google Sheets or Google Data Studio
To get Microsoft Ads data into Google Sheets:
- In the Two Minute Reports sidebar, open Data Queries.
- Select Add.
- Select the accounts you want to report on. You can select more than one.
- Select your metrics and dimensions.
- Select the date range.
- Set sorting and filters if you need them.
- Select Run query. Two Minute Reports adds the data to your sheet.
To get Microsoft Ads data into Google Data Studio:
- In the Hub, open Google Data Studio › Microsoft Ads.
- Select Create report.
- Select or create a query config:
- To use a query config you have: select it in Choose your query config. Then select Save.
- To create a query config: if you already have one, first select Create new query config in the list. Enter a name in Name your query config, and select the accounts in Select your accounts. Select Save.
- Select Create from scratch. If templates show under Quick start from a template, you can select one instead.
- Looker Studio (formerly Google Data Studio) opens in a new tab, with the Two Minute Reports connector. If you are in more than one team, select your team in Select your Team.
- In Select Query Config, select your query config.
- Select Connect in the top-right corner.
- In your new report, add Microsoft Ads metrics and dimensions to the canvas.
Understanding and resolving data discrepancies
The data in Two Minute Reports can be different from the data in Microsoft Advertising. This section gives the usual causes and how to correct each one.
Ad group totals lower than the Overview
Your query can include Ad group name, or another ad group, ad or keyword dimension. Then the spend, clicks and revenue can be lower than on the Overview page in Microsoft Advertising, for the same account and dates.
Performance Max campaigns do not use ad groups. They use asset groups. Microsoft has no ad group for their data, so ad group reports do not include it. The Overview page shows the totals for the account, which include all campaign types. Your Search and Shopping data is correct. The difference is the Performance Max spend.
If you add Campaign name next to Ad group name, the result does not change. While Ad group name is in the query, Two Minute Reports gets the data from the ad group report.
To include Performance Max:
- Remove Ad group name and show the report by Campaign name. Add Campaign type to see which rows are Performance Max.
- For account totals only, use Date or no dimension. These totals agree with the Overview.
- If you also need the ad group data for Search or Shopping, keep that query. Add a second query by Campaign name for your totals.
Limitations
Microsoft Ads keeps report data for the last 36 months only. A query cannot get data that is older than 36 months.
Troubleshooting
A date range outside the last 36 months shows an error
If the date range of your query falls outside the last 36 months, Microsoft Ads can refuse the request. Then you see this message:
Microsoft Ads only keeps report data for the last 36 months, and this date range falls outside it. Please choose dates within the last 36 months, then try again.
Change the date range so that it is in the last 36 months. Then run the query again.