Free Facebook Ads to BigQuery Connector by OWOX: Take Control of Your Ad Data at Scale

Running Facebook Ads is one thing. Reporting on them at scale? Reporting on them at scale with a Facebook to BigQuery solution? That’s a whole different beast.

Exporting Facebook ad data into BigQuery often means costly ETL tools, complex pipelines, or constant engineering help -  barriers that slow down insights.

Analysts deserve straightforward control over their own ad performance data, without needing a full tech stack. That’s why we built this free, no-code Facebook Ads to BigQuery connector a part of the OWOX Data Marts. It lets you load, refresh, and manage Facebook Ads data directly into BigQuery, with full transparency and zero vendor lock-in.

No limits, no black boxes. Just your Facebook Ads data to BigQuery, exactly where you need it.

Why We Made This Free Connector

Most Facebook Ads connectors are either expensive, limited in what they pull, or completely opaque in how they work. We wanted to flip that model on its head. We believe analysts and marketers should own their data workflows, not rent them from third-party vendors.

So we built this open-source connector to give you:

• Full access to all Facebook Ads API fields
• Full control over how your data is extracted and loaded
• A cost-free alternative to proprietary, paywalled solutions

This Facebook Ads to BigQuery connector from OWOX Data Marts is the first step toward a more open, self-owned future in marketing analytics. It is 100% free – no paywalls, no restrictions, no surprises.

Join the Open-Source Movement

We’re not just releasing a free connector – we’re inviting you to help shape the future of data and marketing analytics tools.

At OWOX, we believe that data access and transparency should be a right, not a luxury. That’s why this connector is 100% open-source – giving you full control over how it works, what it does, and how far it can go.

If you like what we do, please ⭐ star our GitHub repo to show your support – it helps us reach more analysts and grow the number of available connectors.

Also, feel free to:

• Explore the code and customize it to fit your needs.
• Contribute to this data connectivity ecosystem: suggest new connectors, pull new connectors, and/or documentation to support the wider community.
• Join our community & share your feedback.

We’ve built the core, the foundation – now it’s your turn to take it further.

Why Bring Facebook Ads Data into BigQuery?

When it comes to running scalable marketing analytics, BigQuery is hard to beat. But getting raw Facebook Ads data into it? That’s where most teams hit a wall.

• Complex pipelines that require engineering help
• Limited access to raw data for modeling or enrichment
• Expensive tools that gate key metrics or APIs

That’s exactly why we built this connector for Facebook ads to Google BigQuery – to unlock a better way. Here’s why it’s a must-have for data teams:

✅ Automatically load TikTok Ads to BigQuery – no manual steps or third-party ETL required
✅ No-code setup with a simple, open-source spreadsheet template
✅ Full-funnel data access: impressions, clicks, CTR, video engagement, conversions, and more
✅ Schedule recurring imports and incremental updates
✅ Pull granular data across campaigns, ad groups, creatives, and audiences

This connector gives you the raw access, flexibility, and power needed to run marketing analytics your way – and at your scale.

And you don’t need to pay a cent or write a single line of backend code to get started.

Want even more control over your ad data?
If you're moving Facebook Ads to BigQuery, you’ll love what else you can connect, completely free and code-free:
‍
Facebook Ads → Google Sheets
‍TikTok Ads → BigQuery
‍Reddit Ads → BigQuery
‍Twitter Ads → BigQuery
‍
Unify your ad data, customize your analysis, and scale your reporting, your way.

Why OWOX’s Facebook Ads to BigQuery Connector Beats Other Tools

There’s no shortage of tools that push Facebook Ads data into BigQuery. Still, many come at a cost: restrictive pricing models, rigid pipelines, and limited visibility into what’s happening under the hood.

The OWOX connector was built to eliminate those problems:

• 100% free and open-source: no usage fees, hidden limits, or tiered pricing. This connector is available free on GitHub as part of OWOX Data Marts.
• Direct Facebook Ads to BigQuery flow: skips CSVs, staging layers, and 3rd-party services in between.
• Full API coverage: extract any metrics, breakdowns, or dimensions available in Meta’s Ads API.
• Own your schema: Define your destination table schema, assign clear field aliases, and adjust the structure to align with your specific reporting requirements.
• Complete transparency: inspect, modify, and extend every pipeline component with open configs and SQL in your warehouse.

You don’t have to settle for a black-box ETL or worry about how much data will cost this month.

If you want total control over how Facebook Ads data lands in your BigQuery project, with zero vendor lock-in, the OWOX connector is built for you.

How the Connector Works

We designed this connector to work out of the box for data analysts, marketers, and technical teams, as part of the OWOX Data Marts, with no middleware or ETL platforms required.

Here’s what’s under the hood:

• It’s based on an open-source framework you operate yourself, removing the need for additional platforms, paid ETL tools, or manual CSV handling.
• Connects directly to the Facebook Marketing API to fetch campaigns, ad insights, creatives, and account data.
• It loads your Facebook Ads data to BigQuery tables directly 

And yes – it’s 100% free and open, with no usage limits.

You can use it to:

• Replace pricey ETL tools with a solution you wholly own, built on OWOX Data Marts.
• Schedule regular imports to keep your BigQuery tables fresh
• Power Looker Studio dashboards and advanced models using clean, structured ad data

It’s the simplest, fastest way to start running Facebook Ads analysis in BigQuery – no waiting, no black boxes.

💡Check out this video for a step-by-step guide on connecting Facebook Ads to BigQuery using OWOX’s free template. It’s a quick and easy way to see the setup in action.

Step-by-Step Guide: Import Facebook Ads Data to BigQuery with OWOX Data Marts

Set up a fully self-managed, SaaS-free pipeline to import Facebook Ads data directly into BigQuery using OWOX Data Marts and a local server.

Step 1: Install Node.js and OWOX CLI ( ~2 min)

To run OWOX Data Mart locally, you’ll need to install Node.js and the OWOX CLI. This setup allows you to start a local server and work with OWOX Data Marts effectively.

To get started, install the LTS version of Node.js from nodejs.org and use a version manager like nvm or nvm-windows to avoid permission issues. Once Node.js is set up, you can install the OWOX CLI globally and run ‘owox serve’ to launch the local server.

Step 2: Connect Google BigQuery and Set Up Your Data Mart ( ~3 min)

Set up BigQuery as your destination and link it to a new Facebook Ads data mart in OWOX.

1. Open your browser and go to http://localhost:3000.

💡 Follow our guide, where you’ll find easy-to-follow instructions on how to configure your storage in OWOX Data Marts.

2. Create your Service Account JSON Key.

• Follow our guide to create your service account JSON Key.

3. Paste it into the ‘OWOX Service Account JSON Field’

• Don’t forget to click ‘Save’.

4. Create your first Data Mart: Once storage is added, click on the Data Mart Tab, then on ‘New Data Mart’

• Now, create the Data Mart, name the title as ‘Facebook Data’, as the data source
• Choose the storage named ‘Facebook Ads Storage’ you just created

• Click ‘Create Data Mart’.

Now we will do the Data Setup

5. Setup your Data Mart
   
   • Go to Data Setup Tab and then select Connector

• Click on Setup Connector and Choose Facebook Ads Connector

Step 3: Get a Facebook Ads Access Token ( ~1 min)

To connect your Facebook Ads account, you’ll need an access token. Let’s make sure you’ve got the right access credentials in place. 

Prerequisites

• A Facebook account with access to the Meta for Developers portal
• A Meta Developer App created in the Developers portal
• Marketing API set up and enabled in your app
• A valid Access Token generated via OAuth to authenticate requests

Steps to Obtain Credentials

1. Log in to Meta for Developers
   
   • Visit the Meta for Developers site

• Sign in using your Facebook account.
  (Use the account that has access to your Meta Ads Business Manager.)

2. Create a New App
   
   • Click My Apps in the top-right menu, then Create App

‍

‍

• In the App Name field, enter a name of your choice.

• For the use case, select Other

• Choose Business as the app type → click Next

3. Connect to a Business Portfolio
   
   • Select the appropriate Business Portfolio
   • Click Create App

4. Start Business Verification
   
   • Go to App Settings → Basic

‍

• If prompted, connect your app to your business portfolio.

• Click Start Business Verification

5. Submit Verification Info
   
   • Fill in the required fields with accurate contact and organizational information.
   • Ensure your submission meets Meta's requirements.

• Meta will review your submission within 2 business days.

6. Set Up Marketing API
   
   • After successful verification, return to your app dashboard.
   • Locate the Marketing API card and click Set Up

7. Grant Required Permissions
   
   • In the Tools section, enable the following scopes:
     
     • ads_read
     • Read_insights

‍

8. Generate and Save Token
   
   • Click Get Token

‍

• Copy the generated access token and store it securely.
  To regenerate, go to Marketing API → Tools → User Token section.

‍

Security Notes

• Keep your access token and app secret secure
• Don’t share credentials
• For production environments, always implement secure token refresh logic 

Step 4: Configure Facebook Ads Connector and Run Your First Import ( ~2 min)

Now that you’ve retrieved your Facebook Ads access token, it’s time to configure the connector in OWOX.

1. Add the Access Token

2. Find your Account ID
   
   • It is found in your Meta Ads Account Overview or the adsmanager.facebook.com URL

• Paste the Account ID

3. Start Date: 
   
   • Set the reporting start date (e.g., 2025-07-01). This determines how far back data will be fetched.

4. When you scroll down, you’ll see some more fields with parameters. For your first run, they are optional, and you can always come back and adjust them later.
5. Click Next.
6. Endpoint: Choose the following valid endpoint nodes:
   

• ad-account/ads 
• ad-account/user – Information about the user connected to the ad account.
• ad-account – General account-level details such as account name, currency, and status.
• ad-account/adcreatives – Metadata and details of ad creatives, including format and assets.
• ad-account/ads – Information on individual ads within the account.
• ad-account/insights – Performance metrics like impressions, clicks, spend, and conversions.
• ad – Specific details for a single ad entity.

👉 Tip for first-time setup: If you’re just getting started, begin with the ad-account/ads endpoint. It provides detailed information on each ad, including creatives and delivery status, which most teams use to build their first reports. Later, you can add ad-account/insights for performance metrics or ad-account/adcreatives to enrich your model with creative-level context. 

7. Select Fields for chosen node. 
   
   • Select all available fields or choose specific metrics like clicks, spend, and impressions based on your reporting needs.

8. Dataset Name: 

• Enter the BigQuery dataset name where the imported data should be stored.

Note: If the dataset doesn't exist, OWOX will create it automatically in the storage during the import process.

9. Click Finish

10. In the Data Setup Tab, Click 'Save'.

11. Click 'Publish Data Mart'..

12. Click 'Manual Run' button or use the 3-dot menu.

13. A configuration panel will appear to choose a Run Type. Select Backfill or Incremental Load. Then add the required start and end dates, then click Run to load the data. 

Please Note: If you are setting up this connector for the first time, you need to go with the Backfill Run Type.

14. Go to 'Run History' and see the message 'Success'.

Step 5: Schedule Automated Imports ( ~1 min)

Set up a trigger to pull data on a recurring schedule.

1. Go to the 'Triggers' tab in the new Data Mart
   
   • Click 'Add Trigger'.

2. Configure:

• Trigger Type: Connector Run
• Schedule Settings: Daily / Weekly / Monthly / Interval
• Time Settings: hour, minute, second
• Days of the week
• Time zone

3. Click 'Create Trigger'. Your data will now refresh automatically.

4. The trigger is now active and scheduled to run automatically on the defined days and at the defined time.

What’s Next?

The free Facebook Ads to BigQuery connector in OWOX Data Marts continues our mission to make data ownership simple, transparent, and accessible to everyone.

Here are more resources to explore:

🔗 More free connectors – including LinkedIn Ads and Microsoft Ads Connectors for BigQuery.

🎥 Step-by-step video tutorials – so you can follow along and set everything up with ease.

📊 Prebuilt dashboard templates – designed to help you get actionable insights instantly from BigQuery faster than ever.

Check out our GitHub repo, leave us a ⭐ star, and let’s build better tools together.