How to get your Bing Ads data ready for agentic AI
Sync Microsoft Advertising (Bing Ads) campaigns, keywords, and performance reports with Airbyte so AI agents query a governed copy of search ad data.

Airbyte syncs Microsoft Advertising (Bing Ads) accounts, campaigns, keywords, and hourly to monthly performance reports into your warehouse, where agents query a governed copy alongside your other search and paid channels.
Microsoft Advertising is often the second search channel after Google Ads, and it tends to get less attention for that reason. Budgets are smaller, reviews are less frequent, and problems can sit unnoticed. That makes it a good place for an agent to help: checking performance, spotting wasted spend on search queries, and comparing results with Google for the same keywords.
To do that well, agents need a centralized, governed copy. Microsoft doesn't publish specific API rate limits and returns throttling errors when clients call too often, so agents shouldn't be generating reports on demand. A warehouse copy gives them consistent history at the granularity you choose, and puts Bing next to Google Ads, analytics, and CRM data so comparisons are possible.
Why Bing Ads data matters for agentic AI
- It is a second view of search demand. Search query and keyword reports show what people searched for and which terms cost money without converting.
- It is report-driven. Performance comes from report requests with fixed columns and aggregation windows, so how reports are defined affects every answer.
- Metrics change after the fact. Conversions are attributed later and metrics are corrected, so recent days need rereading.
- It is easy to compare. Bing and Google share many concepts, so a joined copy lets agents compare channels on cost, clicks, and conversions.
What agents can do with Bing Ads data
- Search query review. Summarize search terms that spent the most without converting and suggest negative keyword candidates for a person to review.
- Performance summaries. Report spend, clicks, and conversions by campaign, ad group, or keyword over a chosen period.
- Geographic and audience breakdowns. Use geographic, user location, and age and gender reports to see where and for whom ads perform.
- Cross-channel comparisons. Join Bing results with Google Ads in the warehouse to compare the same keywords across both networks.
How Airbyte gets Bing Ads data ready
Authentication
You need a Microsoft Advertising account and a Microsoft developer token, requested with Super Admin credentials in the Microsoft Advertising Developer Portal.
- Airbyte Cloud: enter the developer token and authorize your Bing Ads account with OAuth.
- Self-managed (Core): register an app in the Azure portal and provide a client ID, client secret, and refresh token along with the developer token.
Use Microsoft's common tenant, or enter a custom Tenant ID if your OAuth app requires one.
Microsoft refresh tokens are valid for 90 days and rotate each time they are used. Airbyte saves the rotated token whenever it refreshes the access token, so a connection that syncs at least once every 90 days stays authenticated.
Choosing accounts
Account Names Predicates filter which accounts are synced, using Contains or Equals against the account name. You can combine several predicates.
Streams
Basic streams:
- Accounts, Ad Groups, Ads, and Campaigns (full refresh)
- Budget, Keywords, App Install Ads, and labels for ad groups, campaigns, keywords, and app install ads (incremental)
The incremental basic streams use Microsoft's Bulk API. If more than 30 days pass between syncs, the Bulk API returns a full download on the next sync.
Report streams, each in hourly, daily, weekly, and monthly versions:
- Account, campaign, ad group, and ad performance, plus account, campaign, and ad group impression performance
- Keyword performance and search query performance
- Geographic and user location performance
- Age and gender audience and audience performance
- Goals and funnels
- Product dimension and product search query performance
There is also a Budget Summary Report. A few reports, such as Geographic Performance and the impression performance reports, need a user-defined primary key that you set on the connection's Replication tab.
Report fields and custom reports
Removing fields in the replication settings doesn't change the report request. Reports are always generated with every field in the stream schema, so results can be grouped by fields you can't see. If you need a report with fewer or different fields, define a custom report:
- Report Name, which becomes the stream name, converted from camelCase to snake_case unless you turn that off
- Reporting Data Object, any Bing Ads object ending in
ReportRequest - Columns, which must include the report's required columns
- Aggregation: Hourly, Daily, Weekly, Monthly, DayOfWeek, HourOfDay, WeeklyStartingMonday, or Summary
Changing the name conversion setting on an existing custom report creates a new stream and removes the old one, so set it before data depends on it.
Sync modes and settings
The connector supports Full Refresh Overwrite and Append and Incremental Append and Append + Deduped.
- Reports Replication Start Date: if blank, data from the previous and current calendar years is replicated.
- Lookback window: the number of days before the saved report cursor to reread, applied to all report streams in incremental mode, so late conversions and corrected metrics are captured.
Rate limits
When Microsoft returns error code 117 (CallRateExceeded), the connector retries automatically. Persistent throttling can slow syncs for large accounts.
How agents reach Bing Ads data
Bing Ads is not listed as an agent connector, so the context layer doesn't read Bing Ads directly. Two paths work today:
- Sync to BigQuery or Snowflake. In Airbyte Cloud, the context layer can give agents read-only SQL access to those destinations, limited to
SELECTandSHOW TABLES. - Use the Airbyte MCP for pipeline work. At
https://mcp.airbyte.com/mcp, agents can create a Bing Ads connection, run syncs, and read job logs. Add?read-only=trueto limit an agent to read-only tools.
What this unlocks
- Search query and keyword analysis from a full Bing Ads history.
- Reports defined once, at the columns and granularity you need.
- Late conversions captured with a lookback window.
- Bing and Google compared side by side in the warehouse.
- Pipeline management through the Airbyte MCP.
Getting started
- Get a Microsoft developer token.
- Create a Bing Ads source in Airbyte and authorize your account.
- Pick report streams or define custom reports, and set a lookback window.
- Sync to BigQuery or Snowflake, then connect your agent to the Airbyte MCP.
Try Airbyte free or talk to sales about search ad data for agents.
Frequently asked questions
What do I need to connect Bing Ads to Airbyte?
A Microsoft Advertising account and a Microsoft developer token. On Airbyte Cloud you authorize the account with OAuth. On self-managed Airbyte you register an app in the Azure portal and provide a client ID, client secret, and refresh token. You can use the common tenant or your own tenant ID.
How often does a Bing Ads connection need to sync to stay authenticated?
Microsoft refresh tokens are valid for 90 days and rotate each time they are used. Airbyte saves the rotated token, so a connection that syncs at least once every 90 days stays authenticated without reauthorizing.
Why do my Bing Ads report totals look wrong after I removed fields?
Removing fields in the replication settings doesn't change the API request. Reports are always generated with every field in the stream schema, so results can be grouped by fields you no longer see. If you need fewer fields, build a custom report.
How do late conversions get into Bing Ads reports?
Set the Lookback window to the number of days before the saved report cursor that should be reread. It applies to all report streams in incremental mode, so corrected metrics and late conversions replace earlier values.
Can agents read Bing Ads directly through the Airbyte context layer?
Not at the time of writing. Bing Ads is not listed as an agent connector. Agents can query a BigQuery or Snowflake destination with read-only SQL through the context layer, and manage Bing Ads pipelines through the Airbyte MCP.
Integrate with 700+ apps using Airbyte
Move data from 700+ sources into warehouses, lakes, and beyond. Set up pipelines in minutes with pre-built connectors and the Connector Builder.
