Hivestack Predefined Reports

Predefined Reports

The HiveStack 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.

Source-Level Selections

HiveStack does not have any source-level selections available to filter each report in the river.

Demographics

The Demographics report returns a list of demographics that belong to the account's organization.

Field	Data Type	Dimension/Metric
demographic_id	Integer	Dimension
code	String	Dimension
created_on_utc	String	Dimension
modified_on_utc	String	Dimension
name	String	Dimension
organization_id	Integer	Dimension
show_buyers	Boolean	Dimension
type	String	Dimension

Languages

The Languages report returns a list of languages within the account.

Field	Data Type	Dimension/Metric
language_id	Integer	Dimension
code	String	Dimension
name	String	Dimension

Networks

The Networks report returns a list of networks that belong to the account's organization.

Field	Data Type	Dimension/Metric
network_id	Integer	Dimension
code	String	Dimension
created_on_utc	String	Dimension
modified_on_utc	String	Dimension
name	String	Dimension
owner_id	Integer	Dimension

Report Defenitions

The Report Definitions report returns the report definitions associated to the account's organization.

Field	Data Type	Dimension/Metric
report_definition_id	Integer	Dimension
definition_json	Record	Dimension
exchange_id	String	Dimension
last_executed_on_utc	String	Dimension
name	String	Dimension
organization_id	Integer	Dimension

Sites

The Sites report returns a list of sites targeted by lineitems also targeting this event with their current event status. The current event status can be true, false or null if the value is not defined.

Field	Data Type	Dimension/Metric
site_id	Integer	Dimension
uuid	String	Dimension
active	Boolean	Dimension
created_on_utc	String	Dimension
description	String	Dimension
external_id	String	Dimension
longitude	Float	Metric
modified_on_utc	String	Dimension
name	String	Dimension
owner_id	Integer	Dimension
latitude	Float	Metric
location_id	Integer	Dimension

Unit Languages

The Unit Languages report returns a list of allowed languages per unit for the account's organization.

Field	Data Type	Dimension/Metric
unitlanguage_id	Integer	Dimension
created_on_utc	String	Dimension
language_id	Integer	Dimension
modified_on_utc	String	Dimension
unit_id	Integer	Dimension

Units

The Units report returns a list of units that belong to the account's organization.

Field	Data Type	Dimension/Metric
unit_id	Integer	Dimension
uuid	String	Dimension
allow_flash	Boolean	Dimension
allow_video	Boolean	Dimension
available_for_adserver	Boolean	Dimension
available_for_deals	Boolean	Dimension
available_for_open_exchange	Boolean	Dimension
available_for_storefront	Boolean	Dimension
created_on_utc	String	Dimension
description	String	Dimension
enable_strict_iab_blacklisting	Boolean	Dimension
enable_strict_iab_frequency_capping	Boolean	Dimension
external_id	String	Dimension
facing_direction	String	Dimension
floor_cpm	Float	Metric
image_uri	String	Dimension
latitude	Float	Metric
location_id	Integer	Dimension
longitude	Float	Metric
loop_length	Integer	Metric
max_spot_length	Integer	Metric
mediatype_id	Integer	Dimension
min_seconds_between_ad_domain_plays	Integer	Metric
min_seconds_between_creative_category_plays	Integer	Metric
min_seconds_between_iab_category_plays	Integer	Metric
min_spot_length	Integer	Metric
modified_on_utc	String	Dimension
name	String	Dimension
network_id	Integer	Dimension
operating_hours	String	Dimension
owner_id	Integer	Dimension
physical_screen_height_cm	Integer	Metric
physical_screen_width_cm	Integer	Metric
screen_height	Integer	Metric
screen_width	Integer	Metric
site_id	Integer	Dimension
spot_length	Integer	Metric
timezone	String	Dimension
allow_image	Boolean	Dimension
allow_html	Boolean	Dimension
weekly_impressions	Integer	Metric

Accounts

The Accounts report returns a list of up to 100 accounts.

Field	Data Type	Dimension/Metric
account_id	Integer	Dimension
external_id	String	Dimension
logo_url	String	Dimension
name	String	Dimension
organization_id	Integer	Dimension

Campaigns

The Campaigns report returns a list of up to 100 campaigns in the account's organization.

Field	Data Type	Dimension/Metric
campaign_id	Integer	Dimension
account	Record	Dimension
advertiser	Record	Dimension
advertiser_id	Integer	Dimension
budget_cap	Float	Metric
account_id	Integer	Dimension
created_on_utc	String	Dimension
end_date	String	Dimension
min_seconds_between_plays	Integer	Metric
modified_on_utc	String	Dimension
name	String	Dimension
notes	String	Dimension
organization_id	Integer	Dimension
priority	String	Dimension
start_date	String	Dimension

Line Items

The Line Items report returns a list of up to 20 line items.

Field	Data Type	Dimension/Metric
lineitem_id	Integer	Dimension
ad_duration	Integer	Metric
budget_mode	String	Dimension
campaign_id	Integer	Dimension
cancelled_at	String	Dimension
cpm_net	Record	Dimension
created_at	String	Dimension
created_on_utc	String	Dimension
daypart	String	Dimension
delivery_curve	String	Dimension
external_id	String	Dimension
flight_from	String	Dimension
flight_to	String	Dimension
is_cpm_from_rate_card	Boolean	Dimension
budget	Float	Metric
market_targeted_impressions	Integer	Metric
max_bid_cpm	Float	Metric
mediaowner_ids	Integer	Metric
min_concentration_factor	Float	Metric
min_seconds_between_plays	Integer	Metric
modified_on_utc	String	Dimension
name	String	Dimension
notes	String	Dimension
priority	Integer	Metric
purchase_type	String	Dimension
run_state	String	Dimension
state	String	Dimension
submitted_at	String	Dimension
unit_ids	Integer	Metric

Locations

The Locations report returns a list of locations.

Field	Data Type	Dimension/Metric
location_id	Integer	Dimension
code	String	Dimension
country_id	Integer	Dimension
latitude	String	Dimension
level	Integer	Metric
longitude	String	Dimension
name	String	Dimension
region_id	Integer	Dimension

Advertisers

The Advertisers report returns a list of up to 100 advertisers.

Field	Data Type	Dimension/Metric
advertiser_id	Integer	Dimension
created_on_utc	String	Dimension
external_id	String	Dimension
modified_on_utc	String	Dimension
name	String	Dimension
organization_id	Integer	Dimension
unique_advertiser	Record	Dimension