Collect Facebook Ads Data into Google BigQuery

Own your Facebook Ads data in Google BigQuery with OWOX Data Marts. Collect granular, analytics-ready Facebook Ads data directly into BigQuery, control schema & refresh logic, and build reliable reporting without vendor lock-in.

Step 1: Connect Google BigQuery as Your Data Storage

Start by connecting your own Google BigQuery project - this is where your Facebook Ads data will live.

Use your GCP Service Account or Google oAuth
Keep full ownership of data & access controls

Once connected, BigQuery becomes the single source of truth for your Facebook Ads analytics.

Step 1: Connect Google BigQuery as Your Data Storage

Connect BigQuery

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 using Facebook credentials
No engineering or API work required

This defines what data you collect — not just where it goes.

Create Facebook Data Mart

Request a demo

Step 3: Select Fields & Configure Data Import

Choose exactly which Facebook Ads data you want to store in BigQuery.

Select the API endpoint (e.g. ad-account/insights)
Choose only the fields you need (spend, clicks, impressions, conversions, etc.)
Define destination dataset & table name (or use defaults)
Publish the Data Mart once configuration is complete

Your schema is explicit, documented, and reusable across teams.

Configure Data Import

Step 4: Run the Data Mart (Manual or Scheduled)

Once published, you control how and when data is imported.

Option 1: Incremental Load (Daily Data)

Run Incremental load to fetch today’s data
Re-runs automatically pull new data + optional lookback window

Option 2: Backfill Historical Data

Choose Backfill (custom period)
Select start & end dates
Load historical Facebook Ads data into BigQuery

All runs are logged and visible under the Run History tab.

Run Data Mart

Request a demo

Step 5: Activate Facebook Ads Data Across Your Stack

Your Facebook Ads data is now available in Google BigQuery & OWOX Data Marts– ready to use anywhere.

Connect the same data mart to Google Sheets or Looker Studio
Join Facebook Ads data with CRM, GA4, or revenue tables using SQL
Enable AI Insights to ask questions or receive notifications into Slack, MS Teams or by Email

Note: Don't forget to schedule both connector & report(s)