ETL Amazon Ads data to Amazon Redshift

Represents advertiser accounts and marketplaces available to the authenticated user. Contains profile-level metadata such as account identifiers, country/region, currency, and account type used to scope all other Amazon Ads API requests.

Represents the top-level advertising entities for Sponsored Products, Sponsored Brands, or Sponsored Display. Contains campaign settings such as name, state, budget, targeting type, bidding strategy, and start/end dates.

Represents logical groupings of ads and targeting rules within a campaign. Contains ad group identifiers, names, default bids, status, and the relationship to the parent campaign.

Represents the individual ads or promoted products served within ad groups. Contains creative or product-level references, ad status, review state, and links to the associated campaign and ad group.

Represents the targeting criteria used to match ads to shopper queries or audiences. Includes keyword-based targeting, product targeting, audience targeting, bids, match types, expressions, and serving status.

Represents performance data for actual customer search queries that triggered ads. Contains metrics such as impressions, clicks, spend, sales, orders, and attributed conversions, typically used for optimization and search term mining.

Represents aggregated reporting data at campaign, ad group, ad, keyword, or target level. Contains time-series performance metrics such as impressions, clicks, cost, CTR, CPC, ROAS, sales, and conversions for analytics and ETL pipelines.