Connector

Collect Microsoft Ads data in Google BigQuery

Load Microsoft Advertising, formerly Bing Ads, into your own BigQuery tables with OWOX Data Marts: campaigns and performance reports, each in its own table, refreshed on a schedule. Join it with web analytics and CRM to see which search ads become deals.

Microsoft AdsConnectedAd Performance R…CampaignsUser Location Pe…
Data MartPublishedone definition
Google BigQuerySpendClicksImpre…Daily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get Started Free

Hand this to your AI

Microsoft Ads search traffic gets left out of channel reports because its data stays in its own account, not in Google BigQuery.

Paste this into your AI assistant. It creates a Microsoft Ads Data Mart on your Google BigQuery storage, loads campaigns and performance reports into your own tables, and joins spend to sessions and deals.

The prompt

load Microsoft Ads ad performance reports into Google BigQuery on a daily schedule and build a Data Mart with spend, conversions, revenue and CRM deals by campaign and month

Endpoints

S00 · Why

Why join Microsoft Ads with your web analytics and CRM

Microsoft Advertising reports spend, clicks and the conversions and revenue it tracked. Where Bing search share is material, those clicks deserve the same scrutiny as Google's, and that means joining spend with website touch points and CRM deals in one data warehouse.

  • Add Microsoft Ads to the same spend table as Google, Facebook and LinkedIn
  • Connect Microsoft Ads clicks and form fills to the deals they became
  • Compare the Revenue Microsoft reports with the revenue in your CRM
Microsoft AdsSearch spend, revenue
Web analyticsClicks, form fills
CRMDeals
Your data warehouseBigQueryAdTouch pointDealJoined by idSearch ad clickedDeal months laterOne query links the ad to the deal.

S01 · Step 1

Step 1: Connect Microsoft Ads and pick the fields

Create a Data Mart, choose Microsoft Ads as the data source, sign in with Microsoft or add an access token, and tick only the fields you need.

  • 3 endpoints and 225 fields to choose from
  • Ad Performance Report alone has 92 fields: spend, clicks, conversions, revenue, video views
New Data MartChoose a sourceGoogle AdsMicrosoft AdsLinkedIn AdsAuthorizeConnectedEndpointAd Performance Re…CampaignsUser Location Per…
Ad Performance Re…95 fieldsTimePeriodSpendImpressionsClicksConversionsRevenue

S02 · Step 2

Step 2: Load Microsoft Ads into a BigQuery table

The dataset and table in your data storage are pre-filled, and you can change them. Run it and the first load lands in your own BigQuery project.

  • Each report gets its own table, such as microsoft_ads_ad_performance_report
  • Rows are dated by TimePeriod, with campaign, ad group and ad ids beside the names
DestinationBigQueryDatasetmicrosoft_adsTablead_performance_reportRun
Run HistoryPendingRunningSuccessIncremental load
Tablemicrosoft_ads.ad_performance_…

S03 · Step 3

Step 3: Get a business-friendly output schema

After the first run you get the output schema: every field with a readable description, not a report column code. Your data quality checks can read it too.

  • Account, campaign, ad group and ad names sit beside their ids
  • Anyone on the team can read the table
microsoft_ads.ad_performance_reportOutput schemaFieldDescriptionTimePeriodThe time period of each report…SpendThe cost per click (CPC) summed…ImpressionsThe number of times an ad has…ClicksClicks are what you pay for.ConversionsThe number of conversions.RevenueThe revenue optionally reported…

S04 · Step 4

Step 4: Keep the Microsoft Ads tables linked

Campaigns and the two performance reports stay separate tables, joined by CampaignId. Together they become one Microsoft Ads data model.

  • The ad report and the user location report both carry CampaignId
  • FinalUrl gives each ad's landing page, ready to match web analytics
CampaignsCampaignIdCampaignBudget
Ad Performance Re…CampaignIdAdIdSpend
User Location Per…CampaignIdCountrySpend

S05 · Step 5

Step 5: Schedule the refresh and backfill history

Set it once. A scheduled refresh keeps the tables current, and a manual backfill loads any past period.

  • Each incremental run reloads today plus a lookback window you set
  • Backfill a custom start and end date
ScheduleRun on a scheduleDaily 09:00
BackfillRun backfill
Run HistoryDaily scheduleManual backfillDaily schedule

S06 · Step 6

Step 6: Reuse the same table everywhere

One table feeds your data model, spreadsheets, dashboards, AI assistants like Claude and ChatGPT, and scheduled AI insights in Slack or email.

  • Show search spend from Microsoft and Google side by side
  • Every report reads the same table
Microsoft A…Data MartPublished
Blended search spend
Google Sheets
Data Studio dashboards
Claude, ChatGPT
Slack, email

Recent updates

Why OWOX

Why OWOX for Microsoft Ads in BigQuery

Hand-built reporting API scripts, a generic ETL tool or exports from the Microsoft Advertising interface each get the data out. OWOX also keeps it yours, readable and ready to model.

  • You own the data. It lands in your own BigQuery project, in tables you control.
  • Report tables you can read. Performance reports arrive as ordinary tables with described columns, instead of files to download and parse.
  • Ready for a data model. Campaigns and reports joined by CampaignId, built to connect to Google Ads, web analytics and CRM.
  • Maintained for you. No scripts to fix when Microsoft changes its reporting API.
  • Free to self-host. The open-source OWOX Data Marts runs in your own infrastructure.

Book a callGet Started Free

Trust

The Data Partner You Can Trust

users

166K Source: Internal OWOX data as of 2026-11-15

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers