ETL Reddit Ads data to Amazon Redshift

Represents Reddit Ads accounts and their core metadata, such as account ID, name, status, currency, and timezone. This endpoint is typically the top-level entity used to scope campaigns, billing context, and access permissions.

Contains campaign-level configuration and performance context, including campaign name, objective, status, budget settings, and schedule. Data engineers use this endpoint to model the primary advertising structure and track delivery at the campaign level.

Stores ad group details such as targeting setup, bid strategy, placements, optimization settings, and run dates. It is the key layer between campaigns and ads for analyzing audience segmentation and delivery logic.

Provides the individual ad creatives and their metadata, including ad name, creative type, destination URL, review status, and serving status. This endpoint is essential for joining creative assets with campaign structure and performance data.

Represents the reusable creative assets used in ads, such as image, video, copy, headline, and call-to-action elements. It helps teams analyze creative variations separately from campaign and ad group configuration.

Returns aggregated performance metrics for accounts, campaigns, ad groups, or ads across selected date ranges. Typical fields include impressions, clicks, spend, conversions, CTR, CPC, and other reporting dimensions needed for analytics pipelines.

Contains audience and targeting-related entities, including custom audiences, pixel-based segments, and other addressable user groups available for campaign targeting. This endpoint is useful for modeling activation inputs and audience-based performance analysis.