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 → BigQuery connector. 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 is our first step toward a more open, self-owned future in marketing analytics.

Join the Open-Source Movement

We’re not just releasing a free connector – we’re inviting you to help shape the future of open 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.

✅ With BigQuery, you can structure and store Facebook Ads data at scale.
✅ You can blend it with Google Analytics, CRM, and cost data to build unified attribution models.
✅ You can automate daily updates and query performance across all channels using SQL.

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.

Google BigQuery

Data sources

Free Facebook Ads Connector to Google BigQuery

Download template

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.
• Direct Facebook Ads → BigQuery flow — skips CSVs, third-party dashboards, or middlemen.
• Full API coverage — extract any metrics, breakdowns, or dimensions available in Meta’s Ads API.
• Own your schema — customize how data is structured, cleaned, and loaded inside BigQuery.
• Complete transparency — view, edit, or extend every part of the pipeline using Apps Script.

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 – no middleware or ETL platforms required.

Here’s what’s under the hood:

•  It’s an open-source tool based on Google Apps Script that runs inside Google Sheets, where you set parameters and start your load.
• The script pulls raw data from the Facebook Marketing API – including all available metrics, dimensions, breakdowns, and filters.
• 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 fully own
• 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.

Step-by-Step: Import Facebook Ads Data to BigQuery

This is where the magic happens. In just a few minutes, you’ll have your Facebook Ads data flowing into BigQuery — no coding, no roadblocks, just results. Let’s walk through each step.

Step 1: Copy the Google Sheets Template ( ~1 min)

To streamline the setup process for your Facebook to BigQuery reporting, use our pre-configured BigQuery template – no need to build from scratch.

Master Facebook Ads to Google BigQuery Reporting With Our Free Template!

Skip manual exports and API wrangling – this Google Sheets template helps you send Facebook Ads data straight to BigQuery with just a few clicks.

Download your FREE template today!

‍

1. Access the Template
   
   • Open the “Facebook Marketing → Google BigQuery. Template” from OWOX.
     
     
2. Create a Personal Copy
   
   • Go to File → Make a copy to save it to your Google Drive.

 Step 2: Configure the Template ( ~1 min)

Fill in the key settings that define what data you'll send and where.

1. Set the Start Date
   
   • On the Config sheet, specify when the data import should begin.
     Note: Using a long date range may cause the import to fail due to data volume limits.

2. Add Your Facebook Ads Account ID(s)
   
   • Find your Account ID in Meta Ads Manager on the Account Overview page.

• Paste it into the corresponding field in the template.
    You can list multiple IDs, separated by commas, to pull data from several accounts.

3. Select the Data Fields
   
   • Navigate to the Fields tab.
   • Check the boxes for the metrics, breakdowns, and dimensions you want to include.
     Some fields may be preselected by default.

Further Specify the Fields with the Following Parameters:

• Destination Dataset ID: Leave blank to load data into the currently open spreadsheet.
• Destination Location: Destination Location is set to the default as US.
• ReimportLookbackWindow: Days to look back when reimporting data (default: 2)
• MaxFetchingDays: Max number of days to fetch per run (default: 31)

‍

4. Set Your BigQuery Destination
   
   • Dataset ID: Add the destination in this format → project_id.dataset_id
   • Location: Specify the BigQuery region for your dataset.
       If the dataset doesn’t already exist, it will be created automatically.

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

Authorize the connector to access your ad data using a secure token from Meta.

1. Log Into 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.

Once your token is ready, proceed to the next step to connect it to the Google Sheets template.

Step 4: Input Access Token into the Template ( ~10 seconds)

Now it’s time to link your access token to the template.

1. Open the Credentials Menu
   
   • Go to the spreadsheet’s top menu → OWOX → Manage credentials

2. Add Your Token
   
   • Paste the token you generated.
   • Click OK to save.

 Step 5: Import Data into BigQuery (~1 min)

Everything’s set – now launch your import.

1. Start the Import
   
   • From the menu, click OWOX → Import New Data.

2. Monitor the Logs
   
   • The Logs sheet will show “Import is finished” once complete.
     
     
3. Check Your Data
   
   • Data will appear directly in BigQuery under the dataset you specified.

📊 Real-Time Reporting with OWOX Reports

Want to take your BigQuery data to the next level?

Use the OWOX Reports Extension for Google Sheets to turn your Facebook Ads data in BigQuery into insightful reports in seconds, no SQL required.

With OWOX Reports, you can:
📥 Pull data directly from BigQuery into Google Sheets
📊 Build shareable, refreshable dashboards without Looker Studio
✅ Empower your team with real-time access to ad performance metrics

No code, no queries, no delays. Just actionable reports – when and where you need them.

What’s Next?

This free connector is just the first step in our mission to make data ownership simple, transparent, and accessible for everyone.

Here’s what’s coming soon:

🔗 More free connectors – including TikTok Ads, LinkedIn Ads, and other key marketing platforms.

🎥 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.

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

Google BigQuery

Data sources

Free Facebook Ads Connector to Google BigQuery

Download template