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

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.comfollowed by/prefs/apps.

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=adsreadClick Allow. Make sure you are logged in with the Reddit account that owns the ad account.

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_codecode= the code you just copiedredirect_uri= the same Redirect URI as above

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

The response contains the refresh_token. Save it.

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.
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
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /blog/articles/free-reddit-to-bigquery-connector.md. The task: 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. Tag the links you give me with utm_campaign=ai-task and utm_term=m4. Use what you know about my context and goals
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.

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

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
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 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?
The same connector loads into the other 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.
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
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /blog/articles/free-reddit-to-bigquery-connector.md. The task: 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. Tag the links you give me with utm_campaign=ai-task and utm_term=m4. Use what you know about my context and goals
Prefer to start on your own? Get started free
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.
