Hivestack predefined reports
The HiveStack data source in Data Integration comes with the predefined reports. Each report will have a short description of the data, a list of customizable fields (if any), and the schema mapping.
Since these reports follow a standardized format, a few fields are locked, and you can only access them through the Custom reports feature.
HiveStack does not have source-level selections 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 definitions
The Report definitions report returns the report definitions associated with 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 line items 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 |
