ETL Amazon Ads data to ClickHouse

Represents advertiser accounts and marketplaces available to the authenticated user. Contains profile identifiers, account metadata, country or region settings, and serves as the entry point for scoping requests to the correct Amazon Ads account.

Contains the top-level configuration for advertising initiatives across supported ad products. Includes campaign names, status, budget settings, targeting type, start and end dates, and other attributes used to manage delivery and reporting.

Represents logical groupings of ads and targeting rules within a campaign. Stores ad group status, default bids, and relationships to parent campaigns, making it essential for analyzing campaign structure and performance at a more granular level.

Includes keyword-based targeting for search campaigns and product or audience targeting entities where supported. Contains bid values, match types, expressions, targeting clauses, and serving status used to control how ads are matched to shopper intent.

Represents the individual ad creatives or promoted entities delivered within ad groups. Contains ad identifiers, creative status, associated ASINs or products, moderation state, and links between the advertised item and its campaign structure.

Provides catalog-level information for advertised products, such as ASINs, SKUs, titles, and marketplace-specific attributes when available through related endpoints. This data is commonly used to enrich campaign datasets and connect ad performance to product catalogs.

Provides asynchronous access to performance data for campaigns, ad groups, ads, keywords, targets, and search terms. Report outputs typically include impressions, clicks, cost, sales, orders, conversions, and other metrics required for analytics, attribution, and ETL pipelines.