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 Looker Studio or Google Sheets.
Available Data
- Key Performance Indicators - Impressions, clickthrough rate, clicks, conversions, and spend. View all of your trends in one place.
- Campaign breakdowns - Clicks, cost per click, impressions, spend, and conversion data.
- Ad Group breakdowns - Impressions, Impression shares, clickthrough rate, clicks, conversions, and spend.
- Keyword breakdowns - Impressions, clickthrough rate, clicks, conversions, cost per acquisition, and spend.
- Search Query breakdowns - Impressions, clickthrough rate, clicks, conversions, cost per acquisition, ROAS, and spend.
- Age and Gender demographic breakdowns - Campaign performance by clicks.
- Company demographic breakdowns - Company, industry, job function, campaign, status, and spend. Data available for company-targeted advertising only.
- Location breakdowns - Campaigns, clicks, impressions, and CTR by country.
- 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.
- Goals reporting - Check progress on your goals by clicks, spend, conversion, revenue, cost per click, conversion rate, and ROAS.
- Complete List of Fields.
API Limitations
- Custom Fields - Custom fields are not available.
Connection Requirements
A minimum of Advertiser Campaign Manager level access is required to retrieve data successfully. Multifactor Authentication must also be enabled. To grant access to an account in Microsoft Ads, go to Users and click Invite user. Make sure the Account role is set to Advertiser Campaign Manager or higher.
Backfilling
Power My Analytics will initially backfill 13 months of data when you first create a report. 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 Instagram Ads connector. It includes metrics available and instructions for how to connect, use, and backfill your Instagram Ads data. To create an Instagram Ads report, you will need ...Twitter Ads Data Connector User Guide
The following article is a guide to automating reports with your Twitter Ads connector. It includes information on available data as well as tips on how to get the most out of your Twitter Ads reports. To begin creating reports with your Twitter Ads ...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 ...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 ...