Microsoft Advertising (formerly Bing Ads)
Microsoft Advertising, formerly Bing Ads and also known informally as Microsoft Ads, is a part of Microsoft Advertising Platform and made up of multiple web services that you can use to manage your advertising campaigns and accounts, as well as request reports that you can use to track the performance of your campaigns. For more information, please see the Microsoft Advertising site.=
Microsoft Advertising is a pay-per-click (PPC) advertising platform used to display ads based on the keywords in a user’s search query. For advertisers placing a large number of ads or developers building advertising tools, the Bing Ads API provides a programmatic interface to Microsoft Advertising. Using the Bing Ads API is the most efficient way to manage many large campaigns or to integrate your marketing with other in-house systems. The Bing Ads API also supports multiple customer accounts making it easy for ad agencies to manage campaigns for many clients. More features are described in the Bing Ads API documentation.
The Bing Ads API Version 13 is implemented in the CData Virtuality Studio for data analysis, and the Bing Ads API Version 9 is supported as well in the Data Virtuality Studio for data analysis.
Pre-requisites
You need a ClientId, ClientSecret, RefreshToken for gaining access to the API.
How to Connect
There are two ways to connect to Microsoft Advertising: via the Sources connection wizard in the Web UI (recommended), or using SQL statements in the CData Virtuality Studio or the Code Editor in the Web UI. Here, we describe the first way; for the second way, see the subpage.
1. Go to the Sources tab and click + New Source:
2. Find the Microsoft Advertising button in the list of connectors or type ‘microsoft advertising’ in the search field and select it:
3. Enter your data, click Sign in with Microsoft, and follow the instructions:
Usage
The Bing Ads API connector introduces a new virtual schema bingads that contains the following stored procedures:
In addition to these public API procedures, there are numerous views in the bingads_examples virtual schema that shows an exemplary usage of the public API.
If not needed, you can delete all the example views directly by dropping bingads_examples.