Connector Name, Essential Attributes and Supported Tables

Discover key attributes and supported tables for various connectors to enhance your integration and data management strategies.

Need help with something?

Talk to data expert

1. Overview

The Reddit Ads connector lets Saras Analytics (Daton) replicate your Reddit advertising data — campaign metadata, ad metadata, and performance/insights reports — into your data warehouse (BigQuery, Snowflake, Redshift, etc.)


2. Prerequisites

Before you begin, make sure you have:

  1. A Reddit account that is a member of the Reddit Business Manager that owns the ad accounts you want to replicate. 
  2. At least Admin or Ad Account Manager level access on each Ad Account you intend to pull. 
  3. Your Reddit Business ID.  
  4. A destination warehouse already connected in Daton. 

The connector requests only the read scope adsread. It cannot create, edit, pause, or delete anything in your Reddit Ads account — it is read-only.


Supported Tables

The connector produces three tables:

Table

Grain

Full load supported

Description

campaigns

One row per campaign

Yes

Campaign metadata. Full Replication

ads

One row per ad

Yes

Ad metadata. Full Replication

report_1

Report grain (defined by your breakdowns)

No (incremental only)

The performance/insights report. Columns are auto-generated from the breakdowns and fields you selected. Uses the lookback window to refresh recent data.