Free Reddit Ads to BigQuery Connector by OWOX: Own the Data Behind Your Campaigns

Running ads on Reddit is straightforward. But moving that campaign data into BigQuery for meaningful analysis? That’s where things get messy. Forget limited dashboards, clunky CSV exports, or pricey ETL platforms that restrict your access and charge by volume.

With this free, open-source connector from OWOX Data Marts, you can send raw Reddit Ads data straight to Google BigQuery - no code, no limitations, no hidden layers. Just clear logic, full transparency, and the freedom to manage your Reddit BigQuery reporting your way.

Why We Made This Connector

At OWOX, we believe digital analysts, marketing analysts, and data teams deserve full access to their advertising data, without hitting paywalls, platform limits, or hidden logic.

That’s why we built this 100% free Reddit Ads to BigQuery connector. No premium plans, no data caps, and no restricted fields. It’s completely open-source and runs in your own environment, giving you full transparency into how your Reddit BigQuery integration works.

You’re not forced into rigid schemas or locked into proprietary workflows. Instead, you get a direct, customizable pipeline that pushes raw Reddit Ads data into Google BigQuery - ready for SQL-based analysis, modeling, and dashboards.

Whether you're joining BigQuery Reddit data with Salesforce, or HubSpot, or just want to own your reporting process end-to-end, this connector gives you total control.

💡 Join the Open-Source Movement

We’re not just releasing a free connector – we’re inviting you to help shape the future of data and marketing analytics tools.

At OWOX, we believe that data access and transparency should be a right, not a luxury. That’s why this connector is 100% open-source – giving you full control over how it works, what it does, and how far it can go.

If you like what we do, please ⭐ star our GitHub repo to show your support – it helps us reach more analysts and grow the number of available connectors.

Also, feel free to:

• Explore the code and customize it to fit your needs.
• Contribute to this data connectivity ecosystem: suggest new connectors, pull new connectors, and/or provide documentation to support the wider community.
• Join our community & share your feedback.

We’ve built the core, the foundation – now it’s your turn to take it further. 

Why Bring Reddit Ads Data into BigQuery?

Reddit Ads Manager is useful for launching campaigns, but when it comes to advanced reporting, large-scale analysis, or integrating with other platforms, it falls short.

Here’s why it’s a must-have for data teams:

✅ Automatically load Reddit Ads to BigQuery – no manual steps or third-party ETL required
✅ No-code setup with a simple, open-source spreadsheet template
✅ Full-funnel data access: impressions, clicks, CTR, engagement, conversions, and more
✅ Schedule recurring imports and incremental updates
✅ Pull granular data across campaigns, ad groups, creatives, and audiences

With full control over what’s imported and how it’s refreshed, analysts and marketing teams can finally use Reddit Ads data the way they need – fast, flexible, and fully integrated.

Explore More Free Connectors
Enjoying the flexibility of custom Reddit Ads reports? Expand your stack with these free, plug-and-play integrations:

Reddit Ads → Sheets
Twitter Ads → BigQuery
Facebook Ads → BigQuery
TikTok Ads → BigQuery

No costs, no coding – just streamlined, scalable reporting across all your ad platforms.

Why Choose OWOX Free Connector for Reddit Ads to BigQuery

Most Reddit Ads to BigQuery tools out there look simple on the surface – until you start using them. You’ll run into hidden limitations, rigid schemas, usage caps, or locked features behind premium tiers.

OWOX takes a different approach.

• 100% free and open-source – No costs, hidden restrictions, or pricing tiers — this connector is completely free on GitHub as part of OWOX Data Marts.
• No platform lock-in – You own the setup. No signup required, no hosted environment, and no risk of vendor lockout.
• Full visibility – Unlike most platforms that obscure their logic, the OWOX connector is fully transparent and editable. You can inspect, tweak, and expand every part of the pipeline.
• Field-level control – Select only the Reddit Ads fields you need. No bloated schemas, no black-box syncing.
• Direct Reddit Ads → BigQuery flow — skips CSVs, staging layers, and 3rd-party services in between.
• Control your schema — Set up your destination table schema, apply clear field aliases, and adapt the structure to fit your reporting needs.

Whether you’re comparing against tools like Portable, Windsor.ai, or Rivery, OWOX gives analysts complete control over their Reddit BigQuery integration, without added complexity or cost.

How the Connector Works 

The Reddit to BigQuery connector from OWOX Data Marts is built entirely on an open-source framework you run yourself – no third-party tools, no vendor lock-in, and no hidden limits.

Here’s how it works:

• Connects directly to the Reddit Ads API and transfers structured ad data into your BigQuery project.
• Let you define custom fields, metrics, dimensions, and date ranges – with full control over aggregation and data refreshes.
• Delivers raw data straight into your BigQuery tables, ready for advanced analysis and reporting.

Whether you're building internal dashboards, blending Reddit campaign data or running complex SQL models, this Reddit to Google BigQuery connector helps you: 

• Bypass closed ETL platforms and rigid schemas 
• Automate Reddit Ads data collection at scale 
• Powerful, precise, flexible reporting in BigQuery

From data fetch to transformation, you control everything - your connector, your BigQuery schema, and your Reddit Ads report.

Step-by-Step Guide: Import Reddit Ads Data to BigQuery with the OWOX Data Marts 

Set up a fully self-managed, SaaS-free pipeline to import Reddit Ads data directly into BigQuery using the OWOX Data Marts and a local server.

Step 1: Install Node.js and OWOX CLI ( ~2 min)

To run OWOX Data Mart locally, you’ll need to install Node.js and the OWOX CLI. This setup allows you to start a local server and work with the OWOX Data Marts effectively.

To get started, install the LTS version of Node.js from nodejs.org and use a version manager like nvm or nvm-windows to avoid permission issues. Once Node.js is set up, you can install the OWOX CLI globally and run ‘owox serve’ to launch the local server. 

💡 For detailed setup instructions and troubleshooting, check the official documentation.

Step 2: Connect Google BigQuery and Set Up Your Data Mart ( ~3 min)

Set up BigQuery as your destination and link it to a new Reddit Ads data mart in OWOX.

1. Open your browser and go to http://localhost:3000.

💡 Follow our guide, where you’ll find easy-to-follow instructions on how to configure your storage in OWOX Data Marts.

2. Create and paste your Service Account JSON Key.

• Follow our guide to create your service account JSON Key.

3. Paste the JSON file content into the ‘Service Account Field’ under Authentication.

• Don’t forget to click Save

4. Once storage is added, click on the Data Mart Tab, then on ‘New Data Mart’

• Now, create the Data Mart, name the title as ‘Reddit Data’, as the data source
• Choose the storage named ‘Reddit Ads Storage’ you just created
• Click ‘Create Data Mart’.

Now we will do the Data Setup

5. Set up your Data Mart

• Go to the Data Setup Tab and then select Connector

• Click on Setup Connector and Choose Reddit Ads Connector

Step 3: Get a Reddit Ads Access Token ( ~1 min)

To start importing data into BigQuery, first connect to the Reddit Ads API. 

Prerequisites

• A Reddit account with access to Reddit Ads.
• Advertiser-level access to the ad accounts you want to pull data from.
• Developer access to create and manage Reddit Apps.
• A BigQuery project where the Reddit Ads data will be stored.
• An API tool (e.g., Postman) or command-line environment to generate tokens.

Steps to Obtain Credentials

Here are the steps:

1. Visit the Reddit  Login Page.
   
   • Go to the Reddit Ads page and log in with your Reddit account.
     
     
2. Create a new app:
   
   • In the left-hand panel, select Developer Applications. 

3. Click Add Apps and fill in the form with:
   
   • App Name: e.g., OWOX Data Marts
   • Description: “This app will extract advertising metrics and store them in my sheets & data warehouse. This data will be processed via OWOX Data Marts to support daily marketing reporting and optimization efforts.”
   • About URL: https://docs.owox.com/packages/connectors/src/sources/reddit-ads/readme/
   • Redirect URI: https://www.reddit.com/prefs/apps
   • Primary contact: your details.

Then click Create App.

4. Once the app is created, note down the 
   
   • App ID (Client ID) 
   • Secret (Client Secret) shown on the page.
     
     
5. Generate the Authorization Code:
   
   • To generate the authorization code, open the following URL in your browser (replace YOUR_APP_ID):
     

https://www.reddit.com/api/v1/authorize
?client_id=YOUR_APP_ID
&response_type=code
&state=xyz_123
&redirect_uri=https://www.reddit.com/prefs/apps
&duration=permanent
&scope=adsread

• Press Enter and click Allow when prompted. You’ll be redirected to a URL containing a code parameter.

• Copy the code value e.g., tPy-1pWJgMkzJrBmdFvIxWzS42girQ
  
  

6. Make a POST Request
   
   
   • Open Postman (or another API tool) and make a POST request to: https://www.reddit.com/api/v1/access_token 

• With the following parameters:
  
  1. grant_type=authorization_code
  2. code=YOUR_CODE
  3. redirect_uri=https://www.reddit.com/prefs/apps

7. Under Authorization, set Basic Auth with:

• Username: Your App ID
• Password: Your App Secret.
•  Then click Send.
  
  

• The response will return your refresh token. Save this securely.

8. Setting a User-Agent header
   
   • For all Reddit API requests, set a User-Agent header in this format:
   • Replace /u/your_reddit_username with your actual Reddit username.
     
     googleapps:owox-data-marts.redditads:v1.0.0 (by /u/your_reddit_username)

You now have everything needed:

• App ID (Client ID)
• Secret (Client Secret)
• Redirect URI
• Refresh Token
• User-Agent Header

Security Notes

• Keep your App ID, Client Secret, and Refresh Token secure.
• Never share your Reddit API credentials publicly.
• Always include a proper User-Agent header in API requests (Reddit requires it).

Step 4: Configure Reddit Ads Connector and Run Your First Import ( ~2 min)

Now that you’ve retrieved your Reddit Ads Access tokens and Client Secret, it’s time to configure the connector in OWOX.

1. Add the Client ID, Client Secret, Redirect URI, Refresh Token, and User Agent.

• Paste the Account ID

2. Start Date: 

• Set the reporting start date (e.g., 2025-01-01). This determines how far back data will be fetched.

3. As you scroll further, you’ll find extra parameter fields. They’re optional for the first run and can be updated later if required.
4. Click Next
5. Endpoint: Choose from the following valid endpoints:

• Ad Group– Data about ad groups, including targeting, budget, and delivery settings.
• Ad Account User – Information about the user connected to the Reddit Ads account.
• Ad Account – General account-level details such as account name, status, and currency.
• Ad – Information on individual ads within campaigns.
• Campaign – Campaign-level details such as objectives, budgets, and scheduling.
• User Custom Audience – Data about custom audiences you’ve built on Reddit Ads.
• Funding Instrument – Information about billing instruments like credit lines or payment methods.
• Lead Gen Form – Details of lead generation forms and their collected responses.
• User Ad Metrics by ad_id – Performance metrics (impressions, clicks, spend, conversions) broken down by individual ad ID.
• User Ad Metrics by country – Performance metrics segmented by country.
• User Ad Metrics by ad_group_id – Performance metrics grouped by ad group.

👉 Tip for first-time setup: If you’re just getting started, begin with the Ad Group endpoint. It gives you a structured view of budgets, targeting, and delivery at the mid-level between campaigns and ads. Later, you can add User Ad Metrics by ad_group_id for performance insights or include Campaigns and Ads to enrich your model with broader context.

6. Select Fields for chosen node. 

• Select all available fields or choose specific metrics like bid strategy, bid type, bid value, and many more based on your reporting needs.

7. Name the Dataset:

• Enter the BigQuery dataset name where the imported data should be stored.

Note: If the dataset doesn't exist, OWOX will create it automatically during the import process.

8. Click Finish

In the Data Setup Tab

9. Click 'Save'.

10. Click 'Publish Data Mart'.

11. Click 'Manual Run' button or use the 3-dot menu.

12. A configuration panel will appear to choose a Run Type. Select Backfill or Incremental Load. Then add the required start and end dates, then click Run to load the data. 

Please Note: If you are setting up this connector for the first time, you need to go with the Backfill Run Type.

13. Go to 'Run History' and see the message: 'Success'.

Step 5: Schedule Automated Imports ( ~1 min)

Set up a trigger to pull data on a recurring schedule.

1. Go to the 'Triggers' tab in the new Data Mart

• Click 'Add Trigger'.

2. Configure:

• Choose the Trigger Type as Connector Run and the Schedule Settings: Daily / Weekly / Monthly / Interval.
• Set the Time (hour, minute, or second), days of the week, and choose your time zone.

3. Click 'Create Trigger'. Your data will now refresh automatically.

4. The trigger is now active and scheduled to run automatically on the defined days and at the defined time.

What’s Next?

The free Reddit Ads to BigQuery connector in OWOX Data Marts supports our mission to make ad data ownership simple, transparent, and accessible to everyone.

Explore more resources to help you go further: 

🔗 More free connectors – like LinkedIn Ads, and Microsoft Ads – so you can unify your marketing data in BigQuery with zero switching costs
🎥 Step-by-step video tutorials – guiding you through setup and analysis with no prior coding experience
📊 Ready-to-use dashboards – deliver your BigQuery data directly into Google Sheets and Looker Studio, so teams get insights faster with less effort.

Visit our GitHub repo, give us a ⭐ star, and help us build a more open, flexible future for data analysts and marketers everywhere.