Linking Reddit Ads as a source
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Contents
You can sync data from Reddit Ads reports by configuring it as a source in PostHog. The supported reports that can be synced include Ad Groups, Campaigns, Ads, Ad Group Report, Campaign Report, and Ad Report, as described here:
- Ad Groups
- Campaigns
- Ads
- Ad Groups Report: Report broken down by
AD_GROUP_ID - Campaign Report: Report broken down by
CAMPAIGN_ID - Ad Report: Report broken down by
AD_ID
Additional reports will be added based on user feedback we receive via our in-app support form.
Requirements
- A Reddit Ads account with permission to access data from accounts you want to sync.
- Your account ID (optional, but useful for reference). You can find it in the business manager app > Menu > Assets > Ad Accounts > get the ID
Configuring PostHog
Connect PostHog to your Reddit Ads account using a Reddit account. The Reddit account must have permission to access data.
- In PostHog, go to the Data pipelines tab.
- Open the + New drop-down menu in the top-right and select Source.
- Find Reddit Ads in the sources list and click Link.
- Connect your Reddit account by selecting an existing integration or creating a new one.
- Select your ad account from the dropdown. Accounts are grouped by the business that owns them.
- (Optional) Add a prefix for the table name.
Configuration
| Option | Type | Required |
|---|---|---|
Reddit Ads account | oauth | Yes |
Reddit Ads Account ID | oauth-account-select | Yes |
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
campaigns | A Reddit Ads campaign grouping ad groups under a shared objective and budget. | Incremental, Full refresh | modified_at | — |
ad_groups | A Reddit Ads ad group within a campaign, defining targeting, bidding, and budget. | Incremental, Full refresh | modified_at | — |
ads | A Reddit Ads ad — the creative shown to users within an ad group. | Incremental, Full refresh | modified_at | — |
campaign_report | Daily aggregated performance metrics broken down by campaign. | Incremental, Full refresh | date | — |
ad_group_report | Daily aggregated performance metrics broken down by ad group. | Incremental, Full refresh | date | — |
ad_report | Daily aggregated performance metrics broken down by ad. | Incremental, Full refresh | date | — |
ad_account | The connected Reddit Ads account, including the currency and time zone every spend figure is reported in. | Full refresh | — | — |
custom_audiences | An audience built from advertiser-supplied data: a customer list, website or app retargeting via a Pixel, engagement retargeting, or a lookalike. | Full refresh | — | — |
saved_audiences | A reusable targeting definition that ad groups can point at instead of redefining targeting each time. | Full refresh | — | — |
pixels | A Reddit Pixel, the conversion tracker that reports website events back to Reddit Ads. | Full refresh | — | — |
funding_instruments | A payment source campaigns bill against, carrying the currency spend is denominated in. | Full refresh | — | — |
lead_gen_forms | A lead generation form users fill in from an ad, defining the questions asked and the privacy policy shown. | Full refresh | — | — |
profiles | A Reddit profile the ad account can publish ads from. Ad and post rows reference it by ID. | Full refresh | — | — |
structured_posts | The post backing an ad's creative, carrying the headline, media, and destination the ad actually showed. Join to ads on | Full refresh | — | — |
campaign_country_report | Daily campaign performance metrics broken down by the country the impression was served in. | Incremental, Full refresh | date | — |
campaign_gender_report | Daily campaign performance metrics broken down by the viewer's gender. | Incremental, Full refresh | date | — |
campaign_placement_report | Daily campaign performance metrics broken down by where on Reddit the creative was placed. | Incremental, Full refresh | date | — |
campaign_community_report | Daily campaign performance metrics broken down by the community (subreddit) the ad ran in. | Incremental, Full refresh | date | — |
campaign_os_type_report | Daily campaign performance metrics broken down by the viewer's device operating system. | Incremental, Full refresh | date | — |
campaign_keyword_report | Daily campaign performance metrics broken down by the keyword the ad was matched on. | Incremental, Full refresh | date | — |