ETL TikTok Ads data to SQL Server

Retrieves information about advertiser accounts, including account status, balance, and account-level settings. Essential for managing and monitoring TikTok Ads accounts.

Provides access to campaign-level data such as campaign names, objectives, budgets, and status. Used to organize and control advertising initiatives.

Returns details about ad groups within campaigns, including targeting settings, bids, schedules, and delivery status. Useful for granular campaign management.

Fetches data on individual ads, such as creative assets, formats, status, and performance metrics. Enables tracking and optimization of ad creatives.

Generates detailed performance reports across campaigns, ad groups, and ads, including key metrics like impressions, clicks, conversions, and spend. Supports analytics and ROI measurement.

Manages custom audience segments for targeting, including uploading and retrieving audience lists. Facilitates precise audience targeting and segmentation.

Handles creative asset management, allowing upload, retrieval, and organization of images, videos, and other ad creatives. Central for creative workflow and ad production.