Pull X Ads data into Microsoft Excel
X bills in micros and counts engagements. Load X Ads into your data warehouse, join billed spend to leads and results, then pull the Data Mart into Excel for the promoted-post review.
X AdsConnectedAccountsAd PerformanceAd Performance b…All Cards
Microsoft ExcelDateClicksImpre…Daily 09:00The promoted-post review in Microsoft Excel starts with converting X Ads micros by hand and ends without leads.
Paste this into your AI assistant. It loads X Ads into your data warehouse with OWOX Data Marts, joins billed spend to leads and results, and pulls the Data Mart into Microsoft Excel.
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/x-ads-connector-to-microsoft-excel.md. The task: pull an X Ads Data Mart into a Microsoft Excel workbook for our promoted-post review, with billed spend in account currency, engagements and leads by campaign, from our data warehouse. 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
X Ads Endpoints
10 X Ads endpoints you can import. Each lands in its own table in your data 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.
30 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
Why X Ads does not go straight to Excel
X Ads reaches Excel by export or add-on, but not reliably, at scale or business-ready. Billed charges come in local micro-units and billed engagements say little about leads. The conversion and join happen in the data warehouse.
- X Ads reports billed engagements, not what an engagement was worth
- The data analyst links promoted-post spend to leads and results by SQL keys
- The workbook shows cost against pipeline
X AdsPromoted postsMicrosoft Exc…
Data warehouseJoined by idStep 1: Load X Ads into your data warehouse first
Create a Data Mart with X Ads as the source and choose where the data lands. Any popular warehouse works.
- 10 endpoints and 187 fields; Ad Performance feeds the workbook
- Campaigns, line items, promoted posts and country breakdowns are tables of their own
- Open the X Ads connector for your data warehouse below
X AdsData MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databricksx_ads.statsStep 2: Link X Ads to web analytics and deals
In your data warehouse the model merges X Ads with LinkedIn Ads and Google Ads, then joins leads and campaign results by a key. Pick an industry to see the shape of its model.
- Billed spend from every platform sits in one table
- Leads and campaign results join by SQL keys
- pipeline_per_dollar is defined once
X AdsAd Performance
LinkedIn AdsAd spend
Google AdsAd spendStep 3: Pull X Ads data into Excel with the add-in
In Excel, add the OWOX Data Marts add-in and sign in. Choose the published X Ads Data Mart (Ad Performance), tick the columns you want and press Create & Run.
- Pick date, billed_charge_local_micro and clicks; billed_engagements is one tick away
- Rows come from the data warehouse, not the X API
Microsoft ExcelYour columns staydatebilled_charge…impressionsStep 4: Refresh the X Ads workbook when you need it
Refresh before the promoted-post review. Imported columns update; the micro-to-currency column you added keeps working.
- Your conversion formula survives every refresh
- Nothing runs unless you press Refresh
Microsoft ExcelYour column staysdatebilled_ch…impressio…YoursStep 5: Reuse X Ads inside OWOX MCP
The X Ads Data Mart also serves OWOX MCP, your assistant for data. Request any report, chat with it, then get the result in Google Sheets or Excel in one click.
- Ask what a pipeline dollar costs on X
- The workbook and chat share pipeline_per_dollar
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 X Ads in Excel
A console export puts X Ads rows in Excel. OWOX puts the cost next to the leads it produced.
- Promoted posts in context. Billed spend joins leads and campaign results in your data warehouse.
- Line items and posts as tables. Pick the level the review needs from 10 endpoints.
- Your formulas stay. Refresh rewrites imported columns only.
- Maintained for you. X API changes land in the connector, not in your formulas.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.