ETL Display & Video 360 data to Amazon Redshift

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

Manages campaign-level data, including campaign settings, budgets, schedules, and performance metrics, enabling users to organize and optimize digital advertising efforts.

Handles insertion order objects, which define budget allocations, flight dates, and pacing for groups of line items within a campaign, serving as a core financial and scheduling structure.

Contains detailed configuration for individual ad placements, including targeting criteria, bidding strategies, and creative assignments, allowing granular control over campaign delivery.

Stores creative assets and metadata, such as ad formats, dimensions, and approval statuses, supporting the management and deployment of visual and video ads.

Facilitates the generation and retrieval of performance reports, providing aggregated metrics on impressions, clicks, conversions, and spend across various dimensions.

Manages audience segments and targeting lists, enabling advertisers to define and leverage custom or third-party audiences for more effective ad delivery.