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 |
| 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 |
| cpc | NUMERIC | CPC | The Cost-per-click |
| cpm | NUMERIC | CPM | The Cost per thousand impressions |
| 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 |
| 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 |
| 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 |
| 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 |