Bing Ads, now Microsoft Advertising, is a pay-per-click advertising platform for search and native ads across Bing and the Microsoft Advertising network.

Prerequisites

To connect to Bing Ads, you will need:

• A Microsoft account with access to the Microsoft Advertising accounts you want to extract data for.
• Your customer ID, shown as cid= in the Microsoft Advertising URL.
• Optionally, one or more account IDs, shown as aid= in the Microsoft Advertising URL, to restrict extraction to those accounts.

Setup

In Meltano Cloud:

1. Login and connect with your Microsoft account
2. Enter your customer ID
3. Optionally enter the account IDs to extract data for - leave this empty to extract data for every account under the customer
4. Choose a start date for extraction

Available Streams

Entity streams

Extracted through the Bing Ads Bulk service. Each stream is replicated incrementally on the Sync Time column.

Name | Description --- | --- campaigns | Campaigns in each account, including budget, bid strategy and targeting settings ad_groups | Ad groups in each account ads | Ads of every type in each account keywords | Keywords in each account, including quality and relevance scores campaign_negative_sites | Website exclusions set at campaign level

A campaign negative site has no ID of its own, so campaign_negative_sites is keyed on the campaign (Parent Id) and Website pair rather than on Id.

The accounts stream comes from the Customer Management service instead, and carries account settings, currency, time zone, and billing and address details. It is replicated in full on each run.

Daily performance report streams

Requested from the Bing Ads Reporting service with Daily aggregation, over the range from the start date, or from the previous bookmark, to the current date. Each stream is replicated incrementally on the TimePeriod column. Reports are requested in the GMT time zone, so a row date reflects GMT rather than the account time zone.

Name | Description --- | --- ad_group_daily_performance | Daily performance statistics by ad group ad_daily_performance | Daily performance statistics by ad keyword_daily_performance | Daily performance statistics by keyword asset_daily_performance | Daily performance statistics by asset publisher_usage_daily_performance | Daily performance statistics by publisher website

A performance report stream requests only the columns you select, and it derives its primary key from the attribute columns that stay selected. Deselecting an attribute column therefore coarsens the grain of the stream, and the rows that the API returns are aggregated over the columns that remain.

Bing Ads also rejects some column combinations. In ad_group_daily_performance, the BidMatchType, DeviceOS, Goal, GoalType and TopVsOther attributes cannot be combined with the impression share statistics. Where you select both, the tap keeps the attributes and drops the impression share statistics.

Settings

OAuth Client ID

OAuth client ID for client credentials token creation - only used if an OAuth refresh proxy URL is not supplied

OAuth Client Secret

OAuth client secret for client credentials token creation - only used if an OAuth refresh proxy URL is not supplied

Customer ID

ID of the Microsoft Advertising customer to extract data for, shown as cid= in the Microsoft Advertising URL

Account ID(s)

IDs of the Microsoft Advertising accounts to extract data for, shown as aid= in the Microsoft Advertising URL. Leave empty to extract data for every account under the customer

Start Date

The earliest record date to sync