ETL Amazon Ads data to Snowflake

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, or Sponsored Display. Contains campaign settings such as name, status, budget, targeting type, bidding strategy, and start or end dates.

Represents logical groupings of ads within a campaign. Contains ad group identifiers, campaign relationships, default bids, state, and other configuration fields used to organize targeting and creatives.

Represents the targeting criteria used to trigger ads, including keywords, product targets, and audience or contextual targets depending on ad type. Contains bid values, match types, expressions, targeting clauses, and serving status.

Represents the individual ad entities delivered within ad groups. Contains references to promoted ASINs or creatives, ad status, review state, and links to the parent campaign and ad group.

Represents performance reporting data at the search term, keyword, target, campaign, ad group, or ad level. Contains metrics such as impressions, clicks, cost, attributed sales, conversions, and other KPIs used for analytics and optimization.

Represents collections of campaigns grouped for budget control and account organization. Contains portfolio names, states, budget caps, and associations that help manage spend across multiple campaigns.