ETL Display & Video 360 data to Snowflake

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

Provides access to campaign-level data, including campaign settings, budgets, schedules, and performance metrics, enabling management and reporting of digital advertising initiatives.

Represents insertion orders within a campaign, detailing budget allocation, pacing, flight dates, and delivery status for granular control over media spend.

Contains data on individual line items under an insertion order, specifying targeting criteria, bidding strategies, creatives, and performance outcomes.

Manages creative assets and metadata, including formats, approval status, and associations with campaigns and line items for ad delivery.

Enables the creation and retrieval of custom and standard reports, providing detailed analytics on campaign performance, impressions, clicks, and other key metrics.

Represents partner-level entities, offering access to aggregated data, account management, and configuration options for agencies or holding companies.