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.
Data Partner You Can Trust
users
175K
Executives and data analysts across 20+ industries
G2 rating
4.9★
“A trusted data analytics partner” — verified review
Customers
IT
Retail
IT
Business & Consumer Services
Available connectors
Reddit Ads Connector to Azure SynapseReddit Ads Connector to ChatGPTReddit Ads Connector to ClaudeReddit Ads Connector to Microsoft ExcelReddit Ads Insights to EmailReddit Ads Insights to Google ChatReddit Ads Insights to Microsoft TeamsReddit Ads Insights to SlackReddit Ads to AWS Athena ConnectorReddit Ads to AWS Redshift ConnectorReddit Ads to Databricks ConnectorReddit Ads to Google BigQuery ConnectorReddit Ads to Google Sheets ConnectorReddit Ads to Looker Studio ConnectorReddit Ads to Snowflake Connector
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 fieldsAd Account User
The authenticated Reddit Ads user — identity and contact details.
7 fieldsAd Groups
Ad groups within your campaigns — bid strategy, goal, targeting, and schedule.
27 fieldsAd Performance
Daily ad performance — impressions, clicks, spend, conversions, and ROAS.
55 fieldsTime seriesAd Performance by Account
Daily ad performance broken down by ad account.
56 fieldsTime seriesAd Performance by Ad Group
Daily ad performance broken down by ad group.
56 fieldsTime seriesAd Performance by Campaign
Daily ad performance broken down by campaign.
57 fieldsTime seriesAd Performance by Community
Daily ad performance broken down by subreddit (community).
56 fieldsTime seriesAd Performance by Country
Daily ad performance broken down by user country.
56 fieldsTime seriesAd Performance by DMA
Daily ad performance broken down by Designated Market Area (DMA).
56 fieldsTime seriesAd Performance by Interest
Daily ad performance broken down by user interest targeting.
56 fieldsTime seriesAd Performance by Keyword
Daily ad performance broken down by keyword.
56 fieldsTime seriesAd Performance by Placement
Daily ad performance broken down by ad placement.
56 fieldsTime seriesAds
Individual ads — type, status, and links to their campaigns and posts.
23 fieldsCampaigns
Your campaigns — objective, status, spend cap, and account association.
15 fieldsCustom Audiences
Custom audiences built from your user lists — type, status, and size estimates.
9 fieldsFunding Instruments
Payment methods linked to your campaigns — credit limits and current outstanding balance.
9 fieldsLead Gen Forms
Lead generation forms shown in your ads — prompt text and creation details.
8 fields
Reddit Ads Ad Account schema
17 fieldsreddit_ads_ad_accountSchema on GitHub
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. |
Reddit Ads Ad Account User schema
7 fieldsreddit_ads_ad_account_userSchema on GitHub
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. |
Reddit Ads Ad Groups schema
27 fieldsreddit_ads_ad_groupSchema on GitHub
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. |
Reddit Ads Ad Performance schema
55 fieldsTime seriesreddit_ads_reportSchema on GitHub
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 fieldsTime seriesreddit_ads_report_by_AD_ACCOUNT_IDSchema on GitHub
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 fieldsTime seriesreddit_ads_report_by_AD_GROUP_IDSchema on GitHub
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 fieldsTime seriesreddit_ads_report_by_CAMPAIGN_IDSchema on GitHub
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 fieldsTime seriesreddit_ads_report_by_COMMUNITYSchema on GitHub
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 fieldsTime seriesreddit_ads_report_by_COUNTRYSchema on GitHub
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. |
Reddit Ads Ad Performance by DMA schema
56 fieldsTime seriesreddit_ads_report_by_DMASchema on GitHub
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 fieldsTime seriesreddit_ads_report_by_INTERESTSchema on GitHub
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 fieldsTime seriesreddit_ads_report_by_KEYWORDSchema on GitHub
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 fieldsTime seriesreddit_ads_report_by_PLACEMENTSchema on GitHub
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. |
Reddit Ads Ads schema
23 fieldsreddit_ads_adsSchema on GitHub
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. |
Reddit Ads Campaigns schema
15 fieldsreddit_ads_campaignsSchema on GitHub
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. |
Reddit Ads Custom Audiences schema
9 fieldsreddit_ads_user_custom_audienceSchema on GitHub
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. |
Reddit Ads Funding Instruments schema
9 fieldsreddit_ads_funding_instrumentsSchema on GitHub
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. |
Reddit Ads Lead Gen Forms schema
8 fieldsreddit_ads_lead_gen_formSchema on GitHub
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. |
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.
Collect to your warehouse
No per-connector pricing — connect as many sources as you need, all included
Zero-maintenance syncs
Fully open-source on GitHub — self-host anytime, no vendor lock-in, your data stays yours
Full-funnel joins
Full transparency and control — every query, every schema, every schedule is visible and auditable
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
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
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
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.
Not testimonials. Comment threads.
Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.
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.”
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.”
Nodari RizunFounder & 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.
