Microsoft Ads Data Connector User Guide

Microsoft Ads Data Connector User Guide


The following article is a guide to automating reports with your Microsoft Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Microsoft Ads reports. To begin creating reports with your Microsoft Ads connector, you will need at least one Microsoft Ads account as well as access to Google Data Studio or Google Sheets.

Available Data

  1. Key Performance Indicators - Impressions, clickthrough rate, clicks, conversions, and spend. View all of your trends in one place.
  2. Campaign breakdowns - Clicks, cost per click, impressions, spend, and conversion data.
  3. Ad Group breakdowns - Impressions, Impression shares, clickthrough rate, clicks, conversions, and spend.
  4. Keyword breakdowns Impressions, clickthrough rate, clicks, conversions, cost per acquisition, and spend.
  5. Search Query breakdowns Impressions, clickthrough rate, clicks, conversions, cost per acquisition, ROAS, and spend.
  6. Age and Gender demographic breakdowns - Campaign performance by clicks.
  7. Company demographic breakdowns - Company, industry, job function, campaign, status, and spend. Data available for company-targeted advertising only. 
  8. Location breakdowns - Campaigns, clicks, impressions, and CTR by country.
  9. Competition reporting - Show how well your ads are performing versus the competition. Data includes impression share, average positions of the competition, overlap rate, above rate, top of page rate, and outranking share.
  10. Goals reporting - Check progress on your goals by clicks, spend, conversion, revenue, cost per click, conversion rate, and ROAS.
  11. Complete List of Fields.

Connection Requirements

A minimum of Advertiser Campaign Manager level access is required to retrieve data successfully. Multifactor Authentication must also be enabled.

Backfilling

Power My Analytics will initially backfill 13 months of data with the Microsoft Ads connector. To access up to 2 years of data, run a backfill from your Hub.

Troubleshooting Microsoft Ads

See our Troubleshooting Microsoft Ads article for all of the latest information on issues that may affect Microsoft Ads connectors.


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

      • Instagram Ads Data Connector User Guide

        The following article is a guide for automating reports with your Facebook Ads connector. It includes metrics available and instructions for how to connect, use, and backfill your Facebook Ads data. To create a Facebook Ads report, you will need at ...
      • Google Ads Data Connector User Guide

        The following article is a guide to automating reports with your Google Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Google Ads reports. To begin creating ...
      • Quora Ads Data Connector User Guide

        The following article is a guide to automating reports with your Quora Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Quora Ads reports. To begin creating ...
      • LinkedIn Ads Data Connector User Guide

        The following article is a guide to automating reports with your LinkedIn Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your LinkedIn Ads reports. To begin ...
      • Pinterest Ads Data Connector User Guide

        The following article is a guide to automating reports with your Pinterest Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Pinterest Ads reports. To begin ...