ETL Amazon Ads data to Google BigQuery

Returns the advertiser profiles available to the authenticated user, including account identifiers, country/marketplace, currency, and account type. This endpoint is typically used to discover which Amazon Ads accounts can be queried and to scope subsequent API requests.

Provides campaign-level entities for Sponsored Products, Sponsored Brands, and Sponsored Display, including campaign names, status, budget, targeting type, and serving dates. It is the core structure for organizing advertising activity and performance reporting.

Contains ad group objects that sit within campaigns and define a more granular level of targeting and bid management. Data usually includes ad group identifiers, names, default bids, and state, making it essential for campaign hierarchy modeling.

Returns the individual ads or creatives associated with ad groups and campaigns. This data includes ad identifiers, linked ASINs or creative assets, review status, and delivery state, which is useful for tracking what is actually being served.

Exposes keyword-based and product/category targeting entities used in sponsored advertising. These records typically include match type, bid, expression or target definition, and status, enabling detailed analysis of targeting strategy and performance.

Provides performance data for customer search queries that triggered ads, including impressions, clicks, spend, sales, and conversions. This endpoint is widely used for search term mining, optimization workflows, and attribution analysis.

Delivers aggregated metrics at campaign, ad group, ad, keyword, or target level, depending on the selected report type. Common fields include impressions, clicks, cost, attributed sales, orders, and ROAS, making it the primary source for analytics and BI pipelines.