Skip to content

How to Import Data from the Reddit Ads Source

Before you begin, please ensure that:

  • You have already obtained all required credentials, as described in CREDENTIALS.
  • You have set up OWOX Data Marts and created at least one storage in the Storages section.

Reddit Ads Storage

  • Click New Data Mart.
  • Enter a title and select the Storage.
  • Click Create Data Mart.

Reddit Ads New Data Mart

  1. Select Connector as the input source type.
  2. Click Setup connector and choose Reddit Ads.
  3. Fill in the required fields:
    • Client ID – paste the App ID you saved earlier.
    • Client Secret – paste the Secret you saved earlier.
    • Redirect URI – paste https://www.reddit.com/prefs/apps
    • Refresh Token – paste the token you created following the CREDENTIALS tutorial.
    • User Agentgoogleapps:owox-data-marts.redditads:v1.0.0 (by /u/your_reddit_username) (replace your_reddit_username with your actual Reddit username).
    • Account ID – you can find this value on your Reddit Ads Manager.
    • Leave the other fields as default and proceed to the next step.

Reddit Ads Input Source

Reddit Ads Fill Data

Reddit Ads Account ID

  1. Choose one of the available endpoints.
  2. Select the required fields.
  3. Specify the dataset where the data will be stored (or leave the default).
  4. Click Finish, then Save and Publish Data Mart.

Reddit Ads Publish Data Mart

You now have two options for importing data from Reddit Ads:

Option 1: Import Current Day’s Data

Choose Manual run → Incremental load to load data for the current day.

Reddit Ads Import New Data

Reddit Ads Incremental Load

ℹ️ If you click Incremental load 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 Ads Reimport

Option 2: Manual Backfill for Specific Date Range

Choose Backfill (custom period) to load historical data.

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

Reddit Ads Backfill

The process is complete when the Run history tab shows the message:
“Success”

Reddit Ads Success

Once the run is complete, the data will be written to the dataset you specified earlier.

Reddit Ads Import Success

If you encounter any issues:

  1. Check the Run history 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