ETL X Ads data to Snowflake

Provides access to advertiser account information, including account IDs, names, status, and billing details. Essential for managing and organizing campaigns under different business entities.

Retrieves data on advertising campaigns, such as campaign objectives, budgets, start and end dates, and performance status. Enables tracking and optimization of campaign-level strategies.

Returns details about ad groups within campaigns, including targeting criteria, bid settings, and scheduling. Useful for granular control and analysis of ad delivery.

Fetches information on individual ads, such as creative assets, formats, statuses, and associated metadata. Supports creative performance analysis and management.

Provides reporting metrics and performance data across accounts, campaigns, ad groups, and ads. Includes impressions, clicks, spend, conversions, and other key KPIs for comprehensive analytics.

Accesses audience segments and targeting lists, including custom audiences, lookalike segments, and demographic breakdowns. Facilitates advanced targeting and segmentation strategies.

Delivers details on ad creative assets, such as images, videos, and copy. Enables creative asset management and versioning for campaign optimization.