Skip to main content

Reddit Ads API Connector

Updated yesterday
Reddit Logo And the History of the Business | LogoMyWay

Summary

This integration pulls Reddit Ads delivery and metadata into the system through two scheduled jobs: one for daily delivery data import and another for meta data refresh (campaigns, ad groups, and ads). It uses Reddit API credentials and account IDs for access.

Core metrics include spend, clicks, impressions, and various video view metrics. Composite metrics such as CTR, CPC, CPM, and CPCV provide campaign performance insights.

For more information on this integration, please follow the link here.


Overview

  • Jobs:

    • Reddit Ads - Delivery Import: imports daily delivery data, appending it to the main data table.

    • Reddit Ads - Meta Refresh: refreshes metadata tables for campaigns, ad groups, and ads daily.

  • Data Source Tables:

    • Delivery data: reddit_data_ad

    • Metadata: reddit_meta_campaigns, reddit_meta_ad_groups, reddit_meta_ads

  • Connection: Uses client ID, client secret (both hidden), and required Reddit account IDs.

  • Dimensions: Campaign, AdGroup, Ad

  • Base Metrics: Spend, Clicks, Impressions, multiple video watch metrics

  • Composite Metrics: CTR, CPC, CPM, CPCV


Jobs Configuration

Job Label

Feed

Update Mode

Description

Reddit Ads - Delivery Import

reddit

append

Reddit Ads - Delivery Data

Reddit Ads - Meta Refresh

reddit

refresh

Reddit - Meta Refresh

Delivery Import Job Details

  • Feed: reddit

  • Table: reddit_data_ad

  • Date column: bright_custom_date

  • Create target: true

  • Priority: 1

  • Targets:

    • Type: data

    • Description: Reddit Ads - Delivery Data

Meta Refresh Job Details

  • Feed: reddit

  • Tables and priorities:

    1. reddit_meta_campaigns (priority 1)

    2. reddit_meta_ad_groups (priority 2)

    3. reddit_meta_ads (priority 3)

  • Update mode: refresh

  • Create targets: true


Connection Options Table

Key

Type

Required

Size

Description

Hint

reddit_client_id

hidden

No

50

Reddit client ID

Reddit client ID

reddit_client_secret

hidden

No

50

Reddit client secret (UI-generated)

Reddit client secret generated in the UI

reddit_accounts

text

Yes

100

Reddit Ads Account IDs (comma-separated)

Comma delimited list of account ids


Dimensions

Dimension Name

Result Field

Campaign [Reddit]

reddit_meta_campaigns.name

AdGroup [Reddit]

reddit_meta_ad_groups.name

Ad [Reddit]

reddit_meta_ads.name


Base Metrics

Name

Formula

Prefix

Spend [Reddit]

SUM({reddit_data_ad.spend}) / 1000000

£

Clicks [Reddit]

SUM({reddit_data_ad.clicks})

-

Impressions [Reddit]

SUM({reddit_data_ad.impressions})

-

Video Viewable Impressions

SUM({reddit_data_ad.video_viewable_impressions})

-

Video Fully Viewable Impressions

SUM({reddit_data_ad.video_fully_viewable_impressions})

-

Video 3s Watched

SUM({reddit_data_ad.video_watched_3_seconds})

-

Video 50% Watched

SUM({reddit_data_ad.video_watched_50_percent})

-

Video 75% Watched

SUM({reddit_data_ad.video_watched_75_percent})

-

Video 95% Watched

SUM({reddit_data_ad.video_watched_95_percent})

-

Video 100% Watched

SUM({reddit_data_ad.video_watched_100_percent})

-


Datasource Joins

Join Spec #

LHS Column

RHS Table

RHS Column

0

ad_id

reddit_meta_ads

id

1

campaign_id

reddit_meta_campaigns

id

2

bright_custom_ad_group_id

reddit_meta_ad_groups

id

  • Source table: reddit_data_ad


Composite Metrics

Name

Round

Prefix

Suffix

Formula

CTR [Reddit]

2

-

%

{Clicks [Reddit]} / {Impressions [Reddit]} * 100

CPC [Reddit]

2

£

-

{Spend [Reddit]} / {Clicks [Reddit]}

CPM [Reddit]

2

£

-

({Spend [Reddit]} / {Impressions [Reddit]}) * 1000

CPCV [Reddit]

2

£

-

{Spend [Reddit]} / {Video 100% Watched [Reddit]}

Did this answer your question?