ETL Amazon Ads data to Google Cloud Storage

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

Represents the top-level advertising entities used to organize media spend and targeting strategy. Contains campaign settings such as name, status, budget, start and end dates, bidding strategy, and campaign type.

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 targeting criteria used to match ads to shopper queries or product detail pages. Contains keyword text, match type, bid values, expressions, targeting clauses, and status for both keyword-based and product or audience targeting.

Represents the individual ad creatives or promoted products served within campaigns and ad groups. Contains ad identifiers, creative or ASIN references, review and serving status, and associations to the relevant campaign structure.

Represents aggregated performance data for the actual shopper search queries that triggered ads. Contains metrics such as impressions, clicks, spend, sales, orders, and attributed conversions, typically segmented by date and campaign dimensions.

Represents report endpoints that provide campaign, ad group, keyword, targeting, and advertised product performance for Sponsored Products. Contains time-series metrics used for ETL pipelines, attribution analysis, and marketing performance reporting.