---
title: "Reddit Ads to Databricks Connector | OWOX"
canonical: "https://www.owox.com/connectors/free-reddit-ads-connector-to-databricks"
updated: "2026-10-29"
---

# 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.

![](https://cdn.owox.com/www/webflow/679a01adc065220435d26849_328.svg/public)Reddit Ads · Connected · Ad Account · Ad Account User · Ad Groups · Ad Performance

Data Mart · Published · one definition

![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Databricks · Date · Spend · ClicksDaily 09:00

Refreshed on a schedule. No exports, no copy-paste.

[Get Started Free](https://www.owox.com/app-signup)

## Endpoints

## Reddit Ads Endpoints

[Documentation](https://docs.owox.com/packages/connectors/src/sources/reddit-ads/readme/)

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 fields](/data-sources/reddit#schema-ad-account)

*   [Ad Account User The authenticated Reddit Ads user — identity and contact details. 7 fields](/data-sources/reddit#schema-ad-account-user)

*   [Ad Groups Ad groups within your campaigns — bid strategy, goal, targeting, and schedule. 27 fields](/data-sources/reddit#schema-ad-groups)

*   [Ad Performance Daily ad performance — impressions, clicks, spend, conversions, and ROAS. 55 fields · Time series](/data-sources/reddit#schema-ad-performance)

*   [Ad Performance by Account Daily ad performance broken down by ad account. 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-account)

*   [Ad Performance by Ad Group Daily ad performance broken down by ad group. 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-ad-group)

*   [Ad Performance by Campaign Daily ad performance broken down by campaign. 57 fields · Time series](/data-sources/reddit#schema-ad-performance-by-campaign)

*   [Ad Performance by Community Daily ad performance broken down by subreddit (community). 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-community)

*   [Ad Performance by Country Daily ad performance broken down by user country. 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-country)

*   [Ad Performance by DMA Daily ad performance broken down by Designated Market Area (DMA). 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-dma)

*   [Ad Performance by Interest Daily ad performance broken down by user interest targeting. 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-interest)

*   [Ad Performance by Keyword Daily ad performance broken down by keyword. 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-keyword)

*   [Ad Performance by Placement Daily ad performance broken down by ad placement. 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-placement)

*   [Ads Individual ads — type, status, and links to their campaigns and posts. 24 fields](/data-sources/reddit#schema-ads)

*   [Campaigns Your campaigns — objective, status, spend cap, and account association. 15 fields](/data-sources/reddit#schema-campaigns)

*   [Custom Audiences Custom audiences built from your user lists — type, status, and size estimates. 9 fields](/data-sources/reddit#schema-custom-audiences)

*   [Funding Instruments Payment methods linked to your campaigns — credit limits and current outstanding balance. 9 fields](/data-sources/reddit#schema-funding-instruments)

*   [Lead Gen Forms Lead generation forms shown in your ads — prompt text and creation details. 8 fields](/data-sources/reddit#schema-lead-gen-forms)

## S00 · Why

## 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 [data warehouse](/data-storages).

*   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

![](https://cdn.owox.com/www/webflow/679a01adc065220435d26849_328.svg/public)Reddit Ads · Community ad spend

Web analytics · Visits, sign-ups

CRM · Deals

![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Your data warehouse · Databricks · Ad · Touch point · DealJoined by id · Post clicked · Deal laterOne query links the ad to the deal.

## S01 · Step 1

## Step 1: Connect Reddit Ads and choose what to load

Create a Data Mart, choose Reddit Ads as the [data source](/data-sources), 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 Mart · Choose a source · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2024%2024%22%3E%3Cpath%20fill%3D%22%230866FF%22%20d%3D%22M24%2012.073c0-6.627-5.373-12-12-12s-12%205.373-12%2012c0%205.99%204.388%2010.954%2010.125%2011.854v-8.385H7.078v-3.47h3.047V9.43c0-3.007%201.792-4.669%204.533-4.669%201.312%200%202.686.235%202.686.235v2.953H15.83c-1.491%200-1.956.925-1.956%201.874v2.25h3.328l-.532%203.47h-2.796v8.385C19.612%2023.027%2024%2018.062%2024%2012.073z%22%2F%3E%3C%2Fsvg%3E%0A)Facebook Ads · ![](https://cdn.owox.com/www/webflow/679a01adc065220435d26849_328.svg/public)Reddit Ads · ![](data:image/svg+xml;utf8,%3Csvg%20viewBox%3D%220%200%2048%2048%22%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%3E%3Cpath%20fill%3D%22%230A66C2%22%20d%3D%22M40.8983%2040.8992h-7.1121V29.761c0-2.656-.0474-6.0751-3.699-6.0751-3.7043%200-4.271%202.8938-4.271%205.8817v11.3309h-7.1121V17.9938h6.8276v3.1302h.0956c.6833-1.1684%201.6706-2.1295%202.8569-2.781%201.1863-.6516%202.5271-.9691%203.8796-.9189%207.2084%200%208.5375%204.7415%208.5375%2010.91l-.003%2012.5651Zm-30.219-26.0363c-.81634.0001-1.61436-.2418-2.29316-.6952-.67881-.4534-1.20788-1.0979-1.5204-1.852-.31252-.7542-.39442-1.584-.23531-2.38469.15911-.80066.55207-1.53616%201.12917-2.11349.5771-.57732%201.31244-.97055%202.11302-1.12995.80058-.1594%201.63038-.07781%202.38468.23444.7542.31226%201.3988.84116%201.8525%201.51982.4536.67866.6958%201.47661.696%202.29297.0001.542-.1066%201.0787-.3139%201.5795-.2074.5008-.5113.9558-.8944%201.3392-.3832.3833-.8382.6874-1.3389.8949-.5007.2075-1.0374.3144-1.5793.3145Zm3.556%2026.0363H7.11579V17.9938h7.11951v22.9054ZM44.444.00327032H3.54198C2.61362-.00720657%201.71904.351327%201.05488%201.00008.390724%201.64884.0113301%202.53475%200%203.46313V44.5362c.0109423.9288.390114%201.8153%201.05425%202.4647.66413.6495%201.55891%201.0087%202.48773.9988H44.444c.9306.0117%201.8279-.3465%202.4947-.9959.6667-.6494%201.0484-1.537%201.0613-2.4676V3.46017c-.0133-.93023-.3952-1.81714-1.062-2.465882-.6668-.648742-1.5638-1.0062509-2.494-.99398236%22%2F%3E%3C%2Fsvg%3E)LinkedIn Ads · AuthorizeConnected · Endpoint · Ad Performance · Ad Account · Ad Account User · Ad Groups

![](https://cdn.owox.com/www/webflow/679a01adc065220435d26849_328.svg/public)Ad Performance · 55 fields · datespendimpressionsclicksconversion\_purchase\_total\_v…conversion\_roas

## S02 · Step 2

## Step 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

![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Destination · Databricks · Catalog · main · Schema · reddit\_ads · Table · report · Run

Run History · Pending · Running · SuccessIncremental load

![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Table · main.reddit\_ads.report

## S03 · Step 3

## Step 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 [data quality](/product/data-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

![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)main.reddit\_ads.report · Output schema · Field · Descriptiondate · The date for this metric. · spend · The amount (in microcurrency)… · impressions · The number of impressions… · clicks · The number of clicks detected… · conversion\_purchase\_total\_val… · Total value of the purchase. · conversion\_roas · Return 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. In SQL they become one Reddit Ads [data model](/product/data-modeling).

*   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

![](https://cdn.owox.com/www/webflow/679a01adc065220435d26849_328.svg/public)Campaigns · id · name · objective

![](https://cdn.owox.com/www/webflow/679a01adc065220435d26849_328.svg/public)Ad Groups · id · name · optimization\_goal

![](https://cdn.owox.com/www/webflow/679a01adc065220435d26849_328.svg/public)Ads · id · campaign\_id · ad\_group\_id

![](https://cdn.owox.com/www/webflow/679a01adc065220435d26849_328.svg/public)Ad Performance · ad\_id · spend

## S05 · Step 5

## Step 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

Schedule · Run on a schedule · Daily 09:00

Backfill · Run backfill

Run History · Daily schedule · Manual backfill · Daily schedule

## S06 · Step 6

## Step 6: Reuse the Databricks tables in every tool

One set of tables feeds your [data model](/product/data-modeling), [spreadsheets](/product/spreadsheets), [dashboards](/product/dashboards), [AI assistants](/product/ai-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

![](https://cdn.owox.com/www/webflow/679a01adc065220435d26849_328.svg/public)Reddit Ads · Data Mart · Published

Blended ad spend

![](https://cdn.owox.com/www/portfolio-management-data-destination/google-sheets/logo/1.svg/public)Google Sheets

![](https://cdn.owox.com/www/portfolio-management-data-destination/data-studio/logo/1.svg/public)Data Studio dashboards

![](https://cdn.owox.com/www/portfolio-management-data-destination/claude/logo/2.svg/public)Claude, ChatGPT

![](https://cdn.owox.com/www/portfolio-management-data-destination/slack/logo/2.svg/public)Slack, email

## Related connectors

[Reddit Ads to Claude](/connectors/reddit-ads-connector-to-claude)[Facebook Ads to Databricks](/connectors/free-facebook-ads-connector-to-databricks)[Google Ads to Databricks](/connectors/free-google-ads-connector-to-databricks)[Reddit Ads to ChatGPT](/connectors/reddit-ads-connector-to-chatgpt)[Microsoft Ads to Databricks](/connectors/free-microsoft-ads-connector-to-databricks)[TikTok Ads to Databricks](/connectors/free-tiktok-ads-connector-to-databricks)[Bank of Canada to Databricks](/connectors/bank-of-canada-connector-to-databricks)[Criteo Ads to Databricks](/connectors/free-criteo-ads-connector-to-databricks)[LinkedIn Ads to Databricks](/connectors/free-linkedin-ads-connector-to-databricks) · Show 6 more · Show fewer

## Recent updates

*   [0.43.0 · Compare LinkedIn Ads results across markets: spend by country, region, and county](https://docs.owox.com/docs/changelog/#compare-linkedin-ads-results-across-markets-spend-by-country-region-and-county-0430)
*   [0.43.0 · The Sheet link of a Google Sheets source opens the imported tab, not the first one](https://docs.owox.com/docs/changelog/#the-sheet-link-of-a-google-sheets-source-opens-the-imported-tab-not-the-first-one-0430)
*   [0.43.0 · Connect a Google Sheets plan with one Google sign-in](https://docs.owox.com/docs/changelog/#connect-a-google-sheets-plan-with-one-google-sign-in-0430)
*   [0.41.0 · Rotating a warehouse key is one change: Storages share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-warehouse-key-is-one-change-storages-share-reusable-credentials-0410)
*   [0.41.0 · Dates from Google Sheets arrive as dates, not text](https://docs.owox.com/docs/changelog/#dates-from-google-sheets-arrive-as-dates-not-text-0410)

## Why OWOX

## 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.

[Book a call](/book-a-call)

[Get Started Free](https://www.owox.com/app-signup)

## Links

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Get Started Free](https://www.owox.com/app-signup)
- [Documentation](https://docs.owox.com/packages/connectors/src/sources/reddit-ads/readme)
- [Ad AccountYour ad account settings — currency, attribution windows, and account type.17 fields](https://www.owox.com/data-sources/reddit) — /data-sources/reddit.md
- [data warehouse](https://www.owox.com/data-storages) — /data-storages.md
- [data source](https://www.owox.com/data-sources) — /data-sources.md
- [data quality](https://www.owox.com/product/data-quality) — /product/data-quality.md
- [data model](https://www.owox.com/product/data-modeling) — /product/data-modeling.md
- [spreadsheets](https://www.owox.com/product/spreadsheets) — /product/spreadsheets.md
- [dashboards](https://www.owox.com/product/dashboards) — /product/dashboards.md
- [AI assistants](https://www.owox.com/product/ai-assistants) — /product/ai-assistants.md
- [Reddit Ads to Claude](https://www.owox.com/connectors/reddit-ads-connector-to-claude) — /connectors/reddit-ads-connector-to-claude.md
- [Facebook Ads to Databricks](https://www.owox.com/connectors/free-facebook-ads-connector-to-databricks) — /connectors/free-facebook-ads-connector-to-databricks.md
- [Google Ads to Databricks](https://www.owox.com/connectors/free-google-ads-connector-to-databricks) — /connectors/free-google-ads-connector-to-databricks.md
- [Reddit Ads to ChatGPT](https://www.owox.com/connectors/reddit-ads-connector-to-chatgpt) — /connectors/reddit-ads-connector-to-chatgpt.md
- [Microsoft Ads to Databricks](https://www.owox.com/connectors/free-microsoft-ads-connector-to-databricks) — /connectors/free-microsoft-ads-connector-to-databricks.md
- [TikTok Ads to Databricks](https://www.owox.com/connectors/free-tiktok-ads-connector-to-databricks) — /connectors/free-tiktok-ads-connector-to-databricks.md
- [Bank of Canada to Databricks](https://www.owox.com/connectors/bank-of-canada-connector-to-databricks) — /connectors/bank-of-canada-connector-to-databricks.md
- [Criteo Ads to Databricks](https://www.owox.com/connectors/free-criteo-ads-connector-to-databricks) — /connectors/free-criteo-ads-connector-to-databricks.md
- [LinkedIn Ads to Databricks](https://www.owox.com/connectors/free-linkedin-ads-connector-to-databricks) — /connectors/free-linkedin-ads-connector-to-databricks.md
- [0.43.0 · Compare LinkedIn Ads results across markets: spend by country, region, and county](https://docs.owox.com/docs/changelog)
- [Book a call](https://www.owox.com/book-a-call) — /book-a-call.md