ETL X Ads data to Amazon Redshift

Provides access to advertiser account details, including account IDs, names, status, and billing information. Essential for managing and organizing campaign data at the account level.

Retrieves information about advertising campaigns, such as campaign IDs, names, objectives, budgets, and status. Useful for tracking campaign performance and structure.

Returns data on ad groups within campaigns, including ad group IDs, targeting criteria, bids, and scheduling. Enables granular control and analysis of ad delivery.

Fetches details about individual ads, such as creative assets, formats, status, and associated ad group or campaign. Critical for creative performance analysis.

Provides aggregated performance metrics across accounts, campaigns, ad groups, and ads. Includes impressions, clicks, spend, conversions, and other key KPIs for reporting and optimization.

Accesses audience segments and targeting lists, including custom and lookalike audiences. Supports audience management and targeting strategies.

Delivers information on creative assets used in ads, such as images, videos, and copy. Useful for creative management and compliance tracking.