StackAdapt Predefined Reports

Predefined Reports

The StackAdapt datasource in Rivery comes with the below predefined reports. Each report will have a short description of the data, a list of customizable fields (if any), and the schema mapping. Due to the standardized nature of these reports, there are a number of locked fields that will only be accessible through the custom reporting functionality.

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