Ask ChatGPT about your Microsoft Ads data
Load Microsoft Ads into your data warehouse first, link its ad performance report to web analytics and deals with SQL keys, then ask ChatGPT in plain words. The answers come from your governed Data Marts, not from the ad account.
Microsoft AdsConnectedAd Performance R…CampaignsUser Location Pe…
ChatGPTSpendClicksImpre…Daily 09:00ChatGPT can read Microsoft Ads clicks, but not which campaigns returned revenue for what they spent.
Paste this into your AI assistant. It loads Microsoft Ads into your data warehouse, links its ad performance report to web analytics and deals, and connects ChatGPT to that Data Mart through the OWOX MCP server.
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-chatgpt.md. The task: connect ChatGPT to my Microsoft Ads data and show which campaigns returned the most revenue for their spend last month, and which convert worst. 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 ChatGPT needs your data warehouse, not the Microsoft Ads account
Pointed at the Microsoft Ads account alone, ChatGPT sees one platform's own figures. The account does not show which campaign led to a deal, because ad spend, website visits and CRM deals live in different systems. Joining them reliably, at scale and business-ready is the job of a warehouse, so ChatGPT reads the answers from there.
- Microsoft Ads reports where the searcher was and what they searched for, not whether the click became a deal
- The data analyst links Microsoft Ads spend, web analytics and CRM deals by SQL keys and controls the result
- ChatGPT reads governed Data Marts, so every answer traces back to analyst-written SQL
Microsoft AdsMicrosoft ad spendChatGPT
Data warehouseJoined by idStep 1: Load Microsoft Ads into your data warehouse first
Create a Data Mart with Microsoft Ads as the source and choose where the data lands. It works with any popular data warehouse.
- Three endpoints and 225 fields to choose from, each endpoint in its own table
- Open the Microsoft Ads connector for your data warehouse below
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 your other ad platforms, then joins web analytics sessions by a campaign key. Pick an industry to see the shape of its model.
- Microsoft Ads and Google Ads search spend sits in one table with your social spend
- Sessions and deals join by SQL keys, not VLOOKUP and gut feeling
- The measures, such as platform_roas, are defined once
Microsoft AdsAd Performance Re…
Google AdsAd spend
Facebook AdsAd spendStep 3: Connect ChatGPT to your data with OWOX MCP
Install the OWOX Data Marts plugin in ChatGPT (Plugins > Install plugin > Sign in), then choose the Data Marts it may see. ChatGPT gets only what you expose, never raw database access.
- Authorize specific Data Marts, not your whole data warehouse
- Publish the Data Marts you want ChatGPT to answer from, such as Microsoft Ads Ad Performance Report and User Location Performance Report
ChatGPTConnectorsOWOX MCPAddConnectedStep 4: Ask ChatGPT about Microsoft Ads
Ask in plain words. ChatGPT finds the right Data Mart and runs analyst-defined SQL against it, so the answer is built from your data warehouse.
- The answer is built by get_relevant_data_marts_by_prompt and query_data_mart
- Ask about search spend next to Google Ads: both land in the same merged spend table
- platform_roas and platform_cpa are what each platform claims; Sessions and Orders in the same model give the store's own count to set against them
ChatGPTShow platform_roas and platform_cpa by channelget_relevant_data_marts_by_promptquery_data_martplatform_roasplatform_cpaStep 5: Export the answer when you need to check or share it
In one click, export the answer or its source data to Google Sheets, CSV or XLS.
- The export is the same Data Mart the assistant read, so the file and the chat agree
- Optional: ask in chat first, export only what you need
Google SheetsCSVXLSOne click
- 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.36.0Resolve short links in every ads connector, with nested paths and a per-Data-Mart cache
Why OWOX for Microsoft Ads in ChatGPT
Pointing ChatGPT at an ad account gets one platform's own figures into a chat. OWOX also keeps the data yours, linked and ready to model, so the answers cover the whole business.
- You own the data. It lands in your own data warehouse, in tables you control.
- Both Microsoft Ads reports, as tables. Ad Performance Report and User Location Performance Report land in your data warehouse next to Google Ads, so search spend is one model.
- Where the searcher was. User Location Performance Report carries Country and QueryIntentCountry, so spend can be read by where people were and what place they searched for.
- Zero hallucinations. ChatGPT queries governed Data Marts with analyst-written SQL, so every number traces back to the query behind it.
- Maintained for you. No scripts to fix when Microsoft changes its reporting API.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.