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:
Supported report streams:

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

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)
Last modified 11d ago