Connector

Ask Claude about your Facebook Ads data

Load Facebook Ads into your data warehouse first, link Ad Insights (spend, reach, clicks) to web analytics and deals with SQL keys, then ask Claude in plain words. The answers come from your governed Data Marts, not from the ad account.

Facebook AdsConnectedAdAd AccountAd Account UserAd Creatives
Data MartPublishedone definition
ClaudeDateCostClicksDaily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get Started Free

Hand this to your AI

Paste a Facebook Ads export into Claude and it guesses which ad sets still earn their cost back.

Paste this into your AI assistant. It loads Facebook Ads into your data warehouse as a governed Data Mart and connects it to Claude through the OWOX MCP server, so every answer reads from tables your SQL defined.

The prompt

connect our Facebook Ads Data Mart to Claude through the OWOX MCP server so I can ask which ad sets have the highest cost per click this month and which still earn it back in purchases

Endpoints

Facebook Ads Endpoints

Documentation

15 Facebook Ads endpoints you can import. Each lands in its own table in your data warehouse.

S00 · Why

Why Claude needs your data warehouse, not the Facebook Ads account

Pointed at the Facebook Ads account alone, Claude 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 data warehouse, so Claude reads the answers from there.

  • Facebook Ads reports what an ad cost and what Meta's own attribution says it was worth, not what your CRM booked
  • The data analyst links Facebook Ads spend, web analytics and CRM deals by SQL keys and controls the result
  • Claude reads governed Data Marts, so every answer traces back to analyst-written SQL
Facebook AdsSocial ad spend
Claude
No link to deals
Data warehouseJoined by id
Web analyticsClicks, form fills
CRMDeals

S01 · Step 1

Step 1: Load Facebook Ads into your data warehouse first

Create a Data Mart with Facebook Ads as the data source and choose where the data lands. It works with any popular data warehouse.

  • Fifteen endpoints and 1172 fields to choose from, each endpoint in its own table
  • Open the Facebook Ads connector for your data warehouse below
Facebook AdsData Mart
Your data warehouseGoogle BigQueryAWS AthenaSnowflakeAWS RedshiftDatabricks
facebook_ads.ad_account_insig…

S03 · Step 3

Step 3: Connect Claude to your data with OWOX MCP

Add the OWOX MCP server in Claude under Settings > Connectors, then choose the Data Marts it may see. Claude gets only what you expose, never raw database access.

  • Authorize specific Data Marts, not your whole data warehouse
  • Publish the Data Marts you want Claude to answer from, such as Facebook Ads Ad Insights and its breakdowns by country or device
ClaudeConnectorsOWOX MCPAddConnected
Data martsUnified Ad SpendSessions

S04 · Step 4

Step 4: Ask Claude about Facebook Ads

Ask in plain words. Claude 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 a breakdown, for example Ad Insights by Country, and the answer reads that 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
ClaudeShow platform_roas and platform_cpa by channelget_relevant_data_marts_by_promptquery_data_martplatform_roasplatform_cpa

S05 · Step 5

Step 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
Answerplatform_roas
ExportGoogle SheetsCSVXLSOne click

Recent updates

Why OWOX

Why OWOX for Facebook Ads in Claude

Pointing Claude 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.
  • Ad Insights and its breakdowns, as tables. Ad Insights by Region, Country, Device Platform and Publisher Platform and Position are separate tables you can join, not exports to merge by hand.
  • Past Meta's attribution window. Meta reports inside its own attribution window; the history stays in your data warehouse when the windows or the 13-month limit change.
  • Zero hallucinations. Claude 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 Facebook changes its API.

Book a callGet Started Free

Trust

The Data Partner You Can Trust

users

175K Source: Internal OWOX data as of 2026-11-11

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers