Data Integration

How to connect Reddit Ads to BigQuery with OWOX Data Marts

Reddit Ads to Google BigQuery in OWOX Data Marts: get the credentials from a Reddit app, create a Data Mart, choose the Reddit Ads connector, enter the credentials, pick the data and publish. Then add a trigger and it refreshes on its own.

Data IntegrationVadym Kramarenko5 min read

How to connect Reddit Ads to BigQuery with OWOX Data Marts

Reddit Ads Manager shows you campaigns, and a file export if you ask for one. To compare Reddit with your other channels you need the data in Google BigQuery, loaded on a schedule.

OWOX Data Marts does the loading: you create a Data Mart, enter your Reddit credentials once, choose what to load, and publish. Nothing to install. This guide walks through it on OWOX Cloud.

Reddit has no one-click sign-in for its Ads API, so the credentials come from a Reddit app you create yourself. That is Step 1, and it is the longest part.

Reading to get this done?

What you need

What you need

  • An OWOX Cloud account. Sign up if you do not have one.
  • A Google BigQuery storage in OWOX Data Marts. Add it under Storages, or create it while you set up the Data Mart. More on Google BigQuery as a storage.
  • A Reddit account with access to the ad account you want to load.
  • Postman or a similar tool for one API request in Step 1.
  • The ad account ID. It is shown in Reddit Ads Manager.

Step 1: Get your Reddit Ads credentials

Step 1: Get your Reddit Ads credentials

You will leave this step with five values: an App ID, a Secret, a Redirect URI, a Refresh Token and a User Agent. The credentials guide in the OWOX docs is the reference if Reddit’s screens change.

Create the app. Go to the Reddit Ads page, log in, and select Developer Applications in the left-hand panel.

Reddit page with left hand panel expanded with developer applications being highlighted.

Click Create App and fill in the form:

  • App Name: for example, OWOX Data Marts.
  • Description: what the app is for, such as “This app will extract advertising metrics and store them in my data warehouse. The data will be processed via OWOX Data Marts to support daily marketing reporting.”
  • About URL: the address of the Reddit Ads connector page in the OWOX docs.
  • Redirect URI: the address of the Reddit apps page, https://www.reddit.com followed by /prefs/apps.

Reddit developer page showing filled app creation form with highlighted fields for App Name, Description, and Redirect URI.

Create the app and note the App ID, shown under the app name, and the Secret.

Get an authorization code. Open the address below in your browser, with your App ID in place of YOUR_APP_ID. It is one URL, shown on several lines: join them with no spaces.

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

Click Allow. Make sure you are logged in with the Reddit account that owns the ad account.

Reddit authorization screen showing OWOX Data Marts app requesting permission with an “Allow” button.

Reddit sends you back to the apps page. Copy the value of the code parameter from the address bar.

Exchange the code for a refresh token. In Postman, make a POST request to the Reddit token endpoint, https://www.reddit.com followed by /api/v1/access_token, with three parameters:

  • grant_type = authorization_code
  • code = the code you just copied
  • redirect_uri = the same Redirect URI as above

Postman setup showing params for grant type, code, and redirect URI.

Under Authorization choose Basic Auth, with the App ID as the username and the Secret as the password. Click Send.

Postman request showing Basic Auth fields for App ID and Secret.

The response contains the refresh_token. Save it.

Postman response JSON showing refresh token field highlighted.

Write the User Agent. Reddit requires one on every API request. Use this format, with your own Reddit username:

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

Keep the Secret and the Refresh Token private: anyone holding them can read the ad account.

Hand this to your AI

Reddit Ads Manager shows its campaigns in isolation, so you can't say whether Reddit costs more or less per conversion than your other channels.

Paste this into your AI assistant. It loads your Reddit Ads campaigns into BigQuery on a schedule and compares their cost per conversion with your other ad platforms.

The prompt

load my Reddit Ads spend and conversions by campaign into BigQuery every day, and compare Reddit's cost per conversion with my other ad platforms by week

Step 2: Create the Data Mart

Step 2: Create the Data Mart

Click New Data Mart, give it a title, choose your Google BigQuery storage and click Create Data Mart. If you have no storage yet, pick Create new storage in the same dropdown.

The Create Data Mart form in OWOX Data Marts with a title and a Google BigQuery storage selected

Step 3: Choose the Reddit Ads connector and enter the credentials

Step 3: Choose the Reddit Ads connector and enter the credentials

On the Data Setup tab, set Input Source to Connector and click Setup Connector. Choose Reddit Ads in the list and click Next.

Fill in the settings:

  • App ID and Secret: from the Reddit app.
  • Redirect URI: the same address you gave the app.
  • Refresh Token: from the Postman response.
  • User Agent: the line you wrote in Step 1.
  • Account IDs: the ad account to load.

The rest sits under Advanced settings and is optional for a first run.

Step 4: Choose what to load

Step 4: Choose what to load

Pick the data you want. Each option in the list has a one-line description: the entities such as campaigns, ad groups and ads carry names and settings, and the ad metrics carry the performance numbers. Each Data Mart loads one of them, so create another Data Mart for each extra one.

Keep the default fields or add more. The key fields stay selected.

Name the dataset and the table. Both are created on the first run if they do not exist yet.

Click Save.

Step 5: Publish and run

Step 5: Publish and run

Click Publish & Run Data Mart. The first run loads data from the first day of the previous month and can take a few minutes.

To load older history, use Manual Run on the same screen and choose the dates. Run History shows every run and its status.

The Manual Run dialog in OWOX Data Marts with Backfill (custom period) selected and empty Start Date and End Date fields

Step 6: Keep it fresh

Step 6: Keep it fresh

Open Triggers, add a trigger, choose Connector Run and set how often it runs: daily at a time and time zone you pick, weekdays, hourly or every few hours. Click Create trigger.

From here the table updates on its own.

What to do with the data

What to do with the data

The table is raw Reddit Ads data, at the grain of the data you chose. Two things usually come next:

  • Join it with your other ad platforms in SQL, so spend is compared on one grain. The unified ad report guide shows that query.
  • Publish it where people read it. The same Data Mart can feed a destination such as a Google Sheets report, Slack or email, so the number in the sheet matches the number in BigQuery.

OWOX Data Marts loads the data and publishes what you build on it. The SQL that turns it into metrics stays yours.

Not on BigQuery?

Not on BigQuery?

The same connector loads into the other data storages OWOX Data Marts supports: Snowflake, AWS Redshift, AWS Athena and Databricks.

OWOX Data Marts is also open source. If you run it yourself, the Reddit credentials from Step 1 work the same way.

Hand this to your AI

Reddit Ads Manager shows its campaigns in isolation, so you can't say whether Reddit costs more or less per conversion than your other channels.

Paste this into your AI assistant. It loads your Reddit Ads campaigns into BigQuery on a schedule and compares their cost per conversion with your other ad platforms.

The prompt

load my Reddit Ads spend and conversions by campaign into BigQuery every day, and compare Reddit's cost per conversion with my other ad platforms by week

FAQ

Frequently Asked Questions

How do I load older Reddit Ads data?

The first run loads data from the first day of the previous month. For earlier dates, open Manual Run, choose Backfill and set the start and end dates.

How do I get Reddit API credentials for the connector?

Create an app under Developer Applications in Reddit Ads, authorize it with the adsread scope, and exchange the code for a refresh token. You end up with an App ID, a Secret, a Redirect URI, a Refresh Token and a User Agent, and enter them once in the connector settings.

Where do I find my Reddit Ads account ID?

In Reddit Ads Manager, on the main dashboard of your ad account.

Which Reddit Ads data can I load into BigQuery?

Each Data Mart loads one kind of data: entities such as campaigns, ad groups and ads, or ad metrics with the performance numbers. You keep the default fields or choose your own.

Is the Reddit Ads to BigQuery connector free?

The connector is open source and free to run yourself with the open-source edition of OWOX Data Marts. You pay Google for BigQuery storage and queries. The same connector is available on OWOX Cloud, where there is no server to maintain.

Do I need coding experience to connect Reddit Ads to BigQuery?

No code, but one API request. The setup in OWOX Data Marts is point and click. Getting the Reddit refresh token takes one request in a tool such as Postman, described in Step 1.

Who wrote this

Vadym Kramarenko

Vadym Kramarenko Growth Marketing Manager

Vadym Kramarenko is a Growth Marketing Manager at OWOX, where he drives user acquisition and product-led growth strategies. He hosts the OWOX podcast, interviewing analytics professionals about data-driven marketing, attribution, and reporting best practices. Vadym specializes in turning complex analytics concepts into practical, actionable marketing frameworks.