Connect Amazon DSP to Google Sheets

Bring your Amazon DSP data into Google Sheets with Windsor.ai, so your sheets 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.

Try It Free

Free forever plan

No credit card needed

Windsor.ai is your proven Amazon DSP to Google Sheets connector

Get your Amazon DSP data into Google Sheets

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 Google Sheets

Supported fields: 110 metrics49 dimensions

Windsor.ai moves your Amazon DSP fields into Google Sheets on a connection you set up once, so the sheets stay on live records rather than a CSV someone exported last week.

Pick the fields you need and Windsor.ai handles the rest.

With Windsor.ai, your spreadsheet can:

Show Total Cost, Sales and ROAS by Order Name for the last 30 days, sorted by Total Cost.
Compare New To Brand Purchases and New To Brand ROAS by Order Name this month with last month.
List the line items with the lowest Line Item Delivery Rate this month, with Line Item Budget and Total Cost.
List the 10 creatives with the highest Viewability Rate last week, with Creative Name, Click Through Rate and Impressions.
Show Reach, Household Reach and Frequency Average by Order Name for the last 14 days.

Join over 25,000+ businesses that trust Windsor.ai to streamline Amazon DSP to Google Sheets integration

How to connect Amazon DSP to Google Sheets with Windsor.ai

Explore a step-by-step guide to integrate your Amazon DSP data into Google Sheets with the Windsor.ai connector.

Register and log in to Windsor.ai

Create a new Windsor.ai account or log in if you already have one.

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 your destination

Set Google Sheets as the destination for your data.

Select the reporting fields

Choose the Amazon DSP fields you want to show in your spreadsheet.

Follow the setup instructions to complete the integration

Depending on the integration method you choose, set up the connection by following the prescribed steps, whether through an extension or directly via an in-app destination task.

FAQs

What is Amazon DSP?

Amazon DSP is Amazon Ads’ programmatic platform for buying display, video, audio and streaming TV ads on Amazon properties such as Prime Video, Twitch, Fire TV and Amazon.com, and on third-party sites and apps. Amazon now offers it inside Amazon Ads Agent as Display, Video and Audio campaigns.

What Amazon DSP data can I load into Google Sheets?

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 Google Sheets?

Windsor.ai sends your chosen Amazon DSP fields straight into a sheet, either through the Google Sheets add-on or through an in-app destination task. You can set it to refresh on a schedule.

Can I combine Amazon DSP data with other sources in my sheets?

Yes. Windsor.ai supports 350+ data sources, so Amazon DSP data can sit next to other connected sources in the same sheets. 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 Google Sheets?

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 Google Sheets 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 Google Sheets?

Yes. These are the resources to start with for the Amazon DSP to Google Sheets integration:

Tired of manual Amazon DSP data exports? Try Windsor.ai today to work on live data

Access all your data from various sources in one place. Get started for free.

Start for Free Book a Demo