Skip to main content
Connect Reddit Ads to AstroBee to analyze your campaign performance and advertising metrics. Get queryable access to campaigns, ad groups, ads, and conversion data from your Reddit advertising accounts.
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
You need to grant Fivetran the following permissions:
  • adsread - Read advertising data through your account
  • identity - Access your Reddit username and signup date
Important: You must safelist both your user and advertiser accounts to access the Reddit Ads API. If you have not safelisted both accounts, you will see the following message in the setup test: “This account is not allowed to use the API.” If that occurs, contact Reddit Ads Support.

​
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.
1

Choose Connect Sources

On the Import Data screen, click the Connect Sources card.
Onboarding screen with Connect Sources option
2

Select Reddit Ads

Click Connect next to Reddit Ads in the list of available connectors.
Available connectors including Reddit Ads
3

Start connection

A “Configure Connector” modal appears showing “Reddit Ads Not Connected”. Click the orange Connect button to begin setup.
Configure Reddit Ads modal
4

Authorize with Fivetran

AstroBee uses Fivetran to securely connect to Reddit Ads. Review the security information and click Continue.
Fivetran authorization screen
Fivetran ensures:
  • Secure: Data transfer is encrypted end-to-end and your credentials are never exposed
  • Private: Your data passes through without permanent storage
5

Authenticate with Reddit

On the Fivetran setup page, click Authorize to log in through OAuth. You’ll be redirected to Reddit to grant access.
Reddit Ads authentication configuration
You’ll need to grant the following permissions:
  • adsread - Read advertising data through your account
  • identity - Access your Reddit username and signup date
Follow the Fivetran Reddit Ads setup guide for detailed instructions.
6

Configure sync settings

After authentication succeeds, configure your sync settings:
Successful authentication with sync configuration
If you see “This account is not allowed to use the API,” your accounts need to be safelisted. Contact Reddit Ads Support to resolve this.Click Save & Test to verify the connection.
7

Select tables to sync

Back in AstroBee, the “Configure Connector” modal shows your sync progress. Expand Sync Settings to select which tables to include.
Select Reddit Ads tables in AstroBee
Tables marked “(always synced)” are required. Common 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
Click Save Table Selection, then Continue.
8

Data layer building

A modal appears showing “Your data layer is building”. AstroBee is unifying, deduplicating, and resolving entities across your data.
Data layer building modal
This may take 10 minutes to a couple of hours. Feel free to close this and come back later.
9

Data syncing

The Sources page shows your sync progress. Your data source is syncing and the data layer will be generated automatically once syncing completes.
Reddit Ads syncing progress
It’s safe to close this window and continue working. You can connect other data sources while you wait.
10

Connection complete

Your Reddit Ads connection now appears under MY SOURCES on the Sources page. You’ll see the sync status (e.g., “Backfilling history”) while historical data loads.
Reddit Ads connection completed

​
What happens next

After connecting Reddit Ads, AstroBee automatically generates a data layer from your synced tables. Once complete, you can start querying your advertising data using natural language.
You can also edit your data layer to customize entities, add properties, or create relationships.

​
Syncing data

Reddit Ads connections use manual sync - you control when data is refreshed. To sync your latest advertising data:
  1. Navigate to the Sources page
  2. Find your Reddit Ads connection
  3. Click the sync button
AstroBee will pull the latest campaigns, ad performance, and conversion data from your Reddit Ads accounts.

​
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
The exact tables available depend on your Reddit Ads account configuration and which features you use in Reddit Ads Manager.

​
Troubleshooting

For additional help, see Fivetran’s Reddit Ads troubleshooting guide.
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
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
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
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
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
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
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
Issue: Status shows “Backfilling history” for many hours.Solution:
  • Historical backfills for Reddit Ads can take 12+ hours for accounts with extensive campaign data
  • This is normal behavior, not a stuck sync
  • You can safely close the browser and return later
  • The sync continues in the background and your data layer will generate automatically when complete
  • If backfill exceeds 72 hours with no progress, contact support at support@astrobee.ai
Issue: Sync completed but data layer shows an error or never finishes building.Solution:
  • Check that at least one table was selected during setup
  • Verify your synced tables contain actual data (not empty)
  • Try refreshing the page to see updated status
  • If the error persists, try disconnecting and reconnecting Reddit Ads
  • Contact support at support@astrobee.ai with the error message if the issue continues

​
Next steps

Create a Data Layer

Transform your Reddit Ads data into a queryable business model

Ask Questions

Start analyzing your campaign performance and ROI with natural language