Supermetrics for Power BI
Connect The Trade Desk to Power BI — Programmatic Intelligence Dashboards
Analyze The Trade Desk programmatic campaigns in Power BI with supply path optimization, audience segment analysis, and viewability tracking. DAX measures calculate eCPM by supply vendor, conversion attribution across click-through and view-through windows, and frequency management indicators.
Why Connect The Trade Desk to Power BI?
Build live TTD dashboards in Power BI that update automatically and share with your team.
- Compare eCPM and viewability across supply vendors. Identify the most cost-efficient paths to inventory and eliminate redundant supply sources using matrix tables ranked by effective cost.
- Evaluate first-party, third-party, and contextual audience segments by conversion rate and CPA. DAX measures calculate incremental lift per segment to justify targeting investments.
- Combine TTD data with DV360 and Amazon DSP in Power BI for a unified programmatic view. Compare platform-level efficiency and deduplicate audience reach across DSPs.
How to Connect The Trade Desk 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 The Trade Desk in Power BI
Pre-built dashboards to get you started. Customize layouts, filters, and visualizations to match your reporting needs.
TTD Supply Path & Viewability Report
Supply vendor comparison by eCPM and viewability rate with site-level drill-through. Inventory type breakdown (display, video, CTV, audio) with spend distribution.
Audience Segment Performance Dashboard
Segment-level conversion rate and CPA matrix with conditional formatting. First-party vs. third-party audience comparison and frequency distribution analysis.
Reporting Scenarios for The Trade Desk in Power BI
Common reporting use cases that teams build with TTD data in Power BI.
Scatter chart
Supply Vendor eCPM vs. Viewability
Scatter chart plotting supply vendor eCPM against viewability rate, with bubble size representing impression volume. Low-eCPM, high-viewability vendors are your best sources.
Stacked bar chart
Click vs. View-Through Conversion Mix
Stacked bar chart showing the proportion of click-through vs. view-through conversions by campaign, revealing reliance on display-influenced attribution.
What The Trade Desk Data Can You Pull into Power BI?
Supermetrics gives Power BI access to your full TTD reporting data — metrics and dimensions you already know from the TTD interface.
Key Metrics
- Impressions
- Clicks
- CTR
- CPM
- CPC
- Total click conversions
- Total view-through conversions
- CPA (click)
- CPA (view)
- Bids
- Sampled viewable impressions
- Sampled tracked impressions
Key Dimensions
- Campaign name
- Ad group name
- Creative name
- Audience name
- Device type
- Supply vendor
- Site
- Country
- Ad format
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 The Trade Desk 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 The Trade Desk. 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 The Trade Desk 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 The Trade Desk. 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 The Trade Desk 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 The Trade Desk 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 The Trade Desk reporting fields are available, including Impressions, Clicks, CTR, CPM, CPC, and more. You get the same data as the The Trade Desk 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.
- Build a bar chart or matrix table ranking vendors by viewability rate and eCPM. DAX measures calculate viewability-adjusted cost so you can identify the most efficient supply paths.
- Yes. Build stacked bar charts showing the mix of click-through and view-through conversion types by campaign. DAX measures calculate CPA separately for each attribution type.
Also Connect to Power BI
Ready to Connect The Trade Desk to Power BI?
Join 200,000+ companies that use Supermetrics to connect their marketing data. Set up in under two minutes.