Connector

Collect Criteo Ads data in Snowflake

Load Criteo statistics, placements and attributed transactions into Snowflake with OWOX Data Marts: a table per endpoint, a readable schema, a refresh on your schedule. Check the sales Criteo claims against your own orders.

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

Get Started Free

Hand this to your AI

Criteo's sales figures never get tested in Snowflake, because the retargeting data stays in the ad account.

Paste this into your AI assistant. It sets up a Criteo Ads Data Mart on your Snowflake storage, loading statistics and attributed transactions into tables on your schedule, ready to join with your orders.

The prompt

load Criteo Ads statistics and attributed transactions into Snowflake every day and give me a query that compares the revenue Criteo claims with our own order revenue, by week and campaign

Endpoints

S00 · Why

Why Criteo Ads belongs next to your orders in Snowflake

Criteo reports sales and revenue it credits to itself, inside post-click and post-view windows. Those are Criteo's claims. With your own orders and website touch points as tables in the same data warehouse, a query can test them against what the spend returned.

  • Compare Criteo's reported sales with the orders in your tables
  • Match each attributed transaction to your orders by transactionId
  • Put Criteo cost beside Google and Facebook spend
Criteo AdsRetargeting spend
Web analyticsVisits, checkouts
OrdersYour own sales
Your data warehouseSnowflakeAdVisitOrderJoined by idAd displayed or clickedOrder laterA SQL join sets Criteo's sale beside yours.

S01 · Step 1

Step 1: Connect Criteo Ads and choose the fields

Create a Data Mart on Snowflake and pick Criteo Ads as the data source. Enter the Advertiser ID, Client ID and Client Secret, then tick the fields.

  • 4 endpoints and 196 fields are available
  • Statistics has 156 fields: cost, displays, clicks, and sales and revenue per attribution window
New Data MartChoose a sourceGoogle AdsCriteo AdsFacebook AdsAuthorizeConnectedEndpointStatisticsPlacement Categor…PlacementsTransactions
Statistics156 fieldsDayAdvertiserCostDisplaysClicksSalesPc30dRevenueGeneratedPc30d

S02 · Step 2

Step 2: Load Criteo Ads into a Snowflake table

Pick the Snowflake database, schema and table, pre-filled and editable. Run it and statistics land in your own account.

  • Statistics get their own table
  • Rows split by advertiser, campaign, adset, ad and day
DestinationSnowflakeDatabaseSchemacriteo_adsTablestatisticsRun
Run HistoryPendingRunningSuccessIncremental load
Tablecriteo_ads.statistics

S03 · Step 3

Step 3: Read the output schema in plain words

Every column in the output schema carries a description in ordinary language. Your data quality checks can read it too.

  • Placements fields name their window, such as 30-day post-click or 1-day post-view
  • A colleague can read it without the API docs
criteo_ads.statisticsOutput schemaFieldDescriptionDayThe day of the statistics data…AdvertiserCostTotal money spent on Criteo…DisplaysThe number of ad impressions…ClicksThe number of clicks driven by…SalesPc30dThe number of transactions or…RevenueGeneratedPc30dThe amount of money generated…

S04 · Step 4

Step 4: Join the Criteo Ads tables in SQL

Statistics, placements and transactions are separate Snowflake tables that share advertiser and adset ids, so you can summarise each by advertiser, adset and day inside one Criteo Ads data model.

  • Transactions hold transactionId and amount, ready to match your orders
  • Transactions load only for periods that have attributed conversions
StatisticsAdvertiserIdAdsetIdAdvertiserCost
PlacementsadsetIdplacementcost
TransactionsadvertiserIdtransactionIdamount

S05 · Step 5

Step 5: Schedule the load and backfill history

Set the cadence once and a scheduled refresh reloads the tables in Snowflake. Manual runs load past periods.

  • Each incremental run reloads today plus a lookback you set
  • Backfill a custom date range
ScheduleRun on a scheduleDaily 09:00
BackfillRun backfill
Run HistoryDaily scheduleManual backfillDaily schedule

S06 · Step 6

Step 6: Use the same Snowflake tables in every report

Spreadsheets, dashboards, AI assistants such as Claude and ChatGPT, AI insights and your data model read the same tables.

  • Settle Criteo's sales against your orders in one place
  • The same numbers in every report
Criteo AdsData MartPublished
Your data model
Google Sheets
Data Studio dashboards
Claude, ChatGPT
Slack, email

Recent updates

Why OWOX

Why OWOX for Criteo Ads in Snowflake

API scripts and manual exports get Criteo numbers out. OWOX stores them as Snowflake tables you own, so they can sit beside your orders.

  • Yours in Snowflake. The tables live in your account under your roles.
  • Criteo's sales beside yours. Attributed transactions load as a table you can match to your orders, with the click or display behind each.
  • Ready to model. Transactions match your orders by transactionId; statistics and placements summarise by advertiser and adset.
  • Looked after for you. When Criteo changes its API, no script of yours needs fixing.
  • Free when self-hosted. The open-source OWOX Data Marts runs on your own infrastructure at no licence cost.

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