Connect Amazon DSP to AI, Sheets, Databases & BI Tools

Windsor.ai's Amazon DSP connector extracts your Amazon DSP data and syncs it to AI assistants like ChatGPT, Claude and Gemini, spreadsheets like Google Sheets and Excel, data warehouses like BigQuery, Snowflake and PostgreSQL, and BI tools like Looker Studio, Power BI and Tableau. Setup takes a few minutes in the browser, no coding required, and you can start for free, no credit card required.

How to connect Amazon DSP to Windsor.ai

  1. Create your free Windsor.ai account or log in.
  2. Select Amazon DSP and grant Windsor.ai access to your Amazon DSP data.
  3. Pick the fields and date range you need and preview the data.
  4. Choose a destination and start syncing your Amazon DSP data.

Amazon DSP fields

Windsor.ai's Amazon DSP connector offers 159 fields, organized in 4 tables such as dsp_campaign, dsp_creative, dsp_line_item, dsp_reach_frequency. Here are 30 of them:

  • DSP Campaign: Order Name (dsp_campaign__order_name): The name of the order (campaign)
  • DSP Campaign: Impressions (dsp_campaign__impressions): The number of times the ad was displayed
  • DSP Campaign: Total Cost (dsp_campaign__total_cost): The total cost including supply cost and fees
  • Date (date): Date
  • Account Name (account_name): The DSP advertiser name used as the account name
  • Account ID (account_id): The DSP advertiser ID used as the account ID
  • DSP Campaign: Add To Cart (dsp_campaign__add_to_cart): Add-to-cart events attributed to the ad
  • DSP Creative: Click Through Rate (dsp_creative__click_through_rate): Clicks divided by impressions
  • DSP Line Item: Click Through Rate (dsp_line_item__click_through_rate): Clicks divided by impressions
  • DSP Reach Frequency: Frequency Average (dsp_reach_frequency__frequency_average): The average number of exposures per unique user
  • Advertiser ID (advertiserid): The DSP advertiser ID
  • DSP Campaign: Add To List (dsp_campaign__add_to_list): Add-to-list events attributed to the ad
  • DSP Creative: Clicks (dsp_creative__clicks): The number of times the ad was clicked
  • DSP Line Item: Clicks (dsp_line_item__clicks): The number of times the ad was clicked
  • DSP Reach Frequency: Reach (dsp_reach_frequency__reach): The number of unique users exposed to the advertiser's ads
  • Advertiser Name (advertisername): The DSP advertiser name
  • DSP Campaign: Agency Fee (dsp_campaign__agency_fee): The agency fee charged
  • DSP Creative: Creative ID (dsp_creative__creative_id): The unique identifier of the creative
  • DSP Line Item: Detail Page Views (dsp_line_item__detail_page_views): Detail page views of promoted products attributed to the ad
  • Data fetched at (data_fetched_at): UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that...
  • DSP Campaign: Amazon DSP Audience Fee (dsp_campaign__amazon_dsp_audience_fee): The Amazon DSP audience fee charged
  • DSP Creative: Creative Language (dsp_creative__creative_language): The language of the creative
  • DSP Line Item: eCPC (dsp_line_item__ecpc): The effective cost per click
  • Data Source (datasource): The name of the Windsor connector returning the row
  • DSP Campaign: Amazon DSP Console Fee (dsp_campaign__amazon_dsp_console_fee): The Amazon DSP console fee charged
  • DSP Creative: Creative Name (dsp_creative__creative_name): The name of the creative
  • DSP Line Item: eCPM (dsp_line_item__ecpm): The effective cost per thousand impressions
  • Day of month (day_of_month): Day of the month
  • DSP Campaign: Brand Searches (dsp_campaign__brand_searches): Brand searches attributed to the ad
  • DSP Creative: Creative Size (dsp_creative__creative_size): The size of the creative

Use Amazon DSP data in ChatGPT and Claude

Windsor.ai is available as a plugin in ChatGPT and as a connector in Claude. Once Amazon DSP is connected to Windsor.ai, you can ask questions about your Amazon DSP data in plain language. Other MCP clients can add the Windsor MCP server at https://mcp.windsor.ai/.

Available destinations for your Amazon DSP data

AI assistants

ChatGPT, Claude, Copilot, Manus, Gemini, Gemini Enterprise, Perplexity, Cursor, Grok, Google Antigravity, Lovable, n8n, Base44, Mistral, Kimi, DeepSeek, AI Insights (any MCP client)

Spreadsheets

Google Sheets, Excel, Airtable

Databases & warehouses

BigQuery, Snowflake, MySQL, PostgreSQL, Supabase, Azure SQL, Redshift, Databricks, Microsoft Fabric, Windsor.ai Cloud Database, Cache Data Store

BI & dashboards

Data Studio, Power BI Desktop: Native, Power BI Desktop: Web, Tableau

File storage

Amazon S3 Storage, Azure Blob Storage

Code

Python/R Code

Popular connectors

Browse all 350+ connectors