ETL Amazon Ads data to Databricks

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

Provides campaign-level metadata and configuration for advertising programs such as Sponsored Products, Sponsored Brands, and Sponsored Display. It includes fields like campaign name, status, budget, targeting type, start and end dates, and portfolio assignment.

Contains ad group entities that organize ads, keywords, and targets within a campaign. This endpoint is used to analyze campaign structure and retrieve settings such as ad group status, default bids, and associated campaign relationships.

Returns individual ad records linked to campaigns and ad groups, including creative or promoted product references and delivery status. It is commonly used to track which ads are active, paused, or archived and to connect performance data to specific ad units.

Provides keyword-based and product or audience targeting definitions used in Amazon Ads campaigns. The data includes match types, bid values, expressions, targeting clauses, and status, making it essential for search term strategy and bid management workflows.

Delivers performance data for customer search queries that triggered ads, typically through asynchronous report generation endpoints. These reports include metrics such as impressions, clicks, spend, sales, orders, and conversions, and are widely used for optimization and attribution analysis.

Provides aggregated performance metrics at the campaign, ad group, ad, keyword, or target level, depending on the report type requested. This is one of the core data sources for ETL pipelines that support marketing dashboards, pacing analysis, and ROI reporting.