Microsoft Ads (Bing Ads)

Automatic Data Synchronization

The Dataddo Microsoft Ads connector gives you the ability to sync your data automatically in daily, weekly, or monthly increments. If necessary, we can set up a refresh for up to 15 min.

Available Endpoints

All available endpoints from Microsoft are listed here.


Metric and ad recall data may not match

The problem with reach and ad recall metrics is that these metrics cannot be simply summed to get the totals for longer periods. The reason for this is that these metrics are measuring the daily unique users, who either see your ad (reach) or will remember the ad (ad recall). It is not possible to get data for a specific period and keep aggregating them.

  1. One option is to get the daily breakdown and then the daily values will match, but not when summing over more days.
  2. The second solution is to get the data weekly or monthly and again, these weekly/monthly values will match Microsoft exactly.
    1. The way to achieve this is to create a new source and then a new flow with the particular breakdown (for example, source and flow with daily breakdowns/synchronizations)

Read more about the metrics, why the data may not be matching here.

How to create a Microsoft Ads Data Source

Number 1

Sign in to your Dataddo account and click on Sources at the top of the page. Home Page - Data Source

Number 2

Click on Create Source in the top right corner.Data Sources - Create Source

Number 3 From the list of sources, choose Microsoft Ads. You can type the name of the connector into the search bar to find it faster.
Microsoft Ads - step 3
Number 4 Choose the Microsoft Account you want to connect and select User, Advertiser Account, Campaign, and Ad Group. Continue by clicking on Next. Microsoft Ads - step 4
a) Add new account
If you want to connect a Microsoft account, which is not on the list, click on Add Account. You will be redirected to Microsoft sign-in page. Once you confirm, you will be redirected back to the Dataddo app.
Microsoft Ads - login
b) Authorize Microsoft Profile
If you have not authorized your Microsoft Account with Dataddo, click on Authorize and you will be redirected to your account to log in.
Microsoft Ads - step 4 authorization
After you log in and give Dataddo the necessary permissions to access your data, you will be redirected back to the connector.
Number 5

Choose a name for your Data Source, select the Time Aggregation, the Report Type, the Attributes, and the Metrics. To continue to the next page, click Next.

NOTE: Attributes and Metrics depend on the reporting level you select.

Microsoft Ads - step 5a
Microsoft Ads - step 5b

Number 6

On the Storage selection page, you can set up the destination configuration. To help you with the snapshot mapping, we make it easier for you to create a connection to the destination based on your preference.

  • a) Click on the option Dashboarding App if you want your data to connect to applications such as Google Data Studio, Power BI, or Tableau.
  • b) Click on the option Data Warehouse, if you want your data to be sent to warehouse storage, e.g., MySQL, Big Query, or PostgreSQL.
Microsoft Ads - step 6
Number 7

Configure your snapshotting preferences by choosing your Data range*, Sync type, Sync frequency, Time, and Timezone. Confirm your setup by clicking on Next.

NOTE: *If the Data range is available to select, you can load historical data. Read more about it in our guide.

Microsoft Ads - step 7

Number 8 In the last step, you can preview your data. Click on Save and your new Data Source is ready.
Microsoft Ads - step 8 preview


Broken view / Error message
If you cannot see a preview of your data, go back a few steps and check your setup. The most common causes are: 
  • Date range - we recommend a smaller date range. If you need to load historical data, check our guide.
  • Invalid metrics, attributes or breakdowns, or their combination - you may not have any values for them.
Microsoft Ads - step 8 error

Congratulations, your new Data Source is ready!

Need assistance?

Feel free to contact us or create a ticket and we will help you set up the Data Source.