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 (Community Apps Script Edition), 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 powered by Google Apps Script, 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, GA4, 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 open 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 Choose This Free Connector by OWOX  

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 – Not a trial, not a restricted version. Every feature is available from day one, with no hidden fees.
• No platform lock-in – You own the setup. No signup required, no hosted environment, and no risk of vendor lockout.
• Custom-built with Google Apps Script – No need for middleware, external sync services, or paid automation tools. It runs directly in your spreadsheet and writes to BigQuery.
• 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.

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.

Google BigQuery

Data sources

Free Reddit Ads Connector to Google BigQuery

Download template

Why Send Reddit Ads Data to 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.

 ❌ Reporting views are limited and lack customization
❌ Manual CSV exports are slow, error-prone, and don’t scale
❌ No built-in way to connect with GA4, CRM, or cost data systems

That’s why this free Reddit to BigQuery connector from OWOX Data Marts (Community Apps Script Edition) was built:

✅ Export raw campaign and performance data from Reddit Ads directly into Google BigQuery
✅ Blend Reddit data with other sources like GA4, Salesforce, HubSpot, or Meta Ads for complete funnel analysis
✅ Build your own attribution models, retention views, or ROAS frameworks tailored to your business

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.

How the Connector Works 

The Reddit to BigQuery integration is built entirely with open-source Google Apps Script - no third-party tools, no code barriers, 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 with GA4 or CRM sources, 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 insights.

Step-by-Step: Import Reddit Ads Data into BigQuery

This is where things get powerful. In just minutes, your Reddit Ads data can start flowing into BigQuery – no code, no blockers, just clean, structured data ready for analysis, reporting, and cross-channel insights.

Let’s walk through the setup process step by step.

Step 1: Copy the BigQuery Template (~ 30 sec)

Start with our ready-to-use Reddit Ads → BigQuery template - no manual setup required.

• Access the Template
  Open the “Reddit Ads → Google BigQuery. Template” template shared by OWOX.
• Make a Copy
  Click File → Make a copy to save the template to your own Google Drive and begin configuring.

Master Reddit Ads → BigQuery Reporting With Our Free Template!

Say goodbye to CSV exports and complex APIs – this plug-and-play BigQuery template lets you pull Reddit Ads data effortlessly.

Download your FREE template today!

Step 2: Configure the Source ( ~1 min)

1. Set up your import settings in the “Config” sheet to define the scope and timing of your Reddit Ads data pull.

• Choose the Start Date
  Decide how far back you want to fetch campaign data.

Tip: A shorter date range is recommended to ensure a faster and more reliable import.

2. Add Your Account ID(s)

• Your Reddit Ads Account ID is available on the main dashboard of your Reddit Ads account. 

Copy and paste this ID into the designated field within the spreadsheet’s configuration tab.

3. Choose Your Data Field

Go to the “Fields” tab and check the boxes of all the fields you want to import based on your reporting needs.  

4. Configure the BigQuery destination fields:

• Destination Dataset ID in the format: projectid.datasetid
• Destination Location matching your BigQuery region (e.g., US, EU) 

If the specified dataset doesn’t exist yet, it will be automatically created during import.

Then, fill out the remaining configuration parameters in the sheet as needed.

• ReimportLookbackWindow: Days to look back when reimporting data
• MaxFetchingDays: Max number of days to fetch per run 
• CleanUp To Keep Window: Automatically deletes rows older than the specified number of days from today. Leave blank to retain all rows.

Step 3: Get a Reddit Ads Access Token (~30 seconds)

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

Here are the steps:

1. Visit the Reddit Preferences Page.
   Go to the Reddit Preferences page and sign in with your existing Reddit account, or create a new one if you don’t have one yet.
2. Create a new app:
   Click the Create App button.

3. Enter the App Details:

• App Name and Description
• App type: Select script
• Redirect URI: http://localhost:8080

Click Create App 

4. Once the app is created, the following details will be displayed:

• Client ID (just under the app name)
• Client Secret
• Redirect URI 

5. Now, Go to the Reddit API Access Request Form. In the form, make the following selections: 

• Choose: “I'm a Developer”
• Then select: “I want to register to use the free tier of the Reddit API”
• Under “Purpose,” pick: Other

Provide the required additional details in the form:

• Describe your tool’s purpose: Example

"We plan to use the Reddit Ads API to automatically extract advertising metrics and store them in Google Sheets and BigQuery. This data will be processed via OWOX Data Marts to support daily marketing reporting and optimization efforts."

• Add a link to the repository: https://github.com/OWOX/owox-data-marts
• Include your Reddit username

Fill in the contact information and use case details:

• Reddit API Use Case: Example

"The Reddit Ads API will be used to automate data collection from our ad account. We use OWOX Data Marts to transfer this data into Google Sheets and BigQuery for marketing analytics, allowing us to streamline reporting and improve media planning."

• Developer Platform: Google Sheets, App Script
• OAUTH Client ID(s): Paste the Client ID from your app 

Complete the final step of the request form:

• Subject of inquiry: 

Request access to the Reddit API

• Details of inquiry: Example

"Our organization intends to leverage the Reddit Ads API to access campaign-level advertising data for integration into our internal analytics workflows. Using the OWOX Data Marts platform, this data will be securely transferred to Google Sheets and Google BigQuery to support real-time performance tracking, marketing spend analysis, and strategic reporting."

• Leave the file attachment section blank.
• Click “Submit” to send your request.

7. To generate your authorization code, use the following URL format. Be sure to replace YOUR_CLIENT_ID and RANDOM_STRING with your actual values (e.g., abc123):

https://www.reddit.com/api/v1/authorize
  ?client_id=YOUR_CLIENT_ID
  &response_type=code
  &state=RANDOM_STRING
  &redirect_uri=http://localhost:8080
  &duration=permanent
  &scope=read

Paste the URL into your browser and press Enter. 

When prompted, click “Allow,” ensuring you're logged into the Reddit account associated with your ad account. 

8. Copy the code parameter

• You'll be redirected to a URL that looks like this:

http://localhost:8080/?state=xyz123&code=bLcIq0FR9-8hjOpklbxK2dtRTsA#_

• From this URL, copy the value of the code parameter – in this case, it's: bLcIq0FR9-8hjOpklbxK2dtRTsA.

9. Use Postman to exchange the authorization code for a refresh token. Set up the request as follows: 

Fill the Parameters:

• grant_type=authorization_code
• code=YOUR_CODE (from previous step)
• redirect_uri=http://localhost:8080

Auth Type: Basic Auth

• Username: Your Client ID
• Password: Your Client Secret

Set the User-Agent properly:

Use this format in your API requests: 

googleapps:owox-data-marts.redditads:v1.0.0 (by /u/your_reddit_username)

Make sure to replace /u/your_reddit_username with your actual Reddit username. For more info on best practices for User-Agent, see Reddit's API Guidelines.

Now, you have everything you need to complete the setup:

• Client ID
• Client Secret
• Redirect URI
• Refresh Token

You're now ready to connect your Reddit Ads data to Google BigQuery using the OWOX template.

Step 4: Input Credentials in the Template ( ~10 seconds)

Connect your Reddit Ads credentials to the BigQuery template:

1. Open the Credentials Panel

• In your copied BigQuery template, go to the top menu and click: OWOX → Manage Credentials. 

2. Grant App Script Access

When prompted:

• Click “OK” to authorize the Apps Script.
• This allows the connector to access your Google Sheet and import data from Reddit Ads. 

3. Enter Your Add Your Credentials

• Paste your Client ID, Client Secret, Redirect URI, Refresh Token, and User Agent into the form.

• Click Save.

This step activates the connector with the correct credentials.

Step 5: Run the Connector & Import Your Data ( ~1 min)

Now, you're all set to load your data.

1. Start the Import

• From the spreadsheet menu, go to: OWOX → Import New Data.

• The connector will begin importing data from your specified Reddit Ads account(s).

1. Once the process completes, check the “Logs” sheet for the message: “Import is finished.”

In this Google BigQuery template, your data will be written directly into the dataset you configured earlier in the settings. 

To add more fields later, simply open the Fields tab, select the additional checkboxes, and run:

OWOX → Import New Data

Important: To change the date range:

• Clear existing data in the Status columns
• Update the Start Date and/or End Date
• Run OWOX → Import New Data again 

📊 Real-Time Reporting with OWOX Reports

Want to turn your Reddit Ads data in BigQuery into clear, actionable reports?

Use the OWOX Reports Extension for Google Sheets to bring Reddit to BigQuery insights directly into shareable dashboards – no SQL, no Looker Studio setup needed. 

With OWOX Reports, you can:
📥 Instantly pull Reddit Ads data from BigQuery into Google Sheets
📊 Build auto-refreshing dashboards for campaign performance and spend
✅ Share real-time insights with marketing and analytics teams, without technical overhead

No manual downloads. No scripts. Just smooth, visual reporting from Reddit Ads to BigQuery to Sheets – built for analysts who need speed, flexibility, and clarity.

What’s Next?

This free Reddit to BigQuery connector from OWOX Data Marts (Community Apps Script Edition) is part of our mission to make data ownership easy, transparent, and accessible, without expensive tools or technical barriers.

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, customization, and analysis with no prior coding experience
📊 Ready-to-use dashboards – helping you turn Reddit Ads data into insights in minutes, not hours

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

Google BigQuery

Data sources

Free Reddit Ads Connector to Google BigQuery

Download template