Connector

Send Criteo Ads data to Google Sheets

Load Criteo Ads into your data warehouse first, link its spend and attributed orders to web analytics and deals with SQL keys, then send the answers to Google Sheets on a schedule. The sheet stays tied to your source of truth, not to a reporting API that can break.

Criteo AdsConnectedPlacement Catego…PlacementsStatisticsTransactions
Data MartPublishedone definition
Google SheetsClicksAdver…Categ…Daily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get Started Free

Hand this to your AI

The Criteo tab in the team's sheet is a pasted copy, and nobody knows whether its orders are your orders.

Paste this into your AI assistant. It loads Criteo Ads into your data warehouse, links spend and attributed orders to your own sales in a Data Mart, and refreshes the sheet on a schedule.

The prompt

send a weekly Google Sheets report of Criteo Ads cost, clicks and CPC by campaign, with how many of Criteo's attributed orders our shop also recorded, refreshed every Monday

Endpoints

S00 · Why

Why Criteo Ads does not go straight to Google Sheets

A direct link gives you a copy of the Criteo reporting in a sheet. It does not show whether the orders Criteo attributes to itself are the same orders your shop and CRM count, because ad cost, website visits and deals live in different systems. A sheet is not built to join them reliably, at scale or business-ready, so the join happens in a data warehouse first.

  • Criteo Ads reports the sales it attributes to itself, not whether another channel claimed the same order
  • The data analyst links Criteo cost, web analytics and CRM deals by SQL keys and controls the result
  • Stakeholders keep the sheet they like, now tied to your source of truth
Criteo AdsDisplay ad spend
Google Sheets
No link to deals
Data warehouseJoined by id
Web analyticsClicks, form fills
CRMDeals

S01 · Step 1

Step 1: Load Criteo Ads into your data warehouse first

Create a Data Mart with Criteo Ads as the data source and choose where the data lands. It works with any popular data warehouse.

  • Four endpoints and 196 fields to choose from, Statistics being the widest
  • Transactions carries transactionId, the key that joins Criteo's attributed orders to yours
  • Open the Criteo Ads connector for your data warehouse below
Criteo AdsData Mart
Your data warehouseGoogle BigQueryAWS AthenaSnowflakeAWS RedshiftDatabricks
criteo_ads.statistics

S03 · Step 3

Step 3: Send Criteo Ads data to Google Sheets

Connect a Google Sheets report to the Data Mart. Aliases and field descriptions arrive as notes in the column headers, so everyone reads the same definitions.

  • The sheet reads your data warehouse, not the Criteo reporting API
  • Hover a header such as AdvertiserCost to see what it measures
Google SheetsNotes in headersDayCampaignAdvertiserCost
CampaignThe campaign name.
AdvertiserCostTotal money spent on Criteoadvertising.

S04 · Step 4

Step 4: Refresh your Criteo Ads sheet on a schedule

Set a scheduled refresh once. Daily is the usual choice and hourly is possible when you need it.

  • Every refresh is logged in Run History
  • Stakeholders open a sheet that is already up to date
ScheduleRefresh on a scheduleHourlyDailyDaily 09:00
Google SheetsUpdated
Run HistoryReport refreshedReport refreshedReport refreshed

S05 · Step 5

Step 5: Reuse Criteo Ads inside OWOX MCP

The same Data Mart works in OWOX MCP, your AI assistant for data. Request any report, chat with your data, then get the report in Google Sheets or Excel in one click.

  • Ask in plain words; the answer comes from your data warehouse
  • Define the numbers once and every report reads them
OWOX MCPCompare platform_cpa across channels by weekplatform_cpa
Google SheetsOpen
ExcelOpen

Recent updates

Why OWOX

Why OWOX for Criteo Ads in Google Sheets

Hand-built API scripts and add-ons that pull straight from a Criteo account get numbers into a sheet. OWOX also keeps the data yours, linked and ready to model.

  • You own the data. It lands in your own data warehouse, in tables you control.
  • Criteo's orders next to yours. Statistics and Transactions land in your data warehouse, so the orders Criteo attributes to itself can be compared with the orders your shop and CRM count.
  • Sheets stay in sync. Notes in the headers, a schedule you set once, no API token to fix in the sheet.
  • Maintained for you. No scripts to fix when Criteo changes its API.

Book a callGet Started Free

Trust

The Data Partner You Can Trust

users

166K Source: Internal OWOX data as of 2026-11-15

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers