Microsoft Advertising Data Connector User Guide

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 key metrics to optimize your advertising campaigns.


Prerequisites

Before connecting Microsoft Advertising to Power My Analytics, ensure you have:
  1. A Microsoft Advertising account with either Super Admin or Advertiser Campaign Manager role
  2. Multifactor authentication enabled on your Microsoft Advertising account

Grant Access to an Account in Microsoft Advertising

To grant access to an account in Microsoft Advertising:
  1. Log in to Microsoft Advertising.
  2. Go to Tools > Account access.
  3. Under User management, click Invite user.
  4. Make sure the Account role is set to Advertiser Campaign Manager or Super Admin.

Adding Microsoft Advertising as a Data Source

  1. Log in to your Power My Analytics hub.
  2. Navigate to Sources in the main menu.
  3. Click + New Data Source.
  4. Select Microsoft Advertising from the gallery.
  5. Sign in to your Microsoft account to authenticate.

Creating a Looker Studio Report

Follow these steps to create a Looker Studio report using your Microsoft Advertising data:
  1. After adding Microsoft Advertising as a data source, go to Reports > Looker Studio in your PMA hub
  2. Select Microsoft Advertising under Create Looker Studio Report (this will open the official Looker Studio application in a new window)
  3. Google Looker Studio Configuration:
    1. Step 1:
      1. Name your data source (e.g., "Microsoft Advertising - Your Organization")
      2. Choose your Power My Analytics hub from the dropdown
      3. Optional: Leave "Use report template for new reports" checked to use the PMA demo template
      4. Click Next
    2. Step 2:
      1. User Account: Select your Microsoft Advertising account (or "Sample Account" for sample data)
      2. Click Next
    3. Step 3:
      1. Choose "Accounts" and "Currency" for your reports
      2. Optional: Allow "Accounts" modification in reports
      3. Click Connect in the top right to complete the configuration
    4. Step 4:
      1. Click Create Report in the top right
For a quick start, use our pre-built Microsoft Advertising demo template.

Key Reports and Fields

Microsoft Advertising data in Power My Analytics offers a wide range of metrics and dimensions. Here are some popular metrics you can use in your reports:
  1. Account Metrics: Clicks, Impressions, CTR, Avg. CPC, Spend, Conv.
  2. Campaign Metrics: Clicks, Impr., CTR, Avg. CPC, Spend, Conv.
  3. Ad Group Metrics: Clicks, Impr., CTR, Avg. CPC, Spend, Average cost per 1,000 impressions (CPM)
  4. Ad Metrics: Clicks, Impr., CTR, Avg. CPC, Spend, Conv.
  5. Landing Page Metrics: Impressions, Clicks, CTR, Avg. CPC, Spend, Conv.
  6. Keyword Metrics: Clicks, Impr., CTR, Avg. CPC, Spend
  7. Dynamic Ad Target Metrics: Impressions, Clicks, CTR, Avg. CPC, Spend
  8. Auction Metrics: Overlap rate, Position above rate, Top of page rate, Outranking share
  9. Demographic Metrics: Spend, Clicks, Impressions by Company Name, Industry Name, Job Function Name; Impressions by Age, Impressions by Gender
  10. Locations: Spend, Clicks, Impressions by Country
For a complete list of available Microsoft Advertising fields, refer to the Schema Explorer.

Limitations and Important Considerations

  1. Backfilling: Power My Analytics can retrieve up to 2 years of historical data. When first connecting your Microsoft Ads account, 13 months of data will be automatically imported.

Unavailable Data

  1. Custom fields

Troubleshooting Microsoft Ads

See Troubleshooting Microsoft Ads for information on issues that may affect the Microsoft Advertising connector.


    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • Google Ads Data Connector User Guide

        Google Ads is a powerful online advertising platform that allows businesses to reach potential customers across Google's vast network. This guide will walk you through how to connect your Google Ads data to Power My Analytics, create reports in ...

      • Pinterest Ads Data Connector User Guide

        Pinterest Ads is a powerful advertising platform that allows businesses to promote their products and services to Pinterest's vast user base. This guide will walk you through the process of connecting your Pinterest Ads account to Power My Analytics, ...

      • LinkedIn Ads Data Connector User Guide

        LinkedIn Ads is a powerful platform for B2B marketing, lead generation, and brand awareness campaigns. This guide will help you connect your LinkedIn Ads account to Power My Analytics, enabling you to create comprehensive reports and gain valuable ...

      • 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. ...

      • Quora Ads Data Connector User Guide

        Quora Ads allows marketers to reach a highly engaged audience through targeted advertising on the Quora platform. This guide will walk you through how to connect your Quora Ads data to Power My Analytics and create insightful reports in Looker ...