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. On the Hub, you can also share an 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.
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.
- 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.
Connection instructions
When connecting to Microsoft Advertising, you need to log in to Microsoft and select the accounts to pull data from.
- Select the Microsoft Advertising data source on the Supermetrics Hub or in the data destination.
- If prompted, choose to make this connection shared or private.
- Click Start.
- Enter your Microsoft email address and click Next.
- Enter your Microsoft password and click Sign in.
- Click Accept.
- 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.
You can also connect to Microsoft Advertising from these destinations:
- Google Sheets: How to log in to a Supermetrics data source in Google Sheets
- Looker Studio: How to connect data sources to Looker Studio
- Excel: How to connect data sources to Excel with Supermetrics
- Power BI: How to create your first Supermetrics query for Power BI
- The Supermetrics API: How to use the Query Manager
- Data warehouse and cloud storage (Hub): How to create a transfer
- BigQuery (marketplace): How to create a BigQuery (marketplace) transfer