Supernova home
Documentation menu

Reddit Ads#

Connect Reddit Ads with OAuth using your app credentials plus an advertiser id. The source writes 6 fixed tables under titan.reddit_ads.

sql
select
  id,
  name,
  account_id
from titan.reddit_ads.campaigns
limit 10

Connect Reddit Ads#

  1. Open Apps, choose Connect app, and select Reddit Ads.

  2. Enter OAuth using your app credentials plus an advertiser id.

  3. Review the tables, then save the source.

  4. Watch Sync history until the first run completes.

Credentials are stored as secrets. They never become lake columns or appear in query results.

Sync behavior#

Choose the initial history window during setup. Entity and metric tables remain scoped to the advertiser.

A new source syncs when you connect it and then follows its schedule. The default recurring interval is 4 hours. An interrupted run keeps its completed progress and retries safely.

Every lake table also has the system columns _synced_at and _deleted; the column reference below lists source columns only.

Table reference#

campaigns#

titan.reddit_ads.campaigns has 7 source columns.

reddit_ads.campaigns7 columns
idstringpk

Source field id.

namestring

Source field name.

account_idstring

Source field accountId.

statusstring

Source field status.

objectivestring

Source field objective.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

ad_groups#

titan.reddit_ads.ad_groups has 7 source columns.

reddit_ads.ad_groups7 columns
idstringpk

Source field id.

campaign_idstring

Source field campaignId.

namestring

Source field name.

statusstring

Source field status.

targeting_criteriajson

Source field targetingCriteria.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

ads#

titan.reddit_ads.ads has 6 source columns.

reddit_ads.ads6 columns
idstringpk

Source field id.

ad_group_idstring

Source field adGroupId.

namestring

Source field name.

statusstring

Source field status.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

campaign_metrics#

titan.reddit_ads.campaign_metrics has 8 source columns.

reddit_ads.campaign_metrics8 columns
campaign_idstringpk

Source field campaignId.

datedatepk

Source field date.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spendfloat

Source field spend.

ecpmfloat

Source field ecpm.

cpcfloat

Source field cpc.

ctrfloat

Source field ctr.

ad_group_metrics#

titan.reddit_ads.ad_group_metrics has 8 source columns.

reddit_ads.ad_group_metrics8 columns
ad_group_idstringpk

Source field adGroupId.

datedatepk

Source field date.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spendfloat

Source field spend.

ecpmfloat

Source field ecpm.

cpcfloat

Source field cpc.

ctrfloat

Source field ctr.

ad_metrics#

titan.reddit_ads.ad_metrics has 8 source columns.

reddit_ads.ad_metrics8 columns
ad_idstringpk

Source field adId.

datedatepk

Source field date.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spendfloat

Source field spend.

ecpmfloat

Source field ecpm.

cpcfloat

Source field cpc.

ctrfloat

Source field ctr.

Deletes and history#

Rows are merged by their source key. When the source can prove that a row was deleted, Supernova keeps the row and sets _deleted so queries can choose whether to include history. Filter current-state queries with where not _deleted.