---
title: "Reddit Ads to Claude | OWOX MCP"
canonical: "https://www.owox.com/connectors/reddit-ads-connector-to-claude"
updated: "2026-09-17"
---

# Ask Reddit Ads Questions in Claude

Ask Reddit Ads questions in Claude using OWOX Data Marts. Collect Reddit Ads data into a governed data mart, then get answers in Claude via OWOX's MCP server — every number traces back to analyst-written SQL.

[Get Started Free](https://www.owox.com/app-signup)

## Endpoints

## Reddit Ads endpoints

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

*   ### Ad Account

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

    17 fields`reddit_ads_ad_account`
*   ### Ad Account User

    The authenticated Reddit Ads user — identity and contact details.

    7 fields`reddit_ads_ad_account_user`
*   ### Ad Groups

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

    27 fields`reddit_ads_ad_group`
*   ### Ad Performance

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

    55 fieldsTime series`reddit_ads_report`
*   ### Ad Performance by Account

    Daily ad performance broken down by ad account.

    56 fieldsTime series`reddit_ads_report_by_AD_ACCOUNT_ID`
*   ### Ad Performance by Ad Group

    Daily ad performance broken down by ad group.

    56 fieldsTime series`reddit_ads_report_by_AD_GROUP_ID`
*   ### Ad Performance by Campaign

    Daily ad performance broken down by campaign.

    57 fieldsTime series`reddit_ads_report_by_CAMPAIGN_ID`
*   ### Ad Performance by Community

    Daily ad performance broken down by subreddit (community).

    56 fieldsTime series`reddit_ads_report_by_COMMUNITY`
*   ### Ad Performance by Country

    Daily ad performance broken down by user country.

    56 fieldsTime series`reddit_ads_report_by_COUNTRY`
*   ### Ad Performance by DMA

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

    56 fieldsTime series`reddit_ads_report_by_DMA`
*   ### Ad Performance by Interest

    Daily ad performance broken down by user interest targeting.

    56 fieldsTime series`reddit_ads_report_by_INTEREST`
*   ### Ad Performance by Keyword

    Daily ad performance broken down by keyword.

    56 fieldsTime series`reddit_ads_report_by_KEYWORD`
*   ### Ad Performance by Placement

    Daily ad performance broken down by ad placement.

    56 fieldsTime series`reddit_ads_report_by_PLACEMENT`
*   ### Ads

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

    23 fields`reddit_ads_ads`
*   ### Campaigns

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

    15 fields`reddit_ads_campaigns`
*   ### Custom Audiences

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

    9 fields`reddit_ads_user_custom_audience`
*   ### Funding Instruments

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

    9 fields`reddit_ads_funding_instruments`
*   ### Lead Gen Forms

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

    8 fields`reddit_ads_lead_gen_form`

## Data schema

## Reddit Ads data schema

**Ad Account** 17 fields · reddit\_ads\_ad\_account

| 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** 7 fields · reddit\_ads\_ad\_account\_user

| 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** 27 fields · reddit\_ads\_ad\_group

| 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** 55 fields · reddit\_ads\_report

| 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** 56 fields · reddit\_ads\_report\_by\_AD\_ACCOUNT\_ID

| 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** 56 fields · reddit\_ads\_report\_by\_AD\_GROUP\_ID

| 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** 57 fields · reddit\_ads\_report\_by\_CAMPAIGN\_ID

| 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** 56 fields · reddit\_ads\_report\_by\_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** 56 fields · reddit\_ads\_report\_by\_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** 56 fields · reddit\_ads\_report\_by\_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** 56 fields · reddit\_ads\_report\_by\_INTEREST

| 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** 56 fields · reddit\_ads\_report\_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** 56 fields · reddit\_ads\_report\_by\_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** 23 fields · reddit\_ads\_ads

| 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** 15 fields · reddit\_ads\_campaigns

| 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** 9 fields · reddit\_ads\_user\_custom\_audience

| 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** 9 fields · reddit\_ads\_funding\_instruments

| 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** 8 fields · reddit\_ads\_lead\_gen\_form

| 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. |

## In Claude

## Ask Reddit Ads questions in Claude

You

Which subreddits give us the cheapest clicks?

Claude

The Ad Performance by Community endpoint breaks performance down by subreddit. I divided spend by clicks for each community and sorted cheapest first, leaving out communities with too few clicks to judge.

It is read from your governed Reddit Ads Data Mart through the OWOX MCP server and reflects that Data Mart's last scheduled refresh.

You

Do people from those communities add items to cart?

Claude

Adding conversion\_add\_to\_cart\_clicks and conversion\_add\_to\_cart\_total\_value per community shows whether cheap clicks turn into shopping intent or stay as curiosity.

## Related connectors

[AWS Athena Connector to Claude](/connectors/aws-athena-connector-to-claude)

[AWS Redshift Connector to Claude](/connectors/aws-redshift-connector-to-claude)

[Bank of Canada Connector to Claude](/connectors/bank-of-canada-connector-to-claude)

## What users are saying

## Every claim has a receipt.

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

A3re: trusting AI

![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public)Nodari RizunFounder & 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.”_

C9re: one source of truth

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

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

E7re: getting time back

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

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

## Turn Reddit Ads Data into Answers in Claude

See how OWOX Data Marts helps you ask Reddit Ads questions in Claude, blend it with other sources, and scale reporting without rebuilding logic.

[Get Started Free](https://www.owox.com/app-signup)

## 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)
- [AWS Athena Connector to Claude](https://www.owox.com/connectors/aws-athena-connector-to-claude) — /connectors/aws-athena-connector-to-claude.md
- [AWS Redshift Connector to Claude](https://www.owox.com/connectors/aws-redshift-connector-to-claude) — /connectors/aws-redshift-connector-to-claude.md
- [Bank of Canada Connector to Claude](https://www.owox.com/connectors/bank-of-canada-connector-to-claude) — /connectors/bank-of-canada-connector-to-claude.md