Amazon Ads

Amazon Ads

Generally AvailableETL Sources

Extract data from this source and load it into your data warehouse.

Features

Feature Name	Supported	Notes
OAuth	—
Access Token	—
Full Refresh	✓	Complete data reload
Incremental Sync	✓	Only new/updated records
Distribution Stage	✓	Generally Available
Dynamic Streams	—
Start Date	—
Column Hashing	—

Sync Overview

• Total Streams: 37
• Parent Streams: 30
• Sub-Streams: 7
• Supported Sync Modes: Incremental, Full Refresh

Available Streams

• profile (Incremental)
• sponsored_brand_ad (Full Refresh, Incremental)
  • sponsored_brand_ad_asin
  • sponsored_brand_ad_serving_status_detail
• sponsored_brand_campaign (Full Refresh, Incremental)
• sponsored_brand_campaign_report (Incremental)
• sponsored_brand_keyword (Incremental)
• sponsored_brand_negative_keyword (Incremental)
• sponsored_brand_target (Incremental)
• sponsored_display_ad_group (Full Refresh, Incremental)
• sponsored_display_ad_group_report (Incremental)
• sponsored_display_campaign (Full Refresh, Incremental)
• sponsored_display_campaign_report (Incremental)
• sponsored_display_product_ad (Full Refresh, Incremental)
• sponsored_display_product_ad_report (Incremental)
• sponsored_display_target (Full Refresh, Incremental)
• sponsored_display_target_report (Incremental)
• sponsored_product_ad (Full Refresh, Incremental)
  • sponsored_product_ad_status_detail
• sponsored_product_ad_group (Full Refresh, Incremental)
  • sponsored_product_ad_group_status_detail
• sponsored_product_ad_group_report (Incremental)
• sponsored_product_ad_report (Incremental)
• sponsored_product_auto_search_term_report (Incremental)
• sponsored_product_campaign (Full Refresh, Incremental)
• sponsored_product_campaign_negative_keyword (Full Refresh, Incremental)
  • sponsored_product_campaign_negative_keyword_status_detail
• sponsored_product_campaign_placement_report (Incremental)
• sponsored_product_campaign_report (Incremental)
• sponsored_product_keyword (Full Refresh, Incremental)
  • sponsored_product_keyword_status_detail
• sponsored_product_keyword_report (Incremental)
• sponsored_product_keyword_search_term_report (Incremental)
• sponsored_product_negative_keyword (Full Refresh, Incremental)
  • sponsored_product_negative_keyword_status_detail
• sponsored_product_target_report (Incremental)
• sponsored_product_target_search_term_report (Incremental)

Next Steps

• Setup Guide - Learn how to connect Amazon Ads
• API Configuration - View schema and API details
• Release Notes - See recent changes