Supermetrics for Power BI
Connect Display & Video 360 to Power BI — Programmatic Intelligence Dashboards
Analyze DV360 programmatic campaigns in Power BI with insertion order pacing, viewability analysis, and exchange-level cost optimization. DAX measures calculate viewability-adjusted CPM, effective frequency curves, and CTV vs. display performance splits. Share programmatic intelligence via Power BI Service.
Why Connect Display & Video 360 to Power BI?
Build live DV360 dashboards in Power BI that update automatically and share with your team.
Viewability-adjusted CPM analysis
Calculate true media cost on viewable impressions only using DAX. Compare vCPM across exchanges, inventory sources, and environments (web, app, CTV) to optimize supply path decisions.
Insertion order pacing and delivery
Monitor IO-level spend pacing against flight dates. Conditional formatting flags under-delivering or over-spending line items so traders can adjust bids before budget issues arise.
CTV vs. display vs. video comparison
Break down DV360 performance by environment — connected TV, desktop display, mobile app, mobile web — using DAX measures for completion rates, viewability, and cost efficiency in each channel.
How to Connect Display & Video 360 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 Display & Video 360 in Power BI
Pre-built dashboards to get you started. Customize layouts, filters, and visualizations to match your reporting needs.
Programmatic Trading Cockpit
IO-level delivery pacing with flight progress bars, exchange-level vCPM comparison, and viewability rate trending. Environment slicer separates CTV, display, and video analysis.
DV360 Audience & Inventory Report
Audience segment performance matrix with CTR and CPA, inventory source treemap showing spend distribution, and viewability scatter plot by site/app.
Reporting Scenarios for Display & Video 360 in Power BI
Common reporting use cases that teams build with DV360 data in Power BI.
Exchange-Level vCPM Comparison
Bar chart comparing viewability-adjusted CPM across exchanges and inventory sources, identifying the most cost-efficient supply paths for viewable inventory.
Environment Performance Breakdown
Donut chart showing spend distribution across CTV, desktop, and mobile alongside a clustered bar chart comparing viewability and completion rates in each.
What Display & Video 360 Data Can You Pull into Power BI?
Supermetrics gives Power BI access to your full DV360 reporting data — metrics and dimensions you already know from the DV360 interface.
Key Metrics
- Impressions
- Clicks
- Spend
- CTR
- CPC
- CPM
- Conversions
- CPA
- ROAS
- Viewable impressions
- Viewability rate
- Video completions
- Video completion rate
- Reach
- Frequency
Key Dimensions
- Campaign name
- Insertion order
- Line item
- Creative name
- Creative size
- Exchange
- Inventory source
- Audience segment
- Device type
- Environment (App/Web/CTV)
- Country
- Site/App name
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 Display & Video 360 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 Display & Video 360. 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 Display & Video 360 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 Display & Video 360 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 Display & Video 360. 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 Display & Video 360 in Power BI?
Yes. Publish your report to the Power BI Service and configure a scheduled refresh through your dataset settings. Supermetrics refreshes your Display & Video 360 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 Display & Video 360 data with other sources inside Power BI?
Absolutely. Power BI's data model is built for blending. Use Supermetrics to pull Display & Video 360 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 Display & Video 360 metrics and dimensions can I access in Power BI?
All standard Display & Video 360 reporting fields are available, including Impressions, Clicks, Spend, CTR, CPC, and more. You get the same data as the Display & Video 360 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 Display & Video 360 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 viewability-adjusted CPM for DV360 in Power BI?
Pull impressions, viewable impressions, and spend via Supermetrics. Create: vCPM = DIVIDE(SUM(Spend), SUM(ViewableImpressions)) * 1000. Compare against standard CPM to see the true cost of reaching audiences who actually see your ads.
Can I analyze DV360 audience segment performance in Power BI?
Yes. Build matrix tables comparing first-party, third-party, and Google audience segments by CTR, conversion rate, and CPA. Conditional formatting highlights your best-performing audiences.
Also Connect to Power BI
Ready to Connect Display & Video 360 to Power BI?
Join 200,000+ companies that use Supermetrics to connect their marketing data. Set up in under two minutes.