bing-ads.md

Bing Ads

Overview

This source can sync data from the Bing Ads. Connector is based on a Bing Ads Python SDK.

Output schema

This Source is capable of syncing the following core Streams:

• Accounts
• Campaigns
• AdGroups
• Ads

Supported report streams:

• AccountPerformanceReport
• AdPerformanceReport
• AdGroupPerformanceReport
• CampaignPerformanceReport
• BudgetSummaryReport
• KeywordPerformanceReport

Data type mapping

Integration Type	Airbyte Type	Notes
string	string
number	number
array	array
object	object

Features

Feature	Supported?(Yes/No)	Notes
Full Refresh Sync	Yes
Incremental Sync	No
Namespaces	No

Performance considerations

API limits number of requests for all Microsoft Advertising clients. You can find detailied info here

Getting started

Requirements

• accounts: Has 2 options
  • fetch data from all accounts to which you have access
  • you need to provide specific account ids for which you a going to pull data. Use this guide to find your account id
• user_id: Sign in to the Microsoft Advertising web application. The URL will contain a uid key/value pair in the query string that identifies your User ID
• customer_id: Use this guide to get this id
• developer_token: You can find this token here
• refresh_token: Token received during auth process
• client_secret: Secret generated during application registration
• client_id: Id generated during application registration
• reports_start_date: From which date report generation should start
• report_aggregation: Defines how report data will be aggregated
• hourly_reports: includes hourly report streams if true
• daily_reports: includes daily report streams if true
• weekly_reports: includes weekly report streams if true
• monthly_reports: includes monthly report streams if true

Setup guide

• Register Application in Azure portal
• Perform these steps to get auth code.
• Get refresh token using auth code from previous step

Full authentication process described here

Be aware that refresh token will expire in 90 days. You need to repeat auth process to get the new one refresh token

Changelog

Version	Date	Pull Request	Subject
0.1.3	2022-01-14	9510	Fixed broken dependency that blocked connector's operations
0.1.2	2021-12-14	8429	Update titles and descriptions
0.1.1	2021-08-31	5750	Added reporting streams)
0.1.0	2021-07-22	4911	Initial release supported core streams (Accounts, Campaigns, Ads, AdGroups)