Land Reddit Ads data in Databricks
Send Reddit Ads campaigns, ad groups, ads and performance reports to Databricks with OWOX Data Marts: each breakdown as its own table, refreshed on a schedule. Put community-led acquisition in the same tables as your other paid channels.
Reddit AdsConnectedAd AccountAd Account UserAd GroupsAd Performance
DatabricksDateSpendClicksDaily 09:00Reddit 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 web analytics and CRM in Databricks
Reddit Ads reports what a promoted post cost and the conversions Reddit tracked, inside its own account. To weigh it against bigger paid channels and follow a visit to a deal, join spend, website touch points and CRM deals in one warehouse.
- Line Reddit spend up with LinkedIn, Facebook and Google
- Tie Reddit clicks to the sign-ups and deals they became
- Cut spend by community, keyword, interest or placement, each in its own table
Reddit AdsCommunity ad spendYour data warehouseAdTouch pointDealJoined by idPost clickedDeal laterOne query links the ad to the deal.Step 1: Connect Reddit Ads and choose what to load
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
Facebook AdsReddit Ads
LinkedIn AdsAuthorizeConnectedEndpointAd PerformanceAd AccountAd Account UserAd GroupsAd Performancedatespendimpressionsclicksconversion_purchase_total_v…conversion_roasStep 2: Load Reddit Ads into Databricks tables
The catalog defaults to main, and the schema and table are pre-filled; change any of them. Run it and the first load lands in your own Databricks workspace.
- Each endpoint gets its own table, such as reddit_ads_report
- Spend arrives in microcurrency; convert it once in your model
DestinationCatalogmainSchemareddit_adsTablereportRunTablemain.reddit_ads.reportStep 3: Open the output schema in plain words
The first run gives you the output schema: every field with an alias and 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
- Teammates can query the table without the API reference
main.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…Step 4: Keep the Reddit Ads tables linked
Campaigns, ad groups, ads and performance stay separate tables, joined by ids. In SQL 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
CampaignsidnameobjectiveAd Groupsidnameoptimization_goalAdsidcampaign_idad_group_idAd Performancead_idspendStep 5: Refresh on a schedule and backfill the history
Set it once. A scheduled refresh keeps the Databricks tables current, and a manual run loads a past period of your choice.
- Each incremental run reloads today plus a lookback window you set
- Backfill a custom start and end date
Step 6: Reuse the Databricks tables in every tool
One set of tables feeds your model, , , assistants like Claude and ChatGPT and AI insights in Slack or email.
- Show Reddit beside your larger paid channels
- Every report reads the same table
Reddit AdsData MartPublished
Google Sheets
Data Studio dashboards
Claude, ChatGPT
Slack, email
- 0.43.0Compare LinkedIn Ads results across markets: spend by country, region, and county
- 0.43.0The Sheet link of a Google Sheets source opens the imported tab, not the first one
- 0.43.0Connect a Google Sheets plan with one Google sign-in
- 0.41.0Rotating a warehouse key is one change: Storages share reusable Credentials
- 0.41.0Dates from Google Sheets arrive as dates, not text
Why OWOX for Reddit Ads in Databricks
Notebooks over the Reddit API and generic ETL tools get the data in. OWOX also keeps it in your tables, readable and ready to model.
- You own the data. It lands in your own Databricks workspace, in tables you control.
- One table per breakdown. Performance by community, keyword, interest, placement, country, DMA, ad group or campaign loads on its own.
- Lead forms and funding too. Lead gen forms and funding instruments load as tables of their own.
- Joined by campaign, ad group and ad ids. The tables arrive ready to meet web analytics and CRM.
- Maintained for you. No jobs to repair 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.