ETL X Ads data to SQL Server

Retrieves information about advertiser accounts, including account IDs, names, status, and associated billing details. Essential for managing and organizing campaign data across multiple advertisers.

Provides access to campaign-level data such as campaign IDs, names, objectives, budgets, status, and scheduling. Enables tracking and management of advertising initiatives.

Returns details about ad groups within campaigns, including targeting criteria, bid strategies, budgets, and performance metrics. Useful for granular optimization and reporting.

Delivers data on individual ads, including creative assets, formats, statuses, and performance indicators. Supports creative analysis and A/B testing workflows.

Fetches information on ad creatives such as images, videos, copy, and call-to-action elements. Facilitates creative management and compliance checks.

Provides aggregated analytics and performance metrics across accounts, campaigns, ad groups, and ads. Enables comprehensive reporting and data-driven decision-making.

Returns data on audience segments, including custom and lookalike audiences, demographic breakdowns, and targeting parameters. Supports audience analysis and segmentation strategies.