ETL Facebook Ads data to Snowflake

Represents the main container for all advertising activity, including account details, billing information, and permissions. Essential for managing campaigns, ads, and user access.

Contains information about individual ad campaigns, such as objectives, status, budget, and scheduling. Used to organize and track high-level marketing initiatives.

Defines targeting, placement, budget, and schedule settings within a campaign. Ad sets allow for granular control over audience segmentation and delivery parameters.

Stores creative assets and configuration details for individual ads, including format, copy, media, and destination URLs. Each ad is linked to an ad set.

Provides performance metrics and analytics for accounts, campaigns, ad sets, and ads. Includes data such as impressions, clicks, conversions, and spend, enabling in-depth reporting and optimization.

Manages custom and lookalike audiences used for targeting ads. Contains data on audience definitions, sources, and estimated reach.

Holds reusable creative assets like images, videos, and templates. Enables efficient management and deployment of ad content across multiple campaigns.