---
title: "Integrate Reddit Data with Different Data Destinations"
canonical: "https://www.owox.com/data-sources/reddit"
updated: "2026-09-29"
---

![Reddit Ads logo](https://cdn.owox.ai/www/webflow/679a01adc065220435d26849_328.svg/public)

# Collect Reddit Ads data. Deliver reports. Automate AI Insights.

Easily collect Reddit data with OWOX Data Marts, store in your data warehouse, automate reporting across major BI Tools and AI Insights (the ones that matter) delivered straight to corporate messengers on a schedule.

[Get started free](https://www.owox.com/app-signup)

![Reddit Ads](https://cdn.owox.ai/www/portfolio-management-data-source/reddit/hero/1.png/public)

## Available connectors

[Reddit Ads Connector to Azure Synapse](/connectors/reddit-ads-connector-to-azure-synapse)

[Reddit Ads Connector to ChatGPT](/connectors/reddit-ads-connector-to-chatgpt)

[Reddit Ads Connector to Claude](/connectors/reddit-ads-connector-to-claude)

[Reddit Ads Connector to Microsoft Excel](/connectors/reddit-ads-connector-to-microsoft-excel)

[Reddit Ads Insights to Email](/connectors/reddit-ads-insights-to-email)

[Reddit Ads Insights to Google Chat](/connectors/reddit-ads-insights-to-google-chat)

[Reddit Ads Insights to Microsoft Teams](/connectors/reddit-ads-insights-to-microsoft-teams)

[Reddit Ads Insights to Slack](/connectors/reddit-ads-insights-to-slack)

[Reddit Ads to AWS Athena Connector](/connectors/free-reddit-ads-connector-to-aws-athena)

[Reddit Ads to AWS Redshift Connector](/connectors/free-reddit-ads-connector-to-aws-redshift)

[Reddit Ads to Databricks Connector](/connectors/free-reddit-ads-connector-to-databricks)

[Reddit Ads to Google BigQuery Connector](/connectors/free-reddit-ads-connector-to-google-bigquery)

[Reddit Ads to Google Sheets Connector](/connectors/free-reddit-ads-connector-to-google-sheets)

[Reddit Ads to Looker Studio Connector](/connectors/free-reddit-ads-connector-to-looker-studio)

[Reddit Ads to Snowflake Connector](/connectors/free-reddit-ads-connector-to-snowflake)

## Endpoints

## Reddit Ads endpoints

[Documentation](https://docs.owox.com/packages/connectors/src/sources/reddit-ads/readme/)

18 Reddit Ads endpoints you can import. Each lands in its own table in your warehouse.

*   ### [Ad Account](#schema-ad-account)

    Your ad account settings — currency, attribution windows, and account type.

    17 fields
*   ### [Ad Account User](#schema-ad-account-user)

    The authenticated Reddit Ads user — identity and contact details.

    7 fields
*   ### [Ad Groups](#schema-ad-groups)

    Ad groups within your campaigns — bid strategy, goal, targeting, and schedule.

    27 fields
*   ### [Ad Performance](#schema-ad-performance)

    Daily ad performance — impressions, clicks, spend, conversions, and ROAS.

    55 fields · Time series
*   ### [Ad Performance by Account](#schema-ad-performance-by-account)

    Daily ad performance broken down by ad account.

    56 fields · Time series
*   ### [Ad Performance by Ad Group](#schema-ad-performance-by-ad-group)

    Daily ad performance broken down by ad group.

    56 fields · Time series
*   ### [Ad Performance by Campaign](#schema-ad-performance-by-campaign)

    Daily ad performance broken down by campaign.

    57 fields · Time series
*   ### [Ad Performance by Community](#schema-ad-performance-by-community)

    Daily ad performance broken down by subreddit (community).

    56 fields · Time series
*   ### [Ad Performance by Country](#schema-ad-performance-by-country)

    Daily ad performance broken down by user country.

    56 fields · Time series
*   ### [Ad Performance by DMA](#schema-ad-performance-by-dma)

    Daily ad performance broken down by Designated Market Area (DMA).

    56 fields · Time series
*   ### [Ad Performance by Interest](#schema-ad-performance-by-interest)

    Daily ad performance broken down by user interest targeting.

    56 fields · Time series
*   ### [Ad Performance by Keyword](#schema-ad-performance-by-keyword)

    Daily ad performance broken down by keyword.

    56 fields · Time series
*   ### [Ad Performance by Placement](#schema-ad-performance-by-placement)

    Daily ad performance broken down by ad placement.

    56 fields · Time series
*   ### [Ads](#schema-ads)

    Individual ads — type, status, and links to their campaigns and posts.

    23 fields
*   ### [Campaigns](#schema-campaigns)

    Your campaigns — objective, status, spend cap, and account association.

    15 fields
*   ### [Custom Audiences](#schema-custom-audiences)

    Custom audiences built from your user lists — type, status, and size estimates.

    9 fields
*   ### [Funding Instruments](#schema-funding-instruments)

    Payment methods linked to your campaigns — credit limits and current outstanding balance.

    9 fields
*   ### [Lead Gen Forms](#schema-lead-gen-forms)

    Lead generation forms shown in your ads — prompt text and creation details.

    8 fields

## Ad Account schema

## Reddit Ads Ad Account schema

17 fields · `reddit_ads_ad_account` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-account.js)

Your ad account settings — currency, attribution windows, and account type.

| Field | Type | Description |
| --- | --- | --- |
| `admin_approval` | STRING | Describes an employee set state for the account. |
| `attribution_type` | STRING | The attribution type. Only valid for CPA bid types. |
| `business_id` | STRING | The ID of the business that this account belongs to. |
| `click_attribution_window` | STRING | Configures the window to use when querying reporting for click attributions. |
| `created_at` | STRING | The time that this entity was created, represented in ISO 8601. |
| `currency` | STRING | The ISO4217 currency symbol for the currency used. |
| `id` | STRING | The ID of the ad account. |
| `modified_at` | STRING | The last time that this entity was modified, represented in ISO 8601. |
| `name` | STRING | The ad account name. |
| `pixel_partner_preferences` | STRING | A list of pixel partners allowed by the advertiser. |
| `primary_contact_member_id` | STRING | The ID of the primary contact member. |
| `suspension_reason` | STRING | The reason why this ad account was suspended. |
| `time_zone_id` | STRING | The default time zone setting for this entity. |
| `type` | STRING | The type of the ad account. |
| `view_attribution_window` | STRING | Configures the window to use when querying reporting for view attributions. |
| `excluded_communities` | STRING | Account level excluded communities. |
| `excluded_keywords` | STRING | Account level excluded keywords. |

## Ad Account User schema

## Reddit Ads Ad Account User schema

7 fields · `reddit_ads_ad_account_user` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-account-user.js)

The authenticated Reddit Ads user — identity and contact details.

| Field | Type | Description |
| --- | --- | --- |
| `email` | STRING | Email address of the member. |
| `firstname` | STRING | The first name of the member. |
| `id` | STRING | The unique identifier of the member. |
| `lastname` | STRING | The last name of the member. |
| `phone` | STRING | The phone number of the member. |
| `reddit_user_id` | STRING | ID that maps to the Reddit user. |
| `reddit_username` | STRING | The Reddit username of the member. |

## Ad Groups schema

## Reddit Ads Ad Groups schema

27 fields · `reddit_ads_ad_group` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-group.js)

Ad groups within your campaigns — bid strategy, goal, targeting, and schedule.

| Field | Type | Description |
| --- | --- | --- |
| `ad_account_id` | STRING | The ID of the ad account that the ad group belongs to. |
| `app_id` | STRING | The App ID of the app in the mobile app store (iOS App Store, Google Play Store). |
| `bid_strategy` | STRING | The bid strategy for the ad group. |
| `bid_type` | STRING | The bidding strategy for the ad group. |
| `bid_value` | INTEGER | The amount to pay in microcurrency per bidding event. |
| `campaign_id` | STRING | The ID of the campaign the ad group belongs to. |
| `campaign_objective_type` | STRING | The objective type of a campaign. |
| `configured_status` | STRING | The status of the ad group configured by the account owner. |
| `created_at` | STRING | The time that this entity was created, represented in ISO 8601. |
| `effective_status` | STRING | The effective status of the ad group in the system. |
| `end_time` | STRING | ISO 8601 timestamp when the ad group will stop delivering. |
| `goal_type` | STRING | The type of goal for the ad group. |
| `goal_value` | INTEGER | The value used to determine if the goal has been met. Measured in microcurrency for monetary goal types. |
| `id` | STRING | The ID of the ad group. |
| `modified_at` | STRING | The last time that this entity was modified, represented in ISO 8601. |
| `name` | STRING | The name of the ad group. |
| `optimization_strategy_type` | STRING | Deprecated - The type of optimization strategy. |
| `optimization_goal` | STRING | The event you want to measure. Required for conversion and app install campaign objectives. |
| `product_set_id` | STRING | The product set to associate with this ad group. |
| `schedule` | STRING | A list of times to run the ad group. |
| `shopping_targeting` | STRING | A container for shopping ad tracking-related fields. |
| `shopping_type` | STRING | The type of ads an ad group should contain for shopping ads. |
| `skadnetwork_metadata` | STRING | Metadata about the SKAdNetwork source ID associated with the ad group. |
| `start_time` | STRING | ISO 8601 timestamp when the ad group will begin to deliver. |
| `targeting` | STRING | Targeting information for the ad group. |
| `is_campaign_budget_optimization` | BOOLEAN | Determines if the ad group belongs to a CBO (campaign-budget-optimization) campaign. |
| `view_through_conversion_type` | STRING | The type of view-through conversion being measured. |

## Ad Performance schema

## Reddit Ads Ad Performance schema

55 fields · Time series · `reddit_ads_report` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-reports.js)

Daily ad performance — impressions, clicks, spend, conversions, and ROAS.

| Field | Type | Description |
| --- | --- | --- |
| `ad_id` | STRING | The ID of the ad. |
| `date` | DATE | The date for this metric. |
| `clicks` | INTEGER | The number of clicks detected for this report period. |
| `conversion_add_to_cart_avg_value` | NUMBER | Average value of the shopping cart. |
| `conversion_add_to_cart_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_cart_ecpa` | NUMBER | The cost per add to cart conversion. |
| `conversion_add_to_cart_total_items` | INTEGER | Total size of the shopping cart. |
| `conversion_add_to_cart_total_value` | INTEGER | Total value of the shopping cart. |
| `conversion_add_to_cart_views` | INTEGER | The view through conversions count. |
| `conversion_add_to_wishlist_avg_value` | NUMBER | Average value of the wish list. |
| `conversion_add_to_wishlist_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_wishlist_ecpa` | NUMBER | The cost per add to wishlist conversion. |
| `conversion_add_to_wishlist_total_items` | INTEGER | Total size of the wish list. |
| `conversion_add_to_wishlist_total_value` | INTEGER | Total value of the wish list. |
| `conversion_add_to_wishlist_views` | INTEGER | The view through conversions count. |
| `conversion_lead_avg_value` | NUMBER | Avg value of lead. |
| `conversion_lead_clicks` | INTEGER | The click through conversions count. |
| `conversion_lead_ecpa` | NUMBER | The cost per lead conversion. |
| `conversion_lead_total_value` | INTEGER | Total value of leads. |
| `conversion_lead_views` | INTEGER | The view through conversions count. |
| `conversion_page_visit_clicks` | INTEGER | The click through conversions count. |
| `conversion_page_visit_ecpa` | NUMBER | The cost per page visit conversion. |
| `conversion_page_visit_views` | INTEGER | The view through conversions count. |
| `conversion_purchase_avg_value` | NUMBER | Average value of purchase. |
| `conversion_purchase_clicks` | INTEGER | The click through conversions count. |
| `conversion_purchase_ecpa` | NUMBER | The cost per purchase conversion. |
| `conversion_purchase_total_items` | INTEGER | Total size of the purchase. |
| `conversion_purchase_total_value` | INTEGER | Total value of the purchase. |
| `conversion_purchase_views` | INTEGER | The view through conversions count. |
| `conversion_roas` | NUMBER | Return on ad spend for purchases for this period. |
| `conversion_search_clicks` | INTEGER | The click through conversions count. |
| `conversion_search_ecpa` | NUMBER | The cost per search conversion. |
| `conversion_search_views` | INTEGER | The view through conversions count. |
| `conversion_sign_up_clicks` | INTEGER | The click through conversions count. |
| `conversion_sign_up_ecpa` | NUMBER | The cost per sign up conversion. |
| `conversion_sign_up_views` | INTEGER | The view through conversions count. |
| `conversion_signup_avg_value` | NUMBER | Avg value of signup. |
| `conversion_signup_total_value` | INTEGER | Total value of signups. |
| `conversion_view_content_clicks` | INTEGER | The click through conversions count. |
| `conversion_view_content_ecpa` | NUMBER | The cost per view content conversion. |
| `conversion_view_content_views` | INTEGER | The view through conversions count. |
| `cpc` | NUMBER | The cost-per-click for this period. |
| `ctr` | NUMBER | The click-through-rate for this period. |
| `cpv` | NUMBER | \\\[Broken\\\] The cost-per-view for this period. |
| `ecpm` | NUMBER | The effective CPM for this period. |
| `engaged_click` | INTEGER | The number of engaged clicks such as RSVPs. |
| `hour` | STRING | The hour for this metric in ISO-8601. |
| `impressions` | INTEGER | The number of impressions served for this report period. |
| `post_id` | STRING | The unique identifier of the post. |
| `spend` | INTEGER | The amount (in microcurrency) spent for this report period. |
| `key_conversion_ecpa` | NUMBER | Key conversion effective cost per action. |
| `key_conversion_total_count` | INTEGER | Key conversion total count. |
| `reach` | INTEGER | The number of unique users who saw the ad. |
| `frequency` | NUMBER | The average number of times each user saw the ad. |
| `currency` | STRING | The currency of the account. |

## Ad Performance by Account schema

## Reddit Ads Ad Performance by Account schema

56 fields · Time series · `reddit_ads_report_by_AD_ACCOUNT_ID` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-reports-adaccountid.js)

Daily ad performance broken down by ad account.

| Field | Type | Description |
| --- | --- | --- |
| `ad_id` | STRING | The ID of the ad. |
| `date` | DATE | The date for this metric. |
| `clicks` | INTEGER | The number of clicks detected for this report period. |
| `conversion_add_to_cart_avg_value` | NUMBER | Average value of the shopping cart. |
| `conversion_add_to_cart_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_cart_ecpa` | NUMBER | The cost per add to cart conversion. |
| `conversion_add_to_cart_total_items` | INTEGER | Total size of the shopping cart. |
| `conversion_add_to_cart_total_value` | INTEGER | Total value of the shopping cart. |
| `conversion_add_to_cart_views` | INTEGER | The view through conversions count. |
| `conversion_add_to_wishlist_avg_value` | NUMBER | Average value of the wish list. |
| `conversion_add_to_wishlist_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_wishlist_ecpa` | NUMBER | The cost per add to wishlist conversion. |
| `conversion_add_to_wishlist_total_items` | INTEGER | Total size of the wish list. |
| `conversion_add_to_wishlist_total_value` | INTEGER | Total value of the wish list. |
| `conversion_add_to_wishlist_views` | INTEGER | The view through conversions count. |
| `conversion_lead_avg_value` | NUMBER | Avg value of lead. |
| `conversion_lead_clicks` | INTEGER | The click through conversions count. |
| `conversion_lead_ecpa` | NUMBER | The cost per lead conversion. |
| `conversion_lead_total_value` | INTEGER | Total value of leads. |
| `conversion_lead_views` | INTEGER | The view through conversions count. |
| `conversion_page_visit_clicks` | INTEGER | The click through conversions count. |
| `conversion_page_visit_ecpa` | NUMBER | The cost per page visit conversion. |
| `conversion_page_visit_views` | INTEGER | The view through conversions count. |
| `conversion_purchase_avg_value` | NUMBER | Average value of purchase. |
| `conversion_purchase_clicks` | INTEGER | The click through conversions count. |
| `conversion_purchase_ecpa` | NUMBER | The cost per purchase conversion. |
| `conversion_purchase_total_items` | INTEGER | Total size of the purchase. |
| `conversion_purchase_total_value` | INTEGER | Total value of the purchase. |
| `conversion_purchase_views` | INTEGER | The view through conversions count. |
| `conversion_roas` | NUMBER | Return on ad spend for purchases for this period. |
| `conversion_search_clicks` | INTEGER | The click through conversions count. |
| `conversion_search_ecpa` | NUMBER | The cost per search conversion. |
| `conversion_search_views` | INTEGER | The view through conversions count. |
| `conversion_sign_up_clicks` | INTEGER | The click through conversions count. |
| `conversion_sign_up_ecpa` | NUMBER | The cost per sign up conversion. |
| `conversion_sign_up_views` | INTEGER | The view through conversions count. |
| `conversion_signup_avg_value` | NUMBER | Avg value of signup. |
| `conversion_signup_total_value` | INTEGER | Total value of signups. |
| `conversion_view_content_clicks` | INTEGER | The click through conversions count. |
| `conversion_view_content_ecpa` | NUMBER | The cost per view content conversion. |
| `conversion_view_content_views` | INTEGER | The view through conversions count. |
| `cpc` | NUMBER | The cost-per-click for this period. |
| `ctr` | NUMBER | The click-through-rate for this period. |
| `cpv` | NUMBER | \\\[Broken\\\] The cost-per-view for this period. |
| `ecpm` | NUMBER | The effective CPM for this period. |
| `engaged_click` | INTEGER | The number of engaged clicks such as RSVPs. |
| `hour` | STRING | The hour for this metric in ISO-8601. |
| `impressions` | INTEGER | The number of impressions served for this report period. |
| `post_id` | STRING | The unique identifier of the post. |
| `spend` | INTEGER | The amount (in microcurrency) spent for this report period. |
| `key_conversion_ecpa` | NUMBER | Key conversion effective cost per action. |
| `key_conversion_total_count` | INTEGER | Key conversion total count. |
| `reach` | INTEGER | The number of unique users who saw the ad. |
| `frequency` | NUMBER | The average number of times each user saw the ad. |
| `account_id` | STRING | \\\[ONLY in AD\_ACCOUNT\_ID based report\\\] as account\_id The ID of the account. |
| `currency` | STRING | The currency of the account. |

## Ad Performance by Ad Group schema

## Reddit Ads Ad Performance by Ad Group schema

56 fields · Time series · `reddit_ads_report_by_AD_GROUP_ID` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-reports-adgroupid.js)

Daily ad performance broken down by ad group.

| Field | Type | Description |
| --- | --- | --- |
| `ad_id` | STRING | The ID of the ad. |
| `ad_group_id` | STRING | \\\[ONLY in AD\_GROUP\_ID based report\\\] The ID of the ad group. |
| `date` | DATE | The date for this metric. |
| `clicks` | INTEGER | The number of clicks detected for this report period. |
| `conversion_add_to_cart_avg_value` | NUMBER | Average value of the shopping cart. |
| `conversion_add_to_cart_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_cart_ecpa` | NUMBER | The cost per add to cart conversion. |
| `conversion_add_to_cart_total_items` | INTEGER | Total size of the shopping cart. |
| `conversion_add_to_cart_total_value` | INTEGER | Total value of the shopping cart. |
| `conversion_add_to_cart_views` | INTEGER | The view through conversions count. |
| `conversion_add_to_wishlist_avg_value` | NUMBER | Average value of the wish list. |
| `conversion_add_to_wishlist_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_wishlist_ecpa` | NUMBER | The cost per add to wishlist conversion. |
| `conversion_add_to_wishlist_total_items` | INTEGER | Total size of the wish list. |
| `conversion_add_to_wishlist_total_value` | INTEGER | Total value of the wish list. |
| `conversion_add_to_wishlist_views` | INTEGER | The view through conversions count. |
| `conversion_lead_avg_value` | NUMBER | Avg value of lead. |
| `conversion_lead_clicks` | INTEGER | The click through conversions count. |
| `conversion_lead_ecpa` | NUMBER | The cost per lead conversion. |
| `conversion_lead_total_value` | INTEGER | Total value of leads. |
| `conversion_lead_views` | INTEGER | The view through conversions count. |
| `conversion_page_visit_clicks` | INTEGER | The click through conversions count. |
| `conversion_page_visit_ecpa` | NUMBER | The cost per page visit conversion. |
| `conversion_page_visit_views` | INTEGER | The view through conversions count. |
| `conversion_purchase_avg_value` | NUMBER | Average value of purchase. |
| `conversion_purchase_clicks` | INTEGER | The click through conversions count. |
| `conversion_purchase_ecpa` | NUMBER | The cost per purchase conversion. |
| `conversion_purchase_total_items` | INTEGER | Total size of the purchase. |
| `conversion_purchase_total_value` | INTEGER | Total value of the purchase. |
| `conversion_purchase_views` | INTEGER | The view through conversions count. |
| `conversion_roas` | NUMBER | Return on ad spend for purchases for this period. |
| `conversion_search_clicks` | INTEGER | The click through conversions count. |
| `conversion_search_ecpa` | NUMBER | The cost per search conversion. |
| `conversion_search_views` | INTEGER | The view through conversions count. |
| `conversion_sign_up_clicks` | INTEGER | The click through conversions count. |
| `conversion_sign_up_ecpa` | NUMBER | The cost per sign up conversion. |
| `conversion_sign_up_views` | INTEGER | The view through conversions count. |
| `conversion_signup_avg_value` | NUMBER | Avg value of signup. |
| `conversion_signup_total_value` | INTEGER | Total value of signups. |
| `conversion_view_content_clicks` | INTEGER | The click through conversions count. |
| `conversion_view_content_ecpa` | NUMBER | The cost per view content conversion. |
| `conversion_view_content_views` | INTEGER | The view through conversions count. |
| `cpc` | NUMBER | The cost-per-click for this period. |
| `ctr` | NUMBER | The click-through-rate for this period. |
| `cpv` | NUMBER | \\\[Broken\\\] The cost-per-view for this period. |
| `ecpm` | NUMBER | The effective CPM for this period. |
| `engaged_click` | INTEGER | The number of engaged clicks such as RSVPs. |
| `hour` | STRING | The hour for this metric in ISO-8601. |
| `impressions` | INTEGER | The number of impressions served for this report period. |
| `post_id` | STRING | The unique identifier of the post. |
| `spend` | INTEGER | The amount (in microcurrency) spent for this report period. |
| `key_conversion_ecpa` | NUMBER | Key conversion effective cost per action. |
| `key_conversion_total_count` | INTEGER | Key conversion total count. |
| `reach` | INTEGER | The number of unique users who saw the ad. |
| `frequency` | NUMBER | The average number of times each user saw the ad. |
| `currency` | STRING | The currency of the account. |

## Ad Performance by Campaign schema

## Reddit Ads Ad Performance by Campaign schema

57 fields · Time series · `reddit_ads_report_by_CAMPAIGN_ID` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-reports-campaignid.js)

Daily ad performance broken down by campaign.

| Field | Type | Description |
| --- | --- | --- |
| `ad_id` | STRING | The ID of the ad. |
| `campaign_id` | STRING | \\\[ONLY in CAMPAIGN\_ID based report\\\] The ID of the campaign. |
| `date` | DATE | The date for this metric. |
| `dma` | STRING | \\\[ONLY in DMA based report\\\] The Designated Market Area (DMA) targeted for the reports. |
| `clicks` | INTEGER | The number of clicks detected for this report period. |
| `conversion_add_to_cart_avg_value` | NUMBER | Average value of the shopping cart. |
| `conversion_add_to_cart_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_cart_ecpa` | NUMBER | The cost per add to cart conversion. |
| `conversion_add_to_cart_total_items` | INTEGER | Total size of the shopping cart. |
| `conversion_add_to_cart_total_value` | INTEGER | Total value of the shopping cart. |
| `conversion_add_to_cart_views` | INTEGER | The view through conversions count. |
| `conversion_add_to_wishlist_avg_value` | NUMBER | Average value of the wish list. |
| `conversion_add_to_wishlist_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_wishlist_ecpa` | NUMBER | The cost per add to wishlist conversion. |
| `conversion_add_to_wishlist_total_items` | INTEGER | Total size of the wish list. |
| `conversion_add_to_wishlist_total_value` | INTEGER | Total value of the wish list. |
| `conversion_add_to_wishlist_views` | INTEGER | The view through conversions count. |
| `conversion_lead_avg_value` | NUMBER | Avg value of lead. |
| `conversion_lead_clicks` | INTEGER | The click through conversions count. |
| `conversion_lead_ecpa` | NUMBER | The cost per lead conversion. |
| `conversion_lead_total_value` | INTEGER | Total value of leads. |
| `conversion_lead_views` | INTEGER | The view through conversions count. |
| `conversion_page_visit_clicks` | INTEGER | The click through conversions count. |
| `conversion_page_visit_ecpa` | NUMBER | The cost per page visit conversion. |
| `conversion_page_visit_views` | INTEGER | The view through conversions count. |
| `conversion_purchase_avg_value` | NUMBER | Average value of purchase. |
| `conversion_purchase_clicks` | INTEGER | The click through conversions count. |
| `conversion_purchase_ecpa` | NUMBER | The cost per purchase conversion. |
| `conversion_purchase_total_items` | INTEGER | Total size of the purchase. |
| `conversion_purchase_total_value` | INTEGER | Total value of the purchase. |
| `conversion_purchase_views` | INTEGER | The view through conversions count. |
| `conversion_roas` | NUMBER | Return on ad spend for purchases for this period. |
| `conversion_search_clicks` | INTEGER | The click through conversions count. |
| `conversion_search_ecpa` | NUMBER | The cost per search conversion. |
| `conversion_search_views` | INTEGER | The view through conversions count. |
| `conversion_sign_up_clicks` | INTEGER | The click through conversions count. |
| `conversion_sign_up_ecpa` | NUMBER | The cost per sign up conversion. |
| `conversion_sign_up_views` | INTEGER | The view through conversions count. |
| `conversion_signup_avg_value` | NUMBER | Avg value of signup. |
| `conversion_signup_total_value` | INTEGER | Total value of signups. |
| `conversion_view_content_clicks` | INTEGER | The click through conversions count. |
| `conversion_view_content_ecpa` | NUMBER | The cost per view content conversion. |
| `conversion_view_content_views` | INTEGER | The view through conversions count. |
| `cpc` | NUMBER | The cost-per-click for this period. |
| `ctr` | NUMBER | The click-through-rate for this period. |
| `cpv` | NUMBER | \\\[Broken\\\] The cost-per-view for this period. |
| `ecpm` | NUMBER | The effective CPM for this period. |
| `engaged_click` | INTEGER | The number of engaged clicks such as RSVPs. |
| `hour` | STRING | The hour for this metric in ISO-8601. |
| `impressions` | INTEGER | The number of impressions served for this report period. |
| `post_id` | STRING | The unique identifier of the post. |
| `spend` | INTEGER | The amount (in microcurrency) spent for this report period. |
| `key_conversion_ecpa` | NUMBER | Key conversion effective cost per action. |
| `key_conversion_total_count` | INTEGER | Key conversion total count. |
| `reach` | INTEGER | The number of unique users who saw the ad. |
| `frequency` | NUMBER | The average number of times each user saw the ad. |
| `currency` | STRING | The currency of the account. |

## Ad Performance by Community schema

## Reddit Ads Ad Performance by Community schema

56 fields · Time series · `reddit_ads_report_by_COMMUNITY` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-reports-community.js)

Daily ad performance broken down by subreddit (community).

| Field | Type | Description |
| --- | --- | --- |
| `ad_id` | STRING | The ID of the ad. |
| `date` | DATE | The date for this metric. |
| `clicks` | INTEGER | The number of clicks detected for this report period. |
| `conversion_add_to_cart_avg_value` | NUMBER | Average value of the shopping cart. |
| `conversion_add_to_cart_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_cart_ecpa` | NUMBER | The cost per add to cart conversion. |
| `conversion_add_to_cart_total_items` | INTEGER | Total size of the shopping cart. |
| `conversion_add_to_cart_total_value` | INTEGER | Total value of the shopping cart. |
| `conversion_add_to_cart_views` | INTEGER | The view through conversions count. |
| `conversion_add_to_wishlist_avg_value` | NUMBER | Average value of the wish list. |
| `conversion_add_to_wishlist_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_wishlist_ecpa` | NUMBER | The cost per add to wishlist conversion. |
| `conversion_add_to_wishlist_total_items` | INTEGER | Total size of the wish list. |
| `conversion_add_to_wishlist_total_value` | INTEGER | Total value of the wish list. |
| `conversion_add_to_wishlist_views` | INTEGER | The view through conversions count. |
| `conversion_lead_avg_value` | NUMBER | Avg value of lead. |
| `conversion_lead_clicks` | INTEGER | The click through conversions count. |
| `conversion_lead_ecpa` | NUMBER | The cost per lead conversion. |
| `conversion_lead_total_value` | INTEGER | Total value of leads. |
| `conversion_lead_views` | INTEGER | The view through conversions count. |
| `conversion_page_visit_clicks` | INTEGER | The click through conversions count. |
| `conversion_page_visit_ecpa` | NUMBER | The cost per page visit conversion. |
| `conversion_page_visit_views` | INTEGER | The view through conversions count. |
| `conversion_purchase_avg_value` | NUMBER | Average value of purchase. |
| `conversion_purchase_clicks` | INTEGER | The click through conversions count. |
| `conversion_purchase_ecpa` | NUMBER | The cost per purchase conversion. |
| `conversion_purchase_total_items` | INTEGER | Total size of the purchase. |
| `conversion_purchase_total_value` | INTEGER | Total value of the purchase. |
| `conversion_purchase_views` | INTEGER | The view through conversions count. |
| `conversion_roas` | NUMBER | Return on ad spend for purchases for this period. |
| `conversion_search_clicks` | INTEGER | The click through conversions count. |
| `conversion_search_ecpa` | NUMBER | The cost per search conversion. |
| `conversion_search_views` | INTEGER | The view through conversions count. |
| `conversion_sign_up_clicks` | INTEGER | The click through conversions count. |
| `conversion_sign_up_ecpa` | NUMBER | The cost per sign up conversion. |
| `conversion_sign_up_views` | INTEGER | The view through conversions count. |
| `conversion_signup_avg_value` | NUMBER | Avg value of signup. |
| `conversion_signup_total_value` | INTEGER | Total value of signups. |
| `conversion_view_content_clicks` | INTEGER | The click through conversions count. |
| `conversion_view_content_ecpa` | NUMBER | The cost per view content conversion. |
| `conversion_view_content_views` | INTEGER | The view through conversions count. |
| `community` | STRING | \\\[ONLY in COMMUNITY based report\\\] The community/subreddit being targeted. |
| `cpc` | NUMBER | The cost-per-click for this period. |
| `ctr` | NUMBER | The click-through-rate for this period. |
| `cpv` | NUMBER | \\\[Broken\\\] The cost-per-view for this period. |
| `ecpm` | NUMBER | The effective CPM for this period. |
| `engaged_click` | INTEGER | The number of engaged clicks such as RSVPs. |
| `hour` | STRING | The hour for this metric in ISO-8601. |
| `impressions` | INTEGER | The number of impressions served for this report period. |
| `post_id` | STRING | The unique identifier of the post. |
| `spend` | INTEGER | The amount (in microcurrency) spent for this report period. |
| `key_conversion_ecpa` | NUMBER | Key conversion effective cost per action. |
| `key_conversion_total_count` | INTEGER | Key conversion total count. |
| `reach` | INTEGER | The number of unique users who saw the ad. |
| `frequency` | NUMBER | The average number of times each user saw the ad. |
| `currency` | STRING | The currency of the account. |

## Ad Performance by Country schema

## Reddit Ads Ad Performance by Country schema

56 fields · Time series · `reddit_ads_report_by_COUNTRY` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-reports-country.js)

Daily ad performance broken down by user country.

| Field | Type | Description |
| --- | --- | --- |
| `ad_id` | STRING | The ID of the ad. |
| `date` | DATE | The date for this metric. |
| `clicks` | INTEGER | The number of clicks detected for this report period. |
| `conversion_add_to_cart_avg_value` | NUMBER | Average value of the shopping cart. |
| `conversion_add_to_cart_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_cart_ecpa` | NUMBER | The cost per add to cart conversion. |
| `conversion_add_to_cart_total_items` | INTEGER | Total size of the shopping cart. |
| `conversion_add_to_cart_total_value` | INTEGER | Total value of the shopping cart. |
| `conversion_add_to_cart_views` | INTEGER | The view through conversions count. |
| `conversion_add_to_wishlist_avg_value` | NUMBER | Average value of the wish list. |
| `conversion_add_to_wishlist_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_wishlist_ecpa` | NUMBER | The cost per add to wishlist conversion. |
| `conversion_add_to_wishlist_total_items` | INTEGER | Total size of the wish list. |
| `conversion_add_to_wishlist_total_value` | INTEGER | Total value of the wish list. |
| `conversion_add_to_wishlist_views` | INTEGER | The view through conversions count. |
| `conversion_lead_avg_value` | NUMBER | Avg value of lead. |
| `conversion_lead_clicks` | INTEGER | The click through conversions count. |
| `conversion_lead_ecpa` | NUMBER | The cost per lead conversion. |
| `conversion_lead_total_value` | INTEGER | Total value of leads. |
| `conversion_lead_views` | INTEGER | The view through conversions count. |
| `conversion_page_visit_clicks` | INTEGER | The click through conversions count. |
| `conversion_page_visit_ecpa` | NUMBER | The cost per page visit conversion. |
| `conversion_page_visit_views` | INTEGER | The view through conversions count. |
| `conversion_purchase_avg_value` | NUMBER | Average value of purchase. |
| `conversion_purchase_clicks` | INTEGER | The click through conversions count. |
| `conversion_purchase_ecpa` | NUMBER | The cost per purchase conversion. |
| `conversion_purchase_total_items` | INTEGER | Total size of the purchase. |
| `conversion_purchase_total_value` | INTEGER | Total value of the purchase. |
| `conversion_purchase_views` | INTEGER | The view through conversions count. |
| `conversion_roas` | NUMBER | Return on ad spend for purchases for this period. |
| `conversion_search_clicks` | INTEGER | The click through conversions count. |
| `conversion_search_ecpa` | NUMBER | The cost per search conversion. |
| `conversion_search_views` | INTEGER | The view through conversions count. |
| `conversion_sign_up_clicks` | INTEGER | The click through conversions count. |
| `conversion_sign_up_ecpa` | NUMBER | The cost per sign up conversion. |
| `conversion_sign_up_views` | INTEGER | The view through conversions count. |
| `conversion_signup_avg_value` | NUMBER | Avg value of signup. |
| `conversion_signup_total_value` | INTEGER | Total value of signups. |
| `conversion_view_content_clicks` | INTEGER | The click through conversions count. |
| `conversion_view_content_ecpa` | NUMBER | The cost per view content conversion. |
| `conversion_view_content_views` | INTEGER | The view through conversions count. |
| `country` | STRING | \\\[ONLY in COUNTRY based report\\\] The country targeted for the report. |
| `cpc` | NUMBER | The cost-per-click for this period. |
| `ctr` | NUMBER | The click-through-rate for this period. |
| `cpv` | NUMBER | \\\[Broken\\\] The cost-per-view for this period. |
| `ecpm` | NUMBER | The effective CPM for this period. |
| `engaged_click` | INTEGER | The number of engaged clicks such as RSVPs. |
| `hour` | STRING | The hour for this metric in ISO-8601. |
| `impressions` | INTEGER | The number of impressions served for this report period. |
| `post_id` | STRING | The unique identifier of the post. |
| `spend` | INTEGER | The amount (in microcurrency) spent for this report period. |
| `key_conversion_ecpa` | NUMBER | Key conversion effective cost per action. |
| `key_conversion_total_count` | INTEGER | Key conversion total count. |
| `reach` | INTEGER | The number of unique users who saw the ad. |
| `frequency` | NUMBER | The average number of times each user saw the ad. |
| `currency` | STRING | The currency of the account. |

## Ad Performance by DMA schema

## Reddit Ads Ad Performance by DMA schema

56 fields · Time series · `reddit_ads_report_by_DMA` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-reports-dmabased.js)

Daily ad performance broken down by Designated Market Area (DMA).

| Field | Type | Description |
| --- | --- | --- |
| `ad_id` | STRING | The ID of the ad. |
| `date` | DATE | The date for this metric. |
| `dma` | STRING | \\\[ONLY in DMA based report\\\] The Designated Market Area (DMA) targeted for the reports. |
| `clicks` | INTEGER | The number of clicks detected for this report period. |
| `conversion_add_to_cart_avg_value` | NUMBER | Average value of the shopping cart. |
| `conversion_add_to_cart_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_cart_ecpa` | NUMBER | The cost per add to cart conversion. |
| `conversion_add_to_cart_total_items` | INTEGER | Total size of the shopping cart. |
| `conversion_add_to_cart_total_value` | INTEGER | Total value of the shopping cart. |
| `conversion_add_to_cart_views` | INTEGER | The view through conversions count. |
| `conversion_add_to_wishlist_avg_value` | NUMBER | Average value of the wish list. |
| `conversion_add_to_wishlist_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_wishlist_ecpa` | NUMBER | The cost per add to wishlist conversion. |
| `conversion_add_to_wishlist_total_items` | INTEGER | Total size of the wish list. |
| `conversion_add_to_wishlist_total_value` | INTEGER | Total value of the wish list. |
| `conversion_add_to_wishlist_views` | INTEGER | The view through conversions count. |
| `conversion_lead_avg_value` | NUMBER | Avg value of lead. |
| `conversion_lead_clicks` | INTEGER | The click through conversions count. |
| `conversion_lead_ecpa` | NUMBER | The cost per lead conversion. |
| `conversion_lead_total_value` | INTEGER | Total value of leads. |
| `conversion_lead_views` | INTEGER | The view through conversions count. |
| `conversion_page_visit_clicks` | INTEGER | The click through conversions count. |
| `conversion_page_visit_ecpa` | NUMBER | The cost per page visit conversion. |
| `conversion_page_visit_views` | INTEGER | The view through conversions count. |
| `conversion_purchase_avg_value` | NUMBER | Average value of purchase. |
| `conversion_purchase_clicks` | INTEGER | The click through conversions count. |
| `conversion_purchase_ecpa` | NUMBER | The cost per purchase conversion. |
| `conversion_purchase_total_items` | INTEGER | Total size of the purchase. |
| `conversion_purchase_total_value` | INTEGER | Total value of the purchase. |
| `conversion_purchase_views` | INTEGER | The view through conversions count. |
| `conversion_roas` | NUMBER | Return on ad spend for purchases for this period. |
| `conversion_search_clicks` | INTEGER | The click through conversions count. |
| `conversion_search_ecpa` | NUMBER | The cost per search conversion. |
| `conversion_search_views` | INTEGER | The view through conversions count. |
| `conversion_sign_up_clicks` | INTEGER | The click through conversions count. |
| `conversion_sign_up_ecpa` | NUMBER | The cost per sign up conversion. |
| `conversion_sign_up_views` | INTEGER | The view through conversions count. |
| `conversion_signup_avg_value` | NUMBER | Avg value of signup. |
| `conversion_signup_total_value` | INTEGER | Total value of signups. |
| `conversion_view_content_clicks` | INTEGER | The click through conversions count. |
| `conversion_view_content_ecpa` | NUMBER | The cost per view content conversion. |
| `conversion_view_content_views` | INTEGER | The view through conversions count. |
| `cpc` | NUMBER | The cost-per-click for this period. |
| `ctr` | NUMBER | The click-through-rate for this period. |
| `cpv` | NUMBER | \\\[Broken\\\] The cost-per-view for this period. |
| `ecpm` | NUMBER | The effective CPM for this period. |
| `engaged_click` | INTEGER | The number of engaged clicks such as RSVPs. |
| `hour` | STRING | The hour for this metric in ISO-8601. |
| `impressions` | INTEGER | The number of impressions served for this report period. |
| `post_id` | STRING | The unique identifier of the post. |
| `spend` | INTEGER | The amount (in microcurrency) spent for this report period. |
| `key_conversion_ecpa` | NUMBER | Key conversion effective cost per action. |
| `key_conversion_total_count` | INTEGER | Key conversion total count. |
| `reach` | INTEGER | The number of unique users who saw the ad. |
| `frequency` | NUMBER | The average number of times each user saw the ad. |
| `currency` | STRING | The currency of the account. |

## Ad Performance by Interest schema

## Reddit Ads Ad Performance by Interest schema

56 fields · Time series · `reddit_ads_report_by_INTEREST` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-reports-interest.js)

Daily ad performance broken down by user interest targeting.

| Field | Type | Description |
| --- | --- | --- |
| `ad_id` | STRING | The ID of the ad. |
| `date` | DATE | The date for this metric. |
| `clicks` | INTEGER | The number of clicks detected for this report period. |
| `conversion_add_to_cart_avg_value` | NUMBER | Average value of the shopping cart. |
| `conversion_add_to_cart_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_cart_ecpa` | NUMBER | The cost per add to cart conversion. |
| `conversion_add_to_cart_total_items` | INTEGER | Total size of the shopping cart. |
| `conversion_add_to_cart_total_value` | INTEGER | Total value of the shopping cart. |
| `conversion_add_to_cart_views` | INTEGER | The view through conversions count. |
| `conversion_add_to_wishlist_avg_value` | NUMBER | Average value of the wish list. |
| `conversion_add_to_wishlist_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_wishlist_ecpa` | NUMBER | The cost per add to wishlist conversion. |
| `conversion_add_to_wishlist_total_items` | INTEGER | Total size of the wish list. |
| `conversion_add_to_wishlist_total_value` | INTEGER | Total value of the wish list. |
| `conversion_add_to_wishlist_views` | INTEGER | The view through conversions count. |
| `conversion_lead_avg_value` | NUMBER | Avg value of lead. |
| `conversion_lead_clicks` | INTEGER | The click through conversions count. |
| `conversion_lead_ecpa` | NUMBER | The cost per lead conversion. |
| `conversion_lead_total_value` | INTEGER | Total value of leads. |
| `conversion_lead_views` | INTEGER | The view through conversions count. |
| `conversion_page_visit_clicks` | INTEGER | The click through conversions count. |
| `conversion_page_visit_ecpa` | NUMBER | The cost per page visit conversion. |
| `conversion_page_visit_views` | INTEGER | The view through conversions count. |
| `conversion_purchase_avg_value` | NUMBER | Average value of purchase. |
| `conversion_purchase_clicks` | INTEGER | The click through conversions count. |
| `conversion_purchase_ecpa` | NUMBER | The cost per purchase conversion. |
| `conversion_purchase_total_items` | INTEGER | Total size of the purchase. |
| `conversion_purchase_total_value` | INTEGER | Total value of the purchase. |
| `conversion_purchase_views` | INTEGER | The view through conversions count. |
| `conversion_roas` | NUMBER | Return on ad spend for purchases for this period. |
| `conversion_search_clicks` | INTEGER | The click through conversions count. |
| `conversion_search_ecpa` | NUMBER | The cost per search conversion. |
| `conversion_search_views` | INTEGER | The view through conversions count. |
| `conversion_sign_up_clicks` | INTEGER | The click through conversions count. |
| `conversion_sign_up_ecpa` | NUMBER | The cost per sign up conversion. |
| `conversion_sign_up_views` | INTEGER | The view through conversions count. |
| `conversion_signup_avg_value` | NUMBER | Avg value of signup. |
| `conversion_signup_total_value` | INTEGER | Total value of signups. |
| `conversion_view_content_clicks` | INTEGER | The click through conversions count. |
| `conversion_view_content_ecpa` | NUMBER | The cost per view content conversion. |
| `conversion_view_content_views` | INTEGER | The view through conversions count. |
| `cpc` | NUMBER | The cost-per-click for this period. |
| `ctr` | NUMBER | The click-through-rate for this period. |
| `cpv` | NUMBER | \\\[Broken\\\] The cost-per-view for this period. |
| `ecpm` | NUMBER | The effective CPM for this period. |
| `engaged_click` | INTEGER | The number of engaged clicks such as RSVPs. |
| `hour` | STRING | The hour for this metric in ISO-8601. |
| `impressions` | INTEGER | The number of impressions served for this report period. |
| `interest` | STRING | \\\[ONLY in INTEREST based report\\\] The interests of the users being targeted. |
| `post_id` | STRING | The unique identifier of the post. |
| `spend` | INTEGER | The amount (in microcurrency) spent for this report period. |
| `key_conversion_ecpa` | NUMBER | Key conversion effective cost per action. |
| `key_conversion_total_count` | INTEGER | Key conversion total count. |
| `reach` | INTEGER | The number of unique users who saw the ad. |
| `frequency` | NUMBER | The average number of times each user saw the ad. |
| `currency` | STRING | The currency of the account. |

## Ad Performance by Keyword schema

## Reddit Ads Ad Performance by Keyword schema

56 fields · Time series · `reddit_ads_report_by_KEYWORD` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-reports-keyword.js)

Daily ad performance broken down by keyword.

| Field | Type | Description |
| --- | --- | --- |
| `ad_id` | STRING | The ID of the ad. |
| `date` | DATE | The date for this metric. |
| `clicks` | INTEGER | The number of clicks detected for this report period. |
| `conversion_add_to_cart_avg_value` | NUMBER | Average value of the shopping cart. |
| `conversion_add_to_cart_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_cart_ecpa` | NUMBER | The cost per add to cart conversion. |
| `conversion_add_to_cart_total_items` | INTEGER | Total size of the shopping cart. |
| `conversion_add_to_cart_total_value` | INTEGER | Total value of the shopping cart. |
| `conversion_add_to_cart_views` | INTEGER | The view through conversions count. |
| `conversion_add_to_wishlist_avg_value` | NUMBER | Average value of the wish list. |
| `conversion_add_to_wishlist_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_wishlist_ecpa` | NUMBER | The cost per add to wishlist conversion. |
| `conversion_add_to_wishlist_total_items` | INTEGER | Total size of the wish list. |
| `conversion_add_to_wishlist_total_value` | INTEGER | Total value of the wish list. |
| `conversion_add_to_wishlist_views` | INTEGER | The view through conversions count. |
| `conversion_lead_avg_value` | NUMBER | Avg value of lead. |
| `conversion_lead_clicks` | INTEGER | The click through conversions count. |
| `conversion_lead_ecpa` | NUMBER | The cost per lead conversion. |
| `conversion_lead_total_value` | INTEGER | Total value of leads. |
| `conversion_lead_views` | INTEGER | The view through conversions count. |
| `conversion_page_visit_clicks` | INTEGER | The click through conversions count. |
| `conversion_page_visit_ecpa` | NUMBER | The cost per page visit conversion. |
| `conversion_page_visit_views` | INTEGER | The view through conversions count. |
| `conversion_purchase_avg_value` | NUMBER | Average value of purchase. |
| `conversion_purchase_clicks` | INTEGER | The click through conversions count. |
| `conversion_purchase_ecpa` | NUMBER | The cost per purchase conversion. |
| `conversion_purchase_total_items` | INTEGER | Total size of the purchase. |
| `conversion_purchase_total_value` | INTEGER | Total value of the purchase. |
| `conversion_purchase_views` | INTEGER | The view through conversions count. |
| `conversion_roas` | NUMBER | Return on ad spend for purchases for this period. |
| `conversion_search_clicks` | INTEGER | The click through conversions count. |
| `conversion_search_ecpa` | NUMBER | The cost per search conversion. |
| `conversion_search_views` | INTEGER | The view through conversions count. |
| `conversion_sign_up_clicks` | INTEGER | The click through conversions count. |
| `conversion_sign_up_ecpa` | NUMBER | The cost per sign up conversion. |
| `conversion_sign_up_views` | INTEGER | The view through conversions count. |
| `conversion_signup_avg_value` | NUMBER | Avg value of signup. |
| `conversion_signup_total_value` | INTEGER | Total value of signups. |
| `conversion_view_content_clicks` | INTEGER | The click through conversions count. |
| `conversion_view_content_ecpa` | NUMBER | The cost per view content conversion. |
| `conversion_view_content_views` | INTEGER | The view through conversions count. |
| `cpc` | NUMBER | The cost-per-click for this period. |
| `ctr` | NUMBER | The click-through-rate for this period. |
| `cpv` | NUMBER | \\\[Broken\\\] The cost-per-view for this period. |
| `ecpm` | NUMBER | The effective CPM for this period. |
| `engaged_click` | INTEGER | The number of engaged clicks such as RSVPs. |
| `hour` | STRING | The hour for this metric in ISO-8601. |
| `impressions` | INTEGER | The number of impressions served for this report period. |
| `post_id` | STRING | The unique identifier of the post. |
| `spend` | INTEGER | The amount (in microcurrency) spent for this report period. |
| `key_conversion_ecpa` | NUMBER | Key conversion effective cost per action. |
| `key_conversion_total_count` | INTEGER | Key conversion total count. |
| `reach` | INTEGER | The number of unique users who saw the ad. |
| `frequency` | NUMBER | The average number of times each user saw the ad. |
| `currency` | STRING | The currency of the account. |
| `keyword` | STRING | \\\[ONLY in KEYWORD based report\\\] The keyword for the ad. |

## Ad Performance by Placement schema

## Reddit Ads Ad Performance by Placement schema

56 fields · Time series · `reddit_ads_report_by_PLACEMENT` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-reports-placement.js)

Daily ad performance broken down by ad placement.

| Field | Type | Description |
| --- | --- | --- |
| `ad_id` | STRING | The ID of the ad. |
| `date` | DATE | The date for this metric. |
| `clicks` | INTEGER | The number of clicks detected for this report period. |
| `conversion_add_to_cart_avg_value` | NUMBER | Average value of the shopping cart. |
| `conversion_add_to_cart_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_cart_ecpa` | NUMBER | The cost per add to cart conversion. |
| `conversion_add_to_cart_total_items` | INTEGER | Total size of the shopping cart. |
| `conversion_add_to_cart_total_value` | INTEGER | Total value of the shopping cart. |
| `conversion_add_to_cart_views` | INTEGER | The view through conversions count. |
| `conversion_add_to_wishlist_avg_value` | NUMBER | Average value of the wish list. |
| `conversion_add_to_wishlist_clicks` | INTEGER | The click through conversions count. |
| `conversion_add_to_wishlist_ecpa` | NUMBER | The cost per add to wishlist conversion. |
| `conversion_add_to_wishlist_total_items` | INTEGER | Total size of the wish list. |
| `conversion_add_to_wishlist_total_value` | INTEGER | Total value of the wish list. |
| `conversion_add_to_wishlist_views` | INTEGER | The view through conversions count. |
| `conversion_lead_avg_value` | NUMBER | Avg value of lead. |
| `conversion_lead_clicks` | INTEGER | The click through conversions count. |
| `conversion_lead_ecpa` | NUMBER | The cost per lead conversion. |
| `conversion_lead_total_value` | INTEGER | Total value of leads. |
| `conversion_lead_views` | INTEGER | The view through conversions count. |
| `conversion_page_visit_clicks` | INTEGER | The click through conversions count. |
| `conversion_page_visit_ecpa` | NUMBER | The cost per page visit conversion. |
| `conversion_page_visit_views` | INTEGER | The view through conversions count. |
| `conversion_purchase_avg_value` | NUMBER | Average value of purchase. |
| `conversion_purchase_clicks` | INTEGER | The click through conversions count. |
| `conversion_purchase_ecpa` | NUMBER | The cost per purchase conversion. |
| `conversion_purchase_total_items` | INTEGER | Total size of the purchase. |
| `conversion_purchase_total_value` | INTEGER | Total value of the purchase. |
| `conversion_purchase_views` | INTEGER | The view through conversions count. |
| `conversion_roas` | NUMBER | Return on ad spend for purchases for this period. |
| `conversion_search_clicks` | INTEGER | The click through conversions count. |
| `conversion_search_ecpa` | NUMBER | The cost per search conversion. |
| `conversion_search_views` | INTEGER | The view through conversions count. |
| `conversion_sign_up_clicks` | INTEGER | The click through conversions count. |
| `conversion_sign_up_ecpa` | NUMBER | The cost per sign up conversion. |
| `conversion_sign_up_views` | INTEGER | The view through conversions count. |
| `conversion_signup_avg_value` | NUMBER | Avg value of signup. |
| `conversion_signup_total_value` | INTEGER | Total value of signups. |
| `conversion_view_content_clicks` | INTEGER | The click through conversions count. |
| `conversion_view_content_ecpa` | NUMBER | The cost per view content conversion. |
| `conversion_view_content_views` | INTEGER | The view through conversions count. |
| `cpc` | NUMBER | The cost-per-click for this period. |
| `ctr` | NUMBER | The click-through-rate for this period. |
| `cpv` | NUMBER | \\\[Broken\\\] The cost-per-view for this period. |
| `ecpm` | NUMBER | The effective CPM for this period. |
| `engaged_click` | INTEGER | The number of engaged clicks such as RSVPs. |
| `hour` | STRING | The hour for this metric in ISO-8601. |
| `impressions` | INTEGER | The number of impressions served for this report period. |
| `post_id` | STRING | The unique identifier of the post. |
| `spend` | INTEGER | The amount (in microcurrency) spent for this report period. |
| `key_conversion_ecpa` | NUMBER | Key conversion effective cost per action. |
| `key_conversion_total_count` | INTEGER | Key conversion total count. |
| `reach` | INTEGER | The number of unique users who saw the ad. |
| `frequency` | NUMBER | The average number of times each user saw the ad. |
| `currency` | STRING | The currency of the account. |
| `placement` | STRING | \\\[ONLY in PLACEMENT based report\\\] Enum representing the placement of a creative. |

## Ads schema

## Reddit Ads Ads schema

23 fields · `reddit_ads_ads` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ads.js)

Individual ads — type, status, and links to their campaigns and posts.

| Field | Type | Description |
| --- | --- | --- |
| `type` | STRING | The type of ad. |
| `ad_account_id` | STRING | The ID of the ad account that owns this ad. |
| `ad_group_id` | STRING | The ID of the ad group that this ad belongs to. |
| `campaign_id` | STRING | The ID of the campaign that this ad belongs to. |
| `campaign_objective_type` | STRING | The objective type of a campaign. |
| `click_url` | STRING | The website URL to direct users who click on the ad. |
| `configured_status` | STRING | The status that you have configured for this ad. |
| `created_at` | STRING | The time that this entity was created, represented in ISO 8601. |
| `effective_status` | STRING | The effective status for the ad. |
| `event_trackers` | STRING | URLs to be called on certain events. Only URLs from Reddit’s list of approved measurement providers are allowed. |
| `id` | STRING | The ID of the ad. |
| `modified_at` | STRING | The last time that this entity was modified, represented in ISO 8601. |
| `name` | STRING | The ad name to be labeled in the dashboard and reports. |
| `preview_expiry` | STRING | An expiration time for the preview URL of this ad. This may be set to null to disable the preview URL. |
| `preview_url` | STRING | A URL that may be used to preview the ad. This is only available when preview\_expiry is set. |
| `rejection_reason` | STRING | The reason why the ad was rejected. |
| `skadnetwork_metadata` | STRING | Metadata about the SKAdNetwork source ID associated with the ad. |
| `post_id` | STRING | The ID of the post that this ad belongs to. |
| `post_url` | STRING | The URL of the post that this ad belongs to. |
| `products` | STRING | A list of products associated with an ad. |
| `profile_id` | STRING | The ID of the ad post’s author. Currently used only for Shopping Ads. |
| `profile_username` | STRING | The username of the ad post’s author. Currently used only for Shopping Ads. |
| `shopping_creative` | STRING | A collection of attributes used to generate creatives for a particular ad. |

## Campaigns schema

## Reddit Ads Campaigns schema

15 fields · `reddit_ads_campaigns` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/campaigns.js)

Your campaigns — objective, status, spend cap, and account association.

| Field | Type | Description |
| --- | --- | --- |
| `ad_account_id` | STRING | The ID of the ad account. |
| `configured_status` | STRING | The status that the user has configured for this entity. Can differ from the effective status depending on the context such as pending billing information. |
| `created_at` | STRING | The time that this entity was created, represented in ISO 8601. |
| `effective_status` | STRING | The calculated status determining the real status of this entity. |
| `funding_instrument_id` | STRING | Campaign level funding instrument ID. |
| `goal_type` | STRING | The campaign goal type. This cannot be changed after publishing the campaign. Only works for CBO campaigns. |
| `goal_value` | INTEGER | Campaign level goal value in micros. Only works for CBO campaigns. |
| `id` | STRING | The ID of the campaign. |
| `app_id` | STRING | The App ID of the app in the mobile app store (iOS App Store, Google Play Store), and is required for use with App Installs objective campaigns. |
| `modified_at` | STRING | The last time that this entity was modified, represented in ISO 8601. |
| `name` | STRING | The campaign name. Must be at least 3 characters. |
| `objective` | STRING | The objective type of a campaign. |
| `special_ad_categories` | STRING | List of special ad categories related to the campaign. |
| `spend_cap` | INTEGER | Campaign lifetime spend cap in microcurrency. Works for both CBO and non-CBO campaigns. |
| `skadnetwork_metadata` | STRING | Metadata about the SKAdNetwork source ID associated with the campaign. |

## Custom Audiences schema

## Reddit Ads Custom Audiences schema

9 fields · `reddit_ads_user_custom_audience` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-user-custom-audience.js)

Custom audiences built from your user lists — type, status, and size estimates.

| Field | Type | Description |
| --- | --- | --- |
| `name` | STRING | The name of the custom audience. |
| `id` | STRING | The ID of the custom audience. |
| `status` | STRING | The processing status of the custom audience. A custom audience is only VALID if size\_range\_upper is at or above 1,000 users, otherwise it will be in the NOT\_ENOUGH\_MATCHES\_ERROR state. |
| `ad_account_id` | STRING | The ID of the ad account that owns this custom audience. |
| `created_at` | STRING | The time that this entity was created, represented in ISO 8601. |
| `modified_at` | STRING | The last time that this entity was modified, represented in ISO 8601. |
| `size_range_upper` | INTEGER | High estimate of the number of matched users in the audience. |
| `size_range_lower` | INTEGER | Low estimate of the number of matched users in the audience. |
| `type` | STRING | The type of the Custom Audience. |

## Funding Instruments schema

## Reddit Ads Funding Instruments schema

9 fields · `reddit_ads_funding_instruments` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-funding-instruments.js)

Payment methods linked to your campaigns — credit limits and current outstanding balance.

| Field | Type | Description |
| --- | --- | --- |
| `id` | STRING | The ID of the funding instrument. |
| `name` | STRING | The name of the funding instrument, if any. |
| `currency` | STRING | An ISO4217 currency code indicating the currency used in this invoice. |
| `credit_limit` | INTEGER | When the billable\_amount exceeds this number, campaigns linked to this funding instrument will not run. |
| `billable_amount` | INTEGER | The current amount of outstanding debt on this funding instrument, in local micro-currency. |
| `start_time` | STRING | When set, campaigns linked to this funding instrument will not deliver unless the current time is beyond this ISO-8601 time. |
| `end_time` | STRING | When set, campaigns linked to this funding instrument will not deliver unless the current time is before this ISO-8601 time. |
| `is_servable` | BOOLEAN | When true, campaigns linked to this funding instrument are allowed to run. |
| `reasons_not_servable` | STRING | Contains a list of reasons why this funding instrument is not servable. When this list is empty, it is servable. |

## Lead Gen Forms schema

## Reddit Ads Lead Gen Forms schema

8 fields · `reddit_ads_lead_gen_form` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/RedditAds/RedditAdsAPIReference/ad-lead-gen-form.js)

Lead generation forms shown in your ads — prompt text and creation details.

| Field | Type | Description |
| --- | --- | --- |
| `ad_account_id` | STRING | The ID of the ad account that the form belongs to. |
| `id` | STRING | The ID of the form. |
| `name` | STRING | The name of the form. |
| `privacy_link` | STRING | The URL of the privacy policy for the form. |
| `prompt` | STRING | The prompt that is displayed to the user when they are filling out the form. |
| `questions` | STRING | A list of questions that are presented to the user to fill out. |
| `created_at` | STRING | The time that this entity was created represented in ISO 8601. |
| `modified_at` | STRING | The last time that this entity was modified represented in ISO 8601. |

## S01 · Why teams pick OWOX

## Why collect Reddit Ads data into your warehouse with OWOX?

Your Reddit Ads data shouldn’t be trapped in a platform you can’t query. OWOX collects it into your warehouse on autopilot — no per-connector fees, no vendor lock-in. The entire platform is open-source on GitHub, so you can self-host it today and never worry about losing access to your own data pipelines.

![The Set Up Connector dialog in OWOX Data Marts at step 1 of 5, listing the connectors available to choose from.](https://cdn.owox.ai/www/webflow/6a043cc99b38463750b8ea95_connectros-data-source-list.png/public)

### Collect to your warehouse

No per-connector pricing — connect as many sources as you need, all included

![The Create Scheduled Trigger dialog in OWOX Data Marts, setting a connector run to repeat daily at 09:00.](https://cdn.owox.ai/www/portfolio-management-data-source/criteo/body/1.png/public)

### Zero-maintenance syncs

Fully open-source on GitHub — self-host anytime, no vendor lock-in, your data stays yours

![The Joined Data Marts SQL dialog in OWOX Data Marts, showing the generated SQL that joins an orders data mart with unified ad spend and reporting it as valid.](https://cdn.owox.ai/www/portfolio-management-data-source/criteo/body/2.png/public)

### Full-funnel joins

Full transparency and control — every query, every schema, every schedule is visible and auditable

[Get started free →](https://www.owox.com/app-signup)

## How it works

![OWOX Data Marts data setup for Reddit Ads, with the Reddit Ads input source feeding Google BigQuery, AWS Athena, Snowflake, Amazon Redshift and Databricks.](https://cdn.owox.ai/www/portfolio-management-data-source/reddit/hero/1.png/public)

R01 · Collect

## Collect all your Reddit Ads data with zero engineering

Pull everything your company needs from Reddit Ads without touching code or maintaining custom scripts. OWOX Data Marts handle the heavy lifting.

*   Your Reddit Ads data is stored in one place – your own infrastructure. OWOX Data Marts automatically land your data into BigQuery, Snowflake, or Redshift.
*   Your Reddit Ads data lands on a schedule: clean, complete, and ready to re-use across reports, dashboards, BI tools, and spreadsheets.
*   No API maintenance, no broken scripts — just reliable daily syncs

[Explore data marts →](https://www.owox.com/app-signup)

![OWOX Data Marts data setup for Reddit Ads, with Reddit Ads data delivered to Google Sheets, Looker Studio, Slack, Microsoft Teams and email.](https://cdn.owox.ai/www/portfolio-management-data-source/reddit/body/1.png/public)

R02 · Report

## Build reports with Reddit Ads data that everyone trusts

Once your Reddit Ads data lands in your warehouse, OWOX Data Marts make it instantly reusable across spreadsheets and BI tools.

*   Pre-built data marts for campaign performance, spend, and conversions
*   Join Reddit Ads with CRM, GA4, and revenue data in one query
*   Self-serve reporting for marketing teams — no analyst tickets needed

[Explore data marts →](https://www.owox.com/app-signup)

![The OWOX Data Marts side panel open in Google Sheets, building an eCommerce report from a products data mart with its columns selected.](https://cdn.owox.ai/www/webflow/69f4fbc009ea60814be448c5_product-frame.webp/public)

R03 · Visualize

## Visualize Reddit Ads data instantly in your BI tools

With OWOX Data Marts, your Reddit Ads data becomes instantly available for charts, dashboards, pivots, and spreadsheets.

*   Whether you use Google Sheets, Looker Studio, Excel, or Power BI, OWOX delivers clean, scheduled Reddit Ads data that just works.
*   Deliver to Looker Studio, Google Sheets, Power BI, or Excel automatically
*   Same numbers everywhere — one source of truth for all stakeholders

[Get started free →](https://www.owox.com/app-signup)

## S03 · Eight outcomes

## Why use OWOX connectors to collect your Reddit Ads data?

Eight outcomes you get the moment your data marts go live.

### Full picture, one screen

Send Reddit Ads spend and performance into dashboards from one governed source — a niche channel you can finally measure properly.

### Beyond native dashboards

Reddit is small but mighty for the right audience; in your warehouse its numbers sit next to your big channels for fair comparison.

### Your questions, your reports

Build reports that answer your questions — community-level performance, CPA, ROAS — on your definitions, not Reddit’s defaults.

### Faster decisions, better data

A small channel only proves its worth when blended in; Reddit data in your warehouse makes that case with real numbers.

### Always fresh, always complete

OWOX Data Marts automate Reddit Ads collection on a schedule — campaigns, ads, and spend — with no manual exports.

### All sources, one warehouse

Merge Reddit with your other channels and revenue for one complete acquisition picture.

### Zero manual work

Automate transfer into BigQuery, Snowflake, or Redshift — governed and reusable across every report, saving time and removing errors.

### Blended reports

Once Reddit data lands in governed Data Marts, anyone can ask in their own AI chat — “is Reddit worth scaling?” — every number tracing to analyst-written SQL.

## What users are saying

## Not testimonials. Comment threads.

Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.

A3 · re: trusting AI

![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) Nodari Rizun · Founder & CEO, Pürblack®

> _“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”_

C9 · re: one source of truth

![Mark Simmons](https://cdn.owox.ai/www/webflow/6a7b298b2b9daab0ade631d7_mark-headshot.png/public) Mark Simmons · CMO, Pürblack®

> _“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”_

E7 · re: getting time back

![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) Nodari Rizun · Founder & CEO, Pürblack®

> _“We regained time. And time is the one resource that never comes back.”_

## Start collecting Reddit Ads data for free

Set up your Reddit Ads connector in minutes. No credit card, no engineering team required.

[Get started free](https://www.owox.com/app-signup)

![Reddit Ads](https://cdn.owox.ai/www/webflow/6a043cc9dce0415e2d0f6a01_data-marts-list-connector.png/public)

## References

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Get started free](https://www.owox.com/app-signup)
- [Reddit Ads Connector to Azure Synapse](https://www.owox.com/connectors/reddit-ads-connector-to-azure-synapse) — /connectors/reddit-ads-connector-to-azure-synapse.md
- [Reddit Ads Connector to ChatGPT](https://www.owox.com/connectors/reddit-ads-connector-to-chatgpt) — /connectors/reddit-ads-connector-to-chatgpt.md
- [Reddit Ads Connector to Claude](https://www.owox.com/connectors/reddit-ads-connector-to-claude) — /connectors/reddit-ads-connector-to-claude.md
- [Reddit Ads Connector to Microsoft Excel](https://www.owox.com/connectors/reddit-ads-connector-to-microsoft-excel) — /connectors/reddit-ads-connector-to-microsoft-excel.md
- [Reddit Ads Insights to Email](https://www.owox.com/connectors/reddit-ads-insights-to-email) — /connectors/reddit-ads-insights-to-email.md
- [Reddit Ads Insights to Google Chat](https://www.owox.com/connectors/reddit-ads-insights-to-google-chat) — /connectors/reddit-ads-insights-to-google-chat.md
- [Reddit Ads Insights to Microsoft Teams](https://www.owox.com/connectors/reddit-ads-insights-to-microsoft-teams) — /connectors/reddit-ads-insights-to-microsoft-teams.md
- [Reddit Ads Insights to Slack](https://www.owox.com/connectors/reddit-ads-insights-to-slack) — /connectors/reddit-ads-insights-to-slack.md
- [Reddit Ads to AWS Athena Connector](https://www.owox.com/connectors/free-reddit-ads-connector-to-aws-athena) — /connectors/free-reddit-ads-connector-to-aws-athena.md
- [Reddit Ads to AWS Redshift Connector](https://www.owox.com/connectors/free-reddit-ads-connector-to-aws-redshift) — /connectors/free-reddit-ads-connector-to-aws-redshift.md
- [Reddit Ads to Databricks Connector](https://www.owox.com/connectors/free-reddit-ads-connector-to-databricks) — /connectors/free-reddit-ads-connector-to-databricks.md
- [Reddit Ads to Google BigQuery Connector](https://www.owox.com/connectors/free-reddit-ads-connector-to-google-bigquery) — /connectors/free-reddit-ads-connector-to-google-bigquery.md
- [Reddit Ads to Google Sheets Connector](https://www.owox.com/connectors/free-reddit-ads-connector-to-google-sheets) — /connectors/free-reddit-ads-connector-to-google-sheets.md
- [Reddit Ads to Looker Studio Connector](https://www.owox.com/connectors/free-reddit-ads-connector-to-looker-studio) — /connectors/free-reddit-ads-connector-to-looker-studio.md
- [Reddit Ads to Snowflake Connector](https://www.owox.com/connectors/free-reddit-ads-connector-to-snowflake) — /connectors/free-reddit-ads-connector-to-snowflake.md
- [Documentation](https://docs.owox.com/packages/connectors/src/sources/reddit-ads/readme)