StackAdapt Predefined Reports
  • 6 Minutes to read
  • Dark
    Light
  • PDF

StackAdapt Predefined Reports

  • Dark
    Light
  • PDF

Article summary

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

FieldData TypeDimension/Metric
campaign_id system schemaIntegerDimension
acomp_0IntegerMetric
acomp_50IntegerMetric
acomp_75IntegerMetric
acomp_95IntegerMetric
atosStringDimension
avg_time_on_site_unitsStringDimension
campaignStringDimension
acomp_25IntegerMetric
campaign_typeStringDimension
clickIntegerMetric
convIntegerMetric
conv_clickIntegerMetric
conv_cookieIntegerMetric
conv_imp_derivedIntegerMetric
conv_imp_time_avgFloatMetric
conv_ipIntegerMetric
conv_revStringDimension
costFloatMetric
ctrFloatMetric
cvrStringDimension
ecpaFloatMetric
ecpcStringDimension
ecpclStringDimension
ecpeStringDimension
ecpmFloatMetric
ecpvFloatMetric
engage_rateStringDimension
impFloatMetric
line_itemStringDimension
ltrStringDimension
merged_segmentsStringDimension
page_startIntegerMetric
page_timeIntegerMetric
page_time_15sIntegerMetric
roasFloatMetric
s_convIntegerMetric
sub_advertiserStringDimension
time_on_siteIntegerMetric
total_time_unitsIntegerMetric
vcomp_0IntegerMetric
vcomp_25IntegerMetric
vcomp_50IntegerMetric
vcomp_75IntegerMetric
vcomp_95IntegerMetric
vcomp_rateFloatMetric
view_percentStringDimension

Conversion Trackers

FieldData TypeDimension/Metric
id system schemaIntegerDimension
conv_typeStringDimension
count_typeStringDimension
descriptionStringDimension
nameStringDimension
post_timeIntegerMetric
user_idIntegerDimension

Line Items

FieldData TypeDimension/Metric
id system schemaIntegerDimension
advertiser_idIntegerDimension
black_list_optionsStringDimension
budgetFloatMetric
daily_capStringDimension
end_dateStringDimension
all_campaign_idsIntegerMetric
nameStringDimension
pace_evenlyBooleanDimension
purchase_order_numberStringDimension
revenue_typeStringDimension
revenue_valueFloatMetric
start_dateStringDimension
stateStringDimension

Native Ads

FieldData TypeDimension/Metric
id system schemaIntegerDimension
advertiser_idIntegerDimension
allow_iframe_engagementStringDimension
audit_statusStringDimension
bid_amount_totalFloatMetric
bid_typeStringDimension
brandnameStringDimension
budgetFloatMetric
campaign_typeStringDimension
canada_province_optionsStringDimension
channelStringDimension
city_optionsStringDimension
click_urlStringDimension
conversion_trackersRecordDimension
created_atStringDimension
creativesRecordDimension
cta_textStringDimension
custom_segments_listStringDimension
daily_capStringDimension
day_partRecordDimension
device_type_optionsStringDimension
domain_actionStringDimension
domain_optionsStringDimension
end_dateStringDimension
engagement_tracking_typeIntegerMetric
freq_cap_limitIntegerMetric
freq_cap_timeIntegerMetric
geo_radius_targetsRecordDimension
iconStringDimension
all_native_adsRecordDimension
input_dataRecordDimension
ip_optionsStringDimension
language_optionsStringDimension
line_item_idIntegerDimension
nameStringDimension
optimize_typeStringDimension
optimize_valueFloatMetric
pace_evenlyBooleanDimension
smart_targetingBooleanDimension
start_dateStringDimension
stateStringDimension
supply_source_optionsStringDimension
supply_type_optionsStringDimension
timezoneStringDimension
updated_atStringDimension
use_dmaBooleanDimension
weekday_enabledBooleanDimension

Advertisers

FieldData TypeDimension/Metric
id system schemaIntegerDimension
all_line_item_idsIntegerMetric
descriptionStringDimension
external_accessBooleanDimension
external_access_codeStringDimension
nameStringDimension

Campaign Demographics Stats

FieldData TypeDimension/Metric
campaign_id system schemaIntegerDimension
acomp_0IntegerMetric
acomp_50IntegerMetric
acomp_75IntegerMetric
acomp_95IntegerMetric
atosStringDimension
avg_time_on_site_unitsStringDimension
campaignStringDimension
acomp_25IntegerMetric
campaign_typeStringDimension
clickIntegerMetric
convIntegerMetric
conv_clickIntegerMetric
conv_cookieIntegerMetric
conv_imp_derivedIntegerMetric
conv_imp_time_avgFloatMetric
conv_ipIntegerMetric
conv_revStringDimension
costFloatMetric
ctrFloatMetric
cvrStringDimension
demographics_segmentStringDimension
ecpaFloatMetric
ecpcStringDimension
ecpclStringDimension
ecpeStringDimension
ecpmFloatMetric
ecpvFloatMetric
engage_rateStringDimension
impFloatMetric
line_itemStringDimension
ltrStringDimension
page_startIntegerMetric
page_timeIntegerMetric
page_time_15sIntegerMetric
roasFloatMetric
s_convIntegerMetric
sub_advertiserStringDimension
time_on_siteIntegerMetric
total_time_unitsIntegerMetric
vcomp_0IntegerMetric
vcomp_25IntegerMetric
vcomp_50IntegerMetric
vcomp_75IntegerMetric
vcomp_95IntegerMetric
vcomp_rateFloatMetric
view_percentStringDimension

Campaign Total Stats

FieldData TypeDimension/Metric
campaign_id system schemaIntegerDimension
atosIntegerMetric
campaignStringDimension
atos_unitsIntegerMetric
clickIntegerMetric
convIntegerMetric
conv_imp_derivedIntegerMetric
conv_imp_time_avgIntegerMetric
conv_ipIntegerMetric
costFloatMetric
ctrIntegerMetric
cvrIntegerMetric
ecpaFloatMetric
ecpcIntegerMetric
ecpclIntegerMetric
ecpeIntegerMetric
ecpmFloatMetric
ecpvFloatMetric
impIntegerMetric
ltrIntegerMetric
page_startIntegerMetric
page_timeIntegerMetric
page_time_unitsIntegerMetric
profitFloatMetric
rcpcIntegerMetric
rcpeIntegerMetric
rcpmFloatMetric
revenueFloatMetric
s_convIntegerMetric
tp_cpc_costIntegerMetric
tp_cpm_costIntegerMetric
uniq_convIntegerMetric
unique_impIntegerMetric
unique_imp_inverse_rateFloatMetric
vcomp_0IntegerMetric
vcomp_25IntegerMetric
vcomp_50IntegerMetric
vcomp_75IntegerMetric
vcomp_95IntegerMetric
vcomp_rateFloatMetric

Campaigns

FieldData TypeDimension/Metric
id system schemaIntegerDimension
advertiser_idIntegerDimension
allow_iframe_engagementStringDimension
bid_amount_totalFloatMetric
bid_typeStringDimension
budgetFloatMetric
campaign_typeStringDimension
canada_province_optionsStringDimension
channelStringDimension
city_optionsStringDimension
conversion_trackersRecordDimension
created_atStringDimension
custom_segments_listStringDimension
daily_capStringDimension
day_partRecordDimension
device_type_optionsStringDimension
domain_actionStringDimension
domain_optionsStringDimension
end_dateStringDimension
engagement_tracking_typeIntegerMetric
freq_cap_limitIntegerMetric
freq_cap_timeIntegerMetric
geo_radius_targetsRecordDimension
all_native_adsRecordDimension
ip_optionsStringDimension
language_optionsStringDimension
line_item_idIntegerDimension
nameStringDimension
optimize_typeStringDimension
optimize_valueFloatMetric
pace_evenlyBooleanDimension
smart_targetingBooleanDimension
start_dateStringDimension
stateStringDimension
supply_source_optionsStringDimension
supply_type_optionsStringDimension
timezoneStringDimension
updated_atStringDimension
use_dmaBooleanDimension
weekday_enabledBooleanDimension

Line Items Geos Stats

FieldData TypeDimension/Metric
line_item_id system schemaIntegerDimension
acomp_0IntegerMetric
acomp_50IntegerMetric
acomp_75IntegerMetric
acomp_95IntegerMetric
atosStringDimension
avg_time_on_site_unitsStringDimension
clickIntegerMetric
convIntegerMetric
conv_clickIntegerMetric
conv_cookieIntegerMetric
conv_imp_derivedIntegerMetric
conv_imp_time_avgFloatMetric
conv_ipIntegerMetric
conv_revFloatMetric
costFloatMetric
countryStringDimension
ctrFloatMetric
acomp_25IntegerMetric
ecpaFloatMetric
ecpcStringDimension
ecpclStringDimension
ecpeStringDimension
cvrStringDimension
ecpvFloatMetric
engage_rateStringDimension
impIntegerMetric
line_itemStringDimension
ecpmFloatMetric
ltrStringDimension
page_startIntegerMetric
page_timeIntegerMetric
page_time_15sIntegerMetric
regionStringDimension
roasFloatMetric
s_convIntegerMetric
sub_advertiserStringDimension
time_on_siteIntegerMetric
total_time_unitsIntegerMetric
vcomp_0IntegerMetric
vcomp_25IntegerMetric
vcomp_50IntegerMetric
vcomp_75IntegerMetric
vcomp_95IntegerMetric
vcomp_rateFloatMetric
view_percentStringDimension

Line Items Total Stats

FieldData TypeDimension/Metric
line_item_id system schemaIntegerDimension
atosIntegerMetric
clickIntegerMetric
convIntegerMetric
conv_imp_time_avgIntegerMetric
conv_ipIntegerMetric
costFloatMetric
ctrIntegerMetric
cvrIntegerMetric
ecpaFloatMetric
ecpcIntegerMetric
ecpclIntegerMetric
ecpeIntegerMetric
ecpmFloatMetric
ecpvFloatMetric
impIntegerMetric
line_itemStringDimension
atos_unitsIntegerMetric
ltrIntegerMetric
page_timeIntegerMetric
page_time_unitsIntegerMetric
profitFloatMetric
rcpcIntegerMetric
rcpeIntegerMetric
rcpmFloatMetric
rcpvFloatMetric
revenueFloatMetric
s_convIntegerMetric
tp_cpc_costIntegerMetric
tp_cpm_costIntegerMetric
uniq_convIntegerMetric
uniq_ecpaFloatMetric
unique_impIntegerMetric
unique_imp_inverse_rateFloatMetric
vcomp_0IntegerMetric
vcomp_25IntegerMetric
vcomp_50IntegerMetric
vcomp_75IntegerMetric
vcomp_95IntegerMetric
vcomp_rateFloatMetric

Native Ad Total Stats

FieldData TypeDimension/Metric
native_ad_id system schemaIntegerDimension
atosIntegerMetric
clickIntegerMetric
convIntegerMetric
conv_imp_derivedIntegerMetric
conv_imp_time_avgIntegerMetric
conv_ipIntegerMetric
costFloatMetric
ctrIntegerMetric
cvrIntegerMetric
ecpaFloatMetric
ecpcIntegerMetric
ecpclIntegerMetric
ecpeIntegerMetric
ecpmFloatMetric
ecpvFloatMetric
impIntegerMetric
ltrIntegerMetric
native_adStringDimension
atos_unitsIntegerMetric
page_startIntegerMetric
page_timeIntegerMetric
page_time_unitsIntegerMetric
profitFloatMetric
rcpcIntegerMetric
rcpeIntegerMetric
rcpmFloatMetric
revenueFloatMetric
s_convIntegerMetric
tp_cpc_costIntegerMetric
tp_cpm_costIntegerMetric
uniq_convIntegerMetric
unique_impIntegerMetric
unique_imp_inverse_rateFloatMetric
vcomp_0IntegerMetric
vcomp_25IntegerMetric
vcomp_50IntegerMetric
vcomp_75IntegerMetric
vcomp_95IntegerMetric
vcomp_rateFloatMetric

Was this article helpful?