--- title: "Reddit Ads to AWS Athena Connector | OWOX" canonical: "https://www.owox.com/connectors/free-reddit-ads-connector-to-aws-athena" updated: "2026-09-21" --- # Collect Reddit Ads Data into AWS Athena Own your Reddit Ads data in AWS Athena with OWOX Data Marts. Collect granular, analytics-ready Reddit Ads data into Athena, control schema and refresh logic, and reuse the data across BI tools and AI Insights. [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 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. 23 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) ## S01 · Step 1 ## Step 1: Create an AWS Athena data storage Start by connecting AWS Athena as your [data storage](/data-storages) in OWOX Data Marts. * Select the AWS Region where Athena runs * Specify an S3 Output Bucket for query results * Add AWS Access Key ID and Secret Access Key for an IAM user with Athena and S3 permissions [Connect AWS Athena](https://www.owox.com/app-signup) ![Step 1: Create an AWS Athena Data Storage](https://cdn.owox.com/www/portfolio-management-connectors/free-criteo-ads-connector-to-aws-athena/body/1.png/public) ## S02 · Step 2 ## Step 2: Create a Reddit Ads Data Mart Create a new Data Mart and choose Connector as the definition type. * Select Reddit Ads as the data source * Authorize access to your Reddit Ads advertising account * No API coding or engineering required [Add Reddit Ads](https://www.owox.com/app-signup) ![Step 2: Create a Reddit Ads Data Mart](https://cdn.owox.com/www/portfolio-management-connectors/free-reddit-ads-connector-to-aws-athena/body/1.png/public) ## S03 · Step 3 ## Step 3: Select fields & configure data import Choose exactly which Reddit Ads data you want to land in AWS Athena. * Select the required Reddit Ads API endpoint * Choose fields like impressions, clicks, spend, conversions, and campaign attributes * Define destination database and table settings, or keep defaults [Choose Fields](https://www.owox.com/app-signup) ![Step 3: Select Fields & Configure Data Import](https://cdn.owox.com/www/portfolio-management-connectors/free-reddit-ads-connector-to-aws-athena/body/2.png/public) ## S04 · Step 4 ## Step 4: Run & schedule Reddit Ads data collection Once published, control how Reddit Ads data is imported. * Incremental load for current-day data * Backfill (custom period) for historical Reddit Ads data * Monitor execution in Run History [Run First Import](https://www.owox.com/app-signup) ![Step 4: Run & Schedule Reddit Ads Data Collection](https://cdn.owox.com/www/portfolio-management-connectors/free-reddit-ads-connector-to-aws-athena/body/3.png/public) ## S05 · Step 5 ## Step 5: Use Reddit Ads data across BI tools & AI Insights Your Reddit Ads data is now available through AWS Athena. * Analyze in Google Sheets or Data Studio * Join with GA4, CRM, or revenue datasets * Enable AI Insights for summaries and alerts [Activate Reporting](https://www.owox.com/app-signup) ![Step 5: Use Reddit Ads Data Across BI Tools & AI Insights](https://cdn.owox.com/www/portfolio-management-connectors/free-reddit-ads-connector-to-aws-athena/body/4.png/public) ## Related connectors [Reddit Ads to AWS Redshift](/connectors/free-reddit-ads-connector-to-aws-redshift) [Reddit Ads to Databricks](/connectors/free-reddit-ads-connector-to-databricks) [Reddit Ads to Google BigQuery](/connectors/free-reddit-ads-connector-to-google-bigquery) ## What users are saying ## Every claim has a receipt. Real things real customers said — each quote pinned to a specific claim, straight from the quotes database. A3 · re: trusting AI ![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) Nodari Rizun · Founder & CEO, Pürblack® > _“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”_ C9 · re: one source of truth ![Mark Simmons](https://cdn.owox.ai/www/webflow/6a7b298b2b9daab0ade631d7_mark-headshot.png/public) Mark Simmons · CMO, Pürblack® > _“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”_ E7 · re: getting time back ![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) Nodari Rizun · Founder & CEO, Pürblack® > _“We regained time. And time is the one resource that never comes back.”_ ## Recent updates * [0.39.0 · Backfill any past period](https://docs.owox.com/docs/changelog/#backfill-any-past-period-0390) * [0.39.0 · Facebook Ads imports now retry a corrupted response instead of failing](https://docs.owox.com/docs/changelog/#facebook-ads-imports-now-retry-a-corrupted-response-instead-of-failing-0390) * [0.38.0 · Shopify connector: more orders fields, including line-item discounts](https://docs.owox.com/docs/changelog/#shopify-connector-more-orders-fields-including-line-item-discounts-0380) * [0.38.0 · Athena query results are cleaned up when the Output Bucket names a folder](https://docs.owox.com/docs/changelog/#athena-query-results-are-cleaned-up-when-the-output-bucket-names-a-folder-0380) * [0.37.0 · Short links resolve only on known short link services and domains you allow](https://docs.owox.com/docs/changelog/#short-links-resolve-only-on-known-short-link-services-and-domains-you-allow-0370) ## Turn Reddit Ads Data into Business Decisions Schedule a quick walkthrough to see how OWOX Data Marts helps you collect Reddit Ads data in AWS Athena, reduce reporting complexity, and scale analytics with confidence. [Get Started Free](https://www.owox.com/app-signup) ## Book a call You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Schedule a meeting ## Schedule in person meeting at Tip Top Toronto You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## 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 storage](https://www.owox.com/data-storages) — /data-storages.md - [Reddit Ads to AWS Redshift](https://www.owox.com/connectors/free-reddit-ads-connector-to-aws-redshift) — /connectors/free-reddit-ads-connector-to-aws-redshift.md - [Reddit Ads to Databricks](https://www.owox.com/connectors/free-reddit-ads-connector-to-databricks) — /connectors/free-reddit-ads-connector-to-databricks.md - [Reddit Ads to Google BigQuery](https://www.owox.com/connectors/free-reddit-ads-connector-to-google-bigquery) — /connectors/free-reddit-ads-connector-to-google-bigquery.md - [0.39.0 · Backfill any past period](https://docs.owox.com/docs/changelog)