Supermetrics for Power BI
Connect Criteo to Power BI — Commerce Media Dashboards
Analyze Criteo commerce media campaigns in Power BI with product-level ROAS analysis, bidding strategy comparison, and category performance tracking. DAX measures calculate cost of sale trends, average cart value by campaign, and incremental revenue contribution from retargeting.
Why Connect Criteo to Power BI?
Build live Criteo dashboards in Power BI that update automatically and share with your team.
Product-level ROAS analysis
Track ROAS at the product category level in Power BI. DAX measures calculate cost of sale by category, average cart value, and identify which product segments generate the highest return from Criteo retargeting.
Bidding strategy comparison
Compare performance across different Criteo bidding strategies. DAX measures calculate CPA and revenue efficiency per strategy, helping optimize your bid approach for maximum ROAS.
Commerce media attribution
Join Criteo retargeting data with first-party sales data in Power BI. Calculate incremental revenue contribution by comparing Criteo-attributed conversions against organic purchase patterns.
How to Connect Criteo to Power BI
Three steps. Under two minutes. Zero code.
- 1
Open Power BI Desktop and Get Data
Launch Power BI Desktop, click "Get Data," and search for the Supermetrics connector to install it.
- 2
Authorize your data source
Sign in with your Supermetrics account and authorize your data source. Your credentials are encrypted and securely stored.
- 3
Build Your Dashboard
Select your metrics and dimensions, load the data into your model, and start building visuals, DAX measures, and interactive reports.
Dashboard Templates for Criteo in Power BI
Pre-built dashboards to get you started. Customize layouts, filters, and visualizations to match your reporting needs.
Criteo ROAS & Commerce Dashboard
ROAS trending with cost of sale analysis by product category. Campaign performance matrix with bidding strategy comparison and average cart value tracking.
Retargeting Attribution Report
Click-through vs. view-through conversion analysis with category-level revenue breakdown. Incremental revenue estimation and bidding strategy optimization.
Reporting Scenarios for Criteo in Power BI
Common reporting use cases that teams build with Criteo data in Power BI.
Category ROAS vs. Cost of Sale
Scatter chart plotting ROAS against cost of sale per product category, identifying categories where retargeting delivers the best and worst returns.
Bidding Strategy Performance Comparison
Clustered bar chart comparing CPA and average cart value across Criteo bidding strategies, guiding bid optimization decisions.
What Criteo Data Can You Pull into Power BI?
Supermetrics gives Power BI access to your full Criteo reporting data — metrics and dimensions you already know from the Criteo interface.
Key Metrics
- Impressions
- Clicks
- CTR
- Cost
- Revenue
- ROAS
- Sales
- Cost of sale
- CPC (revenue)
- Conversion rate
- Average cart
- eCPM
Key Dimensions
- Campaign name
- Ad set name
- Ad set status
- Ad set bid strategy
- Advertiser name
- Devices
- Operating system
- Targeting countries
- Category name
- Budget strategy
Resources & Guides
Why Supermetrics for Power BI?
The trusted marketing data platform since 2009. 200,000+ companies use Supermetrics — 15% of global ad spend flows through our connectors.
Built for Power BI
Purpose-built Power BI connector with setup in minutes. Your marketing team can build dashboards independently — no data engineering resources required.
170+ Data Sources
Connect Criteo alongside 170+ other platforms through a single integration. All your marketing data in one place.
Template Gallery
Start with pre-built Power BI dashboard templates for Criteo. Connect your account and have a polished, interactive report in minutes.
Enterprise Security
SOC 2 Type II certified. GDPR compliant. OAuth authentication. Your data is encrypted at rest and in transit.
Always Current
Your Criteo data refreshes automatically in Power BI. No manual exports, no stale numbers — open your report and the data is current.
No Data Limits
Query any date range, any number of campaigns, any level of granularity. No row limits, no sampling, no restrictions on the data you can pull.
Frequently Asked Questions
How do I connect Criteo to Power BI with Supermetrics?
Install the Supermetrics connector from the Power BI Desktop "Get Data" menu, sign in with your Supermetrics account, and authorize Criteo. Your data appears as a Power Query table — from there you load it into your model, build relationships, and start creating visuals. No custom connector development needed.
Can I schedule automatic data refreshes for Criteo in Power BI?
Yes. Publish your report to the Power BI Service and configure a scheduled refresh through your dataset settings. Supermetrics refreshes your Criteo data on the schedule you set — hourly, daily, or whatever cadence fits your reporting rhythm. Your dashboards stay current without manual intervention.
Can I combine Criteo data with other sources inside Power BI?
Absolutely. Power BI's data model is built for blending. Use Supermetrics to pull Criteo alongside data from 170+ other marketing platforms — Google Ads, LinkedIn Ads, GA4, and more — then join them through shared dimensions like date, campaign name, or UTM parameters in Power Query or the data model.
What Criteo metrics and dimensions can I access in Power BI?
All standard Criteo reporting fields are available, including Impressions, Clicks, CTR, Cost, Revenue, and more. You get the same data as the Criteo native reporting UI, loaded into Power BI where you can create DAX measures, build relationships, and apply row-level security.
Do I need technical skills to use Criteo data in Power BI?
Basic Power BI Desktop knowledge is enough. Supermetrics handles the API connection, authentication, and data formatting. You pick your metrics, choose a date range, and load — the data arrives as clean tables ready for modeling. No API code, no ETL scripting.
How do I calculate cost of sale from Criteo in Power BI?
Pull cost and revenue metrics via Supermetrics. Create: CostOfSale = DIVIDE(SUM(Cost), SUM(Revenue)). Trend this over time and slice by campaign, category, and ad set to identify where your retargeting spend is most efficient.
Can I compare Criteo bidding strategies in Power BI?
Yes. Pull the bid strategy dimension with performance metrics. Build comparison visuals showing CPA, ROAS, and average cart value per strategy. DAX measures highlight which approach delivers the best results for each campaign type.
Also Connect to Power BI
Ready to Connect Criteo to Power BI?
Join 200,000+ companies that use Supermetrics to connect their marketing data. Set up in under two minutes.