Connector

Collect Reddit Ads data in Google BigQuery

Load Reddit Ads campaigns, ad groups, ads and performance reports into your own BigQuery tables with OWOX Data Marts: each breakdown in its own table, refreshed on a schedule. Put community-led acquisition in the same model as your other paid channels.

Reddit AdsConnectedAd AccountAd Account UserAd GroupsAd Performance
Data MartPublishedone definition
Google BigQueryDateSpendClicksDaily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get Started Free

Hand this to your AI

Reddit counts the conversions it tracked, so you can't tell which promoted posts became sign-ups or deals.

Paste this into your AI assistant. It loads Reddit Ads into Google BigQuery with OWOX Data Marts and joins clicks to the web analytics and CRM tables you already keep there.

The prompt

load Reddit Ads into Google BigQuery and join each campaign's clicks to the sign-ups in web analytics and the deals in our CRM, so I get deals and revenue per campaign next to spend

Endpoints

Reddit Ads Endpoints

Documentation

18 Reddit Ads endpoints you can import. Each lands in its own table in your data warehouse.

S00 · Why

Why join Reddit Ads with your web analytics and CRM

Reddit Ads reports what a promoted post cost and the conversions Reddit tracked, inside its own account. To weigh it against larger paid channels and follow a visit through to a deal, spend has to sit next to website touch points and CRM deals in one data warehouse.

  • Put Reddit next to LinkedIn, Facebook and Google spend in one table
  • Connect Reddit clicks to the sign-ups and deals they became
  • Cut spend by community, keyword, interest or placement in separate tables
Reddit AdsCommunity ad spend
Web analyticsVisits, sign-ups
CRMDeals
Your data warehouseBigQueryAdTouch pointDealJoined by idPost clickedDeal laterOne query links the ad to the deal.

S01 · Step 1

Step 1: Connect Reddit Ads and pick the fields

Create a Data Mart, choose Reddit Ads as the data source, connect your Reddit app credentials and Account ID, and tick only the fields you need.

  • 18 endpoints and 675 fields to choose from
  • Ad Performance alone has 55 fields: spend, clicks, and conversions for leads, purchases, sign-ups and carts
New Data MartChoose a sourceFacebook AdsReddit AdsTikTok AdsAuthorizeConnectedEndpointAd PerformanceAd AccountAd Account UserAd Groups
Ad Performance55 fieldsdatespendimpressionsclicksconversion_purchase_total_v…conversion_roas

S02 · Step 2

Step 2: Load Reddit Ads into a BigQuery table

The dataset and table in your data storage are pre-filled, and you can change them. Run it and the first load lands in your own BigQuery project.

  • Each endpoint gets its own table, such as reddit_ads_report
  • Spend arrives in microcurrency; convert it once in your model
DestinationBigQueryDatasetreddit_adsTablereportRun
Run HistoryPendingRunningSuccessIncremental load
Tablereddit_ads.report

S03 · Step 3

Step 3: Get a business-friendly output schema

After the first run you get the output schema: every field with a readable description, not an API identifier. Your data quality checks can read it too.

  • Conversion fields come in the same family for each event, such as clicks, views and total value
  • Anyone on the team can read the table
reddit_ads.reportOutput schemaFieldDescriptiondateThe date for this metric.spendThe amount (in microcurrency)…impressionsThe number of impressions…clicksThe number of clicks detected…conversion_purchase_total_val…Total value of the purchase.conversion_roasReturn on ad spend for…

S04 · Step 4

Step 4: Keep the Reddit Ads tables linked

Campaigns, ad groups, ads and performance stay separate tables, joined by ids. Together they become one Reddit Ads data model.

  • Ads carry campaign_id and ad_group_id, so spend rolls up to either level
  • Lead gen forms and funding instruments load as tables of their own
Campaignsidnameobjective
Ad Groupsidnameoptimization_goal
Adsidcampaign_idad_group_id
Ad Performancead_idspend

S05 · Step 5

Step 5: Schedule the refresh and backfill history

Set it once. A scheduled refresh keeps the tables current, and a manual backfill loads any past period.

  • Each incremental run reloads today plus a lookback window you set
  • Backfill a custom start and end date
ScheduleRun on a scheduleDaily 09:00
BackfillRun backfill
Run HistoryDaily scheduleManual backfillDaily schedule

S06 · Step 6

Step 6: Reuse the same table everywhere

One table feeds your data model, spreadsheets, dashboards, AI assistants like Claude and ChatGPT, and scheduled AI insights in Slack or email.

  • Show Reddit beside your larger paid channels
  • Every report reads the same table
Reddit AdsData MartPublished
Blended ad spend
Google Sheets
Data Studio dashboards
Claude, ChatGPT
Slack, email

Recent updates

Why OWOX

Why OWOX for Reddit Ads in BigQuery

Hand-built API scripts, a generic ETL tool or manual exports each get Reddit data out. OWOX also keeps it yours, readable and ready to model.

  • You own the data. It lands in your own BigQuery project, in tables you control.
  • One table per breakdown. Performance by community, keyword, interest, placement, country, DMA, ad group or campaign each loads on its own.
  • Ready for a data model. Separate tables joined by campaign, ad group and ad ids, built to connect to web analytics and CRM.
  • Maintained for you. No scripts to fix when Reddit changes its API.
  • Free to self-host. The open-source OWOX Data Marts runs in your own infrastructure.

Book a callGet Started Free

Trust

The Data Partner You Can Trust

users

166K Source: Internal OWOX data as of 2026-11-15

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers