Connect Amazon DSP to Data Studio
Bring your Amazon DSP data into Data Studio with Windsor.ai, so your reports read live programmatic campaign data.
Pick the Amazon DSP fields you need, and Windsor.ai keeps them flowing without a CSV export in between.
Forget CSVs. Stop copy/paste. Connect in minutes. No code required.
Get your Amazon DSP data into Data Studio
Amazon DSP is connected once in Windsor.ai, and these are the use cases the fields support:
Compare orders on return
Total Cost, Sales and ROAS come per Order Name (Amazon DSP calls campaigns orders), so you can see which campaigns earn their spend.
Count new-to-brand customers
New To Brand Purchases, New To Brand Product Sales and New To Brand ROAS show how much of the result came from customers who had not bought from the brand before.
Check line item delivery
Line Item Budget, Line Item Delivery Rate and Total Cost per Line Item Name show which line items are behind on delivery.
Using Windsor.ai to connect data from Amazon DSP to Data Studio
Windsor.ai moves your Amazon DSP fields into Data Studio on a connection you set up once, so the reports stay on live records rather than a CSV someone exported last week.
Pick the fields you need and Windsor.ai handles the rest.
How to connect Amazon DSP to Data Studio with Windsor.ai
Explore a step-by-step guide to integrate your Amazon DSP data into Data Studio with the Windsor.ai connector.
Select your data source
Choose Amazon DSP as your data source and sign in with your Amazon Ads account to grant Windsor.ai access to your DSP advertisers.
Select the reporting fields
Choose the Amazon DSP fields you want in Data Studio on the right side, and preview your data before export.
Select Data Studio as your data destination
Scroll down to the list of data destinations and click Data Studio. Install the Windsor.ai connector by authorizing your account, selecting the required Amazon DSP account(s), and clicking Connect, then Create Report.
FAQs
What Amazon DSP data can I load into Data Studio?
Windsor.ai gives access to 159 Amazon DSP fields. These are the groups; the Amazon DSP field reference lists all of them:
- Orders (campaigns): Order Name, Order Budget, Order Start Time, Order End Time, Impressions, Clicks, Total Cost, Supply Cost, Total Fee, Sales, Purchases, ROAS, Total ROAS.
- New to brand and off Amazon: New To Brand Purchases, New To Brand Product Sales, New To Brand ROAS, Off Amazon Conversions, Off Amazon Product Sales, Off Amazon ROAS.
- Line items: Line Item Name, Line Item Type, Line Item Status, Line Item Budget, Line Item Delivery Rate, Target Demographic, On Target Impressions, eCPM.
- Creatives: Creative Name, Creative Type, Creative Size, Viewability Rate, Video Ad Completion Rate, Click Through Rate.
- Reach and video: Reach, Household Reach, Frequency Average, Video Ad Start, Video Ad Complete, Viewable Impressions.
- Time and account: Date, Advertiser Name, Marketplace.
How does Windsor.ai load Amazon DSP data into Data Studio?
Windsor.ai provides a Data Studio connector. You authorize it once, select your Amazon DSP account and the fields you want, and build the report on live data.
Can I combine Amazon DSP data with other sources in my reports?
Yes. Windsor.ai supports 350+ data sources, so Amazon DSP data can sit next to other connected sources in the same reports. For example, put Amazon DSP Total Cost and Sales by week next to Amazon Ads Sponsored Products Cost and Sales (14 days) for the same weeks, so programmatic and sponsored ad results sit in one table.
Do I need to code to connect Amazon DSP to Data Studio?
No. You connect Amazon DSP in the Windsor.ai dashboard, pick the fields you want, and Windsor.ai handles the transfer.
How much does it cost to integrate Amazon DSP with Data Studio using Windsor.ai?
The free forever plan covers 1 data source, so connecting Amazon DSP on its own costs nothing and needs no credit card. Combining Amazon DSP with other sources needs a paid plan: $19/month for 3 sources or $99/month for 7. See the pricing page.
Do you have helpful links to get started with Amazon DSP and Data Studio?
Yes. These are the resources to start with for the Amazon DSP to Data Studio integration:
Tired of manual Amazon DSP data exports? Try Windsor.ai today to work on live data

