Connect Amazon Ads to your AI agents.
Connect Amazon Ads data to AI agents with Combined. Explore profiles, sponsored brands video report stream, sponsored display report stream, source setup, MCP access and read-only business queries.
Put Amazon Ads records to work in the agent you already use. Combined syncs business data into a managed data layer and exposes scoped, read-only queries through MCP.
Start with 5 million MAR without a card; usage after the trial is $5 per million MAR, with no monthly minimum. Combined offers 1,125 connectors across catalog sources and connectors generated through desktop automation.
How to connect Amazon Ads to Combined
- Add your source. Open Connected Apps in Combined and select Amazon Ads. Use the account or workspace that contains the records you want to analyze.
- Authorize access. Complete the connection flow and choose the required permissions. The setup reference below shows the upstream source's configurable fields; the Combined flow may handle some of them for you.
- Select datasets and sync. Choose the relevant data, set any available history filters, and wait for the first successful sync.
- Grant your agent access. Use the Set up or Access workspace to connect your agent through MCP and scope it to the sources it needs.
- Ask a first question. Discover the synced schema, check freshness, and run a bounded read-only query. Then add another source for a cross-app analysis.
The onboarding guide covers the workspace flow. Prepare these Amazon Ads settings before connecting:
| Setting | When needed | Input |
|---|---|---|
| Client ID | Required by source schema | Credential entered in the connection flow |
| Client Secret | Required by source schema | Credential entered in the connection flow |
| Look Back Window | Optional | integer |
| Marketplace IDs | Optional | array |
| Number of concurrent threads | Optional | integer |
| Profile IDs | Optional | array |
| Refresh Token | Required by source schema | Credential entered in the connection flow |
| Region | Optional | string |
| Start Date | Optional | string |
Authentication choices are alternatives. Supply the settings for your selected method; enter credentials in the connection flow, rather than in an agent prompt.
Amazon Ads datasets you can evaluate
This reference comes from the upstream source catalog and connector definition, version 9.0.7. Your account permissions, selected streams and successful sync determine what your agent can query. Discover the actual table and field names in Combined before writing SQL.
| Dataset | Record key | Update field | Example fields |
|---|---|---|---|
profiles | profileId | Inspect sync configuration | profileId, countryCode, currencyCode, dailyBudget, timezone (6 fields in reference) |
sponsored_brands_video_report_stream | Inspect schema | Inspect sync configuration | Discover in your workspace |
sponsored_display_report_stream | Inspect schema | Inspect sync configuration | Discover in your workspace |
sponsored_brands_report_stream | Inspect schema | Inspect sync configuration | Discover in your workspace |
sponsored_products_report_stream | Inspect schema | Inspect sync configuration | Discover in your workspace |
portfolios | portfolioId | Inspect sync configuration | portfolioId, name, budget, inBudget, state (8 fields in reference) |
sponsored_display_campaigns | campaignId | Inspect sync configuration | campaignId, name, budgetType, budget, startDate (11 fields in reference) |
sponsored_display_ad_groups | adGroupId | Inspect sync configuration | name, campaignId, adGroupId, defaultBid, bidOptimization (8 fields in reference) |
sponsored_display_product_ads | adId | Inspect sync configuration | state, adId, campaignId, adGroupId, asin (6 fields in reference) |
sponsored_display_targetings | targetId | Inspect sync configuration | targetId, adGroupId, state, expressionType, bid (8 fields in reference) |
sponsored_display_creatives | creativeId | Inspect sync configuration | adGroupId, creativeId, creativeType, properties, moderationStatus |
sponsored_display_budget_rules | ruleId | Inspect sync configuration | ruleId, ruleStatus, ruleState, lastUpdatedDate, createdDate (7 fields in reference) |
sponsored_brands_keywords | adGroupId | Inspect sync configuration | campaignId, adGroupId, name, state, extendedData |
sponsored_brands_campaigns | campaignId | Inspect sync configuration | campaignId, name, tags, budget, budgetType (16 fields in reference) |
sponsored_brands_ad_groups | adGroupId | Inspect sync configuration | campaignId, adGroupId, name, state, extendedData |
sponsored_product_campaigns | campaignId | Inspect sync configuration | portfolioId, campaignId, name, tags, targetingType (11 fields in reference) |
sponsored_product_ad_groups | adGroupId | Inspect sync configuration | adGroupId, name, campaignId, defaultBid, state (6 fields in reference) |
sponsored_product_keywords | keywordId | Inspect sync configuration | keywordId, campaignId, adGroupId, state, keywordText (7 fields in reference) |
sponsored_product_negative_keywords | keywordId | Inspect sync configuration | keywordId, campaignId, adGroupId, state, keywordText (7 fields in reference) |
sponsored_product_campaign_negative_keywords | keywordId | Inspect sync configuration | keywordId, campaignId, adGroupId, state, keywordText (6 fields in reference) |
sponsored_product_ads | adId | Inspect sync configuration | adId, campaignId, customText, asin, state (8 fields in reference) |
sponsored_product_targetings | targetId | Inspect sync configuration | expression, targetId, resolvedExpression, campaignId, expressionType (9 fields in reference) |
sponsored_product_ad_group_bid_recommendations | Inspect schema | Inspect sync configuration | adGroupId, campaignId, theme, bidRecommendationsForTargetingExpressions |
sponsored_product_ad_group_suggested_keywords | Inspect schema | Inspect sync configuration | adGroupId, campaignId, keyword, recId, translation (9 fields in reference) |
attribution_report_products | Inspect schema | Inspect sync configuration | date, brandName, marketplace, campaignId, productAsin (37 fields in reference) |
attribution_report_performance_adgroup | Inspect schema | Inspect sync configuration | date, brandName, marketplace, campaignId, productAsin (37 fields in reference) |
attribution_report_performance_campaign | Inspect schema | Inspect sync configuration | date, brandName, marketplace, campaignId, productAsin (37 fields in reference) |
attribution_report_performance_creative | Inspect schema | Inspect sync configuration | date, brandName, marketplace, campaignId, productAsin (37 fields in reference) |
sponsored_brands_v3_report_stream | profileId + reportDate + adGroupName + purchasedAsin | reportDate | profileId, reportDate, attributionType, campaignName, newToBrandSales14d (18 fields in reference) |
sponsored_brands_campaigns_report_stream | profileId + reportDate + campaignId | reportDate | profileId, reportDate, campaignBudgetCurrencyCode, campaignId, campaignName (20 fields in reference) |
sponsored_brands_adgroups_report_stream | profileId + reportDate + adGroupName + adGroupId | reportDate | profileId, reportDate, campaignBudgetCurrencyCode, campaignId, campaignName (19 fields in reference) |
sponsored_display_campaigns_report_stream | profileId + reportDate + campaignId | reportDate | profileId, reportDate, campaignId, addToCart, addToCartClicks (66 fields in reference) |
sponsored_display_adgroups_report_stream | profileId + reportDate + adGroupName + adGroupId | reportDate | profileId, reportDate, adGroupId, addToCart, addToCartClicks (66 fields in reference) |
sponsored_display_productads_report_stream | profileId + reportDate + adGroupName + adId | reportDate | profileId, reportDate, adId, addToCart, addToCartRate (69 fields in reference) |
sponsored_display_targets_report_stream | profileId + reportDate + adGroupName + targetingId | reportDate | profileId, reportDate, targetingId, addToCart, addToCartClicks (61 fields in reference) |
sponsored_display_asins_report_stream | profileId + reportDate + adGroupName + promotedAsin | reportDate | profileId, reportDate, promotedAsin, adGroupId, adGroupName (27 fields in reference) |
sponsored_products_campaigns_report_stream | profileId + reportDate + campaignId | reportDate | profileId, reportDate, campaignId, campaignName, campaignStatus (36 fields in reference) |
sponsored_products_adgroups_report_stream | profileId + reportDate + adGroupName + adGroupId | reportDate | profileId, reportDate, adGroupId, campaignName, campaignId (33 fields in reference) |
sponsored_products_keywords_report_stream | profileId + reportDate + adGroupName + keywordId | reportDate | profileId, reportDate, keywordId, campaignName, campaignId (36 fields in reference) |
sponsored_products_targets_report_stream | profileId + reportDate + adGroupName + keywordId | reportDate | profileId, reportDate, keywordId, campaignName, campaignId (37 fields in reference) |
sponsored_products_productads_report_stream | profileId + reportDate + adGroupName + adId | reportDate | profileId, reportDate, adId, campaignName, campaignId (36 fields in reference) |
sponsored_products_asins_keywords_report_stream | profileId + reportDate + adGroupName + advertisedAsin | reportDate | profileId, reportDate, advertisedAsin, campaignName, campaignId (25 fields in reference) |
sponsored_products_asins_targets_report_stream | profileId + reportDate + adGroupName + advertisedAsin | reportDate | profileId, reportDate, advertisedAsin, campaignName, campaignId (26 fields in reference) |
sponsored_brands_v3_report_stream_daily | profileId + date + adGroupName + purchasedAsin | date | date, profileId, reportDate, attributionType, campaignName (19 fields in reference) |
sponsored_brands_campaigns_report_stream_daily | profileId + date + campaignId | date | date, profileId, reportDate, campaignBudgetCurrencyCode, campaignId (21 fields in reference) |
sponsored_brands_adgroups_report_stream_daily | profileId + date + adGroupName + adGroupId | date | date, profileId, reportDate, campaignBudgetCurrencyCode, campaignId (20 fields in reference) |
sponsored_display_campaigns_report_stream_daily | profileId + date + campaignId | date | date, profileId, reportDate, campaignId, addToCart (65 fields in reference) |
sponsored_display_adgroups_report_stream_daily | profileId + date + adGroupName + adGroupId | date | date, profileId, reportDate, adGroupId, addToCart (65 fields in reference) |
sponsored_display_productads_report_stream_daily | profileId + date + adGroupName + adId | date | date, profileId, reportDate, adId, addToCart (68 fields in reference) |
sponsored_display_targets_report_stream_daily | profileId + date + adGroupName + targetingId | date | date, profileId, reportDate, targetingId, addToCart (60 fields in reference) |
sponsored_display_asins_report_stream_daily | profileId + date + adGroupName + promotedAsin | date | date, profileId, reportDate, promotedAsin, adGroupId (26 fields in reference) |
sponsored_products_campaigns_report_stream_daily | profileId + date + campaignId | date | date, profileId, reportDate, campaignId, campaignName (37 fields in reference) |
sponsored_products_adgroups_report_stream_daily | profileId + date + adGroupName + adGroupId | date | date, profileId, reportDate, adGroupId, campaignName (34 fields in reference) |
sponsored_products_keywords_report_stream_daily | profileId + date + adGroupName + keywordId | date | date, profileId, reportDate, keywordId, campaignName (37 fields in reference) |
sponsored_products_targets_report_stream_daily | profileId + date + adGroupName + keywordId | date | date, profileId, reportDate, keywordId, campaignName (38 fields in reference) |
sponsored_products_productads_report_stream_daily | profileId + date + adGroupName + adId | date | date, profileId, reportDate, adId, campaignName (37 fields in reference) |
sponsored_products_asins_keywords_report_stream_daily | profileId + date + adGroupName + advertisedAsin | date | date, profileId, reportDate, advertisedAsin, campaignName (26 fields in reference) |
sponsored_products_asins_targets_report_stream_daily | profileId + date + adGroupName + advertisedAsin | date | date, profileId, reportDate, advertisedAsin, campaignName (27 fields in reference) |
A cursor tracks changes for a source stream. It is not automatically the right date for a business metric: invoice date, close date and record-update date can answer different questions.
Useful Amazon Ads questions for your AI agent
Start with the datasets you have granted. These prompts turn the referenced schema into checks and summaries; the agent should verify each field against your synced data.
- Count distinct profiles using profileId and check for duplicate keys.
- Describe the sponsored brands video report stream fields, then count the available records and identify a useful grouping field.
- Describe the sponsored display report stream fields, then count the available records and identify a useful grouping field.
- Describe the sponsored brands report stream fields, then count the available records and identify a useful grouping field.
Combine Amazon Ads with another business app
Connect the second source, identify a maintained customer, account or project mapping, and aggregate each dataset before joining. Keep unmatched records visible and define the reporting window. The CRM-and-billing worked example includes runnable SQL demonstrating how a many-to-many join can double the result.
Use Amazon Ads data in Claude Code, Cursor or another MCP client
Once the source is synced, the agent connects to Combined's MCP interface. Use the generated account-specific configuration from your workspace, keep credentials local, and grant only the sources needed for the task. Follow the Claude Code walkthrough or the MCP setup reference.
Use Combined to analyze my Amazon Ads data.
List my granted sources, discover the datasets and describe their fields.
Look for datasets corresponding to profiles, sponsored_brands_video_report_stream, sponsored_display_report_stream, sponsored_brands_report_stream, sponsored_products_report_stream, portfolios.
Check the last successful sync and report the available date coverage.
Propose three useful questions based on the fields actually available.
For the question I choose, run read-only SQL over the complete matching dataset.
Use a bounded result; include source names, time window and query receipt.
Ask for a missing join key or metric definition instead of inventing one.Download this Amazon Ads guide as Markdown to use alongside your agent instructions.
Which Amazon Ads connection fits the task?
Managed data for complete questions across apps
Choose Combined when you want to analyze synced records, calculate totals, or join Amazon Ads with other business data without operating a separate ingestion and query stack. The agent works with your source grants and read-only SQL access.
Application tools for live operations
For a task that must change Amazon Ads immediately, evaluate its available API, native agent tools or desktop workflow. Keep application-action permissions separate from read-only analytics access. A live lookup and an aggregate over synced history solve different jobs.
Desktop-generated connectors for workflows beyond the catalog
Combined's 1,125-connector coverage includes connections generated through computer use. Choose this route when the workflow depends on an application's desktop or browser interface, and establish the fields, access and refresh behavior for that connection.
Read the direct MCP versus managed data comparison and compare business-data MCP options.
Troubleshoot your Amazon Ads connection
- Authorization fails: check the selected authentication method, credential validity, source permissions and target account.
- History is missing: check the source's start-date or history filter and allow the initial sync to finish before comparing totals.
- A dataset is absent: check whether it is enabled and permitted for your account, then inspect discovery and sync status.
- The agent cannot query it: confirm the source is included in the agent's grant and that its sync succeeded.
- A total looks wrong: inspect record keys, duplicate rows, time zones, currencies and join fanout before changing the prompt.
Source details reviewed September 10, 2026. Amazon Ads upstream connector documentation · Versioned connector definition. See also Combined Sources and data freshness for AI agents.