---
title: "Microsoft Advertising connection guide"
slug: "microsoft-advertising-connection-guide"
description: "Connect Microsoft Advertising to Supermetrics with our guide on permissions, requirements, and detailed connection instructions for seamless data access."
updated: 2026-07-08T09:01:07Z
published: 2026-07-08T09:01:07Z
canonical: "docs.supermetrics.com/microsoft-advertising-connection-guide"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft Advertising connection guide

This guide contains all permissions and requirements for connecting your Microsoft Advertising data to Supermetrics.

You can connect to data sources from the [Data sources page on the Supermetrics Hub](https://hub.supermetrics.com/token-management). On the Hub, you can also [share an authentication link](https://docs.supermetrics.com/v1/docs/how-to-connect-to-data-sources-from-supermetrics-hub#share-authentication-link) to connect to a data source you don't have direct access to.

After you connect to the data source on the Hub, you can use the data source connection in [all available destinations](/docs/microsoft-advertising-connection-guide#connection-instructions).

## Required permissions

To connect Supermetrics to Microsoft Advertising, you need:

- A Microsoft user account with at least **Advertiser Campaign Manager** access to an ad account. Learn how to [grant access to Microsoft Advertising account](https://help.bingads.microsoft.com/#apex/3/en/52037/3).
- Multi-factor authentication enabled for the Microsoft user account — this is a requirement for access to Microsoft Advertising via its API. See [Microsoft's account security information for more details](https://support.microsoft.com/en-us/account-billing/microsoft-account-security-info-verification-codes-bf2505ca-cae5-c5b4-77d1-69d3343a5452).

Note that **you need to connect with your Microsoft personal or work account**. A Google account used to sign in to Microsoft Ads isn’t compatible with the Supermetrics authentication flow.

See our [Microsoft Advertising permissions troubleshooting guide](/v1/docs/microsoft-advertising-permissions-troubleshooting-guide) if you're experiencing issues with permissions in your organization or need admin approval.

## Connection instructions

When connecting to Microsoft Advertising, you need to log in to Microsoft and select the accounts to pull data from.

1. Select the Microsoft Advertising data source [on the Supermetrics Hub](https://hub.supermetrics.com/token-management) or in the data destination.
2. If prompted, choose to make this connection [shared or private](https://docs.supermetrics.com/docs/about-shared-and-private-connections).
3. Click **Start**.
4. Enter your Microsoft email address and click **Next**.
5. Enter your Microsoft password and click **Sign in**.
6. Click **Accept**.
7. In your data destination, select the accounts you'd like to include in your reporting.

See detailed instructions on [how to connect to a data source from the Supermetrics Hub](https://docs.supermetrics.com/docs/how-to-connect-to-data-sources-from-supermetrics-hub).

You can also connect to Microsoft Advertising from these destinations:

- Google Sheets: [How to connect to a Supermetrics data source in Google Sheets](https://docs.supermetrics.com/docs/how-to-connect-to-a-supermetrics-data-source-in-google-sheets)
- Data Studio: [How to connect data sources to Data Studio](/v1/docs/how-to-connect-data-sources-to-data-studio)
- Excel: [How to connect data sources to Excel with Supermetrics](https://docs.supermetrics.com/docs/how-to-connect-data-sources-to-excel-with-supermetrics)
- Power BI: [How to create your first Supermetrics query for Power BI](https://docs.supermetrics.com/docs/how-to-create-your-first-supermetrics-query-for-power-bi)
- The Supermetrics API: [How to use the Query Manager](https://docs.supermetrics.com/docs/how-to-use-the-query-manager)
- Data warehouse and cloud storage (Hub): [How to create a transfer](https://docs.supermetrics.com/docs/how-to-create-a-transfer)
- BigQuery (marketplace): [How to create a BigQuery (marketplace) transfer](https://docs.supermetrics.com/v1/docs/how-to-create-a-bigquery-marketplace-transfer)

## More resources

- [Microsoft Advertising report building guide](/v1/docs/microsoft-advertising-report-building-guide)
- [Microsoft Advertising: Permissions troubleshooting guide](/v1/docs/microsoft-advertising-permissions-troubleshooting-guide)
- [How to reauthenticate a data source connection](/v1/docs/how-to-reauthenticate-a-data-source-connection)
- [How to manage data source connections on the Supermetrics Hub](https://docs.supermetrics.com/docs/how-to-manage-data-source-connections-on-supermetrics-hub)