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 |
|---|---|---|---|
| atos | NUMERIC | Atos | Atos |
| campaign | TEXT | Campaign | Alias for Campaign Name |
| campaign_advertiser_id | NUMERIC | Campaign Advertiser Id | Campaign Advertiser Id |
| campaign_allow_iframe_engagement | NUMERIC | Campaign Allow Iframe Engagement | Campaign Allow Iframe Engagement |
| campaign_bid_amount_total | NUMERIC | Campaign Bid Amount Total | Campaign Bid Amount Total |
| campaign_bid_type | TEXT | Campaign Bid Type | Campaign Bid Type |
| campaign_budget | NUMERIC | Campaign Budget | Campaign Budget |
| campaign_city_options | TEXT | Campaign City Options | Campaign City Options |
| campaign_daily_cap | TEXT | Campaign Daily Cap | Campaign Daily Cap |
| campaign_domain_action | TEXT | Campaign Domain Action | Campaign Domain Action |
| campaign_end_date | DATE | Campaign End Date | Campaign End Date |
| campaign_engagement_tracking_type | NUMERIC | Campaign Engagement Tracking Type | Campaign Engagement Tracking Type |
| campaign_freq_cap_limit | NUMERIC | Campaign Freq Cap Limit | Campaign Freq Cap Limit |
| campaign_freq_cap_time | NUMERIC | Campaign Freq Cap Time | Campaign Freq Cap Time |
| campaign_goal | TEXT | Campaign Goal | Campaign Goal |
| campaign_id | TEXT | Campaign Id | Campaign Id |
| campaign_is_deal_id_strict | NUMERIC | Campaign Is Deal Id Strict | Campaign Is Deal Id Strict |
| campaign_line_item_id | NUMERIC | Campaign Group Id | Campaign Group Id |
| campaign_name | TEXT | Campaign Name | Campaign Name |
| campaign_optimize_type | TEXT | Campaign Optimize Type | Campaign Optimize Type |
| campaign_optimize_value | NUMERIC | Campaign Optimize Value | Campaign Optimize Value |
| campaign_pace_evenly | NUMERIC | Campaign Pace Evenly | Campaign Pace Evenly |
| campaign_start_date | DATE | Campaign Start Date | Campaign Start Date |
| campaign_state | TEXT | Campaign State | Campaign State |
| campaign_type | TEXT | Campaign Type | Campaign Type |
| campaign_use_dma | NUMERIC | Campaign Use Dma | Campaign Use Dma |
| campaign_weekday_enabled | NUMERIC | Campaign Weekday Enabled | Campaign Weekday Enabled |
| clicks | NUMERIC | Clicks | Clicks |
| conversions | NUMERIC | Conversions | Conversions |
| cost | NUMERIC | Cost | Cost |
| ctr | PERCENT | Ctr | Click-through rate |
| cvr | NUMERIC | Cvr | Conversion rate |
| date | DATE | Date | Date |
| 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 |
| impressions | NUMERIC | Impressions | Impressions |
| spend | NUMERIC | Spend | Alias for Cost |
| stats_conv_imp_derived | NUMERIC | Conversion Impression Derived | Conversion Impression Derived |
| stats_page_time | NUMERIC | Page Time | Page Time |
| stats_page_time_15s | NUMERIC | Page Time 15s | Page Time 15s |
| stats_unique_imp_inverse_rate | NUMERIC | Unique Impressions Inverse Rate | Unique Impressions Inverse Rate |
| stats_view_percent | PERCENT | View Percent | View Percent |
| totalcost | NUMERIC | Total Cost | Alias for Cost |
| unique_conversions | NUMERIC | Unique Conversions | Unique Conversions |
| unique_impressions | NUMERIC | Unique Impressions | Unique Impressions |