Amazon DSP MCP for AI Insights

Send your Amazon DSP data to the AI chat you already use with Windsor MCP.

Windsor.ai connects Amazon DSP once, and your programmatic campaign data become available to ask about in ChatGPT, Claude, Gemini and other MCP-compatible clients.

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 Windsor MCP connector

Get your Amazon DSP data into the AI chat you already use

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 MCP to connect data from Amazon DSP to LLMs

Supported fields: 110 metrics49 dimensions

Without Windsor.ai, getting Amazon DSP records into an AI chat means an export and an upload every time you want to ask something. Windsor MCP connects Amazon DSP once and the AI chat reads the live records instead.

Connect in minutes, then ask about your orders, line items, creatives, spend, sales and reach.

With Windsor MCP, you can ask your AI chat to:

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 40,000+ businesses that trust Windsor.ai to streamline Amazon DSP to Windsor MCP integration

How to connect Amazon DSP MCP by Windsor.ai

Explore a step-by-step guide to connect your Amazon DSP data to the AI chat you use with Windsor MCP.

Register and log in to Windsor.ai

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

Connect your Amazon DSP account

Choose Amazon DSP as your data source and sign in with your Amazon Ads account to grant Windsor.ai access to your DSP advertisers.

Connect Windsor MCP to your favorite LLM

Connect Windsor MCP to the AI chat you use. Open the Windsor MCP documentation and follow the instructions for your platform.

Start analyzing your Amazon DSP data in the LLM

You can now ask questions about your Amazon DSP data in the AI chat you connected.

FAQs

What is Windsor.ai's Amazon DSP MCP?

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. Through Windsor MCP, ChatGPT, Claude, Gemini or another MCP-compatible AI chat reads your orders, line items, creatives, spend, sales and reach, so you can ask about them in plain language instead of exporting a file first. Amazon DSP calls campaigns orders: Order Name identifies the campaign on each row, and line items and creatives have their own reports.

What Amazon DSP data can my AI chat use through Windsor MCP?

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 my AI chat 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 my AI chat make changes in my Amazon DSP account?

Yes. Windsor.ai has write actions for Amazon DSP, and your AI chat can run them through Windsor MCP when you ask: it can create a campaign, which starts inactive, and rename, activate or deactivate a campaign. See the full list of write actions.

Can I combine Amazon DSP data with other sources through Windsor MCP?

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 Windsor MCP?

No. Connect Amazon DSP in Windsor.ai, add Windsor MCP to your AI chat, and sign in. After that you ask in plain language.

How much does it cost to integrate Amazon DSP with Windsor MCP 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. The AI chat you connect is billed separately by its own provider. See the pricing page.

Do you have helpful links to get started with Amazon DSP and Windsor MCP?

Yes. These are the resources to start with for the Amazon DSP to Windsor MCP integration:

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

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

Start for Free Book a Demo