Amazon DSP (demand-side platform) is Amazon's programmatic advertising platform for buying display, video, audio, and streaming TV ads on and off Amazon. With the Power My Analytics Amazon DSP connector, you can bring your Amazon DSP orders, line items, ads, and daily performance data (spend, impressions, conversions, video engagement, and fees) into your reports. This guide covers what you need before you connect, how to add Amazon DSP as a data source, how to build your first report, and which reports and metrics are available.

Amazon DSP is a Beta connector. It is available and supported now; while it is in Beta, some fields and behavior may still change as we continue to improve it. We will expand this guide as the connector develops.

Prerequisites

• An active Amazon DSP account, with your DSP advertisers linked to an Amazon Ads manager account that your Amazon login can access. Power My Analytics finds your DSP advertisers through the manager accounts your login can see.
• A Login with Amazon (LwA) security profile in the Amazon Developer Console, with Amazon Ads API access assigned to it (including the profile and advertising::campaign_management scopes).
• The Client ID and Client Secret from that security profile. You will paste these into your Hub when you add the source.
• The Power My Analytics Amazon DSP return URL added to your security profile's Allowed Return URLs.

Adding Amazon DSP as a Data Source

1. In your Power My Analytics Hub, select Sources from the menu.
2. Click + Add new source and choose Amazon DSP from the gallery.
3. Select your Region (North America (NA), Europe (EU), or Far East (FE)), then enter your Client ID and Client Secret.
4. Click Connect, sign in with the Amazon account that has access to your DSP advertisers, and allow Power My Analytics access.

Creating a Data Studio Report

1. In your Hub, go to Reports > Data Studio and click the orange + Create report button.
2. In the Templates window, select Single sources, find Amazon DSP, and click Open in Data Studio.
3. In Data Studio, click Authorize if you are prompted, then select your Power My Analytics Hub and the Amazon DSP data source you connected.
4. Configure your Amazon DSP data source:
   • Accounts: Select the Amazon DSP advertisers you want to report on.
5. Click Connect (top right), then click Create report.

Key Reports and Fields

• Performance Campaigns: daily performance by order, line item, and ad (creative).
• Performance Inventory: daily performance by site (where your ads ran), order, and line item.
• Performance Audience: daily performance by order, from Amazon DSP's audience report.
• Orders: the current settings for each order (campaign), such as status, flight dates, and optimization goal.
• Line Items: the current settings for each line item, such as bidding, pacing, and targeting.
• Ads: the current details for each ad (creative).

Dimensions in the performance reports

• All three performance reports: Date (plus Year, Quarter, Year Quarter, Year Month, Week, Year Week, Month, Month Day, Day Of Week, and Day Of Month), Advertiser ID, Order ID, Order Currency, Entity Name
• Performance Campaigns: Line Item ID, Ad ID
• Performance Inventory: Line Item ID, Site

Metrics in all three performance reports

• Delivery and spend: Impressions, Clicks, Other Clicks, Gross Impressions, Invalid Impressions, Invalid Impression Rate, Gross Click Throughs, Invalid Click Throughs, Invalid Click Throughs Rate, Total Cost, Supply Cost, Amazon Dspaudience Fee
• Purchases: Purchases, Purchases Clicks, Purchases Views, New To Brand Purchases, New To Brand Purchases Clicks, New To Brand Purchases Views
• Shopping actions: Detail Page Views, Detail Page View Clicks, Detail Page View Views, Add To Cart, Add To Cart Clicks, Add To Cart Views, Add To List, Add To List Clicks, Add To List Views, Add To Shopping Cart, Add To Shopping Cart Clicks, Add To Shopping Cart Views
• Other conversions: Application, Application Clicks, Application Views, Brand Searches, Brand Searches Clicks, Brand Searches Views, Search, Search Clicks, Page Views, Mobile App First Starts, Mobile App First Start Clicks, Mobile App First Start Views
• Off-Amazon conversions: Off Amazon Conversions, Off Amazon Clicks, Off Amazon Views, Off Amazon Purchases Clicks, Off Amazon Purchases Views
• Video ad engagement: Video Ad Start, Video Ad First Quartile, Video Ad Midpoint, Video Ad Third Quartile, Video Ad Complete, Video Completion Rate, Video Ad Pause, Video Ad Resume, Video Ad Mute, Video Ad Unmute
• Streaming and Prime Video: Video Streams, Video Streams Clicks, Video Streams Views, Video Downloads, Video Downloads Clicks, Video Downloads Views, Downloaded Video Plays, Downloaded Video Plays Clicks, Downloaded Video Plays Views, Rentals, Rentals Clicks, Rentals Views, Play Trailers, Play Trailers Clicks, Play Trailers Views, Add To Watchlist, Add To Watchlist Clicks, Add To Watchlist Views
• Rates: DPVR, Add To Cart Rate, Add To List Rate, New To Brand Purchase Rate, Add To Watchlist Rate, Rental Rate, Play Trailer Rate, Video Streams Rate, Video Download Rate, Added To Shopping Cart CVR, Application CVR, Brand Search CVR, Mobile App First Start CVR
• Cost per result: Effective Cost Per Purchase, New To Brand eCPP, Effective Cost Per Add To Cart, Added To Shopping Cart CPA, Application CPA, Brand Search CPA, Mobile App First Start CPA, Effective Cost Per Rental, Effective Cost Per Play trailer, Effective Cost Per Video Stream, Effective Cost Per Downloaded Video Play, Average Cost to Acquire a Video Complete, eRPM

Additional metrics in Performance Campaigns and Performance Inventory

• Sales and budget: Sales, Units Sold, Total Sales, Total Units Sold, Line Item Budget
• Brand-level conversions: Total Purchases, Total Purchases Clicks, Total Purchases Views, Total Detail Page View, Total Detail Page View Clicks, Total Detail Page View Views, Total Add To Cart, Total Add To Cart Clicks, Total Add To Cart Views, Total Add To List, Total Add To List Clicks, Total Add To List Views
• Other conversions: Off Amazon Purchases, Sign Up, Sign Up Clicks, Sign Up Views
• Viewability: Viewable Impressions, Measurable Impressions, Measurable Rate
• Rates and cost per result: Total Purchase Rate, Total Detail Page View Rate, Total Add To Cart rate, Total Add To List Rate, Total eCPP, Total Effective Cost Per Total Add To Cart, Total eCPATL, Product purchased CPA, Product purchased CVR, Sign Up Button CPA, Sign Up Button CVR
• Fees: Total Fee, Agency Fee, Amazon Dspconsole Fee, 3pfees, 3p Fee Automotive, 3p Fee Automotive Absorbed, 3p Fee Com Score, 3p Fee Com Score Absorbed, 3p Fee Cpm1, 3p Fee Cpm1absorbed, 3p Fee Cpm2, 3p Fee Cpm2absorbed, 3p Fee Cpm3, 3p Fee Cpm3absorbed, 3p Fee Double Verify, 3p Fee Doubleclick Campaign Manager, 3p Fee Doubleclick Campaign Manager Absorbed, 3p Fee Integral Ad Science, 3p Fee Integral Ad Science Absorbed

Performance Campaigns only

• Long Term Sales: the estimated incremental sales the brand can expect over the next 12 months from new-to-brand customers.

Orders, Line Items, and Ads fields

• Orders: Order ID, Order Name, Advertiser ID, Country, State, Delivery Status, Start Date Time, End Date Time, Creation Date Time, Last Updated Date Time, Marketplace ID, Optimization Bid Strategy, Optimization Goal Setting Goal, Optimization Goal Setting Kpi, Optimization Flight Budget Rollover Setting Rollover Strategy, Automate Bid Allocation, Automate Budget Allocation, Targets Amazon Deal
• Line Items: Line Item ID, Line Item Name, Order ID, Advertiser ID, State, Delivery Status, Start Date Time, End Date Time, Creation Date Time, Last Updated Date Time, Inventory Type, Creative Rotation Type, Bid Base Bid, Bid Max Average CPM, Bid Currency Code, Optimization Bid Strategy, Optimization Daily Min Spend Amount, Automate Budget Allocation, Pacing Delivery Profile, Pacing Catch Up Boost Percentage, Enable Language Targeting, Include Unmeasurable Impressions, Targeting Settings Amazon Viewability Viewability Tier, Targeting Settings Default Audience Targeting Match Type, Targeting Settings Time Zone Type, Targeting Settings User Location, Targeting Settings User Location Signal, Targeting Settings Video Completion Tier
• Ads: Ad ID, Ad Name, Advertiser ID, Country, Language, Hosted Type, Created Date Time, Last Updated Date Time

Limitations and Important Considerations

• Backfilling: Amazon DSP makes about the last 94 days of performance data available, through yesterday. When you first connect, Power My Analytics backfills the available history (up to 94 days). Data older than that can't be retrieved from Amazon, but Power My Analytics keeps the data it collects, so your reporting history grows from the day you connect.
• Daily data sync: Each day, Power My Analytics re-requests the last 14 days of Amazon DSP performance data, because Amazon can update recent conversion results.
• Today's data: Performance data runs through yesterday. Today's results appear after the next daily sync.
• Beta connector: While Amazon DSP is in Beta, fields, configuration options, and behavior may change. If a field is renamed or removed, you may need to update the reports that use it.
• Current settings only: The Orders, Line Items, and Ads reports show the current settings for each item, not a history of past changes.
• Currencies: Spend, sales, and fee metrics are reported in each order's currency (see Order Currency), without conversion. If your advertisers use different currencies, report on them separately or convert the values before totaling.
• Regions: Each Amazon DSP data source covers one region (North America, Europe, or Far East). To report on advertisers in more than one region, add a data source for each region.

Unavailable Data

• Audience segment names and IDs (Performance Audience reports by order)
• Hourly performance data
• Performance data older than about 94 days, which Amazon does not provide

Troubleshooting

• Amazon shows an error about the return URL or redirect URL when you sign in: The Amazon DSP return URL is missing from your security profile, or it was entered with a typo. Add it exactly as shown in How to Connect to Amazon DSP (Step 4), save, and connect again.
• "Invalid Scope" when you sign in: Your security profile does not have the required Amazon Ads API scopes. Follow Amazon Ads Error: Invalid Scope; the same fix applies to Amazon DSP.
• You connected, but no advertisers appear: Check that your DSP advertisers are linked to an Amazon Ads manager account your Amazon login can access, and that you chose the region where those advertisers are managed.
• You connected Amazon Ads, but your DSP campaigns have no data: Amazon Ads does not include Amazon DSP campaigns. Add Amazon DSP as its own data source.