Reddit Ads Connector Reference

162 metrics56 dimensions

Fields

https://connectors.windsor.ai/reddit?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv

The Reddit Ads connector exposes 218 fields (162 metrics, 56 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Reddit Ads Fields

Reddit Ads Account fields

The Account report of the Reddit Ads connector includes 6 fields.

ID	Type	Name	Description
account_attribution_type	TEXT	Account Attribution Type	The Account Attribution Type
account_click_attribution_window	TEXT	Account Click Attribution Window	The Account Click Attribution Window
account_currency	TEXT	Account currency	The currency this account uses (ISO-4217)
account_id	TEXT	Account ID	The Account ID
account_name	TEXT	Account Name	The Account Name
account_view_attribution_window	TEXT	Account View Attribution Window	The Account View Attribution Window

Reddit Ads Ad fields

The Ad report of the Reddit Ads connector includes 6 fields.

ID	Type	Name	Description
ad_click_url	TEXT	Ad Click URL	The Ad's click URL
ad_configured_status	TEXT	Ad Configured Status	The status that the user has configured this ad to have. Can differ from the effective status depending on the context such as pending billing information.
ad_effective_status	TEXT	Ad Effective Status	The calculated status determining the real status of this ad.
ad_name	TEXT	Ad Name	The name of the Ad
ad_rejection_reason	TEXT	Ad Rejection Reason	The reason why the ad was rejected
ad_search_term	TEXT	Ad Search Term	The 'Search Term' that is displayed on a promoted trend

Reddit Ads AdGroup fields

The AdGroup report of the Reddit Ads connector includes 8 fields.

ID	Type	Name	Description
ad_group_budget	NUMERIC	Ad Group Budget (Currency)	Ad group-level budget in account currency (ad_group_goal_value divided by 1,000,000). The goal type (see Ad Group Goal Type) determines whether this is a daily or lifetime budget.
ad_group_configured_status	TEXT	Ad Group Configured Status	The status of the ad group configured by the account owner.
ad_group_effective_status	TEXT	Ad Group Effective Status	The calculated status determining the real status of this ad group.
ad_group_goal_type	TEXT	Ad Group Goal Type	The type of goal for the ad group
ad_group_goal_value	NUMERIC	Ad Group Goal Value	The value used to determine the goal has been met. This is measured in microcurrency for monetary goals types
ad_group_id	TEXT	Ad Group ID	Ad Group ID
ad_group_name	TEXT	Ad Group Name	Ad group name
ad_group_targeting_devices	TEXT	Ad Group Targeting Devices	A list of devices to target.

Reddit Ads Campaign fields

The Campaign report of the Reddit Ads connector includes 26 fields.

ID	Type	Name	Description
campaign	TEXT	Campaign	The Campaign Name
campaign_configured_status	TEXT	Campaign Configured Status	The status that the user has configured this campaign to have. Can differ from the effective status depending on the context such as pending billing information.
campaign_effective_status	TEXT	Campaign Effective Status	The calculated status determining the real status of this campaign.
campaign_goal_type	TEXT	Campaign Budget Type	The campaign budget type. Only works when is_campaign_budget_optimization is true
campaign_goal_value	NUMERIC	Campaign Budget	Campaign level budget value in micros. Only works when is_campaign_budget_optimization is true
campaign_id	TEXT	Campaign ID	The ID of the Campaign
campaign_is_campaign_budget_optimization	BOOLEAN	Is Campaign Budget optimization	Indicates whether the campaign will have campaign budget optimization or not.
campaign_name	TEXT	Campaign Name	The Campaign Name
campaign_objective	TEXT	Campaign Objective	The calculated status determining the real status of this campaign.
campaign_spend_cap	NUMERIC	Campaign Spend Cap	Lifetime spend cap for the campaign in account currency.
campaign_status	TEXT	Campaign Status	The status of the campaign.
clicks	NUMERIC	Clicks	The Number of Clicks
cpc	NUMERIC	CPC	The Cost-per-click
cpm	NUMERIC	CPM	The Cost per thousand impressions
ctr	PERCENT	CTR	The Click-through rate
date	DATE	Date	The Date
impressions	NUMERIC	impressions	The Number of Impressions Served
lead_total_value	NUMERIC	Total Value (Lead)	Total Value (Lead)
purchase_average	NUMERIC	Average Value of purchases	Average Value of purchases
purchase_total_items	NUMERIC	Total size of the purchase	Total size of the purchase
purchase_total_value	NUMERIC	Total Value (Purchase)	Total Value (Purchase)
reach	NUMERIC	Reach	The number of people who saw your ads at least once. Reach is different from impressions, which may include multiple views of your ads by the same people.
roas	PERCENT	ROAS	Purchase ROAS (Return On Ad Spend)
signup_total_value	NUMERIC	Total Value (Signup)	Total Value (Signup)
spend	NUMERIC	Spend	The Media Spend in USD
totalcost	NUMERIC	Total Cost	The Media Spend in USD

Reddit Ads Report Metrics fields

The Report Metrics report of the Reddit Ads connector includes 153 fields.

Reddit Ads Report Metrics fields (app_install_add_payment_info_count to app_install_mmp_reinstall_count)

Reddit Ads Report Metrics fields (app_install_mmp_reinstall_cvr to app_install_spend_credits_ecpa)

ID	Type	Name	Description
app_install_mmp_reinstall_cvr	NUMERIC	App install mmp reinstall cvr	App install mmp reinstall cvr
app_install_mmp_reinstall_ecpa	NUMERIC	App install mmp reinstall ecpa	App install mmp reinstall ecpa
app_install_mmp_roas	NUMERIC	App install mmp roas	App install mmp roas
app_install_mmp_search_count	NUMERIC	App install mmp search count	App install mmp search count
app_install_mmp_search_cvr	NUMERIC	App install mmp search cvr	App install mmp search cvr
app_install_mmp_search_ecpa	NUMERIC	App install mmp search ecpa	App install mmp search ecpa
app_install_mmp_sign_up_count	NUMERIC	App install mmp sign up count	App install mmp sign up count
app_install_mmp_sign_up_cvr	NUMERIC	App install mmp sign up cvr	App install mmp sign up cvr
app_install_mmp_sign_up_ecpa	NUMERIC	App install mmp sign up ecpa	App install mmp sign up ecpa
app_install_mmp_spend_credits_cvr	NUMERIC	App install mmp spend credits cvr	App install mmp spend credits cvr
app_install_mmp_spend_credits_ecpa	NUMERIC	App install mmp spend credits ecpa	App install mmp spend credits ecpa
app_install_mmp_total_install_count	NUMERIC	App install mmp total install count	App install mmp total install count
app_install_mmp_total_install_cvr	NUMERIC	App install mmp total install cvr	App install mmp total install cvr
app_install_mmp_total_install_ecpa	NUMERIC	App install mmp total install ecpa	App install mmp total install ecpa
app_install_mmp_view_content_count	NUMERIC	App install mmp view content count	App install mmp view content count
app_install_mmp_view_content_cvr	NUMERIC	App install mmp view content cvr	App install mmp view content cvr
app_install_mmp_view_content_ecpa	NUMERIC	App install mmp view content ecpa	App install mmp view content ecpa
app_install_purchase_count	NUMERIC	App install purchase count	App install purchase count
app_install_purchase_cvr	NUMERIC	App install purchase cvr	App install purchase cvr
app_install_purchase_ecpa	NUMERIC	App install purchase ecpa	App install purchase ecpa
app_install_revenue	NUMERIC	App install revenue	App install revenue
app_install_roas_double	NUMERIC	App install roas double	App install roas double
app_install_search_count	NUMERIC	App install search count	App install search count
app_install_search_cvr	NUMERIC	App install search cvr	App install search cvr
app_install_search_ecpa	NUMERIC	App install search ecpa	App install search ecpa
app_install_sign_up_count	NUMERIC	App install sign up count	App install sign up count
app_install_sign_up_cvr	NUMERIC	App install sign up cvr	App install sign up cvr
app_install_sign_up_ecpa	NUMERIC	App install sign up ecpa	App install sign up ecpa
app_install_skan_install_count	NUMERIC	App install skan install count	App install skan install count
app_install_skan_install_cvr	NUMERIC	App install skan install cvr	App install skan install cvr
app_install_skan_install_ecpa	NUMERIC	App install skan install ecpa	App install skan install ecpa
app_install_skan_reinstall_count	NUMERIC	App install skan reinstall count	App install skan reinstall count
app_install_skan_reinstall_cvr	NUMERIC	App install skan reinstall cvr	App install skan reinstall cvr
app_install_skan_reinstall_ecpa	NUMERIC	App install skan reinstall ecpa	App install skan reinstall ecpa
app_install_skan_total_install_count	NUMERIC	App install skan total install count	App install skan total install count
app_install_skan_total_install_cvr	NUMERIC	App install skan total install cvr	App install skan total install cvr
app_install_skan_total_install_ecpa	NUMERIC	App install skan total install ecpa	App install skan total install ecpa
app_install_spend_credits_count	NUMERIC	App install spend credits count	App install spend credits count
app_install_spend_credits_cvr	NUMERIC	App install spend credits cvr	App install spend credits cvr
app_install_spend_credits_ecpa	NUMERIC	App install spend credits ecpa	App install spend credits ecpa

Reddit Ads Report Metrics fields (app_install_total_conversions to conversion_signup_avg_value)

ID	Type	Name	Description
app_install_total_conversions	NUMERIC	App install total conversions	App install total conversions
app_install_view_content_count	NUMERIC	App install view content count	App install view content count
app_install_view_content_cvr	NUMERIC	App install view content cvr	App install view content cvr
app_install_view_content_ecpa	NUMERIC	App install view content ecpa	App install view content ecpa
comment_downvotes	NUMERIC	Comment downvotes	Comment downvotes
comment_page_views	NUMERIC	Comment page views	Comment page views
comment_submissions	NUMERIC	Comment submissions	Comment submissions
comment_upvotes	NUMERIC	Comment upvotes	Comment upvotes
community	TEXT	Community	The community (subreddit) the ad was served in.
conversion_add_to_cart_avg_value	NUMERIC	Conversion add to cart avg value	Conversion add to cart avg value
conversion_add_to_cart_clicks	NUMERIC	Conversion add to cart clicks	Conversion add to cart clicks
conversion_add_to_cart_ecpa	NUMERIC	Conversion add to cart ecpa	Conversion add to cart ecpa
conversion_add_to_cart_total_items	NUMERIC	Conversion add to cart total items	Conversion add to cart total items
conversion_add_to_cart_total_value	NUMERIC	Conversion add to cart total value	Conversion add to cart total value
conversion_add_to_cart_views	NUMERIC	Conversion add to cart views	Conversion add to cart views
conversion_add_to_wishlist_avg_value	NUMERIC	Conversion add to wishlist avg value	Conversion add to wishlist avg value
conversion_add_to_wishlist_clicks	NUMERIC	Conversion add to wishlist clicks	Conversion add to wishlist clicks
conversion_add_to_wishlist_ecpa	NUMERIC	Conversion add to wishlist ecpa	Conversion add to wishlist ecpa
conversion_add_to_wishlist_total_items	NUMERIC	Conversion add to wishlist total items	Conversion add to wishlist total items
conversion_add_to_wishlist_total_value	NUMERIC	Conversion add to wishlist total value	Conversion add to wishlist total value
conversion_add_to_wishlist_views	NUMERIC	Conversion add to wishlist views	Conversion add to wishlist views
conversion_lead_avg_value	NUMERIC	Conversion lead avg value	Conversion lead avg value
conversion_lead_clicks	NUMERIC	Conversion lead clicks	Conversion lead clicks
conversion_lead_ecpa	NUMERIC	Conversion lead ecpa	Conversion lead ecpa
conversion_lead_views	NUMERIC	Conversion lead views	Conversion lead views
conversion_page_visit_clicks	NUMERIC	Conversion page visit clicks	Conversion page visit clicks
conversion_page_visit_ecpa	NUMERIC	Conversion page visit ecpa	Conversion page visit ecpa
conversion_page_visit_views	NUMERIC	Conversion page visit views	Conversion page visit views
conversion_purchase_avg_value	NUMERIC	Conversion purchase avg value	Conversion purchase avg value
conversion_purchase_clicks	NUMERIC	Conversion purchase clicks	Conversion purchase clicks
conversion_purchase_ecpa	NUMERIC	Conversion purchase ecpa	Conversion purchase ecpa
conversion_purchase_views	NUMERIC	Conversion purchase views	Conversion purchase views
conversion_roas	NUMERIC	Conversion roas	Conversion roas
conversion_search_clicks	NUMERIC	Conversion search clicks	Conversion search clicks
conversion_search_ecpa	NUMERIC	Conversion search ecpa	Conversion search ecpa
conversion_search_views	NUMERIC	Conversion search views	Conversion search views
conversion_sign_up_clicks	NUMERIC	Conversion sign up clicks	Conversion sign up clicks
conversion_sign_up_ecpa	NUMERIC	Conversion sign up ecpa	Conversion sign up ecpa
conversion_sign_up_views	NUMERIC	Conversion sign up views	Conversion sign up views
conversion_signup_avg_value	NUMERIC	Conversion signup avg value	Conversion signup avg value

Reddit Ads Report Metrics fields (conversion_view_content_clicks to viewable_impressions)

ID	Type	Name	Description
conversion_view_content_clicks	NUMERIC	Conversion view content clicks	Conversion view content clicks
conversion_view_content_ecpa	NUMERIC	Conversion view content ecpa	Conversion view content ecpa
conversion_view_content_views	NUMERIC	Conversion view content views	Conversion view content views
country	COUNTRY	Country	The country the ad was served in.
cpv	NUMERIC	Cpv	Cpv
device	TEXT	Device	The operating system of the device on which the ad was shown (e.g. ANDROID, IOS, MACOS, WINDOWS).
dma	TEXT	DMA	The Designated Market Area the ad was served in.
downvotes	NUMERIC	Downvotes	Downvotes
ecpm	NUMERIC	Ecpm	Ecpm
frequency	NUMERIC	Frequency	The average number of times each user saw your ad.
gender	TEXT	Gender	The gender the ad was served to.
interest	TEXT	Interest segment	The interest category the ad was served against.
keyword	TEXT	Keyword	The keyword the ad was served against.
pacing	NUMERIC	Pacing	Pacing
placement	TEXT	Placement	The placement where the ad was served (e.g. feed, conversation).
region	REGION	Region	The region (e.g. state or province) the ad was served in.
upvotes	NUMERIC	Upvotes	Upvotes
video_completion_rate	NUMERIC	Video completion rate	Video completion rate
video_fully_viewable_impressions	NUMERIC	Video fully viewable impressions	Video fully viewable impressions
video_plays_expanded	NUMERIC	Video plays expanded	Video plays expanded
video_plays_with_sound	NUMERIC	Video plays with sound	Video plays with sound
video_started	NUMERIC	Video started	Video started
video_view_rate	PERCENT	Video view rate	Video view rate
video_viewable_impressions	NUMERIC	Video viewable impressions	Video viewable impressions
video_watched_100_percent	NUMERIC	Video watched 100 percent	Video watched 100 percent
video_watched_10_seconds	NUMERIC	Video watched 10 seconds	Video watched 10 seconds
video_watched_25_percent	NUMERIC	Video watched 25 percent	Video watched 25 percent
video_watched_3_seconds	NUMERIC	Video watched 3 seconds	Video watched 3 seconds
video_watched_50_percent	NUMERIC	Video watched 50 percent	Video watched 50 percent
video_watched_5_seconds	NUMERIC	Video watched 5 seconds	Video watched 5 seconds
video_watched_75_percent	NUMERIC	Video watched 75 percent	Video watched 75 percent
video_watched_95_percent	NUMERIC	Video watched 95 percent	Video watched 95 percent
viewable_impressions	NUMERIC	Viewable impressions	Viewable impressions

Reddit Ads other fields

The Reddit Ads connector has 19 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
ad_id	TEXT	Ad ID	The id of the Ad
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors