Experimental feature: Reddit Ads connector is currently in beta. We’re actively improving sync reliability and adding more features.
Prerequisites
- An active Reddit Ads account with campaigns
- Reddit account with access to the advertiser account you want to sync
- adsread - Read advertising data through your account
- identity - Access your Reddit username and signup date
Connecting Reddit Ads
You can connect Reddit Ads in two ways: from the Sources page if you’re already using AstroBee, or during the onboarding process if you’re a new user.- During onboarding
- From Sources page
1
Choose Connect Sources
On the Import Data screen, click the “Connect Sources” card
2
Select Reddit Ads
Click “Connect” next to Reddit Ads in the list of available connectors
3
Start connection
Click “Connect” to begin the setup process
4
Authorize with Fivetran
AstroBee uses Fivetran to securely connect to Reddit Ads. Click “Continue” to proceed
- Secure: Data transfer is encrypted end-to-end and your credentials are never exposed
- Private: Your data passes through without permanent storage
5
Configure authentication
Follow the setup guide on the right for detailed configuration instructions from Fivetran.
- Log in with your Reddit account
- Grant the required permissions (adsread and identity)
- Authorize access to your Reddit Ads data
- How to safelist your accounts with Reddit
- Understanding Reddit Ads account structure
- Managing permissions
6
Test and save connection
Once configured, click “Save & Test” to verify the connection
7
Select tables to sync
Back in AstroBee, your data is being synced from Reddit Ads. This typically takes 10 seconds to 10 minutes depending on your campaign volume and data history.Once synced, select which tables to include in your analysis. Common Reddit Ads tables include:
- account: Your Reddit Ads account information and settings
- campaign: Campaign details, budgets, and objectives
- ad_group: Ad group settings and targeting
- ad: Individual ad creative and performance data
- conversion: Conversion tracking and pixel data
8
Connection complete
Your Reddit Ads connection is now active and appears in “My Sources”
What happens next
After connecting Reddit Ads, you can create a data layer to start querying your advertising data. Click “Create Data Layer” to let AstroBee analyze your Reddit Ads tables and generate a business model for natural language queries.Syncing data
Reddit Ads connections use manual sync - you control when data is refreshed. To sync your latest advertising data:- Navigate to the Sources page
- Find your Reddit Ads connection
- Click the sync button
Understanding Reddit Ads data
Reddit Ads syncs multiple related tables:- Campaign data: Campaign names, objectives, budgets, and status
- Ad group data: Targeting settings, bids, and audience configuration
- Ad creative: Ad copy, images, videos, and post content
- Performance metrics: Impressions, clicks, spend, conversions, and engagement
- Conversion data: Pixel tracking and conversion events
Troubleshooting
Account not safelisted
Account not safelisted
Issue: Setup test fails with “This account is not allowed to use the API.”Solution:
- Both your Reddit user account and advertiser account must be safelisted
- Contact Reddit Ads Support to safelist your accounts
- Provide your Reddit username and advertiser account ID
- Wait for Reddit to approve your safelist request (can take 1-2 business days)
- Retry the connection after receiving confirmation
Authentication failed
Authentication failed
Issue: Unable to authorize access to Reddit Ads.Solution:
- Ensure you have an active Reddit Ads account
- Verify you’re signed in to the correct Reddit account
- Check that you granted both required permissions (adsread and identity)
- Try re-authorizing from the beginning
- Confirm your Reddit account is not suspended
No data syncing
No data syncing
Issue: Connection succeeds but no data appears in tables.Solution:
- Verify your Reddit Ads account has active or past campaigns
- Check that campaigns have actually run and generated impressions
- Ensure your accounts are properly safelisted
- Wait for the initial sync to complete (can take 10+ minutes for large accounts)
- Trigger a manual sync to refresh data
Sync taking too long
Sync taking too long
Issue: Initial sync appears stuck or is taking longer than expected.Solution:
- Accounts with extensive campaign history can take 30+ minutes to sync
- Check your internet connection
- Avoid making changes to the connection during sync
- Reddit Ads API rate limits may slow down large syncs
- If stuck for more than an hour, contact support at support@astrobee.ai
Missing campaigns or ads
Missing campaigns or ads
Issue: Some campaigns or ads don’t appear in synced data.Solution:
- Verify the campaigns exist and are active in Reddit Ads Manager
- Check that campaigns aren’t archived or deleted
- Ensure your user account has access to the advertiser account containing those campaigns
- Trigger a new sync to pull the latest data
- Review your Reddit Ads account permissions
Permission denied errors
Permission denied errors
Issue: Connection fails with permission errors.Solution:
- Verify you granted both adsread and identity permissions during authorization
- Re-authenticate and ensure both permissions are checked
- Check that your Reddit account has admin access to the advertiser account
- Confirm your advertiser account is active and not suspended
- Some features require specific Reddit Ads subscription levels
Conversion data missing
Conversion data missing
Issue: Conversion tracking data is not syncing.Solution:
- Verify Reddit Pixel is properly installed on your website
- Check that conversions have actually occurred and been tracked
- Ensure conversion events are configured in Reddit Ads Manager
- Reddit conversion data may have a delay of up to 48 hours
- Trigger a new sync after conversions have had time to process