ETL X Ads data to ClickHouse

Retrieves information about advertiser accounts, including account IDs, names, statuses, and billing details. Essential for managing and organizing campaign data at the account level.

Provides access to campaign-level data such as campaign IDs, names, objectives, budgets, and status. Enables tracking and management of advertising initiatives.

Returns details about ad groups within campaigns, including targeting criteria, bid strategies, and scheduling. Useful for granular control and analysis of ad delivery.

Fetches creative-level data, including ad copy, media assets, formats, and performance metrics. Supports creative optimization and reporting.

Delivers aggregated performance metrics such as impressions, clicks, conversions, and spend across various entities (accounts, campaigns, ads). Critical for reporting and ROI analysis.

Provides access to audience segments used for targeting, including custom and lookalike audiences, demographic data, and audience sizes.

Returns details about creative assets, including images, videos, and associated metadata. Facilitates asset management and creative performance tracking.