Windsor brings all your Reddit Ads data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Reddit Ads Field Reference
Sample
https://connectors.windsor.ai/reddit?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv
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 |
| 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_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_id | TEXT | Ad Group ID | Ad Group ID |
| ad_group_name | TEXT | Ad Group Name | Ad group name |
| ad_id | TEXT | Ad ID | The id of the 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 |
| app_install_add_payment_info_count | NUMERIC | App install add payment info count | App install add payment info count |
| app_install_add_payment_info_cvr | NUMERIC | App install add payment info cvr | App install add payment info cvr |
| app_install_add_payment_info_ecpa | NUMERIC | App install add payment info ecpa | App install add payment info ecpa |
| app_install_add_to_cart_count | NUMERIC | App install add to cart count | App install add to cart count |
| app_install_add_to_cart_cvr | NUMERIC | App install add to cart cvr | App install add to cart cvr |
| app_install_add_to_cart_ecpa | NUMERIC | App install add to cart ecpa | App install add to cart ecpa |
| app_install_app_launch_count | NUMERIC | App install app launch count | App install app launch count |
| app_install_app_launch_cvr | NUMERIC | App install app launch cvr | App install app launch cvr |
| app_install_app_launch_ecpa | NUMERIC | App install app launch ecpa | App install app launch ecpa |
| app_install_completed_tutorial_count | NUMERIC | App install completed tutorial count | App install completed tutorial count |
| app_install_completed_tutorial_cvr | NUMERIC | App install completed tutorial cvr | App install completed tutorial cvr |
| app_install_completed_tutorial_ecpa | NUMERIC | App install completed tutorial ecpa | App install completed tutorial ecpa |
| app_install_install_count | NUMERIC | App install install count | App install install count |
| app_install_install_cvr | NUMERIC | App install install cvr | App install install cvr |
| app_install_install_ecpa | NUMERIC | App install install ecpa | App install install ecpa |
| app_install_level_achieved_count | NUMERIC | App install level achieved count | App install level achieved count |
| app_install_level_achieved_cvr | NUMERIC | App install level achieved cvr | App install level achieved cvr |
| app_install_level_achieved_ecpa | NUMERIC | App install level achieved ecpa | App install level achieved ecpa |
| app_install_mmp_add_payment_info_count | NUMERIC | App install mmp add payment info count | App install mmp add payment info count |
| app_install_mmp_add_payment_info_cvr | NUMERIC | App install mmp add payment info cvr | App install mmp add payment info cvr |
| app_install_mmp_add_payment_info_ecpa | NUMERIC | App install mmp add payment info ecpa | App install mmp add payment info ecpa |
| app_install_mmp_add_to_cart_count | NUMERIC | App install mmp add to cart count | App install mmp add to cart count |
| app_install_mmp_add_to_cart_cvr | NUMERIC | App install mmp add to cart cvr | App install mmp add to cart cvr |
| app_install_mmp_add_to_cart_ecpa | NUMERIC | App install mmp add to cart ecpa | App install mmp add to cart ecpa |
| app_install_mmp_app_launch_count | NUMERIC | App install mmp app launch count | App install mmp app launch count |
| app_install_mmp_app_launch_cvr | NUMERIC | App install mmp app launch cvr | App install mmp app launch cvr |
| app_install_mmp_app_launch_ecpa | NUMERIC | App install mmp app launch ecpa | App install mmp app launch ecpa |
| app_install_mmp_completed_tutorial_count | NUMERIC | App install mmp completed tutorial count | App install mmp completed tutorial count |
| app_install_mmp_completed_tutorial_cvr | NUMERIC | App install mmp completed tutorial cvr | App install mmp completed tutorial cvr |
| app_install_mmp_completed_tutorial_ecpa | NUMERIC | App install mmp completed tutorial ecpa | App install mmp completed tutorial ecpa |
| app_install_mmp_install_count | NUMERIC | App install mmp install count | App install mmp install count |
| app_install_mmp_install_cvr | NUMERIC | App install mmp install cvr | App install mmp install cvr |
| app_install_mmp_install_ecpa | NUMERIC | App install mmp install ecpa | App install mmp install ecpa |
| app_install_mmp_level_achieved_count | NUMERIC | App install mmp level achieved count | App install mmp level achieved count |
| app_install_mmp_level_achieved_cvr | NUMERIC | App install mmp level achieved cvr | App install mmp level achieved cvr |
| app_install_mmp_level_achieved_ecpa | NUMERIC | App install mmp level achieved ecpa | App install mmp level achieved ecpa |
| app_install_mmp_purchase_count | NUMERIC | App install mmp purchase count | App install mmp purchase count |
| app_install_mmp_purchase_cvr | NUMERIC | App install mmp purchase cvr | App install mmp purchase cvr |
| app_install_mmp_purchase_ecpa | NUMERIC | App install mmp purchase ecpa | App install mmp purchase ecpa |
| app_install_mmp_reinstall_count | NUMERIC | App install mmp reinstall count | App install mmp reinstall count |
| 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 |
| 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 |
| 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_id | TEXT | Campaign ID | The ID of the Campaign |
| campaign_name | TEXT | Campaign Name | The Campaign Name |
| campaign_objective | TEXT | Campaign Objective | The calculated status determining the real status of this campaign. |
| clicks | NUMERIC | Clicks | The Number of Clicks |
| 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 |
| 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 |
| 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 |
| cpc | NUMERIC | CPC | The Cost-per-click |
| cpm | NUMERIC | CPM | The Cost per thousand impressions |
| cpv | NUMERIC | Cpv | Cpv |
| ctr | PERCENT | CTR | The Click-through rate |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row |
| date | DATE | Date | The Date |
| day_of_month | TEXT | Day of month | Day of the month |
| downvotes | NUMERIC | Downvotes | Downvotes |
| ecpm | NUMERIC | Ecpm | Ecpm |
| impressions | NUMERIC | impressions | The Number of Impressions Served |
| lead_total_value | NUMERIC | Total Value (Lead) | Total Value (Lead) |
| month | TEXT | Month | Number of the month |
| pacing | NUMERIC | Pacing | Pacing |
| 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) |
| roas | PERCENT | ROAS | Purchase ROAS (Return On Ad Spend) |
| signup_total_value | NUMERIC | Total Value (Signup) | Total Value (Signup) |
| source | TEXT | Source | The name of the Windsor connector returning the row |
| spend | NUMERIC | Spend | The Media Spend in USD |
| today | DATE | Today | Today's date |
| totalcost | NUMERIC | Total Cost | The Media Spend in USD |
| 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 | NUMERIC | 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 |
| 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_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 |