Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your StackAdapt data to
StackAdapt Connector Reference
64 metrics82 dimensions
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
The StackAdapt connector exposes 146 fields (64 metrics, 82 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available options
report_timezone Report Timezone
Timezone for adjusting date ranges. Select UTC if unsure.
Possible values (12)
UTCAustralia/SydneyAustralia/MelbourneAustralia/BrisbaneAustralia/PerthUS/EasternUS/CentralUS/PacificEurope/LondonEurope/BerlinAsia/TokyoAsia/Singapore
StackAdapt Fields
StackAdapt Account fields
The Account report of the StackAdapt connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| account_currency | TEXT | Account Currency | Account Currency |
| account_id | TEXT | Account ID | The Account ID |
| account_name | TEXT | Account Name | The Account Name |
StackAdapt Campaign fields
The Campaign report of the StackAdapt connector includes 95 fields.
StackAdapt Campaign fields (abm_domain to campaign_pace_evenly)
| ID | Type | Name | Description |
|---|---|---|---|
| abm_domain | TEXT | ABM Domain | The company (ABM/B2B) domain the impression was matched to |
| atos | NUMERIC | Atos | Atos |
| atos_units | TEXT | Atos Units | Atos Units |
| audio_completion_rate | PERCENT | Audio Completion Rate | Listen-through rate: audio completed / audio started |
| audio_completions | NUMERIC | Audio Completed | Number of completed audio plays (95% listened) |
| campaign | TEXT | Campaign | Alias for Campaign Name |
| campaign_advertiser_description | TEXT | Campaign Advertiser Description | Campaign Advertiser Description |
| campaign_advertiser_id | NUMERIC | Campaign Advertiser ID | Campaign Advertiser ID |
| campaign_allow_iframe_engagement | NUMERIC | Campaign Allow Iframe Engagement (Deprecated) | Campaign Allow Iframe Engagement |
| campaign_bid_amount_total | NUMERIC | Campaign Bid Amount Total (Deprecated) | Campaign Bid Amount Total |
| campaign_bid_type | TEXT | Campaign Bid Type (Deprecated) | Campaign Bid Type |
| campaign_budget | NUMERIC | Campaign Budget (Deprecated) | Campaign Budget |
| campaign_budget_rollover | BOOLEAN | Campaign Budget Rollover | Campaign Budget Rollover |
| campaign_city_options | CITY | Campaign City Options (Deprecated) | Campaign City Options |
| campaign_created_at | Campaign Created At | Campaign Created At | |
| campaign_creative_tactic_fallback | TEXT | Campaign Creative Tactic Fallback | Campaign Creative Tactic Fallback |
| campaign_daily_cap | TEXT | Campaign Daily Cap (Deprecated) | Campaign Daily Cap |
| campaign_domain_action | TEXT | Campaign Domain Action (Deprecated) | Campaign Domain Action |
| campaign_end_date | DATE | Campaign End Date (Deprecated) | Campaign End Date |
| campaign_engagement_tracking_type | NUMERIC | Campaign Engagement Tracking Type (Deprecated) | Campaign Engagement Tracking Type |
| campaign_engagement_tracking_type_name | TEXT | Campaign Engagement Tracking Type Name | Campaign Engagement Tracking Type Name |
| campaign_freq_cap_expiry | NUMERIC | Campaign Freq Cap Expiry | Duration of time in minutes before the limit expires |
| campaign_freq_cap_limit | NUMERIC | Campaign Freq Cap Limit | Limit of number of times a unique user can view the ad |
| campaign_freq_cap_time | NUMERIC | Campaign Freq Cap Time (Deprecated) | Campaign Freq Cap Time |
| campaign_freq_min_expiry | NUMERIC | Campaign Freq Min Expiry | Duration of time in minutes before the limit expires. Always a multiple of 60 minutes |
| campaign_freq_min_threshold | NUMERIC | Campaign Freq Min Threshold | Minimum of number of times a unique user should view the ad |
| campaign_ga_integration_enabled | BOOLEAN | Campaign GA Integration Enabled | An indicator of whether the Google Analytics (GA) integration is enabled (true or false) |
| campaign_ga_integration_ga4web_property_id | TEXT | Campaign GA Integration GA4WebPropertyId | A unique identifier associated with a specific Google Analytics account. It is used to track and collect data from a particular website. The ID is typically a 9-digit number |
| campaign_geo_include_dma | BOOLEAN | Campaign Geo Include Dma | Whether or not to include the designated market area of targeted city locations |
| campaign_goal | TEXT | Campaign Goal | Campaign Goal |
| campaign_group | TEXT | Campaign Group | Name of the campaign group the campaign belongs to |
| campaign_id | TEXT | Campaign ID | Campaign ID |
| campaign_is_archived | BOOLEAN | Campaign is Archived | True if the campaign has been archived, false otherwise |
| campaign_is_deal_id_strict | NUMERIC | Campaign Is Deal Id Strict (Deprecated) | Campaign Is Deal Id Strict |
| campaign_is_draft | BOOLEAN | Campaign is Draft | True if the campaign is a draft, false otherwise |
| campaign_line_item_id | NUMERIC | Campaign Line Item ID (Deprecated) | Campaign Line Item ID |
| campaign_name | TEXT | Campaign Name | Campaign Name |
| campaign_optimize_type | TEXT | Campaign Optimize Type (Deprecated) | Campaign Optimize Type |
| campaign_optimize_value | NUMERIC | Campaign Optimize Value (Deprecated) | Campaign Optimize Value |
| campaign_pace_evenly | NUMERIC | Campaign Pace Evenly (Deprecated) | Campaign Pace Evenly |
StackAdapt Campaign fields (campaign_pacing_daily_spend_needed to stats_page_time_15s)
| ID | Type | Name | Description |
|---|---|---|---|
| campaign_pacing_daily_spend_needed | NUMERIC | Campaign Pacing Daily Spend Needed | The daily spend needed |
| campaign_pacing_flight_pacing_lifetime_budget | NUMERIC | Campaign Pacing Flight Pacing Lifetime Budget | Lifetime budget |
| campaign_pacing_flight_pacing_overall_pacing | NUMERIC | Campaign Pacing Flight Pacing Overall Pacing | Overall pacing |
| campaign_pacing_flight_pacing_total_projected_spend | NUMERIC | Campaign Pacing Flight Pacing Total Projected Spend | Total projected spend |
| campaign_start_date | DATE | Campaign Start Date (Deprecated) | Campaign Start Date |
| campaign_state | TEXT | Campaign State | Campaign State |
| campaign_status | TEXT | Campaign Status | Campaign Status |
| campaign_tactic_type | TEXT | Campaign Tactic Type | Creative tactic logic type |
| campaign_timezone | TEXT | Campaign Timezone | Timezone |
| campaign_type | TEXT | Campaign Type | Campaign Type |
| campaign_updated_at | Campaign Updated At | Campaign Updated At | |
| campaign_use_dma | NUMERIC | Campaign Use Dma (Deprecated) | Campaign Use Dma |
| campaign_weekday_enabled | NUMERIC | Campaign Weekday Enabled (Deprecated) | Campaign Weekday Enabled |
| click_conversions | NUMERIC | Click conversions | Conversions attributed to clicks |
| clicks | NUMERIC | Clicks | Clicks |
| conversion_revenue | NUMERIC | Conversion Revenue | Revenue generated through conversions |
| conversions | NUMERIC | Conversions | Conversions |
| cost | NUMERIC | Cost | Cost |
| cpc | NUMERIC | CPC | Cost per click |
| cpe | NUMERIC | CPE (Deprecated) | Cost per engagement |
| cpm | NUMERIC | CPM | Cost per mille (thousand impressions) |
| ctr | PERCENT | CTR | Click-through rate |
| cvr | PERCENT | CVR | Conversion rate |
| date | DATE | Date | Date |
| domain | TEXT | Domain | The domain or app the impression was served on |
| ecpa | NUMERIC | ECPA | Enhanced cost per action |
| ecpc | NUMERIC | ECPC | Enhanced cost per click |
| ecpe | NUMERIC | ECPE | Ecpe |
| ecpm | NUMERIC | ECPM | Enhanced cost per mille |
| ecpv | NUMERIC | ECPV | Ecpv |
| engagement_rate | PERCENT | Engagement rate | Engagement rate |
| impression_conversions | NUMERIC | Impression conversions | Conversions attributed to impressions |
| impressions | NUMERIC | Impressions | Impressions |
| page_starts | NUMERIC | Page starts | Page start events |
| rcpe | NUMERIC | RCPE | Revenue cost per engagement |
| revenue | NUMERIC | Revenue | Revenue |
| spend | NUMERIC | Spend | Alias for Cost |
| stats_conv_imp_derived | NUMERIC | Conversion Impression Derived (Deprecated) | Conversion Impression Derived |
| stats_page_time | NUMERIC | Page Time (Deprecated) | Page Time |
| stats_page_time_15s | NUMERIC | Page Time 15s (Deprecated) | Page Time 15s |
StackAdapt Campaign fields (stats_unique_imp_inverse_rate to view_through_conversions)
| ID | Type | Name | Description |
|---|---|---|---|
| stats_unique_imp_inverse_rate | NUMERIC | Unique Impressions Inverse Rate (Deprecated) | Unique Impressions Inverse Rate |
| stats_view_percent | PERCENT | View Percent | View Percent |
| time_on_site | NUMERIC | Time on site | Time on site in seconds |
| total_time | NUMERIC | Total Time | Total time spent on the page (seconds) |
| total_time_units | TEXT | Total time units (Deprecated) | Time on site in minutes and seconds |
| totalcost | NUMERIC | Total Cost | Alias for Cost |
| unique_conversions | NUMERIC | Unique Conversions | Unique Conversions |
| unique_impressions | NUMERIC | Unique Impressions | Unique Impressions |
| vcomp_0 | NUMERIC | vcomp_0 | Video completion at 0% |
| vcomp_25 | NUMERIC | vcomp_25 | Video completion at 25% |
| vcomp_50 | NUMERIC | vcomp_50 | Video completion at 50% |
| vcomp_75 | NUMERIC | vcomp_75 | Video completion at 75% |
| vcomp_95 | NUMERIC | vcomp_95 | Video completion at 95% |
| vcomp_rate | PERCENT | vcomp_rate | Video completion rate |
| view_through_conversions | NUMERIC | View-through conversions (Deprecated) | Conversions attributed to views |
StackAdapt Conversion_trackers fields
The Conversion_trackers report of the StackAdapt connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| conversion_tracker_conv_type | TEXT | Conversion Tracker Conversion Type (Deprecated) | Conversion Tracker Conversion Type |
| conversion_tracker_count_type | TEXT | Conversion Tracker Count Type (Deprecated) | Conversion Tracker Count Type |
| conversion_tracker_description | TEXT | Conversion Tracker Description (Deprecated) | Conversion Tracker Description |
| conversion_tracker_id | TEXT | Conversion tracker id (Deprecated) | Conversion Tracker ID |
| conversion_tracker_name | TEXT | Conversion Tracker Name (Deprecated) | Conversion Tracker Name |
| conversion_tracker_post_time | TEXT | Conversion Tracker Post Time (Deprecated) | Conversion Tracker Post Time |
| conversion_tracker_user_id | TEXT | Conversion Tracker User ID (Deprecated) | Conversion Tracker User ID |
StackAdapt Creative fields
The Creative report of the StackAdapt connector includes 23 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| creative_audit_status | TEXT | Creative Audit Status | Creative Audit Status |
| creative_brandname | TEXT | Creative Brand Name | The name of the brand associated with the ad |
| creative_channel | TEXT | Creative Channel (Deprecated) | Creative Channel |
| creative_click_url | TEXT | Creative Click Url | Creative Click Url |
| creative_created_at | Creative Created At (Deprecated) | Creative Created At | |
| creative_cta_text | TEXT | Creative Cta Text | Call to Action text |
| creative_heading | TEXT | Creative Heading | Creative Heading |
| creative_icon_file_name | TEXT | Creative Icon File Name | The name of the file containing the image creative |
| creative_icon_height | NUMERIC | Creative Icon Height | The height of the image creative in pixels |
| creative_icon_id | TEXT | Creative Icon ID | The ID of the image creative |
| creative_icon_url | IMAGE_URL | Creative Icon URL | The URL hosting the image creative on the StackAdapt AWS S3 server |
| creative_icon_width | NUMERIC | Creative Icon Width | The width of the image creative in pixels |
| creative_id | TEXT | Creative ID | Creative ID |
| creative_input_data_heading | TEXT | Creative Input Data Heading | Alias for Creative Heading |
| creative_input_data_landing_url | TEXT | Creative Input Data Landing URL (Deprecated) | Creative Input Data Landing URL |
| creative_input_data_tagline | TEXT | Creative Input Data Tagline | Alias for Creative Tagline |
| creative_input_data_vast_xml | TEXT | Creative Input Data Vast XML (Deprecated) | Creative Input Data Vast XML |
| creative_name | TEXT | Creative Name | Creative Name |
| creative_state | TEXT | Creative State | Creative State |
| creative_status_active | TEXT | Creative Status Active (Deprecated) | Creative Status Active |
| creative_status_description | TEXT | Creative Status Description (Deprecated) | Creative Status Description |
| creative_tagline | TEXT | Creative Tagline | Creative Tagline |
| creative_updated_at | Creative Updated At (Deprecated) | Creative Updated At |
StackAdapt other fields
The StackAdapt connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | 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 | 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 |