Windsor brings all your StackAdapt data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure MS SQL
StackAdapt Field Reference
Sample
The StackAdapt connector pulls data StackAdapt data on campaign level.
A sample URL on how to query data:
https://connectors.windsor.ai/stackadapt?=[API_KEY]&date_preset=last_7d&fields=campaign,date,campaign_budget,campaign_state,spend
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | The Account ID | Account |
| account_name | TEXT | Account Name | The Account Name | Account |
| atos | NUMERIC | Atos | Atos | Campaign |
| campaign | TEXT | Campaign | Alias for Campaign Name | Campaign |
| campaign_advertiser_id | NUMERIC | Campaign Advertiser ID | Campaign Advertiser ID | Campaign |
| campaign_allow_iframe_engagement | NUMERIC | Campaign Allow Iframe Engagement | Campaign Allow Iframe Engagement | Campaign |
| campaign_bid_amount_total | NUMERIC | Campaign Bid Amount Total | Campaign Bid Amount Total | Campaign |
| campaign_bid_type | TEXT | Campaign Bid Type | Campaign Bid Type | Campaign |
| campaign_budget | NUMERIC | Campaign Budget | Campaign Budget | Campaign |
| campaign_city_options | CITY | Campaign City Options | Campaign City Options | Campaign |
| campaign_daily_cap | TEXT | Campaign Daily Cap | Campaign Daily Cap | Campaign |
| campaign_domain_action | TEXT | Campaign Domain Action | Campaign Domain Action | Campaign |
| campaign_end_date | DATE | Campaign End Date | Campaign End Date | Campaign |
| campaign_engagement_tracking_type | NUMERIC | Campaign Engagement Tracking Type | Campaign Engagement Tracking Type | Campaign |
| campaign_freq_cap_limit | NUMERIC | Campaign Freq Cap Limit | Campaign Freq Cap Limit | Campaign |
| campaign_freq_cap_time | NUMERIC | Campaign Freq Cap Time | Campaign Freq Cap Time | Campaign |
| campaign_goal | TEXT | Campaign Goal | Campaign Goal | Campaign |
| campaign_id | TEXT | Campaign ID | Campaign ID | Campaign |
| campaign_is_deal_id_strict | NUMERIC | Campaign Is Deal Id Strict | Campaign Is Deal Id Strict | Campaign |
| campaign_line_item_id | NUMERIC | Campaign Line Item ID | Campaign Line Item ID | Campaign |
| campaign_name | TEXT | Campaign Name | Campaign Name | Campaign |
| campaign_optimize_type | TEXT | Campaign Optimize Type | Campaign Optimize Type | Campaign |
| campaign_optimize_value | NUMERIC | Campaign Optimize Value | Campaign Optimize Value | Campaign |
| campaign_pace_evenly | NUMERIC | Campaign Pace Evenly | Campaign Pace Evenly | Campaign |
| campaign_start_date | DATE | Campaign Start Date | Campaign Start Date | Campaign |
| campaign_state | TEXT | Campaign State | Campaign State | Campaign |
| campaign_type | TEXT | Campaign Type | Campaign Type | Campaign |
| campaign_use_dma | NUMERIC | Campaign Use Dma | Campaign Use Dma | Campaign |
| campaign_weekday_enabled | NUMERIC | Campaign Weekday Enabled | Campaign Weekday Enabled | Campaign |
| clicks | NUMERIC | Clicks | Clicks | Campaign |
| conversion_tracker_conv_type | TEXT | Conversion Tracker Conversion Type | Conversion Tracker Conversion Type | Conversion_trackers |
| conversion_tracker_count_type | TEXT | Conversion Tracker Count Type | Conversion Tracker Count Type | Conversion_trackers |
| conversion_tracker_description | TEXT | Conversion Tracker Description | Conversion Tracker Description | Conversion_trackers |
| conversion_tracker_id | TEXT | Conversion tracker id | Conversion Tracker ID | Conversion_trackers |
| conversion_tracker_name | TEXT | Conversion Tracker Name | Conversion Tracker Name | Conversion_trackers |
| conversion_tracker_post_time | TEXT | Conversion Tracker Post Time | Conversion Tracker Post Time | Conversion_trackers |
| conversion_tracker_user_id | TEXT | Conversion Tracker User ID | Conversion Tracker User ID | Conversion_trackers |
| conversions | NUMERIC | Conversions | Conversions | Campaign |
| cost | NUMERIC | Cost | Cost | Campaign |
| ctr | PERCENT | CTR | Click-through rate | Campaign |
| cvr | NUMERIC | CVR | Conversion rate | Campaign |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date | Campaign |
| day_of_month | TEXT | Day of month | Day of the month | |
| ecpa | NUMERIC | ECPA | Enhanced cost per action | Campaign |
| ecpc | NUMERIC | ECPC | Enhanced cost per click | Campaign |
| ecpe | NUMERIC | ECPE | Ecpe | Campaign |
| ecpm | NUMERIC | ECPM | Enhanced cost per mille | Campaign |
| ecpv | NUMERIC | ECPV | Ecpv | Campaign |
| impressions | NUMERIC | Impressions | Impressions | Campaign |
| month | TEXT | Month | Number of the month | |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| spend | NUMERIC | Spend | Alias for Cost | Campaign |
| stats_conv_imp_derived | NUMERIC | Conversion Impression Derived | Conversion Impression Derived | Campaign |
| stats_page_time | NUMERIC | Page Time | Page Time | Campaign |
| stats_page_time_15s | NUMERIC | Page Time 15s | Page Time 15s | Campaign |
| stats_unique_imp_inverse_rate | NUMERIC | Unique Impressions Inverse Rate | Unique Impressions Inverse Rate | Campaign |
| stats_view_percent | PERCENT | View Percent | View Percent | Campaign |
| today | DATE | Today | Today's date | |
| totalcost | NUMERIC | Total Cost | Alias for Cost | Campaign |
| unique_conversions | NUMERIC | Unique Conversions | Unique Conversions | Campaign |
| unique_impressions | NUMERIC | Unique Impressions | Unique Impressions | Campaign |
| 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 |