Supermetrics for Power BI
Connect AdRoll to Power BI — Growth Marketing Dashboards
Analyze AdRoll retargeting and prospecting campaigns in Power BI with audience segment comparison, view-through attribution analysis, and creative performance tracking. DAX measures calculate incremental ROAS, audience saturation indicators, and cross-device conversion paths.
Why Connect AdRoll to Power BI?
Build live AdRoll dashboards in Power BI that update automatically and share with your team.
- Compare retargeting and prospecting campaign performance side by side. DAX measures calculate CPA and ROAS for each campaign type, showing where your budget is most efficiently spent.
- Analyze the split between click-through and view-through conversions. DAX measures calculate the share of each attribution type by campaign, helping evaluate the true impact of display impressions.
- Track frequency and CTR trends per audience segment to detect saturation. Conditional formatting flags segments where declining performance indicates the need for audience expansion or creative refresh.
How to Connect AdRoll 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 AdRoll in Power BI
Pre-built dashboards to get you started. Customize layouts, filters, and visualizations to match your reporting needs.
AdRoll Retargeting & Prospecting Hub
Campaign type comparison by ROAS and CPA with audience segment performance matrix. View-through vs. click-through conversion attribution breakdown.
Audience Health & Creative Report
Audience saturation indicators with CTR trending per segment. Creative performance matrix with format and size comparison.
Reporting Scenarios for AdRoll in Power BI
Common reporting use cases that teams build with AdRoll data in Power BI.
Clustered bar chart
Retargeting vs. Prospecting ROAS
Clustered bar chart comparing ROAS for retargeting and prospecting campaigns by month, revealing seasonal patterns in audience responsiveness.
Line chart
Audience Segment Saturation Tracker
Line chart showing CTR trends per audience segment over time with a reference line at 70% of peak CTR, flagging segments approaching fatigue.
What AdRoll Data Can You Pull into Power BI?
Supermetrics gives Power BI access to your full AdRoll reporting data — metrics and dimensions you already know from the AdRoll interface.
Key Metrics
- Impressions
- Clicks
- Cost
- CTR
- CPC
- CPM
- Conversions
- Conversion rate
- Click-through conversions
- View-through conversions
- Revenue
- CPA
- ROI
Key Dimensions
- Advertiser
- Campaign
- Campaign type
- Adgroup
- Ad
- Ad type
- Device
- Country
- Placement
- Audience
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 AdRoll 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 AdRoll. 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 AdRoll 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 AdRoll. 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 AdRoll 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 AdRoll 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 AdRoll reporting fields are available, including Impressions, Clicks, Cost, CTR, CPC, and more. You get the same data as the AdRoll 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.
- Filter AdRoll data by campaign type dimension. Create DAX measures for ROAS and CPA in each segment. Clustered bar charts make it easy to compare acquisition costs for retargeting vs. prospecting audiences.
- Yes. Track CTR and conversion rate trends per audience segment over time. DAX measures flag when CTR drops below a threshold percentage of its peak, indicating the audience is saturated and needs refreshing.
Also Connect to Power BI
Ready to Connect AdRoll to Power BI?
Join 200,000+ companies that use Supermetrics to connect their marketing data. Set up in under two minutes.