Microsoft Advertising add-on for Google Sheets

Download Microsoft Advertising data to Google Sheets.

This Google Sheets add-on helps you view and edit Microsoft Advertising data more easily in Google Sheets.

  • Easy to use report configurator.
  • Schedule your reports to automatically refresh (up to hourly).
  • Receive an email when your report is ready.
  • Edit report configurations with the sidebar or in the sheet.

Get your subscription

You can use this Microsoft Advertising add-on for Google Sheets for free for 14 days. If you wish to continue using the add-on after the free trial period, please subscribe. Each subscription includes:

  • Unlimited Microsoft Advertising accounts
  • Unlimited reports (Google Sheets limits apply.)
  • Up to hourly automated refreshes
  • Email support

Install the Google Sheets add-on

To use the Microsoft Advertising add-on, you must first add it to your spreadsheet. The following instructions will guide you through the process:

  1. Create a new Google spreadsheet (or open an existing one).
  2. In the menu bar choose: Extensions > Add-ons > Get add-ons
  3. Find the “Microsoft Ads (Bing Ads) reporting by Adformatic” add-on in the add-on gallery and select it.
  4. On the add-on description page, click install in the top right corner to add this add-on to your spreadsheet.
  5. A dialog should appear asking for permission for the add-on to access your Google Sheet. Click on "Allow".
  6. The add-on is now installed. The "Microsoft Ads (Bing Ads) reporting by Adformatic" submenu should now appear in the Extensions menu.

You can also go directly to the add-on in the Google Workspace Marketplace,  here you can install the add-on. The add-on is then available in every Google Spreadsheet under "Extensions".

Create Microsoft Advertising reports

Reports can be created manually in the configuration sheet or using the add-ons sidebar. To use the sidebar, select "Extensions'' > "Microsoft Ads (Bing Ads) reporting by Adformatic" > "Create report" in the menu bar.
This will display a sidebar on the right side with which you can easily create a report configuration. The sidebar helps with the following:

  • Look up Microsoft Advertising account information.
  • Selecting attributes and metrics.
  • Determine the sorting of the report.

When you are done, click on the button "Add report to sheet" and your report configuration will appear in the sheet called “Microsoft Advertising report configuration” (if this sheet does not already exist, it will be created).

You can go through these steps again to add another Microsoft Advertising report. You can also copy the information in the sheet to a new column and edit it in the sheet.
Not all cells are filled by the sidebar. The fields that are not filled by the sidebar can be entered in the sheet.

Edit Microsoft Advertising reports

There are two ways to edit reports after you create them:

  • In the add-on menu you can select "Edit report". A sidebar will open with a list of the report names currently in your configuration sheet. You can select one and the sidebar will load your report configuration in the sidebar. You can make changes in the sidebar and save the new configuration to the configuration sheet.
  • Another option is to edit the report configuration directly in the sheet.

Run reports

Go to "Extensions" > "Microsoft Ads (Bing Ads) reporting by Adformatic" > "Run reports" in the menu to run all the reports you have created.

Schedule reports to run automatically

Reports can be scheduled to run automatically. To do this, go to "Extensions" > "Microsoft Ads (Bing Ads) reporting by Adformatic" > "Set schedule".
A dialog will open in which you can indicate three things:

  • Turning a schedule on and off.
  • Choose the frequency, day and time.
  • Set whether you want to receive an email if the execution of a report fails.

The schedule uses the time zone of the spreadsheet. To update the time zone got to: "File" > "Settings" in the Google Sheets menu. If no time zone is set the schedule uses Coordinated Universal Time (UTC). If you change the time zone, you will have to set the schedule again to use the new time zone.

Report configuration options

Option Required Description
Report name Yes The name you give to the report. The name must be unique. If the name is not unique, a sequence number is automatically added to make it unique. The report name is also the name of the sheet to which the data is written.
Customer ID Yes The ID of the ad account that owns or is associated with the entities in the request. Please enter the id in this format: XXXXXXXXX.
Customer account ID Yes The ID of the Microsoft Advertising customer account you want to retrieve the data from. Please enter the id in this format: XXXXXXXXX.
Customer account name The name of the Microsoft Advertising customer account. This will show at the top of the report for your confenience.
Start date Yes The start date for retrieving Microsoft Advertising data. You can specify a specific start date formatted as YYYY-MM-DD or as a relative date.
Options for specifying a relative date:
  • XdaysAgo (X is a positive integer, for example 7daysAgo)
  • yesterday
  • sundayLastWeek
  • mondayLastWeek
  • fridayLastWeek
  • SaturdayLastWeek
View all possible options for relative dates.

You can also use the date functions of Google Sheets to specify this value programmatically. For example, the following expression returns the last day of the previous month: =EOMONTH(TODAY(), -1)
End date Yes The end date for retrieving Microsoft Advertising data. You can specify a specific end date formatted as YYYY-MM-DD or as a relative date.
Options for specifying a relative date:
  • XdaysAgo (X is a positive integer, for example 7daysAgo)
  • yesterday
  • sundayLastWeek
  • mondayLastWeek
  • fridayLastWeek
  • SaturdayLastWeek
View all possible options for relative dates

You can also use the date functions of Google Sheets to specify this value programmatically. For example, the following expression returns the last day of the previous month: =EOMONTH(TODAY(), -1)
Report type Yes Here you can define the report type. You can choose any report type listed here: https://learn.microsoft.com/en-us/advertising/guides/report-types?view=bingads-13
Columns Yes The columns are all the attributes and metrics for your report.
Sort The sort option allows you to determine in which order the rows are returned. You can sort the report on columns that are included in the report.
Limit The maximum number of rows for the report. If this parameter is left empty, all rows are shown.
Email addresses The email addresses to which this report should be sent. The report is only sent if the report contains at least 1 row of data. Leave this field blank to not send the report.
Hide report Header By default, extra information is shown above the report. Set the value to "TRUE" to hide this report header. The report then starts at row 1.
First column By default, the report data begins in the first column. However, you can alter this by specifying a different starting column number, such as 3, for the report to begin in column 3.
Skip report If TRUE, the report in the corresponding column is not executed.
Last update on This is a read only field. This field is filled by the add-on, so you can easily when a report was last updated.
Internal report ID This is a read only field, filled in by the add-on. It is the id of the requested report. If a report takes more then 6 minutes to create (which is rare), this ensures the report can be written to the sheet in the next run.
Time zone This is the time zone of the Microsoft Advertising account. It is filled in by the add-on if empty. The time zone is needed to request the report. Saving the time zone the the sheet makes the add-on faster.

Overview available relative dates

Relative dates:

  • XdaysAgo (X is a positive integer, for example 7daysAgo)
  • today
  • yesterday
  • mondayThisWeek
  • lastSunday
  • sundayLastWeek
  • mondayLastWeek
  • fridayLastWeek
  • saturdayLastWeek
  • sunday2WeekAgo
  • monday2WeekAgo
  • friday2WeekAgo
  • saturday2WeekAgo
  • firstDayThisMonth
  • firstDayLastMonth
  • lastDayLastMonth
  • firstDay2MonthsAgo
  • lastDay2MonthsAgo
  • firstDayThisYear

Relative dates last year

  • XdaysAgoLastYear (X is a positive integer, for example 7daysAgoLastYear)
  • sundayLastWeekLastYear
  • mondayLastWeekLastYear
  • fridayLastWeekLastYear
  • saturdayLastWeekLastYear
  • firstDayLastMonthLastYear
  • lastDayLastMonthLastYear
  • firstDayLastYear

Terms & privacy

The Google Sheets add-on "Microsoft Ads (Bing Ads) reporting by Adformatic" uses and transfers any information received from Google APIs to any other app in adherence to the Google API Services User Data Policy, including the Limited Use requirements.

For more information please visit our terms and conditions and privacy policy.

Questions and feature requests

If you have a question or a feature request. Please contact us.