ETL Facebook Ads data to Google Cloud Storage

Represents the core entity for managing Facebook advertising activities. Contains account-level data such as account ID, name, currency, spending limits, and user permissions.

Provides access to campaign-level data, including campaign objectives, status, budget, and performance metrics. Used to organize and manage groups of ads under a unified strategy.

Contains data related to ad set configuration within a campaign, such as targeting options, bid strategy, schedule, budget allocation, and delivery status.

Represents individual ads within an ad set, including creative assets, ad format, status, and performance metrics. Enables detailed tracking and management of each ad.

Provides aggregated reporting and analytics data across accounts, campaigns, ad sets, and ads. Includes metrics such as impressions, clicks, conversions, and spend for performance analysis.

Stores information about ad creative assets, including images, videos, text, and call-to-action elements. Used to manage and reuse creative components across multiple ads.

Manages custom and lookalike audience segments for targeting, including audience size, source, and type. Facilitates precise ad delivery to relevant user groups.