Free Criteo Ads to BigQuery Connector by OWOX: Automate Your Reporting Pipeline End-to-End

Criteo’s dynamic retargeting campaigns can drive serious performance, but extracting that data into BigQuery for reporting? That’s usually painful.

From complex APIs to expensive ETL tools, the journey from ad performance to business insight is often slow, opaque, or costly.

That ends here.

With the free, no-code Criteo Ads to BigQuery connector by OWOX, you can automate the import of your Criteo performance data directly into BigQuery, gain full transparency, and customize it to suit your reporting needs, no middleware, no black boxes, no fees.

Why We Made This Free Connector

Most Criteo Ads to BigQuery solutions are either paywalled, opaque, or overly complex. You often end up with limited access, hidden quotas, or black-box tools that restrict how your data is extracted and loaded.

We built the OWOX connector to address this issue.

This free Criteo Ads to BigQuery connector, part of the OWOX Data Marts (Community Apps Script Edition), gives you full visibility and control over your ad data pipeline.

Here’s why it matters:

• You get direct access to Criteo Ads API fields, not a filtered subset.
• You define how the data flows into BigQuery, fields, structure, scheduling, and cleanup.
• You own the entire process, from configuration to import,  without relying on closed platforms or external ETL tools.

We believe marketers and analysts should be able to build data workflows they understand and trust. This OWOX connector is a step toward that kind of data ownership.

Join the Open-Source Movement

This isn’t just a free Criteo Ads to BigQuery connector; it’s part of a broader mission to open up marketing analytics and put control back in the hands of analysts.

At OWOX, we believe that transparency, flexibility, and access to data shouldn't come at a premium. That’s why this OWOX connector, built as part of the OWOX Data Marts (Community Apps Script Edition), is 100% open-source. 

You can inspect the code, extend it, and make it work exactly the way your team needs.

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:

• Dive into the code and customize it for your business case.
• Suggest improvements or request additional connectors to expand functionality.
• Contribute documentation, scripts, or feedback to support other marketers and analysts.

Why Bring Criteo Ads Data into BigQuery?

Criteo is a performance marketing powerhouse, but getting its raw ad data into BigQuery? That’s often where the roadblocks begin.

❌ Engineering-heavy pipelines that delay insights
❌ Minimal access to clean campaign-level data for modeling and reporting
❌ Paid ETL tools that gate Criteo metrics behind subscriptions

That’s exactly why we built this free OWOX connector for Criteo Ads to BigQuery, using the OWOX Data Marts (Community Apps Script Edition).

✅ With BigQuery, you can centralize and structure Criteo ad performance data at scale
✅ You can join it with cost data, GA4, and CRM to build cross-channel attribution models
✅ You can run SQL-based analysis and automate daily updates with zero manual effort

This connector gives you direct, code-free access to Criteo Ads data, inside your BigQuery project, with complete control and zero vendor lock-in.

Why OWOX’s Criteo Ads → BigQuery Connector Stands Out

Most solutions that claim to connect Criteo to BigQuery are either buried behind paywalls or tightly coupled to rigid architectures. 

The OWOX connector takes a different approach, one that prioritizes analysts.

Here’s how it’s different:

• Built with simplicity: Configure everything inside Google Sheets – no extra platforms or tools required
• Transparent by design: View and modify every step of the import logic using Google Apps Script
• Ready for analysts: No backend setup, just a Google Sheet and a BigQuery destination
• Scalable on your terms: Works whether you're importing one campaign or managing 50 accounts.
• Fully community-driven: Built on the OWOX Data Marts (Community Apps Script Edition), with updates shaped by real users

With OWOX, you don’t just use the connector, you own it. And that makes all the difference.

Already streamlining Criteo Ads? You’ll love what else you can automate:

• Criteo Ads → Google Sheets
• Microsoft Ads → BigQuery
• Open Exchange Rates→ BigQuery
• LinkedIn Ads→ BigQuery

Build unified performance reports across platforms with full visibility and transparency, as they should be.

Google BigQuery

Data sources

Free Criteo Ads Connector to Google BigQuery

Download template

How the Connector Works

This connector is part of the OWOX Data Marts (Community Apps Script Edition) and is designed to run directly in Google Sheets, with no third-party tools or engineering dependencies.

Here’s what it does behind the scenes:

• Uses Google Apps Script to fetch campaign, creative, and analytics data from the Criteo Marketing API.
• Lets you define parameters in plain cells like accounts, time ranges, and field selections, without code.
• Sends structured data directly to your specified BigQuery dataset and location.
• Supports automatic cleanup of outdated records to maintain lean, query-ready tables.

You get exactly the data you want, in your BigQuery project, ready for blended reporting, attribution modeling, or funnel analysis.

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

Getting Criteo Ads data into BigQuery shouldn’t be a hassle. With our pre-built template, you can go from setup to structured reporting in just a few clicks, no coding required.

Step 1: Copy the Template ( ~1 min)

To make setup fast and foolproof, we’ve created a ready-to-use Google Sheets template that works with the OWOX Criteo → BigQuery connector.

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

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

Download your FREE template today!

‍

1. Access the Template
   
   • Open the “Criteo  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 Your Data Settings (~1 min)

Set up your desired parameters for importing Criteo Ads data; it takes just a few clicks.

1. Set the Start Date

On the Config sheet, choose when data collection should begin.

Note: Selecting a long date range may prevent data from downloading due to volume limits.

2. Add Your Criteo Advertiser  ID

• Find your Advertiser ID on the homepage of your Criteo Ads account, then 

• Paste it into the Advertiser ID field in the template.

3. Select the Fields to Import

•  To include specific metrics and dimensions in your report, navigate to the Fields tab in the template.
• Check the boxes next to the fields you want to import from your Criteo Ads account. 

These fields help track the traffic source in downstream analytics.

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.

Further, Specify the Fields with the Following Parameters:

• ReimportLookbackWindow: Days to look back when reimporting data (default: 2)
• MaxFetchingDays: Max number of days to fetch per run (default: 31)

Step 3: Get Your Criteo Access Token ( ~1 min)

To authorize your connector and fetch data from Criteo Ads, you’ll need to generate an access token using your Criteo developer account.

1. Log In to Criteo Partners

• Visit  https://partners.criteo.com 

• Sign in with your Criteo Ads credentials.

‍

2. Create a New App

• Click the ➕ icon in the My Apps section or 
• Hit “Create a new app” to start the setup.

3. Set the Application Name

• Enter a recognizable name like: OWOX (open source connector)
• Optionally add a short description to help identify it later.
  Tip: Use a clear name to simplify troubleshooting or team collaboration.

• Click Next.

‍

4. Choose the Authentication Method

• Select  Client Credentials as the method of authentication for the app.

5. Assign the Right Service

• Under Service, choose: C-Growth and marketing solutions.

6. Set Required Permissions

Check the following permissions to enable full access to reporting data:

• Analytics – Read
• Campaigns – Read
• Creatives – Read

Note: You won’t be able to edit these settings once the app is activated.

• Click Activate app to proceed with the setup.

7. Generate Your API Keys

• Click Create new key. 

• After that:
  
  • Download a .txt file containing your client_id and client_secret.
  • Store these credentials securely; you’ll need them during setup.

‍

8. Grant Consent

• Click  Generate new URL → Copy the Consent URL

•  Paste it into your browser.
•  Follow the prompts to grant access to the app.

Once access is granted, you now have everything you need to proceed.

• Client ID
• Client Secret
• App authorization

Step 4: Add Credentials in Google Sheets ( ~10 seconds)

Once you've generated your Criteo credentials, it’s time to connect them to the template.

1. Open the Credentials Menu

• In your Google Sheet, go to the top menu → OWOX → Manage credentials.

2. Add Your Credentials

• Paste the client_id and client_secret from the Criteo developer portal into the prompt that appears.

You’re now ready to start importing your Criteo Ads data into Google Sheets.

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. Check Your Data

• The Logs sheet will show “Import is finished” once complete.
• The data will appear directly in BigQuery under the specified dataset.

3. To Include More Fields or Change the Date Range

• Go to the Fields tab, check additional boxes, and click OWOX → Import New Data.
• To update the date range, clear the Status columns, set new dates, and run Import New Data again.

📊Real-Time Reporting with OWOX Reports

Want to turn your Criteo Ads data in BigQuery into instantly usable reports?

Use the OWOX Reports Extension for Google Sheets to transform your BigQuery tables into clear dashboards, with no SQL or third-party tools required.

With OWOX Reports, you can:
📥 Pull Criteo Ads data from BigQuery straight into Sheets
📊 Build live dashboards your team can explore and share
✅ Enable real-time performance tracking without writing a single query

Whether you're reviewing campaign results or running cross-channel cost analysis, your Criteo Ads data is now just a click away.

What’s Next?

This Criteo Ads to BigQuery connector is part of a growing family of open, no-cost tools built for marketers and analysts.

Here are more resources to explore:

🔗 Free connectors: Twitter and TikTok Ads Connectors for BigQuery and many more

📽️ Video tutorials: Watch setup walkthroughs step-by-step
📊 Dashboard templates: Plug in your BigQuery data and start analyzing instantly

Visit the GitHub repo, leave a ⭐, and share your feedback – let’s build better marketing analytics, together.

Google BigQuery

Data sources

Free Criteo Ads Connector to Google BigQuery

Download template