Pull Criteo Ads data into Microsoft Excel
Criteo credits the sales it drove. Load Criteo Ads into your data warehouse, set its cost next to your own orders, and pull the checked Data Mart into Excel for the retargeting review.
Criteo AdsConnectedPlacement Catego…PlacementsStatisticsTransactions
Microsoft ExcelClicksAdver…Categ…Daily 09:00The retargeting review runs on a Criteo Ads export to Microsoft Excel that counts only the sales Criteo attributes to itself.
Paste this into your AI assistant. It loads Criteo Ads into your data warehouse with OWOX Data Marts, sets its cost next to your own orders, and publishes the checked Data Mart for the Excel add-in.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/criteo-ads-connector-to-microsoft-excel.md. The task: load Criteo Ads cost by campaign into my data warehouse, set it next to the orders we actually booked, and publish it as a Data Mart I pull into Microsoft Excel with the add-in. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
Criteo Ads Endpoints
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 fieldsTime seriesPlacements
Performance metrics broken down by publisher placement.
21 fieldsTime seriesStatistics
Statistics and metrics for Criteo advertising campaigns.
156 fieldsTime seriesTransactions
Transaction-level data with individual order details attributed to Criteo ads.
11 fieldsTime series
Why Criteo Ads does not go straight to Excel
Criteo statistics can be exported to Excel, but not reliably, at scale or business-ready. The file shows displays and the sales Criteo attributes to itself, with no check against the orders you actually booked. That check runs in the data warehouse.
- Criteo reports the orders it claims, and another channel may claim the same one
- The data analyst sets advertiser cost beside your own orders by SQL keys
- The retargeting review opens a workbook built on that comparison
Criteo AdsDisplay ad spendMicrosoft Exc…
Data warehouseJoined by idStep 1: Load Criteo Ads into your data warehouse first
Create a Data Mart with Criteo Ads as the source and choose where the data lands. Any popular warehouse works.
- Four endpoints and 196 fields; Statistics is the widest and feeds the workbook
- Transactions carries transactionId, the key to match Criteo's orders with yours
- Open the Criteo Ads connector for your data warehouse below
Criteo AdsData MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databrickscriteo_ads.statisticsStep 2: Link Criteo Ads to web analytics and deals
In your data warehouse the model adds Criteo Ads cost to the merged spend table beside Facebook Ads and Google Ads, then joins sessions by a campaign key. Pick an industry to see the shape of its model.
- Display spend lands in the same table as every other platform
- Sessions and deals join by SQL keys, so double-claimed orders show up
- platform_cpa is calculated once for all
Criteo AdsStatistics
Facebook AdsAd spend
Google AdsAd spendStep 3: Pull Criteo Ads data into Excel with the add-in
In Excel, add the OWOX Data Marts add-in and sign in. Choose the published Criteo Ads Data Mart (Statistics), tick the columns you want and press Create & Run.
- Pick Day, Campaign and AdvertiserCost, then Displays and Clicks if needed
- Rows come from the data warehouse, not from the Criteo API
Microsoft ExcelYour columns stayDayCampaignAdvertiserCostStep 4: Refresh the Criteo Ads workbook when you need it
Refresh before the next retargeting review. The add-in re-imports its columns and leaves your cost-per-order formulas where you put them.
- Your Cpc check column survives each refresh
- Pull when needed, no refresh job to maintain
Microsoft ExcelYour column staysDayCampaignAdvertise…YoursStep 5: Reuse Criteo Ads inside OWOX MCP
Criteo Ads keeps its Data Mart when you move to OWOX MCP, your assistant for data. Request any report, chat with it, then get the result in Google Sheets or Excel in one click.
- Ask where retargeting cost per acquisition drifts
- The answer and the workbook use one platform_cpa
Google SheetsOpenExcelOpen
- 0.41.0Rotating a connector key is one change: Sources share reusable Credentials
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.37.0Clearer connector errors, and custom connectors that handle more APIs
- 0.37.0Unchecking a column in the OWOX Extension no longer fails Save & Run
- 0.36.0Start a connector run without expanding the Input Source card
Why OWOX for Criteo Ads in Excel
Criteo's own console exports show Criteo's view. OWOX puts that view next to yours before it reaches Excel.
- Criteo's orders next to yours. Transactions and your order table join on transactionId in the data warehouse.
- Four endpoints, tabled. Statistics, transactions and the rest land as separate tables a workbook picks from.
- Your checks stay. Refresh rewrites imported columns, not the audit columns you added.
- Maintained for you. No export script to fix when Criteo changes its reporting API.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.