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 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
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/free-reddit-ads-connector-to-google-bigquery.md. The task: 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. Tag the links you give me with utm_campaign=ai-task and utm_term=m4. Use what you know about my context and goals
Reddit Ads Endpoints
18 Reddit Ads endpoints you can import. Each lands in its own table in your data warehouse.
Ad Account
Your ad account settings — currency, attribution windows, and account type.
17 fieldsAd Account User
The authenticated Reddit Ads user — identity and contact details.
7 fieldsAd Groups
Ad groups within your campaigns — bid strategy, goal, targeting, and schedule.
27 fieldsAd Performance
Daily ad performance — impressions, clicks, spend, conversions, and ROAS.
55 fieldsTime seriesAd Performance by Account
Daily ad performance broken down by ad account.
56 fieldsTime seriesAd Performance by Ad Group
Daily ad performance broken down by ad group.
56 fieldsTime seriesAd Performance by Campaign
Daily ad performance broken down by campaign.
57 fieldsTime seriesAd Performance by Community
Daily ad performance broken down by subreddit (community).
56 fieldsTime seriesAd Performance by Country
Daily ad performance broken down by user country.
56 fieldsTime seriesAd Performance by DMA
Daily ad performance broken down by Designated Market Area (DMA).
56 fieldsTime seriesAd Performance by Interest
Daily ad performance broken down by user interest targeting.
56 fieldsTime seriesAd Performance by Keyword
Daily ad performance broken down by keyword.
56 fieldsTime seriesAd Performance by Placement
Daily ad performance broken down by ad placement.
56 fieldsTime seriesAds
Individual ads — type, status, and links to their campaigns and posts.
24 fieldsCampaigns
Your campaigns — objective, status, spend cap, and account association.
15 fieldsCustom Audiences
Custom audiences built from your user lists — type, status, and size estimates.
9 fieldsFunding Instruments
Payment methods linked to your campaigns — credit limits and current outstanding balance.
9 fieldsLead Gen Forms
Lead generation forms shown in your ads — prompt text and creation details.
8 fields
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 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
Step 1: Connect Reddit Ads and pick the fields
Create a Data Mart, choose Reddit Ads as the 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
Step 2: Load Reddit Ads into a BigQuery table
The dataset and table in your 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
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 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
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 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
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
Step 6: Reuse the same table everywhere
One table feeds your model, , , 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
- 0.44.0Connector Data Marts set up through MCP no longer fail their first run because of the table path
- 0.44.0Backfill a catalog for any period in one run, and follow a long backfill as parts of one operation
- 0.43.0Parallel reads of a SQL Data Mart on Google BigQuery no longer fail with a rate limit error
- 0.41.0Rotating a warehouse key is one change: Storages share reusable Credentials
- 0.41.0Shared SQL logic stays in one place: build a Data Mart on top of another
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.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.