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 easy-to-use sidebar.
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:
- Create a new Google spreadsheet (or open an existing one).
- In the menu bar choose: Extensions > Add-ons > Get add-ons
- Find the “Microsoft Ads (Bing Ads) reporting by Adformatic” add-on in the add-on gallery and select it.
- On the add-on description page, click install in the top right corner to add this add-on to your spreadsheet.
- A dialog should appear asking for permission for the add-on to access your Google Sheet. Click on "Allow".
- 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 in 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 "Save report".
You can go through these steps again to add another Microsoft Advertising report. You can also copy a report using the copy icon in the sidebar.
Edit Microsoft Advertising reports
In the add-on menu you can select "Manage reports". A sidebar will open with a list of your reports. You can click "edit" for the report you would like to edit. You can make changes in the sidebar and save the new configuration.
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. You can also run each report separately through the sidebar.
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:
|
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:
|
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. Enable this option 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 enabled, the report is not executed. |
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.