Pull Facebook Ads data into Microsoft Excel
Load Facebook Ads into your data warehouse, link spend to sessions and CRM deals with SQL keys, then pull the Data Mart into an Excel workbook with the OWOX add-in. Finance keeps Excel; the numbers come from one governed place.
Facebook AdsConnectedAdAd AccountAd Account UserAd Creatives
Microsoft ExcelDateCostClicksDaily 09:00Finance rebuilds Facebook Ads spend in Excel from exports that never match the deals the CRM booked.
Paste this into your AI assistant. It loads Facebook Ads into your data warehouse, links spend to sessions and CRM deals in a Data Mart, and pulls that Data Mart into an Excel workbook with the OWOX 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/facebook-ads-connector-to-microsoft-excel.md. The task: pull a Data Mart with Facebook Ads spend by campaign and month, linked to the CRM deals each campaign led to, into our finance Excel workbook with the OWOX add-in. 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
Facebook Ads Endpoints
15 Facebook Ads endpoints you can import. Each lands in its own table in your data warehouse.
Ad
Individual ads with their creative, status, and links to their campaign and ad set.
32 fieldsAd Account
Your ad account settings, status, currency, and billing details.
61 fieldsAd Account User
Users with access to an ad account and their assigned roles.
2 fieldsAd Creatives
The images, videos, text, and other visual elements used in your ads.
65 fieldsAd Insights
Daily performance metrics for each ad — impressions, clicks, spend, and conversions.
100 fieldsTime seriesAd Insights by Ad Set
Daily ad set performance with reach deduplicated to match Meta Ads Manager.
92 fieldsTime seriesAd Insights by Age and Gender
Daily ad performance broken down by audience age range and gender.
102 fieldsTime seriesAd Insights by Campaign
Daily campaign performance with reach deduplicated to match Meta Ads Manager.
89 fieldsTime seriesAd Insights by Country
Daily ad performance broken down by the country where your audience is located.
101 fieldsTime seriesAd Insights by Device Platform
Daily ad performance broken down by the device type your audience used.
101 fieldsTime seriesAd Insights by Link URL Asset
Daily ad performance broken down by the link URL shown in your ads.
101 fieldsTime seriesAd Insights by Product ID
Daily ad performance broken down by individual product from your catalog.
101 fieldsTime seriesAd Insights by Publisher Platform and Position
Daily ad performance broken down by where your ads appeared — platform and placement position.
102 fieldsTime seriesAd Insights by Region
Daily ad performance broken down by the region where your audience is located.
101 fieldsTime seriesAds
Individual ads with their status, creative, and campaign hierarchy.
24 fields
Why Facebook Ads does not go straight to Excel
A direct export or add-on can technically put the Facebook Ads account into Excel, but not reliably, at scale or business-ready. You get Meta's own attribution in a file with no link to the deals your CRM booked, and every analyst's copy drifts. The data warehouse closes that gap first.
- Meta's attribution says what a click was worth to Meta, not to your CRM
- The data analyst joins spend, sessions and deals by SQL keys and controls the result
- Finance opens a workbook that reads the same Data Mart as every other report
Facebook AdsSocial ad spendMicrosoft Exc…
Data warehouseJoined by idStep 1: Load Facebook Ads into your data warehouse first
Facebook AdsData MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databricksfacebook_ads.ad_account_insig…Step 2: Link Facebook Ads to web analytics and deals
In your data warehouse the model merges Facebook Ads with Google Ads and LinkedIn Ads, then joins web analytics sessions by a campaign key. Pick an industry to see the shape of its model.
- One spend table for every platform, so Excel never adds three exports by hand
- Sessions and deals join by SQL keys instead of a pasted lookup
- Measures such as platform_roas are defined once, not rebuilt per workbook
Facebook AdsAd Insights
Google AdsAd spend
LinkedIn AdsAd spendStep 3: Pull Facebook Ads data into Excel with the add-in
In Excel, add the OWOX Data Marts add-in and sign in. Choose the published Facebook Ads Data Mart (Ad Insights), tick the columns you want and press Create & Run.
- The add-in reads your data warehouse, not the Facebook Ads API
- Tick date_start, campaign_name and spend; add the rest later
Microsoft ExcelYour columns staydate_startcampaign_namespendStep 4: Refresh the Facebook Ads workbook when you need it
Press Refresh when you want the latest rows. The add-in pulls only the imported columns again and leaves everything you added next to them.
- A pivot or a formula column beside the import survives every refresh
- Pull on demand: no job runs unless you press the button
Microsoft ExcelYour column staysdate_startcampaign_…spendYoursStep 5: Reuse Facebook Ads inside OWOX MCP
The Facebook Ads Data Mart also works in OWOX MCP, your assistant for data. Ask which channel returns the most, then take the report to Google Sheets or Excel in one click.
- Ask in plain words; the answer comes from your data warehouse
- One definition of platform_roas for the workbook and the chat
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.39.0Long Facebook Ads imports no longer fail on a corrupted response
- 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
Why OWOX for Facebook Ads in Excel
Marketplace add-ons and export scripts get Facebook Ads rows into Excel. OWOX also keeps them linked to the rest of the business and under your control.
- Your attribution, not only Meta's. Spend sits beside CRM deals in your data warehouse, so a campaign is judged on revenue you booked.
- Breakdowns without a rebuild. Ad Insights and its breakdowns land as tables; a new workbook picks the columns it needs.
- Your columns stay. Formulas next to the imported columns survive a refresh.
- Maintained for you. When Meta changes the Marketing API, the connector changes, not your workbook.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.