How much attributed sales did Amazon Ads drive last month?
Amazon Ads
Amazon Ads attributed $128,450 in sales last month across Sponsored Products and Sponsored Brands.
Via Kondado MCP
You
How did ROAS compare week over week for Sponsored Products?
ROAS
Sponsored Products ROAS rose to 3.42x this week, up from 2.98x the prior week.
Via Kondado MCP
You
Which Amazon Ads search terms spent the most with no orders?
Search terms
The top 5 search terms with no orders consumed $4,780 in spend, led by one term at $1,920.
Via Kondado MCP
You
How many Sponsored Brands campaigns are currently out of budget?
Budget
7 Sponsored Brands campaigns are out of budget today, with 3 of them in the top sales portfolio.
Via Kondado MCP
Works in Claude, ChatGPT and any MCP client
Try out all the features for free for 14 days
AI to analyze Amazon Ads data with Claude and ChatGPT
With Kondado, you can ask Claude, ChatGPT or another MCP client in natural language about Amazon Ads data. Ask which campaigns drove the most attributed sales last month, how ACOS and ROAS changed by portfolio, or which keywords and search terms are spending budget without orders. The assistant reads the Amazon Ads pipelines you connected and replies in the chat, so you can explore Sponsored Products, Sponsored Brands, Sponsored Display, Sponsored TV and Amazon DSP from one conversation.
Kondado exposes Amazon Ads data through an MCP server, so Claude, ChatGPT and other MCP clients can answer questions about 27 Amazon Ads pipelines in chat. The same data also powers ready dashboards in Power BI and Looker Studio.
Marketing analysts, e-commerce managers, and finance or operations teams use this chat experience to check daily spend, compare campaign performance, review budget pacing, and understand which ASINs, keywords, or targets are contributing to sales. They can ask for a campaign status overview, a week-over-week ROAS comparison, or a ranked list of search terms by cost and purchases, then keep the conversation going with follow-up questions. The answers stay grounded in the Amazon Ads data replicated to Kondado on a configurable schedule.
Below you will find the Amazon Ads pipelines available to connect and query in chat. The Sponsored Products report lets you ask which campaigns and search terms produced sales and orders, while the Sponsored Brands report helps compare new-to-brand metrics across campaigns and placements. The Sponsored Display report supports questions about reach, cost and conversions by ad group, and the Amazon DSP report brings advertiser-level event and ROAS metrics into the same conversation. You can also query metadata pipelines such as Sponsored Products - keywords or Sponsored Products - campaigns to check bids, match types, budgets and states. Combining these pipelines lets you move from a high-level ROAS question to the exact keyword or target behind the result, and to compare DSP, Sponsored TV and retail campaign performance in one thread. Automated updates on a configurable schedule keep the answers fresh when you ask again in chat.
How to connect Amazon Ads to Claude, ChatGPT and other AI clients
MCP is an open standard. Add the Kondado server to the connections of Claude (Web or Desktop), ChatGPT, or any other MCP client you use, and authorize via OAuth at app.kondado.com.br. Setup through the UI, no code.
Amazon Ads tables and metrics available via Kondado
Each item below is something Claude, ChatGPT or another MCP client already knows how to query — no schema setup, no manual mapping.
27
Tables
1247
Fields
∞
Ad-hoc questions
Metadata: Amazon DSP - advertisers
Registration of Amazon DSP advertisers, with advertiser ID, name, country, currency, regional-account flag, timezone, URL, and source ad-account profile_id.
Metadata: Amazon DSP - campaigns (orders)
Registration of Amazon DSP campaigns (orders) per advertiser, with identifiers, name, state, delivery status, dates, budget caps, flights, fees, frequencies, country, marketplace, brand, and optimization settings.
Metadata: Amazon DSP - ad groups (line items)
Registry of Amazon DSP ad groups (line items), with profile, advertiser and campaign IDs, name, state, delivery status, dates, budget, bids, optimization, pacing and targeting settings.
Metadata: Advertising accounts (profiles)
Registration of an Amazon Ads advertising account (profile) visible at login, with profile_id, account data (id, marketplace, name, subtype, seller/vendor/agency type, and valid payment method), country, currency, daily budget, and timezone.
Metadata: Portfolios
Registry of each ad account's portfolios, with account and portfolio IDs, name, state, budget amount, currency, start and end dates, policy, unspent-budget sharing setting, and in-budget indicator.
Metadata: Sponsored Brands - ads
Metadata for Sponsored Brands ads, one row per ad identified by ad_key/ad_id, including account, ad group and campaign, creative, landing page, name, state, and creation/update dates and serving status.
Metadata: Sponsored Brands - campaigns
Metadata for one Sponsored Brands campaign per row, with account, campaign and portfolio IDs, name, state, start/end dates, budget and budget type, cost type, goal, KPI, bid optimization/strategy and adjustments, product location, and multi-ad-group flag.
Metadata: Sponsored Brands - ad groups
Metadata for Sponsored Brands ad groups, with profile ID, ad group ID, campaign ID, name, and advertiser-defined state.
Metadata: Sponsored Brands - keywords
Metadata for Sponsored Brands keywords, one row per keyword, with profile, ad group, and campaign IDs, keyword text, match type, bid, and state.
Metadata: Sponsored Display - product ads
Metadata for Sponsored Display product ads, with one row per ad, containing profile_id, ad_id, ad_group_id, ASIN, campaign_id, and state.
Metadata: Sponsored Display - campaigns
One row per Sponsored Display campaign, with account, campaign, and portfolio IDs, name, budget and budget type, cost type, delivery profile, start/end dates, state, tactic, and rule-based budget processing flag.
Metadata: Sponsored Display - ad groups
Metadata for Sponsored Display ad groups, with profile_id, ad_group_id, campaign_id, name, state, default bid, bid optimization, creative type, and tactic.
Metadata: Sponsored Display - targets
Metadata for Sponsored Display targets, with one row per target (audience/product/contextual), containing profile_id, target_id, ad_group_id, campaign_id, bid, expression, expression_type, resolved_expression, and state.
Metadata: Sponsored Products - product ads
Registration of a Sponsored Products product ad, with account, ad, ad group, and campaign identifiers, ASIN, and state.
Metadata: Sponsored Products - campaigns
Registry of Sponsored Products campaigns, with one row per campaign and fields for name, state, budget and budget type, bidding strategy and adjustments, start and end dates, portfolio, targeting type, tags, and off-Amazon settings.
Metadata: Sponsored Products - ad groups
Metadata for Sponsored Products ad groups, with one row per ad group, containing profile ID, ad group ID, campaign ID, default bid, name, and state.
Metadata: Sponsored Products - keywords
Registration of Sponsored Products keywords, with one row per keyword, including profile, keyword, ad group, and campaign IDs, keyword text, match type, bid, and state.
Metadata: Sponsored Products - negative keywords
Registry of Sponsored Products ad group negative keywords, with profile, keyword, ad group, and campaign IDs, keyword text, match type, and state.
Registration of one Sponsored Products campaign negative keyword per row, with profile_id, keyword_id, campaign_id, keyword_text, match_type, and state.
Metadata: Sponsored Products - targets
Registration of a Sponsored Products target (product/category/auto target), with profile_id, target_id, ad_group_id, campaign_id, bid, expression, expression_type, resolved_expression, and state.
Metadata: Sponsored Products - negative targets
Metadata registry of Sponsored Products negative targets, with one row per negative target and fields such as profile_id, target_id, ad_group_id, campaign_id, expression, resolved_expression, and state.
Metadata: Sponsored TV - campaigns
Metadata for one Sponsored TV campaign per row, with profile_id, campaign_id, name, budget and budget type, country, start and end dates, state, and portfolio id.
Sponsored Brands report
Sponsored Brands report at account/date and campaign, ad group, ad, keyword, product, and placement grain, with impressions, clicks, cost, sales, orders, purchases, and new-to-brand metrics.
Sponsored Display report
Daily rows by account, campaign, ad group, and ad for Sponsored Display, with date, country, currency, status, budget, and metrics for impressions, clicks, cost, purchases, sales, reach, and conversions.
Sponsored Products report
Rows from the Sponsored Products report by account, campaign, ad group, ad, keyword/targeting, and search term, with date, impressions, clicks, cost, sales, purchases, ACOS, ROAS, and 1-, 7-, 14-, and 30-day attribution metrics.
Sponsored TV report
Row of the Sponsored TV report by account, date, campaign, ad group, and keyword dimensions, with budget/status and metrics such as impressions, clicks, cost, CTR, CPM, reach/frequency, conversions, new-to-brand, and off-Amazon conversions.
Amazon DSP report
Each row is an Amazon DSP report record at the selected level, detail, and period, with account and advertiser identifiers, date, country, currency, third-party fees, and event/conversion metrics such as add_to_cart, ROAS, and costs.
In 3 steps: connect on Kondado, pick dashboard or chat, analyze.
1
Connect Amazon Ads via Kondado
Sign in at app.kondado.com.br, connect your Amazon Ads account, and choose a Via Kondado destination so your data lands ready for AI access and for the dashboard templates.
2
Add Kondado MCP in Claude or ChatGPT
In Claude Web or Desktop, or in ChatGPT, open the connection settings, add the Kondado MCP server, and authorize once via OAuth at app.kondado.com.br. The setup is GUI-based and the same flow works in both clients, with other MCP clients also supported.
3
Ask Amazon Ads questions in chat
Use natural language to ask about spend, sales, ACOS, ROAS, campaign status, keywords, search terms, or DSP performance, and follow up as needed. For recurring visual monitoring, open a ready Power BI or Looker Studio dashboard template that uses the same data.
Try out all the features for free for 14 days
Other connectors with AI via MCP
Same Kondado data, in chat through Claude, ChatGPT and other MCP clients.
How ready dashboards and chat via Claude / ChatGPT work together with your data via Kondado.
What business questions can Claude answer about Amazon Ads performance?▼
Claude can answer follow-up questions such as why a Sponsored Products campaign's ACOS rose after a bid change, which ad groups are pacing ahead of budget, or which ASINs appear in Sponsored Display ads with the highest reach. You can also compare Sponsored Brands new-to-brand orders by placement or review Amazon DSP event metrics by advertiser. The answers come from the Amazon Ads pipelines connected to your Kondado workspace.
How do I connect Kondado to Claude Web or Claude Desktop?▼
In Claude Web or Claude Desktop, open the connection settings, add the Kondado MCP server, and complete the OAuth authorization at app.kondado.com.br. The same GUI-based setup works in ChatGPT: add the Kondado MCP server in the connection settings and authorize once. The setup does not require code, and other MCP clients can use the same server details.
How does authentication work when I add the Kondado MCP server?▼
You authorize Kondado once through OAuth at app.kondado.com.br after adding the MCP server in Claude or ChatGPT. The authorization links your Kondado workspace to the client, so the chat can read the Amazon Ads pipelines you selected. You can review or update the connection later from the same settings area.
Can the AI change bids, pause campaigns, or write data back to Amazon Ads?▼
No. The chat experience is designed for read-only analysis: Claude or ChatGPT reads the Amazon Ads data replicated to Kondado and answers your questions, while bid changes, campaign pauses, budget edits, and data writes stay in Amazon Ads. You use the chat to investigate performance and decide what to review in Amazon Ads.
How often is the Amazon Ads data updated for chat answers?▼
Kondado replicates Amazon Ads data on a configurable schedule, so the chat answers reflect the latest completed update in your workspace. You can set the cadence that matches your reporting rhythm, from more frequent refreshes to daily updates. When you ask a new question, Claude or ChatGPT reads the current data available in the connected pipelines.
Which dashboard templates can I use with Amazon Ads data?▼
Kondado offers ready dashboard templates for Power BI and Looker Studio, covering Amazon Ads performance views such as spend, sales, ACOS, ROAS, and campaign comparisons. These report templates use the same Amazon Ads pipelines that power the chat experience. The chat experience is for analysis, while the templates give you recurring visual monitoring.
What is the difference between asking Claude in chat and opening a Power BI dashboard?▼
Chat is best for ad hoc questions, follow-ups, and explanations, such as why a Sponsored Brands campaign's ROAS dropped or which search terms deserve a closer look. A ready Power BI or Looker Studio dashboard is better for recurring visual monitoring, sharing a fixed view with stakeholders, and scanning KPIs at a glance. Both use the same Amazon Ads data, so you can move from a dashboard signal to a chat question without changing sources.
Amazon Ads
Via Kondado MCP
