Reddit Ads
Renta allows you to sync Reddit Ads data to your data warehouse: daily campaign statistics (spend, impressions, clicks, video and conversion metrics) and account structure metadata for campaigns, ad groups, and ads.
Authentication
Renta uses OAuth to authenticate with Reddit. You will be redirected to Reddit to grant Renta limited access to your advertising data.
Your credentials are encrypted in transit and at rest, and never stored in Renta's application database. You stay in control and can revoke access from your Reddit account settings at any time.
Connect Reddit Ads source
Follow these steps to add Reddit Ads as a source in Renta using OAuth authentication.
- Navigate to the Connections > Catalog section in the left sidebar.
- Open the Advertising category and click the Reddit Ads card.

Click Log in to your Reddit Ads account. You will be redirected to Reddit to grant access.

Reddit shows the permission list, including read access to your advertising data. Click Allow. After that you are redirected back to Renta.

Finish the setup:
- Source name.
Specify a name for this data source. This is used exclusively in the Renta interface. - Access granted.
Verify that the account is connected successfully.
Click Save to finish.
If your Reddit authorization later changes (for example, after a password change), click Re-authorize on this source. The connection refreshes in place and every pipeline built on it keeps running.

The new source appears in the Sources list with the Active status. You can now use it in pipelines.

Create a pipeline
Once the source is connected, create a pipeline to sync your Reddit Ads data into your destination.
Create a Reddit Ads pipeline
Link your Reddit Ads source to a destination and configure the pipeline.
In the left sidebar, click New pipeline. On the Source step, select Reddit Ads under Already connected and click Next step.

Choose the Reddit Ads connection you created earlier and click Next step.

On the Destination step, select your destination (for example, Google BigQuery) and click Next step.

Choose the destination connection you want to load data into and click Next step.

Pipeline configuration
On the final step, choose which Reddit Ads data to export and how Renta loads it.
Report configuration
Point the pipeline at the business, ad account, and report type you need.

-
Business Choose your Reddit Ads business account.
-
Ad account Choose the Reddit Ads ad account to export data from.
-
Report Types Choose what kind of data the pipeline loads:
Report type Description Statistics report Daily performance metrics for the ad account. Campaigns metadata Campaign metadata for the advertiser's account. Ad groups metadata Ad group metadata for the advertiser's account. Ads metadata Ad creative metadata for the advertiser's account. Ad accounts metadata Ad account metadata for the advertiser's account. Businesses metadata Business entity metadata for the advertiser's account. Gallery items metadata Gallery item (carousel card) metadata for the advertiser's account.
Parameters
Select the fields to include in your destination table. Your dataset schema is defined by the parameters you choose here.

For metadata report types, parameters are the entity fields: IDs, names, statuses, configuration attributes, and creation timestamps.
For the Statistics report, 75 metrics are available: impressions, clicks, spend, CTR, CPC, reach, frequency, engagement (upvotes, comments), video views and completion rates, and conversion metrics (page visits, purchases, sign ups, leads, ROAS).
The Statistics report is grouped by date, so each row in the destination table is one day.
The Reddit Ads API returns Spend in micro-units of your account currency: one dollar is 1,000,000. Select the Costs parameter to get spend converted to regular currency units. Renta then fetches spend automatically and divides it by 1,000,000.
Date range
Set the historical period to load. The date range applies to the Statistics report: Renta requests metrics for the selected window. Metadata report types always load the full current list of entities.

- Date start.
The first date of the extraction period. - Date end.
The last date of the extraction period. Leave it as Today to keep collecting new data on every run.
Schedule
Choose how often the pipeline runs.

| Schedule type | Description |
|---|---|
| Manual | The pipeline runs only when triggered manually through the interface or via API. |
| Daily | The pipeline runs once a day at the specified update time. |
| Interval | The pipeline runs at specified time intervals. |
| Cron Expression | The pipeline runs on a schedule defined by a cron expression. |
For Daily schedules, set the Update time, the exact time each run starts, then click Create pipeline.

Renta also supports API triggers and integration with external orchestrators such as Apache Airflow, Dagster, and Prefect. See the full scheduling documentation for details.
The new pipeline appears in the Pipelines section under the ETL tab, where you can track its runs, progress, and the destination table name.

Sync strategy
The table below describes how Renta synchronizes each Reddit Ads report type.
| Strategy | Supported report types | Description |
|---|---|---|
| Incremental | Statistics report | Renta requests metrics for the selected date range, filtering by the report date. Tables are partitioned by date, and each scheduled run reloads the most recent days of the range, so late metric adjustments from Reddit are captured. |
| Full reload | Ad accounts metadata, Ad groups metadata, Ads metadata, Businesses metadata, Campaigns metadata, Gallery items metadata | The Reddit Ads API returns these entities without a modification-date filter, so Renta reloads the full current list on every run. The table reflects the account structure at the time of the sync. |
Ready to get started?
Build your data pipeline today or get a personalized demo. Start free!
Need help?
Get expert support to ensure your project succeeds. We're here to help!
Feature requests?
Help shape our product! Share your ideas for new features and integrations.