Supermetrics for Power BI
Connect RTB House to Power BI — Retargeting Intelligence Dashboards
Track RTB House retargeting campaigns in Power BI with creative fatigue monitoring, user segment efficiency analysis, and post-view conversion attribution. DAX measures calculate incremental ROAS, creative rotation indicators, and segment-level cost per conversion.
Why Connect RTB House to Power BI?
Build live RTB House dashboards in Power BI that update automatically and share with your team.
- Evaluate user segment performance — compare site visitors, cart abandoners, and past purchasers by conversion rate and ROAS. DAX measures calculate which segments deliver incremental revenue vs. cannibalizing organic conversions.
- Monitor CTR and conversion rate trends per creative. Conditional formatting flags creatives where declining performance indicates audience fatigue, triggering creative refresh.
- Analyze the mix of post-click and post-view conversions by subcampaign. DAX measures calculate the view-through attribution share, helping evaluate the true influence of display retargeting.
How to Connect RTB House 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 RTB House in Power BI
Pre-built dashboards to get you started. Customize layouts, filters, and visualizations to match your reporting needs.
Retargeting Segment Performance
User segment comparison by ROAS and conversion rate with post-view vs. post-click attribution breakdown. Subcampaign drill-through for creative-level analysis.
Creative Health & Fatigue Monitor
Creative-level CTR trend lines with fatigue indicators, size and type performance matrix, and viewability analysis by device.
Reporting Scenarios for RTB House in Power BI
Common reporting use cases that teams build with RTB House data in Power BI.
Bar chart
User Segment ROAS Comparison
Bar chart comparing ROAS across retargeting segments — homepage visitors, product viewers, cart abandoners, past buyers — with cost overlay showing investment in each.
Line chart
Creative CTR Decay Trend
Multi-line chart tracking CTR over time for each creative, with a reference line at launch-week average. Creatives falling below 70% of launch CTR need refreshing.
What RTB House Data Can You Pull into Power BI?
Supermetrics gives Power BI access to your full RTB House reporting data — metrics and dimensions you already know from the RTB House interface.
Key Metrics
- Impressions
- Clicks
- Cost
- Conversions value
- Post-view conversions
- CTR
- eCPM
- eCPC
- ROAS
- Viewability
Key Dimensions
- Subcampaign name
- Creative name
- Creative type
- Creative size
- Category name
- Device type
- Country
- User segment
Resources & Guides
14 Power BI marketing dashboard examples
Power BI for marketing: setup guide
Data transformation in Power BI
PPC reporting: extract insights from paid campaigns
Browse all Power BI templates
Feld Entertainment: enterprise dashboards
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 RTB House 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 RTB House. 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 RTB House 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
- Install the Supermetrics connector from the Power BI Desktop "Get Data" menu, sign in with your Supermetrics account, and authorize RTB House. 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.
- Yes. Publish your report to the Power BI Service and configure a scheduled refresh through your dataset settings. Supermetrics refreshes your RTB House data on the schedule you set — hourly, daily, or whatever cadence fits your reporting rhythm. Your dashboards stay current without manual intervention.
- Absolutely. Power BI's data model is built for blending. Use Supermetrics to pull RTB House 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.
- All standard RTB House reporting fields are available, including Impressions, Clicks, Cost, Conversions value, Post-view conversions, and more. You get the same data as the RTB House native reporting UI, loaded into Power BI where you can create DAX measures, build relationships, and apply row-level security.
- 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.
- Compare ROAS across retargeting segments and use DAX measures to calculate the proportion of conversions that are likely incremental vs. those that would have happened organically.
- Yes. Plot CTR trends per creative over time. Create a DAX measure calculating the percentage decline from peak CTR. Conditional formatting flags creatives with more than 30% decline.
Also Connect to Power BI
Ready to Connect RTB House to Power BI?
Join 200,000+ companies that use Supermetrics to connect their marketing data. Set up in under two minutes.