ETL Reddit Ads data to SQL Server

Returns the advertiser accounts available to the authenticated user. It includes core account-level metadata such as account ID, name, status, currency, and business settings used to organize Reddit Ads data.

Provides campaign-level objects that define the main advertising structure within an account. This endpoint typically contains campaign names, objectives, status, budget configuration, schedule, and associated account references.

Returns ad groups nested under campaigns, where delivery and targeting settings are commonly managed. Data usually includes bidding strategy, optimization settings, audience targeting, placements, schedule, and status.

Provides the individual ads or creatives delivered within ad groups. It contains ad-level metadata such as creative name, format, destination URL, approval status, and links to the parent ad group and campaign.

Returns reusable creative assets used in Reddit Ads, including text, images, videos, and post-based ad content. This endpoint is useful for analyzing creative variations, asset metadata, and moderation or review states.

Provides targeting configuration associated with ad groups or campaigns, depending on the setup. It typically includes audience criteria such as geography, device, interests, communities, demographics, and custom audience references.

Returns performance and delivery metrics for accounts, campaigns, ad groups, or ads over a selected date range. This endpoint is commonly used for analytics pipelines and includes measures such as impressions, clicks, spend, conversions, CTR, and CPC.