This page contains the setup guide and reference information for the Bing Ads source connector.
- Register your application in the Azure portal.
- Request user consent to get the authorization code.
- Use the authorization code to get a refresh token.
:::note
The refresh token expires in 90 days. Repeat the authorization process to get a new refresh token. The full authentication process described here.
:::
- Get your Microsoft developer token.
- If your OAuth app has a custom tenant and you cannot use Microsoft’s recommended common tenant, use the custom tenant in the Tenant ID field when you set up the connector.
:::info
The tenant is used in the authentication URL, for example: https://login.microsoftonline.com/<tenant>/oauth2/v2.0/authorize
:::
- Log in to your Airbyte Cloud account.
- Click Sources and then click + New source.
- On the Set up the source page, select Bing Ads from the Source type dropdown.
- Enter a name for your source.
- For Tenant ID, enter the custom tenant or use the common tenant.
- Add the developer token from Step 1.
- For Replication Start Date, enter the date in YYYY-MM-DD format. The data added on and after this date will be replicated. If this field is blank, Airbyte will replicate all data.
- Click Authenticate your Bing Ads account.
- Log in and authorize the Bing Ads account.
- Click Set up source.
- Log in to your Airbyte Open Source account.
- Click Sources and then click + New source.
- On the Set up the source page, select Bing Ads from the Source type dropdown.
- Enter a name for your source.
- For Tenant ID, enter the custom tenant or use the common tenant.
- Enter the Client ID, Client Secret, Refresh Token, and Developer Token from Step 1.
- For Replication Start Date, enter the date in YYYY-MM-DD format. The data added on and after this date will be replicated. If this field is blank, Airbyte will replicate all data.
- Click Set up source.
The Bing Ads source connector supports the following sync modes:
The Bing Ads source connector supports the following streams. For more information, see the Bing Ads API.
- account_performance_report_hourly
- account_performance_report_daily
- account_performance_report_weekly
- account_performance_report_monthly
- ad_group_performance_report_hourly
- ad_group_performance_report_daily
- ad_group_performance_report_weekly
- ad_group_performance_report_monthly
- ad_performance_report_hourly
- ad_performance_report_daily
- ad_performance_report_weekly
- ad_performance_report_monthly
- budget_summary_report
- campaign_performance_report_hourly
- campaign_performance_report_daily
- campaign_performance_report_weekly
- campaign_performance_report_monthly
- keyword_performance_report_hourly
- keyword_performance_report_daily
- keyword_performance_report_weekly
- keyword_performance_report_monthly
All reports synced by this connector can be aggregated using hourly, daily, weekly, or monthly time windows.
For example, if you select a report with daily aggregation, the report will contain a row for each day for the duration of the report. Each row will indicate the number of impressions recorded on that day.
A report's aggregation window is indicated in its name. For example, account_performance_report_hourly is the Account Performance Reported aggregated using an hourly window.
The Bing Ads API limits the number of requests for all Microsoft Advertising clients. You can find detailed info here.
| Version | Date | Pull Request | Subject |
|---|---|---|---|
| 0.1.12 | 2022-09-05 | 16335 | Added backoff for socket.timeout |
| 0.1.11 | 2022-08-25 | 15684 (published in 15987) | Fixed log messages being unreadable |
| 0.1.10 | 2022-08-12 | 15602 | Fixed bug caused Hourly Reports to crash due to invalid fields set |
| 0.1.9 | 2022-08-02 | 14862 | Added missing columns |
| 0.1.8 | 2022-06-15 | 13801 | All reports hourly/daily/weekly/monthly will be generated by default, these options are removed from input configuration |
| 0.1.7 | 2022-05-17 | 12937 | Added OAuth2.0 authentication method, removed redirect_uri from input configuration |
| 0.1.6 | 2022-04-30 | 12500 | Improve input configuration copy |
| 0.1.5 | 2022-01-01 | 11652 | Rebump attempt after DockerHub failure at registring the 0.1.4 |
| 0.1.4 | 2022-03-22 | 11311 | Added optional Redirect URI & Tenant ID to spec |
| 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) |