ETL Facebook Ads data to Databricks

Represents the core entity for managing advertising on Facebook, containing account-level information such as account ID, currency, status, and user permissions.

Provides access to campaign-level data, including campaign objectives, status, budget, and performance metrics, serving as the top-level structure for organizing ads.

Contains targeting, scheduling, placement, and budget details for groups of ads within a campaign, enabling granular control over audience and delivery settings.

Delivers detailed information about individual ads, including creative assets, status, performance metrics, and associated ad set and campaign references.

Aggregates and returns performance analytics for campaigns, ad sets, or ads, offering metrics such as impressions, clicks, spend, and conversions for reporting and optimization.

Stores and manages ad creative assets, such as images, videos, and text, along with metadata required for rendering ads across Facebook placements.

Handles custom and lookalike audience segments, providing data on audience definitions, sizes, and sources for advanced targeting and retargeting strategies.