Reddit Ads Integration for Nodus
1. Introduction to the Reddit Ads Integration
What Is This Integration?
The Reddit Ads integration connects your Reddit advertising platform data with Nodus, allowing you to extract, analyze, and transform campaign performance metrics, ad creative insights, and audience targeting information. This integration functions as a source connector, bringing your Reddit Ads data into the Nodus ecosystem for advanced analytics and business intelligence.
Prerequisites:
- An active Reddit Ads account with appropriate permissions
- Reddit Ads Account ID for the accounts you want to connect
- Authorization via Reddit Single Sign-On (SSO)
- Reddit requires
adsreadandidentitypermissions for API access - Your Reddit account must be safelisted for API access
Connection Overview:
The integration uses Reddit's Advertising API to extract advertising data and performance metrics. Authentication is handled through OAuth 2.0, and the connector extracts data based on predefined templates that specify which datasets to retrieve.
2. Platform Setup Documentation (Setup Form for Reddit Ads)
Purpose & Scope
This section covers how to set up the initial connection between Nodus and Reddit Ads by providing the necessary authentication credentials and account details.
Field-by-Field Breakdown:
Integration Name
- Field Name & Label: Integration Name
- Description & Purpose: A descriptive name to identify this Reddit Ads integration within your Nodus account.
- Validation Rules & Format: Text string, required field.
- Examples: "Reddit Ads - Main Account", "Reddit Marketing - Community X"
- Troubleshooting Tips: Use a descriptive name that clearly identifies the specific Reddit Ads account or purpose.
Reddit Ads Account ID
- Field Name & Label: Reddit Ads Account ID
- Description & Purpose: The unique identifier for your Reddit Ads account, used to access campaign data.
- Validation Rules & Format: Alphanumeric string, required field.
- Examples: "t2_123abc456"
- Troubleshooting Tips: You can find your Account ID in the Reddit Ads dashboard under Account Settings. Make sure you're using the correct Account ID if you have access to multiple accounts.
External Link
- Link Label: "Locate Your Advertiser ID"
- URL: https://ads.tiktok.com/help/article/account-setup-faq
- Purpose: Helps users locate their Reddit Ads Account ID in the Reddit Ads interface.
Step-by-Step Guide:
- Log in to Reddit Ads dashboard
- Navigate to Account Settings to locate your Account ID
- Enter your Account ID and a meaningful Integration Name in the Nodus setup form
- Click Authorize to launch the Reddit SSO authorization flow
- Grant
adsreadandidentitypermissions when prompted by Reddit - Verify connection and save the configuration
Reference Links:
3. Extraction/Query Configuration (Extraction Form for Reddit Ads)
Purpose & Overview
This section explains how to configure data extraction from Reddit Ads. The platform offers various templates for extracting different types of advertising data and analytics.
Template & Field Documentation:
Template Selection
- Field Name & Label: Select a template
- Description & Purpose: Defines which type of Reddit Ads data to extract
- Validation Rules & Format: Dropdown selection, required field
- Available Options:
- Reddit Ad Groups - Ad group configuration and targeting information
- Reddit Ads - Individual ad creative and delivery settings
- Reddit Ad Performance - Performance metrics including impressions, clicks, and conversions
- Reddit Campaigns - Campaign-level data including budgets, scheduling, and status
- Reddit Source Of Truth Table - Combined dataset with key account metrics and structure
Lookback Range
- Field Name & Label: Lookback Range
- Description & Purpose: Specifies how many days back to extract data
- Validation Rules & Format: Dropdown selection, required field
- Available Options:
- 3-day Range
- 7-day Range
- 28-day Range (recommended)
- 90-day Range
- Troubleshooting Tips: Select a longer range for historical analysis or a shorter range for recent performance data. Reddit typically maintains historical data for up to 12 months.
Historic Date Selection
- Field Name & Label: Historic Date
- Description & Purpose: For historical data extraction, specifies a custom date range
- Validation Rules & Format: Date picker, required field
- Troubleshooting Tips: Reddit maintains historical data for approximately 12 months, so dates beyond that may not return results.
Workflow & Examples:
- Select the appropriate template (e.g., "Reddit Ad Performance" for performance metrics)
- Choose a lookback period or specific historic date range
- Preview the query to confirm configuration
- Execute extraction
Example Use Cases:
Campaign Performance Analysis:
- Template: Reddit Ad Performance
- Metrics: Impressions, clicks, spend, conversions
- Lookback: 28-day Range
Ad Creative Performance Analysis:
- Template: Reddit Ads + Reddit Ad Performance
- Metrics: Creative details with performance metrics
- Lookback: 28-day Range
Account Structure Audit:
- Template: Reddit Source Of Truth Table
- Data: Account structure, campaign settings, targeting criteria
- Historic Date: Custom range for specific campaign periods
4. Data Mapping & Underlying Models for Reddit Ads
Data Model Overview
The Reddit Ads API returns structured data based on the selected template. Each template corresponds to specific API endpoints and data structures within the Reddit Advertising API.
Schema & Field Mapping
Data Mapping & Underlying Models for Reddit Ads
Data Model Overview
The Reddit Ads API returns structured data based on the selected template. Each template corresponds to specific API endpoints and data structures within the Reddit Advertising API.
Schema & Field Mapping
Reddit Ad Performance Schema (fact_ad_performance)
| Field | Description |
|---|---|
| ad_id | The unique identifier of the ad |
| campaign_id | The parent campaign identifier |
| ad_group_id | The parent ad group identifier |
| date | The date for the metrics |
| hour | Hour of the day for metrics |
| impressions | Number of times the ad was shown |
| clicks | Number of clicks received |
| spend | Amount spent on the ad (scaled from micros) |
| ctr | Click-through rate (clicks/impressions) |
| cpc | Average cost per click (scaled from micros) |
| conversions | Number of purchase conversions |
| conversion_rate | Conversion rate percentage |
| conversion_value | Value of conversions (scaled from cents) |
| video_views | Number of video views started |
| video_completion_rate | Rate of complete video views |
| reach | Number of unique users who saw the ad |
| frequency | Average number of times each user saw the ad |
Reddit Account Performance Schema (sot)
| Field | Description |
|---|---|
| date | Date for the aggregated metrics |
| hour | Hour of the day for metrics |
| impressions | Total number of impressions across account |
| clicks | Total number of clicks across account |
| spend | Total amount spent (scaled from micros) |
Reddit Ads Dimensions Schema (dimensions_adid)
| Field | Description |
|---|---|
| id | The unique identifier of the ad |
| name | The name of the ad |
| ad_group_id | The parent ad group identifier |
| campaign_id | The parent campaign identifier |
| account_id | The account identifier |
| status | The configured status of the ad (ACTIVE, PAUSED, etc.) |
| effective_status | The effective status considering all parent statuses |
| click_url | URL where users are directed after clicking |
| created_at | The ad creation timestamp |
| modified_at | The last update timestamp |
| post_id | ID of the Reddit post if the ad is a promoted post |
| post_url | URL to the Reddit post if applicable |
| preview_url | URL to preview the ad |
| rejection_reason | Reason for rejection if ad was rejected |
| campaign_objective_type | The objective type of the parent campaign |
Reddit Ad Groups Schema (dimensions_adgroup)
| Field | Description |
|---|---|
| id | The unique identifier of the ad group |
| name | The name of the ad group |
| campaign_id | The parent campaign identifier |
| account_id | The account identifier |
| status | The configured status of the ad group |
| effective_status | The effective status considering parent status |
| created_at | The ad group creation timestamp |
| modified_at | The last update timestamp |
| targeting_type | The type of targeting used |
| bid_strategy | The bidding strategy (CPM, CPC, etc.) |
| bid_amount | The bid amount |
| optimization_goal | The optimization goal (CLICKS, CONVERSIONS, etc.) |
Reddit Campaigns Schema (dimensions_campaign)
| Field | Description |
|---|---|
| id | The unique identifier of the campaign |
| name | The name of the campaign |
| account_id | The account identifier |
| status | The configured status of the campaign |
| effective_status | The effective status of the campaign |
| created_at | The campaign creation timestamp |
| modified_at | The last update timestamp |
| objective | The campaign objective |
| funding_instrument_id | The payment method identifier |
| total_budget_amount | The total campaign budget amount |
| start_time | The campaign start time |
| end_time | The campaign end time |
5. Troubleshooting & FAQs for Reddit Ads
Common Issues & Error Messages
Authentication Failures
- Error: "Invalid access token" or "Token expired"
- Solution: Re-authorize the integration through Reddit SSO. Reddit access tokens have limited lifetimes and may need to be refreshed.
API Access Issues
- Error: "This account is not allowed to use the API"
- Solution: Your Reddit account needs to be safelisted for API access. Contact Reddit Ads Support to request API access for your account.
Missing Data
- Common Causes:
- Date range outside of campaign activity period
- Insufficient permissions for the account
- Solution: Adjust template filters, check campaign dates, verify account permissions
Contact & Support Information
- Reddit Ads Support: https://www.reddithelp.com/en/submit-request
- Nodus Support: support@nodus.com
Data Retention & Limitations
- Reddit typically retains advertising data for up to 12 months
- The API has a hard limit of 1,000 records per page when paginating
- Reddit enforces rate limits of approximately 100 queries per minute
- Some metrics may have delayed reporting (up to 24 hours for complete data)