# Amazon Ads AI connector guide

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.

Combined offers 1,125 connectors across catalog sources and connectors generated through desktop automation.

## Connect

1. Open Combined Connected Apps and select Amazon Ads.
2. Authorize the source and choose the relevant datasets.
3. Complete a first sync, then grant your agent access through the Set up or Access workspace.
4. Discover the actual source schemas before querying.

## Setup reference

- Client ID: required in the upstream source schema
- Client Secret: required in the upstream source schema
- Look Back Window: optional
- Marketplace IDs: optional
- Number of concurrent threads: optional
- Profile IDs: optional
- Refresh Token: required in the upstream source schema
- Region: optional
- Start Date: optional

## Dataset reference

- profiles; key: profileId
- sponsored_brands_video_report_stream
- sponsored_display_report_stream
- sponsored_brands_report_stream
- sponsored_products_report_stream
- portfolios; key: portfolioId
- sponsored_display_campaigns; key: campaignId
- sponsored_display_ad_groups; key: adGroupId
- sponsored_display_product_ads; key: adId
- sponsored_display_targetings; key: targetId
- sponsored_display_creatives; key: creativeId
- sponsored_display_budget_rules; key: ruleId
- sponsored_brands_keywords; key: adGroupId
- sponsored_brands_campaigns; key: campaignId
- sponsored_brands_ad_groups; key: adGroupId
- sponsored_product_campaigns; key: campaignId
- sponsored_product_ad_groups; key: adGroupId
- sponsored_product_keywords; key: keywordId
- sponsored_product_negative_keywords; key: keywordId
- sponsored_product_campaign_negative_keywords; key: keywordId
- sponsored_product_ads; key: adId
- sponsored_product_targetings; key: targetId
- sponsored_product_ad_group_bid_recommendations
- sponsored_product_ad_group_suggested_keywords
- attribution_report_products
- attribution_report_performance_adgroup
- attribution_report_performance_campaign
- attribution_report_performance_creative
- sponsored_brands_v3_report_stream; key: profileId, reportDate, adGroupName, purchasedAsin; update field: reportDate
- sponsored_brands_campaigns_report_stream; key: profileId, reportDate, campaignId; update field: reportDate
- sponsored_brands_adgroups_report_stream; key: profileId, reportDate, adGroupName, adGroupId; update field: reportDate
- sponsored_display_campaigns_report_stream; key: profileId, reportDate, campaignId; update field: reportDate
- sponsored_display_adgroups_report_stream; key: profileId, reportDate, adGroupName, adGroupId; update field: reportDate
- sponsored_display_productads_report_stream; key: profileId, reportDate, adGroupName, adId; update field: reportDate
- sponsored_display_targets_report_stream; key: profileId, reportDate, adGroupName, targetingId; update field: reportDate
- sponsored_display_asins_report_stream; key: profileId, reportDate, adGroupName, promotedAsin; update field: reportDate
- sponsored_products_campaigns_report_stream; key: profileId, reportDate, campaignId; update field: reportDate
- sponsored_products_adgroups_report_stream; key: profileId, reportDate, adGroupName, adGroupId; update field: reportDate
- sponsored_products_keywords_report_stream; key: profileId, reportDate, adGroupName, keywordId; update field: reportDate
- sponsored_products_targets_report_stream; key: profileId, reportDate, adGroupName, keywordId; update field: reportDate
- sponsored_products_productads_report_stream; key: profileId, reportDate, adGroupName, adId; update field: reportDate
- sponsored_products_asins_keywords_report_stream; key: profileId, reportDate, adGroupName, advertisedAsin; update field: reportDate
- sponsored_products_asins_targets_report_stream; key: profileId, reportDate, adGroupName, advertisedAsin; update field: reportDate
- sponsored_brands_v3_report_stream_daily; key: profileId, date, adGroupName, purchasedAsin; update field: date
- sponsored_brands_campaigns_report_stream_daily; key: profileId, date, campaignId; update field: date
- sponsored_brands_adgroups_report_stream_daily; key: profileId, date, adGroupName, adGroupId; update field: date
- sponsored_display_campaigns_report_stream_daily; key: profileId, date, campaignId; update field: date
- sponsored_display_adgroups_report_stream_daily; key: profileId, date, adGroupName, adGroupId; update field: date
- sponsored_display_productads_report_stream_daily; key: profileId, date, adGroupName, adId; update field: date
- sponsored_display_targets_report_stream_daily; key: profileId, date, adGroupName, targetingId; update field: date
- sponsored_display_asins_report_stream_daily; key: profileId, date, adGroupName, promotedAsin; update field: date
- sponsored_products_campaigns_report_stream_daily; key: profileId, date, campaignId; update field: date
- sponsored_products_adgroups_report_stream_daily; key: profileId, date, adGroupName, adGroupId; update field: date
- sponsored_products_keywords_report_stream_daily; key: profileId, date, adGroupName, keywordId; update field: date
- sponsored_products_targets_report_stream_daily; key: profileId, date, adGroupName, keywordId; update field: date
- sponsored_products_productads_report_stream_daily; key: profileId, date, adGroupName, adId; update field: date
- sponsored_products_asins_keywords_report_stream_daily; key: profileId, date, adGroupName, advertisedAsin; update field: date
- sponsored_products_asins_targets_report_stream_daily; key: profileId, date, adGroupName, advertisedAsin; update field: date

This is the upstream connector reference, version 9.0.7. Account permissions and sync configuration determine the datasets available in your workspace.

## Agent prompt

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.

## Links

- Combined: https://www.trycombined.com/
- Setup: https://www.trycombined.com/docs/getting-started/onboarding
- MCP: https://www.trycombined.com/docs/integrations/mcp
- Pricing: https://www.trycombined.com/pricing
- Upstream source reference: https://docs.airbyte.com/integrations/sources/amazon-ads
- Full guide: https://www.trycombined.com/connectors/amazon-ads