Supermetrics for Power BI
Connect Adform to Power BI — Ad Serving Dashboards
Build ad serving dashboards in Power BI with Adform campaign delivery data, viewability benchmarks, and video completion analysis. DAX measures calculate delivery pacing, banner-level CTR benchmarks, and creative size performance rankings across your entire media buy.
Why Connect Adform to Power BI?
Build live Adform dashboards in Power BI that update automatically and share with your team.
Creative size and format analysis
Compare banner sizes and creative formats by CTR and viewability. Matrix tables ranked by performance help media planners select the most effective ad formats for each campaign.
Delivery pacing and spend monitoring
Track line item delivery against booked impressions with progress indicators. DAX measures calculate daily run rate and projected end-of-flight delivery, flagging pacing issues early.
Cross-buy ad serving consolidation
Combine Adform ad serving data with DSP and publisher-direct data in Power BI to reconcile discrepancies and create a single source of truth for impression delivery.
How to Connect Adform 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 Adform in Power BI
Pre-built dashboards to get you started. Customize layouts, filters, and visualizations to match your reporting needs.
Ad Serving Delivery & Pacing Report
Line item delivery progress bars with daily run rate trending and projected completion dates. Conditional formatting flags under and over-delivering campaigns.
Creative Format Performance Matrix
Banner size and format comparison by CTR, viewability, and video completion rate. Treemap showing impression distribution across creative sizes.
Reporting Scenarios for Adform in Power BI
Common reporting use cases that teams build with Adform data in Power BI.
Banner Size CTR vs. Viewability Scatter
Scatter chart plotting CTR against viewability rate for each banner size, identifying formats that deliver both high engagement and high viewability.
Video Completion Rate by Creative Length
Bar chart showing video completion rates across 6s, 15s, 30s, and 60s creative lengths, guiding video production decisions.
What Adform Data Can You Pull into Power BI?
Supermetrics gives Power BI access to your full Adform reporting data — metrics and dimensions you already know from the Adform interface.
Key Metrics
- Impressions
- Clicks
- CTR
- CPC
- CPM
- Spend
- Conversions
- Viewable impressions
- Viewability rate
- Video starts
- Video completions
- Video completion rate
Key Dimensions
- Campaign name
- Line item name
- Banner name
- Banner size
- Media name
- Order name
- Buy type
- Network
- Media country
- Tag 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 Adform 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 Adform. 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 Adform 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 Adform 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 Adform. 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 Adform in Power BI?
Yes. Publish your report to the Power BI Service and configure a scheduled refresh through your dataset settings. Supermetrics refreshes your Adform 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 Adform data with other sources inside Power BI?
Absolutely. Power BI's data model is built for blending. Use Supermetrics to pull Adform 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 Adform metrics and dimensions can I access in Power BI?
All standard Adform reporting fields are available, including Impressions, Clicks, CTR, CPC, CPM, and more. You get the same data as the Adform 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 Adform 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 compare banner size performance from Adform in Power BI?
Pull impressions, clicks, and viewability with the banner size dimension. Build a matrix table ranking sizes by CTR and viewability rate. DAX measures calculate eCPM per size to identify which formats deliver the best value.
Can I reconcile Adform delivery data with DSP reports in Power BI?
Yes. Pull Adform ad server data alongside DV360 or TTD data via Supermetrics. Join in Power Query on campaign name and date, then build discrepancy reports comparing served impressions.
Also Connect to Power BI
Ready to Connect Adform to Power BI?
Join 200,000+ companies that use Supermetrics to connect their marketing data. Set up in under two minutes.