ETL Google Ads data to ClickHouse

Represents Google Ads accounts and contains metadata such as account name, status, currency, and time zone. Essential for managing account-level settings and access.

Provides detailed information about advertising campaigns, including campaign type, status, budget, and targeting settings. Used to organize and manage ad spend and strategy.

Represents groups of ads within a campaign, containing details like ad group status, type, and bid settings. Facilitates granular control over ad targeting and performance.

Contains individual ad creatives and their properties, such as headlines, descriptions, URLs, and status. Enables management and analysis of ad content and variations.

Stores keyword targeting data, including match types, status, and performance metrics. Critical for optimizing search relevance and campaign effectiveness.

Provides access to aggregated performance data across various entities like campaigns, ad groups, and keywords. Supports custom queries for analytics and data extraction.

Tracks and manages conversion actions, capturing data on user interactions that are valuable to the business, such as purchases or sign-ups.