Skip to content
OWOX Data Marts

How to Import Data from the Reddit Ads Source

To start importing data from Reddit Ads, make a copy of one of the following templates:

Fill in required parameters:

  • Account IDs
  • Fields
  • Destination Dataset ID (applicable only for the Google BigQuery template)
  • Destination Location (applicable only for the Google BigQuery template)

You can find your Account ID on the homepage of your Reddit Ads account:

Reddit Account ID

Copy and paste the ID into the appropriate field in the spreadsheet:

Account ID

Some fields are pre-filled by default.
To include additional fields, go to the Fields tab and check the boxes next to the ones you need.

Reddit Fields

If you are using the Google BigQuery template, you must also specify:

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

ℹ️ Important: If the specified BigQuery dataset does not already exist in your Google Cloud project, it will be automatically created during the import process.

Reddit Dataset

Open the menu: OWOX → Manage Credentials

Reddit Credentials

Enter your credentials as described in this guide:
How to obtain the credentials for the Reddit Ads connector

Reddit Token

Click Check and Save. Once credentials are saved, go to menu.

Now you have two options for importing data from Reddit Ads:

Option 1: Import Current Day’s Data

Choose OWOX → Import New Data to load data for the current day.

Reddit Import New Data

ℹ️ If you click Import New Data again after a successful initial load,
the connector will import: Current day’s data, plus Additional days, based on the value in the Reimport Lookback Window field.

Reddit Reimport

Option 2: Manual Backfill for Specific Date Range

Choose Manual Backfill to load historical data for a custom time range.

Reddit Backfill

  1. Select the Start Date and End Date
  2. Click the Run Manual Backfill button

Reddit Run Backfill

The process is complete when the Log field shows the message:
“Import is finished”

Access Your Data:

  • In the Google Sheets template, the data will appear in new tabs labeled with the corresponding data types (e.g., accounts).

Reddit Finished

  • In the Google BigQuery template, the data will be written to the dataset specified earlier.

Reddit Finished

Want to include more fields? You can customize the imported data by selecting additional checkboxes in the Fields tab. After adjusting your field selection, run the import again to retrieve the updated data.

If you encounter any issues:

  1. Check the “Logs” sheet for specific error messages
  2. Please visit Q&A first
  3. If you want to report a bug, please open an issue
  4. Join the discussion forum to ask questions or propose improvements