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.1

2021-08-31

5750

Added reporting streams)

0.1.0

2021-07-22

4911

Initial release supported core streams (Accounts, Campaigns, Ads, AdGroups)