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.

Create the Data Mart

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

Set Up the Connector

1. Select Connector as the input source type.
2. Click Setup connector and choose Reddit Ads.
3. Fill in the required fields:
   • App ID – paste the App ID you saved earlier following the CREDENTIALS tutorial.
   • Secret – paste the Secret you saved earlier following the CREDENTIALS tutorial.
   • Redirect URI – paste https://www.reddit.com/prefs/apps
   • Refresh Token – paste the token you created following the CREDENTIALS tutorial.
   • User Agent – googleapps: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.

Configure Data Import

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 Save, then Publish & Run Data Mart. Publishing starts the first import automatically.

Resolve Short Links

Ads often point to short links. OWOX can follow each short link and store its target next to it:

• Ads: click_url resolves into click_url_parsed.

Keep the source field and its parsed field selected and enable Process Short Links under Advanced settings. OWOX selects click_url and click_url_parsed by default. A parsed field holds the address the short link service points to, and the original value for other links. OWOX does not request that address, so redirects on the landing site itself are not followed.

OWOX resolves links from known short link services, such as Bitly (bit.ly) and TinyURL (tinyurl.com). Links on other domains stay unchanged. Your administrator adds your own short link domains to the CONNECTOR_SHORT_LINK_DOMAINS environment variable. In OWOX Cloud, contact support to add a domain. See Environment Variables.

OWOX sends one request per distinct link and remembers the answer for 30 days, including links that do not redirect. Later runs skip remembered links. If a Data Mart has more distinct links than the memory holds, OWOX requests the extra ones on each run.

OWOX re-imports Ads on every run, so existing rows get the parsed field on the next run.

Run the Data Mart

Publish & Run Data Mart already started the first import. To import data again, you have two options:

Option 1: Import Current Day’s Data

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

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

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.

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

Access Your Data

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

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