--- title: "Microsoft Advertising (Bing Ads)" slug: "microsoft-ads" description: "Integration your Microsoft Ads data with Dataddo. Easily create a data source to get the exact metrics and attributes you need and select and sync frequency. " updated: 2026-02-18T18:31:23Z published: 2026-02-18T18:31:23Z --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt > Use this file to discover all available pages before exploring further. # Microsoft Advertising (Bing Ads) **Microsoft Advertising** is an online advertising platform that allows businesses to create and run advertising campaigns across Microsoft's search network, including Bing search engine and partner websites. It offers targeting options, ad creation tools, and performance tracking capabilities to help businesses reach their target audience and drive traffic, leads, and conversions through paid search advertising. Refer to Microsoft's official documentation to see [all available endpoints from the Microsoft Ads API](https://docs.microsoft.com/en-us/advertising/reporting-service/reporting-data-objects?view=bingads-13). ## Authorize Connection to Microsoft Advertising To authorize this service, use OAuth 2.0 to share specific data with Dataddo while keeping usernames, passwords, and other information private. 1. On the Authorizers page, click on Authorize New Service and select your service. 2. If your email is used for more than one account, select the right type for your account as set in Microsoft Advertising: either **Work or school** account, or **Personal** account. 3. Follow the on-screen prompts to grant Dataddo the necessary permissions to access and retrieve your data. Use correct account type If you specify the incorrect account type, the setup test fails with the [AADSTS650052 access error](https://learn.microsoft.com/en-us/advertising/guides/handle-service-errors-exceptions?view=bingads-13#aadsts650052) ## How to Create a Microsoft Ads Data Source 1. On the **Sources** page, click on the [**Create Source**](https://app.dataddo.com/sources/new) button. 2. Select the connector from the list and name your ***data source***. 3. On the **Dataset** step, select your **dataset**. **DATADDO TIP** If you're unsure which dataset to select, use the search bar to look for datasets with the desired attributes or metrics. 4. On the **Account** step select your ***authorizer*** from the drop-down menu. **Didn't find your authorizer?** Click on **Add new Account** at the bottom of the drop-down and follow the on-screen prompts. You can also go to the **Authorizers** tab and click on [**Add New Service**](https://app.dataddo.com/service/new). 5. On the **Attributes and Metrics** step, select the **metrics and attributes** you want to extract. ![Create a source using a custom-schema connector.](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Create%20Source%20-%20Custom-Schema%20Connector.png) 6. On the **Metadata** step, select which [**metadata fields**](/docs/metadata-inclusion) such as extraction time to add to your data. 7. On the **Snapshot** step: 1. Configure your [**sync frequency**](/docs/extraction#extraction-frequency) or click **Show advanced settings** to set the exact synchronization time. **DATADDO TIP** If you need to **load historical data**, refer to the [**Data Backfilling**](https://docs.dataddo.com/docs/data-backfilling) article. 2. [Optional] Enable the **Allow Empty Data Extractions** toggle to allow the extraction when no data is available. 8. In the top-right corner, click **Test Data** button to preview extracted data. You can **adjust the date range** for a specific time frame. 9. Click on **Save** and **congratulations, your new data source is ready!** --- ## Limitations ### Columns Restrictions When submitting the following requests, `AccountPerformanceReportRequest` and `AdGroupPerformanceReportRequest`, there are some attribute and impression share performance statistics columns which are **mutually exclusive**. For the whole list of restrictions, see [Microsoft's official documentation](https://learn.microsoft.com/en-us/advertising/guides/reports?view=bingads-13#columnrestrictions). ## Troubleshooting ### Data Preview Unavailable No data preview when you click on **Test Data** might be caused by an issue with your ***source*** configuration. The most common causes are: - **Date range**: Try a smaller date range. You can load the rest of your data afterward using [manual data load](https://docs.dataddo.com/docs/data-backfilling). - **Insufficient permissions**: Please make sure your authorized account has at least admin-level permissions. - **Invalid metrics, attributes, or breakdowns**: You may not have any data for the selected metrics, attributes, or breakdowns. - **Incompatible combination of metrics, attributes, or breakdowns**: Your selected combination cannot be queried together. Please refer to the service's documentation to view a full list of metrics that can be included in the same ***data source***. ### Metric and Ad Recall Data Don't Match The **Reach** and **Recall** metrics cannot be summed to get the totals for longer time periods. As these metrics measure the **daily unique users** who view your ad (= reach) or will remember the ad (=ad recall), it is **not possible to get data for a specific time period and/or aggregate the data**. To avoid this, you can 1. Get **daily** breakdowns: The daily values will match, but not when summed up over a longer time period. 2. Extract data **weekly or monthly**: These weekly/monthly values will match. Simply create a **new source** and a **new flow** with the particular breakdown (for example, a source and a flow with daily breakdowns/synchronizations). Read more about the metrics, and why the data may not be matching [here](https://blog.dataddo.com/why-the-numbers-in-your-bi-tool-dont-always-match-your-source-data?_gl=1*ipsbl8*_ga*MjAwMjE2NTU4NC4xNjUxNzM0NTI4*_ga_NQ4TN4KP4V*MTY1MTc2NzQwMC40LjEuMTY1MTc2Nzg4OS4z). ### Performance Max Campaign Data To extract data from your Performance Max Campaigns: 1. Select the **Campaign Performance Report** report type. The data is only available using this report type. 2. In the **Attributes** section, select all campaign-related fields - `Base Campaign ID` - `Campaign ID` - `Campaign Labels` - `Campaign Name` - `Campaign Status` - `Campaign Type` ## Related Articles Now that you have successfully created a ***data source***, see how you can connect your data to a dashboarding app or a data storage. **Sending Data to Dashboarding Apps** - [Simple Data Integration to Dashboards](https://docs.dataddo.com/docs/simple-data-integration-to-dashboards) - [Data Backfilling to Dashboarding Apps](https://docs.dataddo.com/docs/data-backfilling-to-dashboarding-apps) **Sending Data to Data Storages** - [Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses) - [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages) **Other Resources** - [Troubleshooting](https://docs.dataddo.com/docs/troubleshooting) - [Extraction Logs](https://docs.dataddo.com/docs/extraction-logs) - [Data Duplication](https://docs.dataddo.com/docs/data-duplication)