BigQuery Connector

Sync Criteo Ads Data to BigQuery

Detrics loads Criteo Ads into Google BigQuery on the schedule you set. The tables arrive clean, the history keeps growing, and you can query everything from SQL, Looker Studio, or Claude. We run the pipeline so you don't have to.

Book a Demo

*Free 30-minute consultation

SELECT
  campaign_name,
  SUM(impressions) AS impressions,
  SUM(clicks) AS clicks,
  SUM(sales) AS sales
FROM `your_project.marketing_data.criteo_ads_campaign_performance_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY campaign_name
ORDER BY impressions DESC
LIMIT 10

Why send Criteo Ads data to BigQuery?

Ad creatives that never expire

Creative URLs expire. Detrics archives your campaign images and videos permanently.

History without limits

Platform APIs cap how far back you can query. In BigQuery every Criteo Ads sync is stored across its 6 tables, so you accumulate years of your own history.

One warehouse for everything

Join Criteo Ads with the rest of your platforms in one place, no copy-pasting between sheets.

Ask Claude about it

With your data in BigQuery, Claude can answer business questions about Criteo Ads in plain language.

Criteo Ads tables in BigQuery

This is what Detrics creates for Criteo Ads: 6 preset tables with scheduled syncs, plus any custom one you define.

Attribution

device_breakdown

Spend, CTR, and conversion rate by device

campaign namedevicecostimpressionsclicksCTR+2

Performance

campaign_performance_daily

Spend, clicks, sales, and ROAS by campaign

campaign namecostimpressionsclickssalesrevenue+1

ad_set_overview

Spend, sales, ROAS, and conversion rate by ad set

campaign nameadset namecostclickssalesrevenue+2

weekly_spend_and_roas_trend_daily

Cost, revenue, and ROAS by week

campaign namecostrevenueROASsalesclicks

Settings

ad_set_settings

Budget, bid strategy, and targeting per ad set

adset nameadset statusadset delivery statusbudget amountadset bid value+4

Video

video_engagement

Video starts, completions, and completion rate by ad set

campaign nameadset nameimpressionsvideo startedvideo completedvideo completion rate+2

HOW IT WORKS

From Criteo Ads to your warehouse

Connect your account once. Detrics handles schemas, syncs, and backfills.

First step

Connect your first datasource

Link any of 37+ marketing and ecommerce platforms in a couple of clicks.

Connect a source

Second step

Set up your destination

Point Detrics at your BigQuery project and dataset. We write the SQL and handle the setup for you.

Set up destination

Third step

Create your transfer

Choose what to sync and how often. Detrics builds and runs the pipeline for you.

Create a transfer

And that's it

Real-time data, forever

Your data lands in the warehouse and stays fresh automatically. We handle the syncing, the maintenance, and every API update for you.

Book a demo

In the demo we set everything up for you and save you hours.

Then ask Claude about it

With Criteo Ads in BigQuery, the Detrics MCP server lets you manage your warehouse and run queries in plain language. MCP access is included with every BigQuery plan.

My Criteo Ads CPA jumped last week. Find out where.

Build a weekly Criteo Ads report for my client meeting

Detect anomalies in my Criteo Ads spend over the past 14 days

Explore the Criteo Ads MCP server

Every Criteo Ads field, on demand

Preset tables curated by our team
Custom tables with any field combination
Incremental syncs that only load new data
Automatic backfill of up to 12 months of history

58 metrics

38 dimensions

View Criteo Ads Fields

Get Criteo Ads into your warehouse this week