Bing Ads, now Microsoft Advertising, provides pay-per-click advertising for both the Bing and Yahoo search engines. To get an overview of high-level Microsoft Advertising entity object model from the perspective of one customer that has one or more accounts, see its entity hierarchy and limits documentation.
Through our integration you are able to query for metadata and performance reports for all your accounts and import the data into Y42.
Overview
Authentication: OAuth
Settings: Historical Date selection, Account selection
Schema type: Fixed
Update Type: Full import and incremental
Authentication
OAuth doesn’t share password data but instead uses authorization tokens to prove an identity between you and the service provider. OAuth is an authentication protocol that allows you to approve one application interacting with another on your behalf without giving away your password. For instance, when you tell tell Facebook that it’s OK for another application or website to access your profile. To sum up, you only need to have an existing account to authorize the access.
Import Settings
By default, the historical date will be set to one year ago. Refer to your own datasource to decide from which exact date you would want to retrieve data.
Account pre-requisites
You will need an active Bing/ Microsoft Ads account with permission to access data from accounts you'd like to sync.
Schema
You can find the full overview of Bing Ads objects APIs and the description for each item on Bing Ads API documentation, as well as the breakdown of subset of entities with property limits here.
Note: When setting up integration and importing tables and columns, be aware that Bing Ads reports have some limitation. You may discover that some column selection combinations are not possible. This is why we recommend that instead of importing all possible tables and columns, you refer to the Bing Ads API documentation and find out which specific reports and columns are needed from your side. Refer here for more information regarding column restrictions.
Updating your data
You have the option of scheduling Full imports or Incremental Imports by the month, weeks, days, and even by the hour. With the incremental import you will only add the new rows to that table, while a full import will actually re-import the entire table completely.
Incremental imports significantly increase the import speed, we import your table incrementally based on the last imported state e.g. id - If the table does not have a state, a full import will be triggered - This is done automatically.
We recommend therefore to schedule an incremental import regularly, but also schedule a full import with a certain frequency -- this is because only the full import will guarantee that old rows that have been updated on the data source will also get updated on your Y42 integration destination.
Bing Ads Setup Guide:
Note: In order to connect Bing Ads with Y42, you will need to have a Microsoft Advertising Account.
On Integrate, click on "Add..." to search for Bing Ads and select it.
Name your integration.
Click Authorize and log into your Microsoft account.
After authentication, select your Bing Ads account.
Choose from which point onwards in time to import your data. Select the tables you need and click import. You can start accessing the tables once the status is “Ready”.
Note: You can always import and reimport other tables as well, or delete them.