Home > Destinations > Power BI > Criteo

Connect Criteo to Power BI

Connect Criteo to Power BI and and make the most of your data with direct integration into Power BI. Discover how to transfer, analyze, and visualize your marketing data to support better, data-driven decisions.

Criteo query · Power BI format
Ready to refresh
Criteo One source
Saved query API URL
Power BI Web · Import
Criteo accounts One or several selected accounts
Reporting grain Date · campaign · ad set · ad
Fields Selected metrics + dimensions
Date range Last 28 days · example preset
Filters Optional · query-specific
Power BI mode Import through Web (Basic)
One saved URL represents one Catchr source. Multiple Criteo accounts can share the query.

Used by the world's leading companies

Get Criteo data into Power BI

A no-code connection that works in Power BI Desktop and in the Power BI service.

Connect your data

Launch Criteo reporting faster

Skip ODBC drivers and custom API scripts. The connection runs from your browser and Power BI, with nothing else to install on your machine.

Automate extraction

Always work with fresh numbers

Once the report is published, Power BI calls your Facebook Ads query again on the schedule you choose, so weekly reviews start from current figures.

More than just one source

One query per source, one model for all your ads

Create a separate Catchr query for Google Ads, TikTok Ads, or GA4, load each table, and relate them in the same Power BI model.

Start with a template

Ready-to-use Power BI dashboards

Move faster with templates built for Advertising reporting in Power BI.

Use your Criteo data with ready-to-use dashboards for tracking performance, trends, and key indicators.

Criteo metrics and dimensions available in Power BI

Access 112 metrics and 73 dimensions from Criteo connectors including Cost, Clicks, Display, Click Through Rate, Conversion Rate PC 30d, ROAS PC 30d, Campaign Name, AdSet Name, Advertiser Name, Date, Device, Channel Name and more.

112

Available metrics

73

Available dimensions

How to connect Criteo to Power BI ?

Four steps, from Catchr to a refreshed Power BI report.

Step one

Authorize Criteo

Connect Criteo in Catchr with a Criteo user that has access to the Advertising accounts you need, and make those accounts available for reporting.

Client A · Connected sources
5 sources ready
Criteo 3 advertising accounts Connected
Google Ads 2 advertising accounts Connected
Google Analytics 4 1 web property Connected
HubSpot 1 CRM portal Connected
Step two

Build and preview the query

Choose Power BI format, select Criteo, accounts, fields, date range, filters, and supported options. Preview the response, save the query, and copy its URL.

Step three

Use Get data > Web

In Power BI Desktop, choose Get data > Web, keep Basic selected, paste the complete Catchr URL, confirm, then load or transform the response.

Step four

Shape, model, and refresh

Clean the table in Power Query, add relationships and DAX measures, then publish the report and set its refresh schedule in the Power BI service.

YOUR NEXT REPORT

What you can build with Facebook Ads data in Power BI

Marketing performanceIllustrative data
Purchase value$38,400
Spend$12,000
ROAS3.20×
Purchase value & spend4 weeks
Week 1
Week 2
Week 3
Week 4
● Purchase value● Spend

ROAS and CPA as DAX measures

Define ROAS as purchase value divided by spend, and CPA as spend divided by purchases, once in the model, so every visual and filter uses the same calculation.

Criteo to Power BI pricing

Choose your plan by the number of platforms and accounts you report on.

Starter

For freelancers and small teams.

$ 24 /mo

Billed monthly · cancel anytime

Platforms3
Accounts10
Start free trial

Growth

For agencies managing more clients.

$ 239 /mo

Billed monthly · cancel anytime

Platforms10
Accounts100
Start free trial

Scale

For teams reporting at scale.

$ 599 /mo

Billed monthly · cancel anytime

Platforms25
Accounts500
Start free trial

More Power BI connectors

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Criteo to Power BI: FAQ

Answers to common questions about connecting data to spreadsheets, dashboards, AI assistants, and reporting tools with Catchr.

How do I connect Criteo to Power BI?

Connect Criteo in Catchr with the API Client ID and Client Secret of an application authorized for the advertiser. In Catchr’s Power BI query builder, select Cost, Clicks and Display and preview a short extraction. Import the generated URL through Get data > Web in Power BI Desktop. Check the returned rows before building measures, keeping advertiser and the exact attribution metric selected clear in the model.

Does Criteo already offer a Power BI connector?

Yes. Criteo provides its own Criteo Marketing Data connector for Marketing Solutions clients. Catchr is another option when you want to manage Criteo alongside other marketing sources. Compare the available fields and setup with your needs. Marketing Solutions reporting and Retail Media reporting are separate products, so do not assume every Criteo connector covers both.

Which Criteo metrics can I report on with Catchr?

The catalog includes Cost, Clicks, Display, Visits, Qualified Visits, CPC, viewable display measures and several ROAS and cost-per-order fields. Campaign and ad set identifiers help organize performance, while Device and OS support compatible breakdowns. Choose metrics that match the campaign type and tracking available in your account; a field in the catalog does not guarantee a populated value for every advertiser.

Why are there several ROAS and cost-per-order fields?

Criteo exposes separate metric variants for different attribution scopes. Catchr field names distinguish options such as PC 1d, PC 7d, PC 30d, PV 24h and Client Attribution. Select the same variant across the measures in a chart and match it to the Criteo report you are comparing. Do not add overlapping attribution variants together or compare two ROAS fields as if they used the same rules.

Which currency does the Catchr Criteo report use?

The current Catchr reporting request asks Criteo for USD. If your Criteo interface shows another currency, cost and other monetary figures can differ even when the campaign and dates match. Label the dashboard currency clearly and compare against a report in the same currency. Do not combine these values with other accounts or channels in different currencies without a consistent conversion method.

Why does Criteo ROAS differ from GA4 or my store?

Criteo reports outcomes attributed to its advertising, while GA4 and your store use their own measurement and reporting rules. Match the date range, currency and outcome definition, then check the selected Criteo attribution variant. Recent conversions can also change previously viewed results. Use store totals for overall sales and clearly label platform-attributed performance rather than expecting both reports to be identical.

Can I compare Criteo with Google Ads and Facebook Ads?

Yes. Add Google Ads and Facebook Ads to the same Power BI report. Align currencies and dates before comparing costs, and use clearly labelled attribution metrics for outcomes. The same purchase may be credited by several platforms, so the sum of platform-attributed sales is not a deduplicated total.

Still have a question?

Our team is always here to answer any questions you may have about our data connector.

Your next report should not start with five exports

Connect your marketing platforms and build a data workflow your entire agency can use.

14 days free-trial
No credit-card required
100+ sources