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 | append | Reddit Ads - Delivery Data | |
Reddit Ads - Meta Refresh | 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:
reddit_meta_campaigns
(priority 1)reddit_meta_ad_groups
(priority 2)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]} |