All resources

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.

Dashboard displaying Facebook Ads data flowing into BigQuery storage and being exported to Google Sheets and Looker Studio. i-shadow

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, 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 data and 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, 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.

✅ With BigQuery, you can centralize and structure Criteo ad performance data at scale
✅ You can join it with cost data 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:

  • 100% free and open-source: no usage fees, hidden limits, or tiered pricing. The Criteo Ads connector is available on GitHub as part of OWOX Data Marts.
  • Transparent by design: Inspect and customize the full connector code and SQL logic directly in your environment with OWOX Data Marts.
  • Ready for analysts: No third-party setup required — just run the connector in your environment and stream data directly into BigQuery.
  • Own your schema: Define how Criteo Ads data lands in BigQuery, assign clear field aliases, and structure it to match your reporting needs.
  • Fully community-driven: Built on the OWOX Data Marts, 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.

How the Connector Works

This connector is part of OWOX Data Marts and is designed to run directly in your environment via Node.js CLI, with no third-party tools or engineering dependencies.

Here’s what it does behind the scenes:

  • Built on an open-source framework you control, the Criteo Ads connector eliminates the need for extra platforms, paid ETL tools, or manual CSV uploads.
  • Configure parameters in JSON or CLI (accounts, time ranges, field selections) with full flexibility.
  • Sends structured data directly to your specified BigQuery dataset and location.
  • Includes SQL patterns for automatic cleanup of outdated records, keeping tables lean and query-ready.

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

Criteo Ads Connector to Google BigQuery

💡 Check out this video for a step-by-step guide to sending Criteo Ads data to BigQuery using OWOX. It walks you through access token setup, connector configuration, and scheduling automated imports.

Step-by-Step: Import Criteo Ads Data to BigQuery with the OWOX Data Marts

Set up a fully self-managed, SaaS-free pipeline to import Criteo Ads data directly into BigQuery using the 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. 

💡 For detailed setup instructions and troubleshooting, check the official documentation.

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 Criteo Ads data mart in OWOX.

  1. Open your browser and go to http://localhost:3000.
Local host being redirected to the home page of OWOX Data Marts. i-shadow
💡 Follow our guide, where you’ll find easy-to-follow instructions on how to configure your storage in OWOX Data Marts.
  1. Create your Service Account JSON Key
Navigation panel in Google Cloud Console showing the path to access service accounts by going to IAM and then selecting the Service Accounts section. i-shadow
  1. Paste it into the ‘OWOX Service Account JSON Field’
  • Don’t forget to click Save
OWOX connector configuration labeled ‘OWOX Service Account JSON Field’ where users paste their service account key for authentication. i-shadow
  1. Create your first Data Mart: Once storage is added, click on the Data Mart Tab, then on ‘New Data Mart
OWOX Data Marts interface showing the main dashboard with the ‘New Data Mart’ button. i-shadow
  • Now, create the Data Mart, name the title as ‘Criteo Data’, as the data source
  • Choose the storage named ‘Criteo Ads Storage’ you just created
  • Click ‘Create Data Mart’.
Create Data Mart screen with title set to " Criteo Data" and storage selected as "Criteo Ads Storage". i-shadow

Now we will do the Data Setup

  1. Set up your Data Mart
  • Go to Data Setup Tab and then select Connector
 Input Setup section in OWOX Data Marts with 'Connector' selected as the definition type for the data source. i-shadow
  • Click on Setup Connector and Choose Criteo Ads Connector
Setup Connector panel in OWOX Data Marts with Criteo Ads selected as the connector source. i-shadow

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. Let’s make sure you’ve got the right access credentials in place. 

Prerequisites

  • A Criteo Ads account with access to the Criteo Partners portal
  • A Criteo Developer App created in the portal with authentication set to Client Credentials
  • A valid Client ID and Client Secret generated when creating the app
  • A Consent URL authorized through your Criteo account to finalize access

Steps to Obtain Credentials

  1. Log In to Criteo Partners
Criteo login screen with fields to enter email address and option to stay logged in. i-shadow
  • Sign in with your Criteo Ads credentials.

  1. Create a New App
    • Click the ➕ icon in the My Apps section or 
    • Hit “Create a new app” to start the setup.
 My Apps section in Criteo developer portal with option to create a new app highlighted. i-shadow
  1. 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.
Application name and description fields populated in Criteo developer portal. i-shadow
  • Click Next.

  1. Choose the Authentication Method
    • Select  Client Credentials as the method of authentication for the app.
Authentication method screen showing Client Credentials selected for the Criteo app. i-shadow
  1. Assign the Right Service
    • Under Service, choose: C-Growth and marketing solutions.
Service dropdown showing "C-Growth and marketing solutions" selected. i-shadow
  1. Set Required Permissions: Check the following permissions to enable full access to reporting data:
    • Analytics – Read
    • Campaigns – Read

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

    • Click Activate app to proceed with the setup.
Activation confirmation screen for Criteo app with "Activate" button highlighted. i-shadow
  1. Generate Your API Keys
    • Click Create new key. 
Criteo App Credentials section showing option to create a new API key with a “Create new key” button. i-shadow
  • Download a .txt file containing your client_id and client_secret.
  • Store these credentials securely; you’ll need them during setup.

  1. Grant Consent
    • Click  Generate new URL → Copy the Consent URL
Consent URL field shown with copy button and instructions to open in browser. i-shadow
  •  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

Security Notes

  • Keep your Client ID, Client Secret, and access token confidential; never share them outside your team
  • Store credentials in a secure location (e.g., password manager or secret manager)
  • Rotate credentials periodically to reduce risk
  • Use the generated Consent URL only in trusted environments to grant access
  • Avoid hardcoding sensitive keys directly into scripts; rely on secure configuration files or environment variables

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

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

  1. Add the Advertiser ID, Client Id, Client Secret, Access Token .
    • Paste the Advertiser ID, Client Id and Client Secret
    • Paste the Access Token
  2. Start Date
    • Set the reporting start date (e.g., 2025-07-01). This determines how far back data will be fetched.
  3. As you scroll further, you’ll find extra parameter fields. They’re optional for the first run and can be updated later if required.

  4. Click 'Next'.

  5. Select an Endpoint
    • Choose the endpoint that fits your reporting needs.
  6. Select Fields for the chosen node. 
    • Select all available fields or choose specific metrics based on your reporting needs.
  7. Name the Dataset:
  • Enter the BigQuery dataset name where the imported data should be stored.

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

  1. Click Finish
  2. In the Data Setup Tab. Click 'Save'.

10. Click 'Publish Data Mart'.

11. Click 'Manual Run' or use the 3-dot menu → 'Run Now'.

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

13. 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
  1. Click 'Create Trigger'
  2. The trigger is now active and scheduled to run automatically on the defined days and at the defined time.

What’s Next?

This Criteo Ads to BigQuery connector belongs to a growing collection of free, open-source tools designed to give marketers and analysts full control over their data.

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 Visualization: Send your BigQuery data directly into Google Sheets and Looker Studio, so teams can analyze and share insights instantly.

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

Criteo Ads Connector to Google BigQuery

FAQ

Do I need coding skills to use the Criteo Ads to BigQuery connector?
What credentials are required to connect to Criteo Ads?
Can I choose what data gets imported to BigQuery?
Does the connector support automatic updates?
Will it create a BigQuery dataset if one doesn’t exist?
How much does this connector cost?

You might also like

2,000 companies rely on us

Oops! Something went wrong while submitting the form...