--- title: "Criteo Ads to Databricks Connector | OWOX" canonical: "https://www.owox.com/connectors/free-criteo-ads-connector-to-databricks" updated: "2026-10-29" --- # Send Criteo Ads data to Databricks Move Criteo statistics, placements and attributed transactions into Databricks with OWOX Data Marts: one table per endpoint, a readable schema, a scheduled refresh. Check the sales Criteo credits to itself against your own orders. ![](https://cdn.owox.com/www/portfolio-management-connectors/criteo-ads-insights-to-email/icon/1.svg/public)Criteo Ads · Connected · Placement Catego… · Placements · Statistics · Transactions Data Mart · Published · one definition ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Databricks · Clicks · Adver… · Categ…Daily 09:00 Refreshed on a schedule. No exports, no copy-paste. [Get Started Free](https://www.owox.com/app-signup) ## Endpoints ## Criteo Ads Endpoints [Documentation](https://docs.owox.com/packages/connectors/src/sources/criteo-ads/readme/) 4 Criteo Ads endpoints you can import. Each lands in its own table in your data warehouse. * [Placement Categories Performance metrics broken down by content category. 8 fields · Time series](/data-sources/criteo#schema-placement-categories) * [Placements Performance metrics broken down by publisher placement. 21 fields · Time series](/data-sources/criteo#schema-placements) * [Statistics Statistics and metrics for Criteo advertising campaigns. 156 fields · Time series](/data-sources/criteo#schema-statistics) * [Transactions Transaction-level data with individual order details attributed to Criteo ads. 11 fields · Time series](/data-sources/criteo#schema-transactions) ## S00 · Why ## Why join Criteo Ads with your orders and web analytics in Databricks Criteo reports the sales and revenue it credits to itself, counted inside post-click and post-view windows. Those are Criteo's claims. Load your own orders and website touch points into the same [data warehouse](/data-storages) and you can check them against what the spend returned. * Compare the sales Criteo reports with your own orders * Match each attributed transaction to your order by its id * Put Criteo cost beside Google and Facebook spend ![](https://cdn.owox.com/www/portfolio-management-connectors/criteo-ads-insights-to-email/icon/1.svg/public)Criteo Ads · Retargeting spend Web analytics · Visits, checkouts Orders · Your own sales ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Your data warehouse · Databricks · Ad · Touch point · OrderJoined by id · Ad displayed or clicked · Order laterOne query sets Criteo's sale beside yours. ## S01 · Step 1 ## Step 1: Connect Criteo Ads and choose what to load Create a Data Mart, choose Criteo Ads as the [data source](/data-sources), enter your Advertiser ID, Client ID and Client Secret, and tick only the fields you need. * 4 endpoints and 196 fields to choose from * Statistics alone has 156 fields: cost, displays, clicks, sales and revenue by attribution window New Data Mart · Choose a source · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2024%2024%22%3E%3Cpath%20fill%3D%22%230866FF%22%20d%3D%22M24%2012.073c0-6.627-5.373-12-12-12s-12%205.373-12%2012c0%205.99%204.388%2010.954%2010.125%2011.854v-8.385H7.078v-3.47h3.047V9.43c0-3.007%201.792-4.669%204.533-4.669%201.312%200%202.686.235%202.686.235v2.953H15.83c-1.491%200-1.956.925-1.956%201.874v2.25h3.328l-.532%203.47h-2.796v8.385C19.612%2023.027%2024%2018.062%2024%2012.073z%22%2F%3E%3C%2Fsvg%3E%0A)Facebook Ads · ![](https://cdn.owox.com/www/portfolio-management-connectors/criteo-ads-insights-to-email/icon/1.svg/public)Criteo Ads · ![](data:image/svg+xml;utf8,%3Csvg%20viewBox%3D%220%200%20835%20835%22%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%3E%3Cpath%20fill%3D%22%23FEB908%22%20d%3D%22M433%20433h367v367H433z%22%2F%3E%3Cpath%20fill%3D%22%2304A5EF%22%20d%3D%22M35%20433h367v367H35z%22%2F%3E%3Cpath%20fill%3D%22%2380BB05%22%20d%3D%22M433%2035h367v367H433z%22%2F%3E%3Cpath%20fill%3D%22%23F25224%22%20d%3D%22M35%2035h367v367H35z%22%2F%3E%3C%2Fsvg%3E)Microsoft Ads · AuthorizeConnected · Endpoint · Statistics · Placement Categor… · Placements · Transactions ![](https://cdn.owox.com/www/portfolio-management-connectors/criteo-ads-insights-to-email/icon/1.svg/public)Statistics · 156 fields · DayAdvertiserCostDisplaysClicksSalesPc30dRevenueGeneratedPc30d ## S02 · Step 2 ## Step 2: Load Criteo Ads into Databricks tables The catalog defaults to main, and the schema and table are pre-filled; change any of them. Run it and the first load lands in your own Databricks workspace. * Statistics go to a table such as criteo\_ads\_statistics * Rows break down by advertiser, campaign, adset, ad and day ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Destination · Databricks · Catalog · main · Schema · criteo\_ads · Table · statistics · Run Run History · Pending · Running · SuccessIncremental load ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Table · main.criteo\_ads.statistics ## S03 · Step 3 ## Step 3: Open the output schema in plain words The first run gives you the output schema: every field with an alias and a readable description, not an API identifier. Your [data quality](/product/data-quality) checks can read it too. * Placements fields state their window, such as 30-day post-click or 1-day post-view * Teammates can query the table without the API reference ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)main.criteo\_ads.statistics · Output schema · Field · DescriptionDay · The day of the statistics data… · AdvertiserCost · Total money spent on Criteo… · Displays · The number of ad impressions… · Clicks · The number of clicks driven by… · SalesPc30d · The number of transactions or… · RevenueGeneratedPc30d · The amount of money generated… ## S04 · Step 4 ## Step 4: Keep the Criteo Ads tables linked Statistics, placements and transactions stay separate tables, joined by advertiser and adset ids. In SQL they become one Criteo Ads [data model](/product/data-modeling). * Transactions carry transactionId and amount, ready to match to your own orders * Transactions load only for periods with attributed conversions ![](https://cdn.owox.com/www/portfolio-management-connectors/criteo-ads-insights-to-email/icon/1.svg/public)Statistics · AdvertiserId · AdsetId · AdvertiserCost ![](https://cdn.owox.com/www/portfolio-management-connectors/criteo-ads-insights-to-email/icon/1.svg/public)Placements · adsetId · placement · cost ![](https://cdn.owox.com/www/portfolio-management-connectors/criteo-ads-insights-to-email/icon/1.svg/public)Transactions · advertiserId · transactionId · amount ## S05 · Step 5 ## Step 5: Refresh on a schedule and backfill the history Set it once. A scheduled refresh keeps the Databricks tables current, and a manual run loads a past period of your choice. * Each incremental run reloads today plus a lookback window you set * Backfill a custom start and end date Schedule · Run on a schedule · Daily 09:00 Backfill · Run backfill Run History · Daily schedule · Manual backfill · Daily schedule ## S06 · Step 6 ## Step 6: Reuse the Databricks tables in every tool One set of tables feeds your [data model](/product/data-modeling), [spreadsheets](/product/spreadsheets), [dashboards](/product/dashboards), [AI assistants](/product/ai-assistants) like Claude and ChatGPT and AI insights in Slack or email. * Reconcile Criteo's sales with your orders once * Every report reads the same table ![](https://cdn.owox.com/www/portfolio-management-connectors/criteo-ads-insights-to-email/icon/1.svg/public)Criteo Ads · Data Mart · Published Your data model ![](https://cdn.owox.com/www/portfolio-management-data-destination/google-sheets/logo/1.svg/public)Google Sheets ![](https://cdn.owox.com/www/portfolio-management-data-destination/data-studio/logo/1.svg/public)Data Studio dashboards ![](https://cdn.owox.com/www/portfolio-management-data-destination/claude/logo/2.svg/public)Claude, ChatGPT ![](https://cdn.owox.com/www/portfolio-management-data-destination/slack/logo/2.svg/public)Slack, email ## Related connectors [Criteo Ads to Claude](/connectors/criteo-ads-connector-to-claude)[Facebook Ads to Databricks](/connectors/free-facebook-ads-connector-to-databricks)[Google Ads to Databricks](/connectors/free-google-ads-connector-to-databricks)[Criteo Ads to ChatGPT](/connectors/criteo-ads-connector-to-chatgpt)[Microsoft Ads to Databricks](/connectors/free-microsoft-ads-connector-to-databricks)[TikTok Ads to Databricks](/connectors/free-tiktok-ads-connector-to-databricks)[Bank of Canada to Databricks](/connectors/bank-of-canada-connector-to-databricks)[LinkedIn Ads to Databricks](/connectors/free-linkedin-ads-connector-to-databricks)[LinkedIn Pages to Databricks](/connectors/free-linkedin-pages-connector-to-databricks) · Show 6 more · Show fewer ## Recent updates * [0.40.0 · Connecting a plan from Google Sheets takes fewer guesses](https://docs.owox.com/docs/changelog/#connecting-a-plan-from-google-sheets-takes-fewer-guesses-0400) * [0.39.0 · Reload a year of history in one backfill, not twelve](https://docs.owox.com/docs/changelog/#reload-a-year-of-history-in-one-backfill-not-twelve-0390) * [0.39.0 · Long Facebook Ads imports no longer fail on a corrupted response](https://docs.owox.com/docs/changelog/#long-facebook-ads-imports-no-longer-fail-on-a-corrupted-response-0390) * [0.38.0 · Shopify connector: more orders fields, including line-item discounts](https://docs.owox.com/docs/changelog/#shopify-connector-more-orders-fields-including-line-item-discounts-0380) * [0.37.0 · Short links resolve only on known short link services and domains you allow](https://docs.owox.com/docs/changelog/#short-links-resolve-only-on-known-short-link-services-and-domains-you-allow-0370) ## Why OWOX ## Why OWOX for Criteo Ads in Databricks Notebooks over the Criteo API and generic ETL tools get statistics in. OWOX also keeps them in your tables, readable and ready to model. * **You own the data.** It lands in your own Databricks workspace, in tables you control. * **Criteo's sales beside yours.** Attributed transactions, with the click or display behind each, load as a table you match to your orders. * **Windows spelled out.** Placement fields state their window, such as 30-day post-click or 1-day post-view. * **Joined by advertiser and adset ids.** The tables arrive ready to meet web analytics and your order data. * **Maintained for you.** No jobs to repair when Criteo changes its API. * **Free to self-host.** The open-source OWOX Data Marts runs in your own infrastructure. [Book a call](/book-a-call) [Get Started Free](https://www.owox.com/app-signup) ## Book a call You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Schedule a meeting ## Schedule in person meeting at Data Outpost San Francisco You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Links Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Get Started Free](https://www.owox.com/app-signup) - [Documentation](https://docs.owox.com/packages/connectors/src/sources/criteo-ads/readme) - [Placement CategoriesPerformance metrics broken down by content category.8 fields · Time series](https://www.owox.com/data-sources/criteo) — /data-sources/criteo.md - [data warehouse](https://www.owox.com/data-storages) — /data-storages.md - [data source](https://www.owox.com/data-sources) — /data-sources.md - [data quality](https://www.owox.com/product/data-quality) — /product/data-quality.md - [data model](https://www.owox.com/product/data-modeling) — /product/data-modeling.md - [spreadsheets](https://www.owox.com/product/spreadsheets) — /product/spreadsheets.md - [dashboards](https://www.owox.com/product/dashboards) — /product/dashboards.md - [AI assistants](https://www.owox.com/product/ai-assistants) — /product/ai-assistants.md - [Criteo Ads to Claude](https://www.owox.com/connectors/criteo-ads-connector-to-claude) — /connectors/criteo-ads-connector-to-claude.md - [Facebook Ads to Databricks](https://www.owox.com/connectors/free-facebook-ads-connector-to-databricks) — /connectors/free-facebook-ads-connector-to-databricks.md - [Google Ads to Databricks](https://www.owox.com/connectors/free-google-ads-connector-to-databricks) — /connectors/free-google-ads-connector-to-databricks.md - [Criteo Ads to ChatGPT](https://www.owox.com/connectors/criteo-ads-connector-to-chatgpt) — /connectors/criteo-ads-connector-to-chatgpt.md - [Microsoft Ads to Databricks](https://www.owox.com/connectors/free-microsoft-ads-connector-to-databricks) — /connectors/free-microsoft-ads-connector-to-databricks.md - [TikTok Ads to Databricks](https://www.owox.com/connectors/free-tiktok-ads-connector-to-databricks) — /connectors/free-tiktok-ads-connector-to-databricks.md - [Bank of Canada to Databricks](https://www.owox.com/connectors/bank-of-canada-connector-to-databricks) — /connectors/bank-of-canada-connector-to-databricks.md - [LinkedIn Ads to Databricks](https://www.owox.com/connectors/free-linkedin-ads-connector-to-databricks) — /connectors/free-linkedin-ads-connector-to-databricks.md - [LinkedIn Pages to Databricks](https://www.owox.com/connectors/free-linkedin-pages-connector-to-databricks) — /connectors/free-linkedin-pages-connector-to-databricks.md - [0.40.0 · Connecting a plan from Google Sheets takes fewer guesses](https://docs.owox.com/docs/changelog) - [Book a call](https://www.owox.com/book-a-call) — /book-a-call.md