Pull Microsoft Ads data into Microsoft Excel
Microsoft Ads and Excel share a vendor, not a data model. Load Microsoft Ads into your data warehouse, merge it with Google Ads, and pull one search-spend Data Mart into a workbook through the OWOX add-in.
Microsoft AdsConnectedAd Performance R…CampaignsUser Location Pe…
Microsoft ExcelSpendClicksImpre…Daily 09:00Microsoft Ads and Microsoft Excel share a vendor, yet the search spend workbook is still a weekly export someone pastes in.
Paste this into your AI assistant. It loads Microsoft Ads into your data warehouse, merges it with your other ad platforms, and pulls one search spend Data Mart into Microsoft Excel through the add-in.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/microsoft-ads-connector-to-microsoft-excel.md. The task: give me a Microsoft Excel workbook of Microsoft Ads spend, clicks and conversions by campaign and week, next to my other ad platforms, that I refresh instead of exporting. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
Microsoft Ads Endpoints
3 Microsoft Ads endpoints you can import. Each lands in its own table in your data warehouse.
Ad Performance Report
Daily ad performance — impressions, clicks, spend, and conversions segmented by device, network, and match type.
95 fieldsTime seriesCampaigns
Your campaign and ad group structure — type, status, bid strategy, budget, and keyword settings.
54 fieldsUser Location Performance Report
Daily performance by user physical location — impressions, clicks, spend, and conversions broken down by country, state, and city.
81 fieldsTime series
Why Microsoft Ads does not go straight to Excel
Reports from the Microsoft Ads account can be downloaded to Excel, but not reliably, at scale or business-ready. Each download is a snapshot with its own column names, and Bing spend never lines up with Google Ads spend. The data warehouse aligns them first.
- Microsoft Ads counts the conversions it saw, not what the customer later paid
- The data analyst lines up Microsoft and Google search spend and ties both to deals
- The workbook reads the aligned Data Mart, not a pile of downloads
Microsoft AdsMicrosoft ad spendMicrosoft Exc…
Data warehouseJoined by idStep 1: Load Microsoft Ads into your data warehouse first
Microsoft A…Data MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databricksmicrosoft_ads.ad_performance_…Step 2: Link Microsoft Ads to web analytics and deals
In your data warehouse the model merges Microsoft Ads with Google Ads and Facebook Ads, then joins web analytics sessions by a campaign key. Pick an industry to see the shape of its model.
- Bing and Google search spend share one table with social spend
- Sessions and deals join by SQL keys, not by matching campaign names by eye
- platform_roas is defined once for every workbook
Microsoft AdsAd Performance Re…
Google AdsAd spend
Facebook AdsAd spendStep 3: Pull Microsoft Ads data into Excel with the add-in
In Excel, add the OWOX Data Marts add-in and sign in. Choose the published Microsoft Ads Data Mart (Ad Performance Report), tick the columns you want and press Create & Run.
- Choose TimePeriod, CampaignName and Spend, then widen the list when you need more
- The workbook reads the data warehouse, so no Microsoft login lives in the file
Microsoft ExcelYour columns stayTimePeriodCampaignNameSpendStep 4: Refresh the Microsoft Ads workbook when you need it
Refresh when you want the newest rows. The imported columns are rewritten; your own columns, notes and formulas are left alone.
- The Spend column updates, the margin column you added does not move
- Refreshing is a click, not a job
Microsoft ExcelYour column staysTimePeriodCampaignN…SpendYoursStep 5: Reuse Microsoft Ads inside OWOX MCP
Microsoft Ads data reuses the same Data Mart in OWOX MCP, your assistant for data. Request any report, chat with your numbers, then land it in Google Sheets or Excel in one click.
- Ask how Microsoft Ads compares with Google Ads without opening either account
- Chat and workbook share one platform_roas
Google SheetsOpenExcelOpen
- 0.41.0Rotating a connector key is one change: Sources share reusable Credentials
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.37.0Short links resolve only on known short link services and domains you allow
- 0.37.0Clearer connector errors, and custom connectors that handle more APIs
- 0.37.0Unchecking a column in the OWOX Extension no longer fails Save & Run
Why OWOX for Microsoft Ads in Excel
A report downloaded from Microsoft gets a file into Excel. OWOX gets a Data Mart that Microsoft Ads and Google Ads both flow through.
- Both search engines, one table. Microsoft Ads and Google Ads spend merge in the data warehouse before it reaches Excel.
- Both report types as tables. The Ad Performance Report and its siblings arrive as separate tables you can pick from.
- Pull on demand. Press Refresh in Excel; the imported columns update and yours stay.
- Maintained for you. Microsoft report schema changes are handled upstream of your workbook.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.