Connect Amazon DSP to Gemini Enterprise
Connect your Amazon DSP data to Gemini Enterprise with the Windsor.ai connector, and ask about your Amazon DSP campaigns in plain language.
Ask for ROAS by order, new-to-brand purchases or line item delivery, built on your own Total Cost, ROAS, New To Brand Purchases and Line Item Budget fields.
Forget CSVs. Stop copy/paste. Connect in minutes. No code required.
Get your Amazon DSP data into Gemini Enterprise
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.
Review creatives
Viewability Rate, Video Ad Completion Rate and Click Through Rate per Creative Name show which creatives are seen and watched.
Using Windsor.ai to connect data from Amazon DSP to Gemini Enterprise
Without Windsor.ai, Gemini Enterprise answers about Amazon DSP data come from a file you exported and pasted in. Through the Windsor.ai connector, Gemini Enterprise reads the live records with their real field names, so the answers match what is in Amazon DSP today.
Connect in minutes, then ask about your orders, line items, creatives, spend, sales and reach.
Available actions
Create Campaign
Create an Amazon DSP campaign with a single flight (start, end, budget), an uncapped frequency, and the given optimization goal. The campaign is created in an inactive state and only starts delivering after ad groups with creatives are added and the campaign is activated via the update_campaign action. The budget amount is in the advertiser currency major unit (e.g. 100.00 means one hundred).
Update Campaign
Update an Amazon DSP campaign: rename it and/or change its state. Setting state=ACTIVE starts delivery (the campaign must have active ad groups with creatives), state=INACTIVE stops it. Both changes are reversible with another update_campaign call.
How to connect Amazon DSP to Gemini Enterprise with Windsor.ai
Watch the video tutorial, or follow the step-by-step guide to connect your Amazon DSP data to Gemini Enterprise with Windsor.ai.
Create the Windsor.ai data store in Google Cloud
In the Google Cloud console, open Gemini Enterprise, go to Data stores and click Create data store. Under Third-party data sources, find Windsor.ai and click Add data source. Choose the actions to enable, set the location and create the store.
Create an app and connect the data store
Create a Gemini Enterprise app in the same location as your data store, or pick an existing one. Then open Connected data stores in the app and add the Windsor.ai data store.
Authorize Windsor.ai
Open the app’s web app, click the puzzle piece icon and click Authorize next to Windsor.ai. Allow access, sign in to Windsor.ai if asked, and click Finish.
Ask Gemini about your Amazon DSP data
Ask a question such as “Show Total Cost, Sales and ROAS by Order Name for the last 30 days, sorted by Total Cost.” Data can take about 10 minutes to appear after you connect the data store to the app.
FAQs
What Amazon DSP data can Gemini Enterprise use?
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.
What can I ask Gemini Enterprise about my Amazon DSP data?
These prompts name the fields to use, so the answer comes back on your own records:
-
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.
Can Gemini Enterprise make changes in my Amazon DSP account?
Yes. Windsor.ai has write actions for Amazon DSP, so Gemini Enterprise can make changes when you ask: it can create a campaign, which starts inactive, and rename, activate or deactivate a campaign. Execute Action must be enabled on the Windsor.ai data store, and Write actions must be on in your Windsor.ai account. See the full list of write actions.
Can I combine Amazon DSP data with other sources in Gemini Enterprise?
Yes. Windsor.ai supports 350+ data sources, so you can connect Amazon DSP alongside tools such as Google Ads, GA4 or Shopify and ask about them together. 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 Gemini Enterprise?
No. Connect Amazon DSP in Windsor.ai, add Windsor to Gemini Enterprise, and sign in. After that you ask in plain language.
How much does it cost to integrate Amazon DSP with Gemini Enterprise 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. Gemini Enterprise is billed separately by Google. See the pricing page.
Do you have helpful links to get started with Amazon DSP and Gemini Enterprise?
Yes. These are the resources to start with for the Amazon DSP to Gemini Enterprise integration:
Tired of manual Amazon DSP data exports? Try Windsor.ai today to work on live data

