Reddit Ads Custom Reports

The Reddit Ads connector supports custom reports that you can configure with breakdowns - dimensions that segment your advertising data for detailed analysis.

Custom reports with breakdowns provide flexibility to analyze your Reddit Ads performance data across different dimensions. Instead of using predefined level and segmentation combinations, you select up to 2 breakdowns per custom report to create reports tailored to your analytics needs.

Available breakdowns

You can use the following breakdowns when creating custom reports:

Region and country auto-selection

If you select REGION as a breakdown, we automatically include the COUNTRY dimension in the report's primary key. This ensures data integrity because regions are unique only within their respective countries.

For example, if you configure a report with only the REGION breakdown, the resulting table has the account_id, date, region, and country primary keys. This lets you to distinguish between regions with the same name in different countries (e.g., "Georgia" the state vs. "Georgia" the country).

Common use cases

The following examples demonstrate common custom report configurations:

Country-level campaign performance:

{
  "reportName": "campaign_by_country",
  "breakdowns": ["CAMPAIGN_ID", "COUNTRY"]
}

Regional performance (includes country automatically):

{
  "reportName": "campaign_by_region",
  "breakdowns": ["CAMPAIGN_ID", "REGION"]
}

Performance by interest:

{
  "reportName": "ad_group_by_interest",
  "breakdowns": ["AD_GROUP_ID", "INTEREST"]
}

Gender performance:

{
  "reportName": "campaign_by_gender",
  "breakdowns": ["CAMPAIGN_ID", "GENDER"]
}

OS type optimization:

{
  "reportName": "ad_by_os_type",
  "breakdowns": ["AD_ID", "OS_TYPE"]
}

Placement effectiveness:

{
  "reportName": "campaign_by_placement",
  "breakdowns": ["CAMPAIGN_ID", "PLACEMENT"]
}

Custom reports schema and table structure

Each custom report with breakdowns creates a table in your destination with the following structure:

Primary keys

• account_id (always included)
• date (always included)
• Breakdown-specific key(s) based on your selection
• country (automatically added only when REGION is selected)

Data fields

• Selected report fields (impressions, clicks, spend, etc.)
• All selected conversion metrics (if conversions are enabled)

Example table structure for a campaign + country report:

Conversion data with breakdowns

When you enable Include event conversions data for a custom report with breakdowns, Fivetran creates an additional conversions table with the same primary keys as your main report table.

Naming convention:

• Main report: {REPORT_NAME}_REPORT
• Conversions report: {REPORT_NAME}_CONVERSIONS_REPORT

Example:

• Report name: CAMPAIGN_COUNTRY
• Main table: CAMPAIGN_COUNTRY_REPORT
• Conversions table: CAMPAIGN_COUNTRY_CONVERSIONS_REPORT

Migration from level/segmentation to breakdowns

If you had previously configured custom reports using the level and segmentation fields, those configurations will continue to function and are automatically migrated to use breakdowns.

Existing reports using level/segmentation are automatically mapped to the equivalent breakdowns:

Limitations

• You can select up to 2 breakdowns per custom report.
• You cannot modify breakdowns after the initial report creation. Instead, you must create a new report.
• Report names must be unique within a connection.
• Some breakdown combinations may result in sparse data depending on your Reddit Ads account configuration.

Related articles

Connector Overview

Schema Information

Release Notes

API Connector Configuration

Documentation Home