Ask X Ads Questions in Claude
Ask X (Twitter) Ads questions in Claude using OWOX Data Marts. Collect X (Twitter) Ads data into a governed data mart, then get answers in Claude via OWOX's MCP server — every number traces back to analyst-written SQL.
X Ads Endpoints
10 X Ads endpoints you can import. Each lands in its own table in your warehouse.
Accounts
Advertising accounts — name, business, country, timezone, and approval status.
12 fieldsAd Performance
Daily ad performance by placement — impressions, clicks, spend, engagements, and social actions.
20 fieldsTime seriesAd Performance by Country
Daily ad performance broken down by country — impressions, clicks, spend, engagements, and social actions.
21 fieldsTime seriesAll Cards
All card types with full creative details — type, title, destination URL, call to action, and media.
28 fieldsCampaigns
Your campaigns — status, budget optimization, daily and total budget, and currency.
19 fieldsCards
Website and app cards — type, URI, and components.
8 fieldsLine Items
Line items within campaigns — bid strategy, goal, product type, budget, and schedule.
33 fieldsPromoted Tweets
Tweets promoted as ads — status, approval, and links to their tweets and line items.
8 fieldsTargeting Locations
Reference table of location IDs with names and country codes — join targeting_value with the country field in Ad Performance by Country.
4 fieldsTweets
Original tweets used as ad creatives — text, type, language, engagement counts, and card URI.
34 fields
Ask X Ads questions in Claude
- You
In which countries are our X ads seen most?
- Claude
Ad Performance by Country (x_ads_stats_by_country) holds impressions and qualified_impressions for each country. I ranked countries by impressions and put clicks beside each.
It is read from your governed X Ads Data Mart through the OWOX MCP server and reflects that Data Mart's last scheduled refresh.
- You
Where do people actually engage?
- Claude
Dividing engagements by impressions per country gives an engagement rate for each. The Targeting Locations table maps location ids to names if you want to line this up with your targeting settings.
Every claim has a receipt.
Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.
“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”
“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
“We regained time. And time is the one resource that never comes back.”
- 0.37.0Short links resolve only on known short link services and domains you allow
- 0.36.0Support MCP protocol 2026-07-28 and alert on compatibility failures
- 0.36.0Resolve short links in every ads connector, with nested paths and a per-Data-Mart cache
- 0.35.0Destinations tab now promotes connecting an AI assistant alongside your existing destinations
- 0.34.0Connect Claude or ChatGPT to your Data Marts
Turn X Ads Data into Answers in Claude
See how OWOX Data Marts helps you ask X Ads questions in Claude, blend it with other sources, and scale reporting without rebuilding logic.
Get Started Free- Internal OWOX data as of 2026-10-02
- G2 reviews of OWOX
- npm installs stat
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.


