StackAdapt predefined reports
The StackAdapt data source in Data Integration includes predefined reports. Each report consists of a short description of the data, a list of customizable fields (if any), and the schema mapping.
These reports follow a standardized format, so specific fields are locked, and you can only access them through the Custom reports feature.
Campaign audience stats
| Field | Data Type | Dimension/Metric |
|---|---|---|
| campaign_id | Integer | Dimension |
| acomp_0 | Integer | Metric |
| acomp_50 | Integer | Metric |
| acomp_75 | Integer | Metric |
| acomp_95 | Integer | Metric |
| atos | String | Dimension |
| avg_time_on_site_units | String | Dimension |
| campaign | String | Dimension |
| acomp_25 | Integer | Metric |
| campaign_type | String | Dimension |
| click | Integer | Metric |
| conv | Integer | Metric |
| conv_click | Integer | Metric |
| conv_cookie | Integer | Metric |
| conv_imp_derived | Integer | Metric |
| conv_imp_time_avg | Float | Metric |
| conv_ip | Integer | Metric |
| conv_rev | String | Dimension |
| cost | Float | Metric |
| ctr | Float | Metric |
| cvr | String | Dimension |
| ecpa | Float | Metric |
| ecpc | String | Dimension |
| ecpcl | String | Dimension |
| ecpe | String | Dimension |
| ecpm | Float | Metric |
| ecpv | Float | Metric |
| engage_rate | String | Dimension |
| imp | Float | Metric |
| line_item | String | Dimension |
| ltr | String | Dimension |
| merged_segments | String | Dimension |
| page_start | Integer | Metric |
| page_time | Integer | Metric |
| page_time_15s | Integer | Metric |
| roas | Float | Metric |
| s_conv | Integer | Metric |
| sub_advertiser | String | Dimension |
| time_on_site | Integer | Metric |
| total_time_units | Integer | Metric |
| vcomp_0 | Integer | Metric |
| vcomp_25 | Integer | Metric |
| vcomp_50 | Integer | Metric |
| vcomp_75 | Integer | Metric |
| vcomp_95 | Integer | Metric |
| vcomp_rate | Float | Metric |
| view_percent | String | Dimension |
Conversion trackers
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | Integer | Dimension |
| conv_type | String | Dimension |
| count_type | String | Dimension |
| description | String | Dimension |
| name | String | Dimension |
| post_time | Integer | Metric |
| user_id | Integer | Dimension |
Line items
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | Integer | Dimension |
| advertiser_id | Integer | Dimension |
| black_list_options | String | Dimension |
| budget | Float | Metric |
| daily_cap | String | Dimension |
| end_date | String | Dimension |
| all_campaign_ids | Integer | Metric |
| name | String | Dimension |
| pace_evenly | Boolean | Dimension |
| purchase_order_number | String | Dimension |
| revenue_type | String | Dimension |
| revenue_value | Float | Metric |
| start_date | String | Dimension |
| state | String | Dimension |
Native ads
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | Integer | Dimension |
| advertiser_id | Integer | Dimension |
| allow_iframe_engagement | String | Dimension |
| audit_status | String | Dimension |
| bid_amount_total | Float | Metric |
| bid_type | String | Dimension |
| brandname | String | Dimension |
| budget | Float | Metric |
| campaign_type | String | Dimension |
| canada_province_options | String | Dimension |
| channel | String | Dimension |
| city_options | String | Dimension |
| click_url | String | Dimension |
| conversion_trackers | Record | Dimension |
| created_at | String | Dimension |
| creatives | Record | Dimension |
| cta_text | String | Dimension |
| custom_segments_list | String | Dimension |
| daily_cap | String | Dimension |
| day_part | Record | Dimension |
| device_type_options | String | Dimension |
| domain_action | String | Dimension |
| domain_options | String | Dimension |
| end_date | String | Dimension |
| engagement_tracking_type | Integer | Metric |
| freq_cap_limit | Integer | Metric |
| freq_cap_time | Integer | Metric |
| geo_radius_targets | Record | Dimension |
| icon | String | Dimension |
| all_native_ads | Record | Dimension |
| input_data | Record | Dimension |
| ip_options | String | Dimension |
| language_options | String | Dimension |
| line_item_id | Integer | Dimension |
| name | String | Dimension |
| optimize_type | String | Dimension |
| optimize_value | Float | Metric |
| pace_evenly | Boolean | Dimension |
| smart_targeting | Boolean | Dimension |
| start_date | String | Dimension |
| state | String | Dimension |
| supply_source_options | String | Dimension |
| supply_type_options | String | Dimension |
| timezone | String | Dimension |
| updated_at | String | Dimension |
| use_dma | Boolean | Dimension |
| weekday_enabled | Boolean | Dimension |
Advertisers
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | Integer | Dimension |
| all_line_item_ids | Integer | Metric |
| description | String | Dimension |
| external_access | Boolean | Dimension |
| external_access_code | String | Dimension |
| name | String | Dimension |
Campaign demographics stats
| Field | Data Type | Dimension/Metric |
|---|---|---|
| campaign_id | Integer | Dimension |
| acomp_0 | Integer | Metric |
| acomp_50 | Integer | Metric |
| acomp_75 | Integer | Metric |
| acomp_95 | Integer | Metric |
| atos | String | Dimension |
| avg_time_on_site_units | String | Dimension |
| campaign | String | Dimension |
| acomp_25 | Integer | Metric |
| campaign_type | String | Dimension |
| click | Integer | Metric |
| conv | Integer | Metric |
| conv_click | Integer | Metric |
| conv_cookie | Integer | Metric |
| conv_imp_derived | Integer | Metric |
| conv_imp_time_avg | Float | Metric |
| conv_ip | Integer | Metric |
| conv_rev | String | Dimension |
| cost | Float | Metric |
| ctr | Float | Metric |
| cvr | String | Dimension |
| demographics_segment | String | Dimension |
| ecpa | Float | Metric |
| ecpc | String | Dimension |
| ecpcl | String | Dimension |
| ecpe | String | Dimension |
| ecpm | Float | Metric |
| ecpv | Float | Metric |
| engage_rate | String | Dimension |
| imp | Float | Metric |
| line_item | String | Dimension |
| ltr | String | Dimension |
| page_start | Integer | Metric |
| page_time | Integer | Metric |
| page_time_15s | Integer | Metric |
| roas | Float | Metric |
| s_conv | Integer | Metric |
| sub_advertiser | String | Dimension |
| time_on_site | Integer | Metric |
| total_time_units | Integer | Metric |
| vcomp_0 | Integer | Metric |
| vcomp_25 | Integer | Metric |
| vcomp_50 | Integer | Metric |
| vcomp_75 | Integer | Metric |
| vcomp_95 | Integer | Metric |
| vcomp_rate | Float | Metric |
| view_percent | String | Dimension |
Campaign total stats
| Field | Data Type | Dimension/Metric |
|---|---|---|
| campaign_id | Integer | Dimension |
| atos | Integer | Metric |
| campaign | String | Dimension |
| atos_units | Integer | Metric |
| click | Integer | Metric |
| conv | Integer | Metric |
| conv_imp_derived | Integer | Metric |
| conv_imp_time_avg | Integer | Metric |
| conv_ip | Integer | Metric |
| cost | Float | Metric |
| ctr | Integer | Metric |
| cvr | Integer | Metric |
| ecpa | Float | Metric |
| ecpc | Integer | Metric |
| ecpcl | Integer | Metric |
| ecpe | Integer | Metric |
| ecpm | Float | Metric |
| ecpv | Float | Metric |
| imp | Integer | Metric |
| ltr | Integer | Metric |
| page_start | Integer | Metric |
| page_time | Integer | Metric |
| page_time_units | Integer | Metric |
| profit | Float | Metric |
| rcpc | Integer | Metric |
| rcpe | Integer | Metric |
| rcpm | Float | Metric |
| revenue | Float | Metric |
| s_conv | Integer | Metric |
| tp_cpc_cost | Integer | Metric |
| tp_cpm_cost | Integer | Metric |
| uniq_conv | Integer | Metric |
| unique_imp | Integer | Metric |
| unique_imp_inverse_rate | Float | Metric |
| vcomp_0 | Integer | Metric |
| vcomp_25 | Integer | Metric |
| vcomp_50 | Integer | Metric |
| vcomp_75 | Integer | Metric |
| vcomp_95 | Integer | Metric |
| vcomp_rate | Float | Metric |
Campaigns
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | Integer | Dimension |
| advertiser_id | Integer | Dimension |
| allow_iframe_engagement | String | Dimension |
| bid_amount_total | Float | Metric |
| bid_type | String | Dimension |
| budget | Float | Metric |
| campaign_type | String | Dimension |
| canada_province_options | String | Dimension |
| channel | String | Dimension |
| city_options | String | Dimension |
| conversion_trackers | Record | Dimension |
| created_at | String | Dimension |
| custom_segments_list | String | Dimension |
| daily_cap | String | Dimension |
| day_part | Record | Dimension |
| device_type_options | String | Dimension |
| domain_action | String | Dimension |
| domain_options | String | Dimension |
| end_date | String | Dimension |
| engagement_tracking_type | Integer | Metric |
| freq_cap_limit | Integer | Metric |
| freq_cap_time | Integer | Metric |
| geo_radius_targets | Record | Dimension |
| all_native_ads | Record | Dimension |
| ip_options | String | Dimension |
| language_options | String | Dimension |
| line_item_id | Integer | Dimension |
| name | String | Dimension |
| optimize_type | String | Dimension |
| optimize_value | Float | Metric |
| pace_evenly | Boolean | Dimension |
| smart_targeting | Boolean | Dimension |
| start_date | String | Dimension |
| state | String | Dimension |
| supply_source_options | String | Dimension |
| supply_type_options | String | Dimension |
| timezone | String | Dimension |
| updated_at | String | Dimension |
| use_dma | Boolean | Dimension |
| weekday_enabled | Boolean | Dimension |
Line items geos stats
| Field | Data Type | Dimension/Metric |
|---|---|---|
| line_item_id | Integer | Dimension |
| acomp_0 | Integer | Metric |
| acomp_50 | Integer | Metric |
| acomp_75 | Integer | Metric |
| acomp_95 | Integer | Metric |
| atos | String | Dimension |
| avg_time_on_site_units | String | Dimension |
| click | Integer | Metric |
| conv | Integer | Metric |
| conv_click | Integer | Metric |
| conv_cookie | Integer | Metric |
| conv_imp_derived | Integer | Metric |
| conv_imp_time_avg | Float | Metric |
| conv_ip | Integer | Metric |
| conv_rev | Float | Metric |
| cost | Float | Metric |
| country | String | Dimension |
| ctr | Float | Metric |
| acomp_25 | Integer | Metric |
| ecpa | Float | Metric |
| ecpc | String | Dimension |
| ecpcl | String | Dimension |
| ecpe | String | Dimension |
| cvr | String | Dimension |
| ecpv | Float | Metric |
| engage_rate | String | Dimension |
| imp | Integer | Metric |
| line_item | String | Dimension |
| ecpm | Float | Metric |
| ltr | String | Dimension |
| page_start | Integer | Metric |
| page_time | Integer | Metric |
| page_time_15s | Integer | Metric |
| region | String | Dimension |
| roas | Float | Metric |
| s_conv | Integer | Metric |
| sub_advertiser | String | Dimension |
| time_on_site | Integer | Metric |
| total_time_units | Integer | Metric |
| vcomp_0 | Integer | Metric |
| vcomp_25 | Integer | Metric |
| vcomp_50 | Integer | Metric |
| vcomp_75 | Integer | Metric |
| vcomp_95 | Integer | Metric |
| vcomp_rate | Float | Metric |
| view_percent | String | Dimension |
Line items total stats
| Field | Data Type | Dimension/Metric |
|---|---|---|
| line_item_id | Integer | Dimension |
| atos | Integer | Metric |
| click | Integer | Metric |
| conv | Integer | Metric |
| conv_imp_time_avg | Integer | Metric |
| conv_ip | Integer | Metric |
| cost | Float | Metric |
| ctr | Integer | Metric |
| cvr | Integer | Metric |
| ecpa | Float | Metric |
| ecpc | Integer | Metric |
| ecpcl | Integer | Metric |
| ecpe | Integer | Metric |
| ecpm | Float | Metric |
| ecpv | Float | Metric |
| imp | Integer | Metric |
| line_item | String | Dimension |
| atos_units | Integer | Metric |
| ltr | Integer | Metric |
| page_time | Integer | Metric |
| page_time_units | Integer | Metric |
| profit | Float | Metric |
| rcpc | Integer | Metric |
| rcpe | Integer | Metric |
| rcpm | Float | Metric |
| rcpv | Float | Metric |
| revenue | Float | Metric |
| s_conv | Integer | Metric |
| tp_cpc_cost | Integer | Metric |
| tp_cpm_cost | Integer | Metric |
| uniq_conv | Integer | Metric |
| uniq_ecpa | Float | Metric |
| unique_imp | Integer | Metric |
| unique_imp_inverse_rate | Float | Metric |
| vcomp_0 | Integer | Metric |
| vcomp_25 | Integer | Metric |
| vcomp_50 | Integer | Metric |
| vcomp_75 | Integer | Metric |
| vcomp_95 | Integer | Metric |
| vcomp_rate | Float | Metric |
Native ad total stats
| Field | Data Type | Dimension/Metric |
|---|---|---|
| native_ad_id | Integer | Dimension |
| atos | Integer | Metric |
| click | Integer | Metric |
| conv | Integer | Metric |
| conv_imp_derived | Integer | Metric |
| conv_imp_time_avg | Integer | Metric |
| conv_ip | Integer | Metric |
| cost | Float | Metric |
| ctr | Integer | Metric |
| cvr | Integer | Metric |
| ecpa | Float | Metric |
| ecpc | Integer | Metric |
| ecpcl | Integer | Metric |
| ecpe | Integer | Metric |
| ecpm | Float | Metric |
| ecpv | Float | Metric |
| imp | Integer | Metric |
| ltr | Integer | Metric |
| native_ad | String | Dimension |
| atos_units | Integer | Metric |
| page_start | Integer | Metric |
| page_time | Integer | Metric |
| page_time_units | Integer | Metric |
| profit | Float | Metric |
| rcpc | Integer | Metric |
| rcpe | Integer | Metric |
| rcpm | Float | Metric |
| revenue | Float | Metric |
| s_conv | Integer | Metric |
| tp_cpc_cost | Integer | Metric |
| tp_cpm_cost | Integer | Metric |
| uniq_conv | Integer | Metric |
| unique_imp | Integer | Metric |
| unique_imp_inverse_rate | Float | Metric |
| vcomp_0 | Integer | Metric |
| vcomp_25 | Integer | Metric |
| vcomp_50 | Integer | Metric |
| vcomp_75 | Integer | Metric |
| vcomp_95 | Integer | Metric |
| vcomp_rate | Float | Metric |