Table

Grain

Full load supported

Description

campaigns

One row per campaign

Yes

Campaign metadata (see below). Full Replication

ads

One row per ad

Yes

Ad metadata (see below). Full Replication

report_1

Report grain (defined by your breakdowns)

No (incremental only)

The performance/insights report. Columns are auto-generated from the breakdowns and fields you selected. Uses the lookback window to refresh recent data.

Column

Data Type

Description

id

STRING (PK)

Unique campaign identifier assigned by Reddit.

ad_account_id

STRING

ID of the ad account the campaign belongs to.

name

STRING

Campaign name as set by the advertiser.

objective

STRING

Campaign Objective

funding_instrument_id

STRING

ID of the funding instrument (payment method) financing the campaign.

effective_status

STRING

System-computed delivery status accounting for parent/child and account state (e.g., ACTIVE, PAUSED, COMPLETED).

configured_status

STRING

Status explicitly set by the advertiser (e.g., ACTIVE, PAUSED, ARCHIVED, DELETED).

created_at

TIMESTAMP

When the campaign was created (ISO 8601).

modified_at

TIMESTAMP

When the campaign was last modified (ISO 8601).

special_ad_categories

STRING

Regulated ad categories declared for the campaign (e.g., housing, employment, credit); empty when none.

age_restriction

STRING

Age-based targeting/eligibility restriction applied to the campaign.

is_campaign_budget_optimization

BOOLEAN

true if Campaign Budget Optimization (CBO) is enabled — budget is optimized across ad groups.

conversion_pixel_id

STRING

ID of the conversion (Reddit Pixel) tracking event tied to the campaign.

is_max

BOOLEAN

Whether the campaign uses Reddit's max-delivery / maximization setting.

delivery_status

STRING

Reason(s) affecting delivery (e.g., budget exhausted, under review, no active ads).

goal_value

NUMERIC

Numeric value of the campaign goal (e.g., budget cap or target amount) in the account currency's minor units.

goal_type

STRING

Type of campaign goal (e.g., LIFETIME_SPEND, DAILY_SPEND, NONE).

bid_strategy

STRING

Bidding strategy (e.g., MAXIMIZE_VOLUME, BIDDABLE, MANUAL_BIDDING, TARGET_CPX).

bid_type

STRING

Bid type / billing event the bid applies to (e.g., CPC, CPM, CPV).

end_time

TIMESTAMP

Scheduled end time of the campaign (ISO 8601); null if open-ended.

optimization_goal

STRING

The event the campaign optimizes delivery toward (e.g., CLICKS, CONVERSIONS, IMPRESSIONS).

start_time

TIMESTAMP

Scheduled start time of the campaign (ISO 8601).

view_through_conversion_type

STRING

View-through attribution setting applied to conversions for the campaign.

bid_value

NUMERIC

Bid amount (in the account currency's minor units) when manual/target bidding is used.

Column

Data Type

Description

id

STRING (PK)

Unique ad identifier assigned by Reddit.

ad_account_id

STRING

ID of the ad account the ad belongs to.

ad_group_id

STRING

ID of the parent ad group.

campaign_id

STRING

ID of the parent campaign.

click_url

STRING

Destination URL the ad clicks through to.

name

STRING

Ad name as set by the advertiser.

post_id

STRING

ID of the underlying Reddit post used as the ad creative.

post_url

STRING

Permalink URL of the underlying Reddit post.

profile_id

STRING

ID of the Reddit profile/account the ad is published under.

effective_status

STRING

System-computed delivery status of the ad (e.g., ACTIVE, PAUSED, PENDING, REJECTED).

configured_status

STRING

Status explicitly set by the advertiser (e.g., ACTIVE, PAUSED, ARCHIVED, DELETED).

created_at

TIMESTAMP

When the ad was created (ISO 8601).

modified_at

TIMESTAMP

When the ad was last modified (ISO 8601).

delivery_status

STRING

Reason(s) affecting the ad's delivery (e.g., under review, rejected, parent paused).

shopping_creative

RECORD

Nested object holding shopping/catalog creative details (products, catalog references).

click_url_query_parameters

RECORD

Nested list of key/value query parameters appended to the click URL (e.g., UTM tags). Flattened or stored as JSON depending on the "Loading Nested Objects" setting.