With Kondado, you can replicate Amazon Ads performance data and account metadata into the destination you use for analysis. The available pipelines cover Sponsored Products, Sponsored Brands, Sponsored Display, Sponsored TV, and Amazon DSP, with metrics such as impressions, clicks, cost, attributed sales, orders, ACOS, ROAS, reach, frequency, and conversion events. You can analyze results by account, campaign, ad group, ad, keyword, search term, placement, and portfolio, and use metadata pipelines for profiles, portfolios, campaigns, ad groups, ads, keywords, targets, and negative keywords.
Kondado provides 27 Amazon Ads pipelines with 1,247 fields, covering Sponsored Products, Sponsored Brands, Sponsored Display, Sponsored TV, and Amazon DSP. The available data includes performance reports plus metadata for profiles, portfolios, campaigns, ad groups, ads, keywords, targets, and negative keywords, so teams can analyze cost, sales, ACOS, ROAS, and attribution metrics in one place.
Marketing teams can monitor ACOS and ROAS by campaign, ad group, and search term, while analysts build cross-format views that compare Sponsored Products, Sponsored Brands, Sponsored Display, and Amazon DSP performance. Operations teams can track budgets, portfolio spend, keyword bids, match types, targeting expressions, and negative keyword coverage. Ecommerce and marketplace teams can connect advertising performance to the products and campaigns they manage, making it easier to prioritize spend and improve campaign structure.
The Kondado platform takes care of refreshing Amazon Ads data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing Amazon Ads data with AI (Claude, ChatGPT and MCP) or in your report, spreadsheet, data warehouse, data lake, or database
Try out all the features for free for 14 days
The pipelines below give you a detailed view of Amazon Ads performance and account structure, with options for both reporting metrics and metadata registries. The Sponsored Products report shows impressions, clicks, cost, sales, purchases, ACOS, ROAS, and 1-, 7-, 14-, and 30-day attribution by campaign, ad group, ad, keyword or targeting, and search term. The Sponsored Brands report adds campaign, ad group, ad, keyword, product, and placement grain, including new-to-brand metrics, while the Amazon DSP report brings advertiser-level event and conversion metrics such as add_to_cart, ROAS, costs, and third-party fees. The Metadata: Portfolios pipeline helps you group spend and performance by portfolio, and the Metadata: Sponsored Products - keywords pipeline adds keyword text, match type, bid, and state for deeper keyword analysis. Combining these pipelines lets you compare performance across ad formats, connect campaign metadata to daily metrics, and analyze budgets, bids, and targeting in the same reporting layer. With updates on a configurable schedule from every 5 minutes to daily, you can keep KPI monitoring current for ACOS, ROAS, spend, and attributed sales.
Connector schema
Available Amazon Ads data
27
available pipelines
1247
extractable fields
Available integrations
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.
Connect Amazon Ads to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, or databases — no code required.
1
Add the Amazon Ads data source
Sign in with Login with Amazon through the OAuth flow, authorize access, and select the advertising profiles you want Kondado to use.
2
Select pipelines and destinations
Choose the Amazon Ads pipelines to replicate, then send them to Google Sheets, BigQuery, PostgreSQL, or other destinations such as MySQL, Excel, Redshift, SQL Server, and Amazon S3.
Find answers to common questions about connecting Amazon Ads to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, and databases
What Amazon Ads data can I access through Kondado?▼
You can access Sponsored Products, Sponsored Brands, Sponsored Display, Sponsored TV, and Amazon DSP performance pipelines, plus metadata pipelines for profiles, portfolios, campaigns, ad groups, ads, keywords, targets, and negative keywords. Metrics include impressions, clicks, cost, sales, orders, purchases, ACOS, ROAS, reach, frequency, and attribution windows. This data supports analysis by account, campaign, ad group, ad, keyword, search term, placement, and portfolio.
How do I connect Amazon Ads to Kondado?▼
Add the Amazon Ads data source in Kondado and sign in with Login with Amazon through the OAuth flow. After you authorize access, select the advertising profiles you want to use and choose the pipelines you want to replicate. No code is required, and you can send the selected data to your preferred destination.
How often does Kondado update Amazon Ads data?▼
Kondado updates Amazon Ads data on a configurable schedule that ranges from every 5 minutes to daily. You can choose a cadence that matches your campaign optimization rhythm, from frequent checks during active launches to daily refreshes for executive reporting. This helps keep ACOS, ROAS, spend, and attributed sales visible in your destination.
Can I build custom dashboards with Amazon Ads data?▼
Yes, you can send Amazon Ads pipelines to Looker Studio or Power BI and build custom dashboards for your team. Common views include ACOS and ROAS by campaign, spend by portfolio, search term performance, and Sponsored Products versus Sponsored Brands comparisons. You can also blend Amazon DSP metrics with retail ad performance for a broader advertising view.
Which BI tools and databases can I send Amazon Ads data to?▼
You can send Amazon Ads data to Power BI, Looker Studio, Google Sheets, BigQuery, and PostgreSQL. Other destinations include MySQL, Excel, Redshift, SQL Server, and Amazon S3. This makes it easy to support dashboarding, spreadsheet analysis, and database modeling from the same Amazon Ads pipelines.
Can I analyze search terms and keyword performance outside Amazon Ads?▼
Yes, the Sponsored Products report includes keyword or targeting and search term grain, with impressions, clicks, cost, sales, purchases, ACOS, ROAS, and attribution metrics. You can combine it with the Metadata: Sponsored Products - keywords pipeline to review keyword text, match type, bid, and state, and with negative keyword pipelines to check coverage. This helps you find high-cost search terms, compare match types, and refine bids using your own reporting logic.
How can I monitor ACOS and ROAS by campaign and portfolio?▼
Combine the Sponsored Products report, Sponsored Brands report, and Sponsored Display report with the Metadata: Portfolios and campaign metadata pipelines. You can then group spend, sales, ACOS, and ROAS by portfolio, campaign, and date in Looker Studio, Power BI, or a database destination. This gives marketing and finance teams a shared view of efficiency across ad formats and budget owners.
What Amazon DSP data is available in Kondado?▼
Kondado includes the Amazon DSP report plus metadata pipelines for Amazon DSP advertisers, campaigns (orders), and ad groups (line items). The report provides account and advertiser identifiers, date, country, currency, third-party fees, and event or conversion metrics such as add_to_cart, ROAS, and costs. You can use the metadata pipelines to analyze delivery status, budgets, flights, fees, frequencies, optimization settings, and targeting settings alongside performance.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
