Send data from Criteo to BigQuery

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

shape
shape

Criteo to BigQuery Data Replication Pipeline

How to send Criteo data to BigQuery? Kondado provides a direct integration that lets you replicate your programmatic advertising data from Criteo into BigQuery without writing code. Configure your data source once, set your preferred update schedule, and watch your advertising metrics flow into your data warehouse automatically. Whether you need near-real-time updates every five minutes or daily batch loads, Kondado handles the data extraction and loading so your analytics team can focus on insights.

Kondado automates the replication of Criteo advertising data to BigQuery, delivering Daily Ad Statistics with 146 fields including clicks, impressions, spend, and revenue metrics on a configurable schedule.

Once your Criteo data lands in BigQuery, you can combine it with other marketing data sources to build comprehensive attribution models and optimize your retargeting campaigns. Agency analysts and marketing teams use this automated pipeline to eliminate manual CSV exports and keep their dashboards current with fresh advertising performance data.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Available Criteo Pipelines for BigQuery

The Daily Ad Statistics pipeline captures 146 distinct fields from your Criteo campaigns, including granular metrics on clicks, impressions, bounce rates, and revenue attribution. In BigQuery, you can query this rich dataset to calculate true ROAS, identify high-performing audience segments, and track how your dynamic retargeting ads perform across different time periods and devices.

Combine these advertising metrics with sales data from your CRM or website analytics to build custom reports that show the complete customer journey from ad impression to conversion. Marketing teams leverage this automated data flow to create sophisticated cohort analyses and optimize bid strategies based on historical performance trends stored in their BigQuery data warehouse.

Try out all the features for free for 14 days

Custom reports

This connector lets you create custom reports with dimensions and metrics of your choice. In addition to the pre-configured reports below, you can build tailored reports for your needs.

1
configurable report
146
extractable fields

Pre-configured reports

Report Description
Daily Ad Statistics Analyze clicks, impressions, and total ad spend, along with bounce rate and revenue generated over a specific period.
Daily Ad Statistics
Analyze clicks, impressions, and total ad spend, along with bounce rate and revenue generated over a specific period.
See all available data →

Try out all the features for free for 14 days

How to send Criteo data to BigQuery

Sync data automatically — no code, no manual exports.

1
Connect Your Criteo Account

Authenticate your Criteo data source in Kondado by entering your API credentials through the connection interface. The platform validates your programmatic advertising access and prepares the available pipelines for replication.

2
Configure BigQuery Destination

Enter your Google Cloud project details to establish BigQuery as the destination for your Criteo advertising data. Kondado automatically creates the appropriate dataset structure to receive the Daily Ad Statistics pipeline.

3
Select Data and Schedule

Choose the Daily Ad Statistics pipeline and define your update frequency, from every five minutes to daily batches, based on your reporting requirements. Activate the pipeline to begin automated replication of your 146 Criteo fields into BigQuery.

Try out all the features for free for 14 days

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Why Kondado?

Focus on extracting value from your data and leave the rest to us

shape-data-to-dashboards icon-data-multiple-destinations

Wherever you need

With the same platform, you send data to reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →
shape-data-to-dashboards icon-data-multiple-destinations

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →
shape-data-to-dashboards icon-data-dollar

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Send data from Criteo to other destinations

Looker Studio

Criteo > Looker Studio
Power BI

Criteo > Power BI
Other visualizations
Other visualizations
Amazon S3

Criteo > Amazon S3
BigQuery

Criteo > BigQuery
Excel

Criteo > Excel
Google Sheets

Criteo > Google Sheets
MySQL

Criteo > MySQL
PostgreSQL

Criteo > PostgreSQL
Redshift

Criteo > Redshift
SQL Server

Criteo > SQL Server

Choose a tool to visualize your Criteo data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Airtable
Criteo > Airtable
Alteryx
Criteo > Alteryx
Amazon Quicksight
Criteo > Amazon Quicksight
BIMachine
Criteo > BIMachine
Cortex
Criteo > Cortex
Data Studio
Criteo > Data Studio
Geckoboard
Criteo > Geckoboard
Grafana
Criteo > Grafana
IBM Cognos Analytics
Criteo > IBM Cognos Analytics
Klipfolio
Criteo > Klipfolio
Looker Studio
Criteo > Looker Studio
Looker
Criteo > Looker
Looqbox
Criteo > Looqbox
Metabase
Criteo > Metabase
Microstrategy
Criteo > Microstrategy
Pentaho
Criteo > Pentaho
Power BI
Criteo > Power BI
Qlik Cloud Analytics
Criteo > Qlik Cloud Analytics
Qlik Sense
Criteo > Qlik Sense
Qlik
Criteo > Qlik
QlikView
Criteo > QlikView
Redash
Criteo > Redash
Superset
Criteo > Superset
Tableau
Criteo > Tableau
BI TOTVS
Criteo > BI TOTVS
Zoho Analytics
Criteo > Zoho Analytics

Frequently Asked Questions (FAQ)

Answers about sending Criteo data to BigQuery automatically

How does Kondado replicate Criteo data to BigQuery? ▼
Kondado connects directly to the Criteo API to extract your advertising performance data and load it into BigQuery on your chosen schedule. The platform handles authentication, data type mapping, and schema management automatically, requiring no manual coding or maintenance from your team. Once configured, the pipeline runs continuously to keep your BigQuery dataset synchronized with your latest Criteo campaign metrics.
What specific Criteo advertising metrics can I analyze in BigQuery? ▼
The Daily Ad Statistics pipeline delivers 146 fields including click-through rates, impression counts, total ad spend, bounce rates, and revenue generated by your retargeting campaigns. You can analyze performance across different ad formats, device types, and time periods to identify which dynamic display ads drive the highest conversion rates. This granular data enables precise ROI calculations and budget allocation decisions directly within your BigQuery environment.
How often does Criteo data update in my BigQuery warehouse? ▼
Kondado updates your Criteo data on a configurable schedule that you control, ranging from every five minutes for near-real-time monitoring to daily batches for trend analysis. You can adjust the frequency based on your reporting needs and BigQuery processing costs, ensuring fresh data without unnecessary API calls. The automated scheduling eliminates the need for manual refreshes while maintaining data freshness for your analytics workflows.
Can I combine Criteo data with other marketing platforms in BigQuery? ▼
Yes, once your Criteo data resides in BigQuery, you can join it with datasets from Criteo and other sources like Google Sheets, PostgreSQL, or additional advertising platforms to create unified marketing dashboards. BigQuery's SQL capabilities allow you to correlate retargeting performance with organic traffic, email campaigns, and offline sales data. This cross-platform analysis reveals holistic attribution patterns that single-platform reporting cannot capture.
What format does Criteo data take when loaded into BigQuery? ▼
Kondado loads Criteo data into BigQuery as structured tables with properly typed columns for dates, currencies, metrics, and dimensions, ready for immediate SQL querying. The schema preserves all 146 fields from the Daily Ad Statistics pipeline in a format optimized for BigQuery's columnar storage and processing engine. Your data arrives clean and query-ready, eliminating the need for additional transformation jobs before analysis.
Do I need technical skills to set up the Criteo to BigQuery pipeline? ▼
No coding is required to configure the Criteo data source or establish your BigQuery destination within Kondado's visual interface. You simply authenticate your Criteo account, provide your BigQuery project details, and select the Daily Ad Statistics pipeline to begin replication immediately. The platform manages API connections, data type conversions, and schema creation automatically, making enterprise data warehousing accessible to marketing analysts without engineering support.
Which Criteo reports are available through the Daily Ad Statistics pipeline? ▼
The Daily Ad Statistics pipeline provides comprehensive campaign performance data equivalent to Criteo's native reporting on clicks, impressions, spend, and revenue across your retargeting initiatives. While individual creative-level reports require custom queries in BigQuery, the pipeline captures all foundational metrics needed to reconstruct any standard Criteo performance analysis. You can build custom reports in Looker Studio, Power BI, or other visualization tools connected to your BigQuery warehouse.
Can I send Criteo data to destinations other than BigQuery? ▼
While this page focuses on BigQuery, Kondado enables you to replicate Criteo data to multiple destinations including PostgreSQL, Google Sheets, Power BI, and Looker Studio simultaneously. You can also send data to MySQL, Excel, Redshift, SQL Server, or Amazon S3 depending on your analytics stack requirements. This flexibility allows marketing teams to maintain Criteo datasets in both their data warehouse and business intelligence tools without separate replication efforts.

Try out all the features for free for 14 days