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
Section titled “Create the Data Mart”- Click New Data Mart.
- Enter a title and select the Storage.
- Click Create Data Mart.
Set Up the Connector
Section titled “Set Up the Connector”- Select Connector as the input source type.
- Click Setup connector and choose Reddit Ads.
- 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 Agent –
googleapps:owox-data-marts.redditads:v1.0.0 (by /u/your_reddit_username)
(replaceyour_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
Section titled “Configure Data Import”- Choose one of the available endpoints.
- Select the required fields.
- Specify the dataset where the data will be stored (or leave the default).
- Click Finish, then Save and Publish Data Mart.
Run the Data Mart
Section titled “Run the 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.
ℹ️ 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.
- Select the Start Date and End Date.
- Click the Run button.
The process is complete when the Run history tab shows the message:
“Success”
Access Your Data
Section titled “Access Your Data”Once the run is complete, the data will be written to the dataset you specified earlier.
If you encounter any issues:
- Check the Run history for specific error messages
- Please visit Q&A first
- If you want to report a bug, please open an issue
- Join the discussion forum to ask questions or propose improvements