How to Connect to Microsoft Advertising

Looking to bring your Microsoft Advertising (formerly Bing Ads) data into a single, automated reporting workflow? This guide will walk you through connecting Microsoft Advertising as a data source in Power My Analytics, so you can centralize your search advertising metrics, create comprehensive reports, and make data-driven decisions to optimize your campaigns.

Prerequisites

Before you begin, make sure you have:

• A Microsoft Advertising account with either the Super Admin or Advertiser Campaign Manager role on the account you want to connect
• Multifactor authentication (MFA) enabled on your Microsoft Advertising account

If you do not yet have one of the required roles, follow Step 1 below to grant it before continuing.

Step 1: Grant Account Access in Microsoft Advertising

Power My Analytics requires either the Super Admin or Advertiser Campaign Manager role to authorize the connection and pull your ad data. To grant access to a user in Microsoft Advertising:

1. Log in to Microsoft Advertising.
2. Go to Tools > Account access.
3. Under User management, click Invite user.
4. Set the Account role to Advertiser Campaign Manager or Super Admin.
5. Send the invitation, and have the invited user accept it before continuing.

Power My Analytics' connector will never edit, create, or delete anything in your Microsoft Advertising account. The Super Admin or Advertiser Campaign Manager role is required because Microsoft's API restricts ad data access to those roles.

Step 2: Add Microsoft Advertising as a Data Source in Power My Analytics

1. Log in to your Power My Analytics hub at https://hub.powermyanalytics.com.
2. Navigate to Sources from the main menu.
3. Click + Add new source.
4. Select Microsoft Advertising from the list of available sources.
5. Sign in to your Microsoft account using credentials with one of the required roles from Step 1.
6. Complete the multifactor authentication prompt and authorize the requested permission scopes.

Once connected, Microsoft Advertising will appear in your list of active data sources. Your Microsoft Advertising data will automatically begin syncing to your Power My Analytics data warehouse — 13 months of historical data is imported automatically on the initial backfill, with up to 2 years available via manual backfill. When the initial backfill is finished, you can use this data in Looker Studio reports, Google Sheets, Microsoft Excel, or export it to your preferred data destination.

MFA required: Microsoft requires multifactor authentication on accounts used with their advertising APIs. If MFA is not yet enabled on your Microsoft Advertising account, you'll need to enable it before the connection will succeed.

Account Name vs Account fields: For most reporting purposes, the Account Name field is the recommended field to use, as it displays the clean, human-readable account name. The Account field appends an internal ID in parentheses, which is only needed if you manage multiple accounts with identical names.

Related Articles

• Microsoft Advertising Data Connector User Guide
• Troubleshooting Microsoft Ads
• Basic Troubleshooting
• Submit a Ticket

• Related Articles

• Microsoft Advertising Data Connector User Guide

  Microsoft Advertising (formerly known as Bing Ads) is a powerful platform for search advertising, keyword targeting, and more. This guide will walk you through how to connect Microsoft Advertising to Power My Analytics, create reports, and leverage ...

• How to Connect to Google Ads

  Looking to bring your Google Ads data into a single, automated reporting workflow? This guide will walk you through connecting Google Ads as a data source in Power My Analytics, so you can centralize your campaign performance metrics, create ...

• Spotify Advertising Data Connector User Guide

  Spotify Advertising allows marketers to track and analyze their audio, video, and display ad campaigns across the Spotify platform. This guide will help you connect your Spotify Advertising data to Power My Analytics and create insightful reports. ...

• How to Connect to LinkedIn Ads

  Looking to bring your LinkedIn Ads data into a single, automated reporting workflow? This guide will walk you through connecting LinkedIn Ads as a data source in Power My Analytics, so you can centralize your B2B advertising metrics, create ...

• How to Connect to Pinterest Ads

  Looking to bring your Pinterest Ads data into a single, automated reporting workflow? This guide will walk you through connecting Pinterest Ads as a data source in Power My Analytics, so you can centralize your campaign, ad group, and ad performance ...