ETL Amazon Ads data to SQL Server

Represents advertiser accounts and marketplaces available to the authenticated user. Contains profile identifiers, account metadata, country or region information, currency, and permissions used to scope all subsequent API requests.

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

Represents logical groupings of ads and targeting rules within a campaign. Contains ad group identifiers, status, default bids, and links to the parent campaign for performance and configuration analysis.

Represents the individual ad creatives or promoted products delivered within ad groups. Contains ad identifiers, creative or ASIN references, serving status, moderation state, and associations to campaigns and ad groups.

Represents the targeting criteria used to match ads to shopper searches or audiences. Contains keyword text, match type, bids, expressions, product targeting rules, and status fields required for optimization workflows.

Represents performance data for actual shopper queries that triggered ads. Contains metrics such as impressions, clicks, spend, sales, orders, and attributed conversions, making it essential for search term mining and bid optimization.

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