Reddit Ads is the advertising platform of Reddit that enables businesses to create, manage, and measure paid campaigns across Reddit communities. It allows you to target audiences by interests, communities, keywords, locations, and devices, and to track the performance of your campaigns, ad groups, and ads.
Hevo uses the Reddit Ads API to replicate data from your Reddit Ads account to the Destination of your choice. Hevo connects to your account using Open Authorization (OAuth), where you sign in to Reddit and grant Hevo access to your advertising data. Hevo requests the adsread and identity scopes during authorization.
Supported Features
| Feature Name |
Supported |
| Capture deletes |
No |
| History mode |
Yes (for the Business Account object) |
| Custom data (user-configured tables & fields) |
Yes, custom reports
|
| Data blocking (skip objects and fields) |
Yes |
| Resync (objects and Pipelines) |
Yes |
| API configurable |
Yes |
Perform the following steps to configure your Reddit Ads Source:
-
Click Pipelines in the Navigation Bar.
-
Click + Create Pipeline in the Pipelines List View.
-
On the Select Source Type page, select Reddit Ads.
-
On the Select Destination Type page, select the type of Destination you want to use.
-
In the Configure Source screen, specify the following:

-
Source Name: A unique name for your Source, not exceeding 255 characters. For example, Reddit Ads Source.
-
In the Connect to Reddit Ads section:
-
Click Authorize Reddit Ads.
-
Log in to Reddit as a user who has access to your ad accounts.
-
Click Allow to grant Hevo permission to read your advertising data and your Reddit username.

-
In the Select Account section, select the Sync Mode:
-
Sync All Accounts (default): Hevo ingests data from all the ad accounts that the Reddit user can access, including the ad accounts added later.
-
Sync Specific Accounts: Hevo ingests data only from the ad accounts that you select. In the Select Ad Accounts section, select the ad accounts from which you want to ingest data.
-
(Optional) In the Custom Reports section, click Add Report to create a custom report, and click Save after you configure it. You can add up to 25 custom reports.
-
In the Historical Sync section, select the Historical Sync Time Frame: The period for which the first run of the Pipeline ingests the data of the report objects. Select one of the following: 3 months, 6 months (default), 12 months, 24 months, or All available history. If you select All available history, Hevo ingests the report data from November 4, 2024. You cannot change this value after you create the Pipeline.
-
Click Test & Continue to test the connection to your Reddit Ads Source. Once the test is successful, you can proceed to set up your Destination.
Data Replication
Hevo replicates data for all the objects selected on the Configure Objects page during Pipeline creation. By default, all supported objects and their available fields are selected. However, you can modify this selection while creating or editing the Pipeline. To ingest a child object, you must also select its parent object. The Data Model lists the child objects of each parent object.
Hevo ingests the objects as follows:
| Ingestion |
Objects |
| The daily performance data of the period that you select in Historical Sync Time Frame in the first run. In subsequent runs, Hevo ingests the data of the last 30 days again once every 24 hours, and the data of the last 2 days in the other runs, so that metrics that Reddit updates later, such as conversions, are included. |
The report objects, such as Account Report and Campaign Conversions Report, and the custom reports |
| All the records, in each run |
All the other objects |
Reddit limits the number of API requests that an application can make. If a limit is exceeded, Hevo waits and retries the request. To understand how Hevo handles such scenarios, read Handling Rate Limit Exceptions.
Hevo supports the Merge and History Tracking load modes for this Source. The History Tracking mode is available only for the Business Account object. All other objects support only the Merge mode.
Custom Reports
A custom report contains the performance metrics of your ad accounts, broken down by the dimensions that you choose. Hevo creates a table for each custom report, named after the report, and ingests it in the same way as the other report objects. If you add or edit a custom report after you create the Pipeline, resync the corresponding object to apply the changes. To create a custom report, click Add Report in the Configure Source screen, specify the following, and click Save:

-
Report name: A unique name for the report. You cannot change it after you add the report.
-
Breakdowns: One or two dimensions by which Reddit breaks down the metrics, such as CAMPAIGN_ID, COUNTRY, COMMUNITY, or PLACEMENT. If you select REGION, Reddit also includes COUNTRY, which does not count toward the limit.
-
Report data time zone: The time zone in which Reddit returns the report data: the time zone of each ad account, or a time zone that you select.
-
Fields: The metrics to ingest. If you do not select any field, Hevo ingests all the available fields.
-
Include event conversion data: Turn this on to also ingest the conversion metrics of the report into an additional table.
Schema and Primary Keys
Hevo uses the following schema to upload the records in the Destination. For a detailed view of the objects, fields, and relationships, click the ERD.
Data Model
The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:
| Object |
Description |
| Account Conversions Report |
Contains the daily conversion metrics of each ad account, such as the number of clicks, views, and purchases attributed to the ads. |
| Account Report |
Contains the daily performance metrics of each ad account, such as impressions, clicks, spend, and video views. |
| Ad |
Contains the ads in your ad accounts, such as the name, status, and ad group of each ad. It includes the following child objects: - Click URL Query Parameter - Event Tracker |
| Ad Conversions Report |
Contains the daily conversion metrics of each ad. |
| Ad Group |
Contains the ad groups in your ad accounts, such as the name, status, bid, and campaign of each ad group. It includes the following child objects: - Schedule - Targeting Community - Targeting Custom Audience - Targeting Device - Targeting Geolocation - Targeting Interest - Targeting Keyword - Targeting Placement |
| Ad Group Conversions Report |
Contains the daily conversion metrics of each ad group. |
| Ad Group Report |
Contains the daily performance metrics of each ad group. |
| Ad Report |
Contains the daily performance metrics of each ad. |
| Business Account |
Contains the ad accounts of your Reddit business, such as the name, currency, time zone, and status of each ad account. It includes a child object, Pixel Partner Reference. |
| Campaign |
Contains the campaigns in your ad accounts, such as the name, objective, status, and budget of each campaign. |
| Campaign Conversions Report |
Contains the daily conversion metrics of each campaign. |
| Campaign Country Conversions Report |
Contains the daily conversion metrics of each campaign, broken down by country. |
| Campaign Country Report |
Contains the daily performance metrics of each campaign, broken down by country. |
| Campaign Report |
Contains the daily performance metrics of each campaign. |
| Community |
Contains the Reddit communities (subreddits) that you can target, such as the name and the number of subscribers of each community. |
| Custom Audience History |
Contains the custom audiences of your ad accounts, such as the name, type, status, and size of each audience. It includes the following child objects: - Engagement Audience Campaign - Engagement Audience Tracking Type - Pixel Audience Custom Targeting - Pixel Audience Targeting |
| Geolocation |
Contains the locations that you can target, such as countries, regions, and cities. |
| Interest |
Contains the interests that you can target, such as the name and category of each interest. |
| Time Zone |
Contains the time zones that Reddit Ads supports. |
Hevo also creates a table for each custom report that you add, and an additional table for its conversion metrics if you turn on Include event conversion data.
Read the detailed Hevo documentation for the following related topics:
Handling of Deletes
Hevo does not capture deletes for any object, including the report objects and custom reports. Records deleted in your Reddit Ads account remain in the Destination.
Source Considerations
-
The Community, Geolocation, and Interest objects contain the targeting options that Reddit provides to all advertisers, not only the data of your ad accounts. For example, the Community object contains all the Reddit communities that you can target, which can be several hundred thousand records. Deselect these objects if you do not need them.
-
Hevo creates a table in the Destination only for the objects that have data. For example, if your ads do not use event trackers, the Event Tracker table is not created.