ETL Facebook Ads data to Amazon S3

Represents the core entity for managing advertising on Facebook. Contains account-level details 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 track high-level advertising initiatives.

Contains targeting, scheduling, bidding, and placement settings for groups of ads within a campaign. Enables granular control over audience segmentation and budget allocation.

Delivers detailed information about individual ads, including creative assets, ad format, status, and associated performance metrics such as impressions and clicks.

Provides aggregated analytics and performance data across accounts, campaigns, ad sets, and ads. Includes metrics like reach, conversions, cost, and engagement, supporting in-depth reporting.

Stores creative assets and configurations used in ads, such as images, videos, text, and call-to-action elements. Facilitates creative management and reuse across campaigns.

Manages custom and lookalike audience segments for targeting, including data on audience size, source, and type. Supports advanced audience management and retargeting strategies.