Skip to content
OWOX Docs

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:

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

The import will begin from the selected Start Date.

⚠️ Note: Choosing a long date range may result in import failure due to high data volume.

Reddit Start Date

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:
OWOX → Import New Data

Reddit Import Data

The process is complete when the Log sheet 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

To include more fields later, check the appropriate boxes in the Fields tab and click:
OWOX → Import New Data

⚠️ Important: To change the date range:

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

Reddit Clear

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