Connector

Collect Facebook Ads Data into Databricks

Own your Facebook Ads data in Databricks with OWOX Data Marts. Collect granular, analytics-ready Facebook Ads data into Databricks, control schema and refresh logic, and reuse the data across BI tools and AI Insights.

Get Started Free

Endpoints

Facebook Ads Endpoints

Documentation

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

  • Ad

    Individual ads with their creative, status, and links to their campaign and ad set.

    32 fields

  • Ad Account

    Your ad account settings, status, currency, and billing details.

    61 fields

  • Ad Account User

    Users with access to an ad account and their assigned roles.

    2 fields

  • Ad Creatives

    The images, videos, text, and other visual elements used in your ads.

    63 fields

  • Ad Insights

    Daily performance metrics for each ad — impressions, clicks, spend, and conversions.

    100 fieldsTime series

  • Ad Insights by Ad Set

    Daily ad set performance with reach deduplicated to match Meta Ads Manager.

    92 fieldsTime series

  • Ad Insights by Age and Gender

    Daily ad performance broken down by audience age range and gender.

    102 fieldsTime series

  • Ad Insights by Campaign

    Daily campaign performance with reach deduplicated to match Meta Ads Manager.

    89 fieldsTime series

  • Ad Insights by Country

    Daily ad performance broken down by the country where your audience is located.

    101 fieldsTime series

  • Ad Insights by Device Platform

    Daily ad performance broken down by the device type your audience used.

    101 fieldsTime series

  • Ad Insights by Link URL Asset

    Daily ad performance broken down by the link URL shown in your ads.

    101 fieldsTime series

  • Ad Insights by Product ID

    Daily ad performance broken down by individual product from your catalog.

    101 fieldsTime series

  • Ad Insights by Publisher Platform and Position

    Daily ad performance broken down by where your ads appeared — platform and placement position.

    102 fieldsTime series

  • Ad Insights by Region

    Daily ad performance broken down by the region where your audience is located.

    101 fieldsTime series

  • Ads

    Individual ads with their status, creative, and campaign hierarchy.

    24 fields

S01 · Step 1

Step 1: Create a Databricks Data Storage

Start by connecting Databricks as your data storage in OWOX Data Marts.

  • Provide the Databricks Workspace URL
  • Specify the HTTP Path for your SQL Warehouse
  • Add a Personal Access Token for Databricks authentication

Connect Databricks

Step 1: Create a Databricks Data Storage

S02 · Step 2

Step 2: Create a Facebook Ads Data Mart

Create a new Data Mart and choose Connector as the definition type.

  • Select Facebook Ads as the data source
  • Authorize access to your Facebook Ads advertising account
  • No API coding or engineering required

Add Facebook Ads

Step 2: Create a Facebook Ads Data Mart

S03 · Step 3

Step 3: Select Fields & Configure Data Import

Choose exactly which Facebook Ads data you want to land in Databricks.

  • Select the required Facebook Marketing API endpoint
  • Choose fields like impressions, clicks, spend, conversions, and creative attributes
  • Define destination schema and table settings, or keep defaults

Choose Fields

Step 3: Select Fields & Configure Data Import

S04 · Step 4

Step 4: Run & Schedule Facebook Ads Data Collection

Once published, control how Facebook Ads data is imported.

  • Incremental load for current-day data
  • Backfill (custom period) for historical Facebook Ads data
  • Monitor execution in Run History

Run First Import

Step 4: Run & Schedule Facebook Ads Data Collection

S05 · Step 5

Step 5: Use Facebook Ads Data Across BI Tools & AI Insights

Your Facebook Ads data is now available through Databricks.

  • Analyze data in Google Sheets or Data Studio
  • Join Facebook Ads data with GA4, CRM, or revenue datasets
  • Enable AI Insights for summaries and alerts

Activate Reporting

Step 5: Use Facebook Ads Data Across BI Tools & AI Insights

What users are saying

Every claim has a receipt.

Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.

A3re: trusting AI
Nodari RizunNodari RizunFounder & CEO, Pürblack®
“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.”
C9re: one source of truth
Mark SimmonsMark SimmonsCMO, Pürblack®
“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
E7re: getting time back
Nodari RizunNodari RizunFounder & CEO, Pürblack®
“We regained time. And time is the one resource that never comes back.”

Turn Facebook Ads Data into Business Decisions

Schedule a quick walkthrough to see how OWOX Data Marts helps you collect Facebook Ads data in Databricks, reduce reporting complexity, and scale analytics with confidence.

Get Started Free

Trust

Data Partner You Can Trust

users

176K1

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

165K3

In Open Source We Trust

Customers

References

  1. Internal OWOX data as of 2026-10-02
  2. G2 reviews of OWOX
  3. npm installs stat