ETL Display & Video 360 data to ClickHouse

Represents advertiser accounts within Display & Video 360, containing configuration settings, billing information, and access to associated campaigns, creatives, and targeting settings.

Manages campaign-level data, including campaign settings, budgets, flight dates, and links to associated insertion orders and line items.

Handles insertion order details within a campaign, such as budget allocation, scheduling, and delivery settings, serving as a parent to line items.

Defines individual ad buying strategies within an insertion order, specifying targeting, bidding, pacing, and creative assignments.

Stores creative assets and metadata, including formats, dimensions, approval status, and associations with campaigns or line items.

Provides access to available targeting criteria, such as audience segments, geographies, devices, and contextual categories, for precise campaign targeting.

Enables generation and retrieval of performance reports, offering detailed metrics on impressions, clicks, conversions, and spend across various dimensions.