Supermetrics for Power BI
Connect Amazon DSP to Power BI — Amazon Display Dashboards
Analyze Amazon DSP display and video campaigns in Power BI with viewability benchmarking, audience targeting analysis, and 14-day conversion window attribution. DAX measures calculate viewability-adjusted eCPM, pixel conversion rates, and creative performance rankings by size and type.
Why Connect Amazon DSP to Power BI?
Build live Amazon DSP dashboards in Power BI that update automatically and share with your team.
Viewability and measurability analysis
Track viewable impression rates and measurability across orders and line items. DAX measures calculate vCPM — cost on viewable impressions only — to evaluate true media value.
14-day attribution window analysis
Analyze Amazon DSP's 14-day lookback conversion data. Compare click-through vs. view-through pixel conversions to understand how display ads influence purchase decisions over time.
Full-funnel Amazon advertising view
Join Amazon DSP data with Sponsored Products data in Power BI to see the full funnel — from awareness (DSP) to consideration (SB) to purchase (SP) — across your Amazon strategy.
How to Connect Amazon DSP 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 Amazon DSP in Power BI
Pre-built dashboards to get you started. Customize layouts, filters, and visualizations to match your reporting needs.
Amazon DSP Viewability & Conversions
vCPM trend by line item type, viewability rate gauges, and 14-day pixel conversion analysis. Order-level drill-through to creative and placement performance.
Amazon Full-Funnel Ad Dashboard
DSP awareness metrics feeding into Sponsored Products conversion data. Funnel visual showing how display impressions correlate with search ad conversions.
Reporting Scenarios for Amazon DSP in Power BI
Common reporting use cases that teams build with Amazon DSP data in Power BI.
Line Item vCPM vs. Conversion Scatter
Scatter chart plotting viewability-adjusted CPM against pixel conversion rate per line item, identifying inventory that delivers both viewability and conversions.
Click vs. View-Through Attribution Split
Stacked bar chart showing click-through vs. view-through conversion shares by order, revealing which campaigns drive direct response vs. awareness-influenced purchases.
What Amazon DSP Data Can You Pull into Power BI?
Supermetrics gives Power BI access to your full Amazon DSP reporting data — metrics and dimensions you already know from the Amazon DSP interface.
Key Metrics
- Impressions
- Click-throughs
- CTR
- eCPC
- eCPM
- Total cost
- Supply cost
- Viewable impressions
- Viewability rate
- Measurable rate
- Total pixel conversions (14d)
- Total pixel CVR (14d)
Key Dimensions
- Order name
- Line item name
- Creative name
- Creative type
- Creative size
- Advertiser name
- Account name
- Date
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 Amazon DSP 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 Amazon DSP. 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 Amazon DSP 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 Amazon DSP 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 Amazon DSP. 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 Amazon DSP in Power BI?
Yes. Publish your report to the Power BI Service and configure a scheduled refresh through your dataset settings. Supermetrics refreshes your Amazon DSP 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 Amazon DSP data with other sources inside Power BI?
Absolutely. Power BI's data model is built for blending. Use Supermetrics to pull Amazon DSP 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 Amazon DSP metrics and dimensions can I access in Power BI?
All standard Amazon DSP reporting fields are available, including Impressions, Click-throughs, CTR, eCPC, eCPM, and more. You get the same data as the Amazon DSP 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 Amazon DSP 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 Amazon DSP line item performance in Power BI?
Pull line item data with viewability, pixel conversions, and cost. Build a matrix table ranked by pixel CVR and vCPM. Conditional formatting highlights strong performers for budget reallocation.
Can I combine Amazon DSP and Sponsored Products data in Power BI?
Yes. Pull both via Supermetrics into separate queries. Join in Power Query on date and advertiser name. Build full-funnel reports showing how display awareness drives search conversions.
Also Connect to Power BI
Ready to Connect Amazon DSP to Power BI?
Join 200,000+ companies that use Supermetrics to connect their marketing data. Set up in under two minutes.