Skip to main content

Snowflake Data Fields

After you've imported your HUMAN data into Snowflake, you'll be able to view the following data fields that correspond to each Snowflake view.

There are three Snowflake views available: mediaguard_prebid and mediaguard_prebid_sampled, which include pre-bid MediaGuard data, and mediguard_postbid, which includes post-bid FraudSensor data.

note

The mediaguard_prebid review pulls data from all MediaGuard requests during the selected time period, but the mediaguard_prebid_sampled view pulls data from a smaller subset of MediaGuard requests to provide more detailed information about a limited data pool. Certain pre-bid fields are only available for sampled data.

  • App ID (app_id): (sampled data only) The app bundle where the ad was intended to be delivered, as provided by the publisher (for in-app mobile environments only).
  • Bots (ivt_bots): The number of bid requests that were identified as invalid traffic (IVT).
  • Customer ID (customer_id): The unique identifier associated with your HUMAN account.
  • Device Type (device_type): The device type, as provided in your request to MediaGuard.
  • Domain (domain): (sampled data only) The domain where the ad is intended to be delivered.
  • GIVT (givt_bots): The number of bid requests that were categorized as General IVT (GIVT).
  • IVT - Automated Browsing (ivt_bot_category_ab): The number of invalid bid requests that were driven by automated programs or scripts that did not declare themselves as crawlers.
  • IVT - Data Center (ivt_bot_category_dc): The number of invalid bid requests that originated from servers in data centers whose IP addresses are linked to invalid activity.
  • IVT - False Representation (ivt_bot_category_fr): The number of invalid bid requests that requested content that differed from the actual content that was supplied.
  • IVT - Irregular Pattern (ivt_bot_category_fr): The number of invalid bid requests that were associated with patterns of irregular, nonhuman behavior.
  • IVT - Known Crawler (ivt_bot_category_kc): The number of invalid bid requests that were driven by non-malicious automated scripts that declare themselves as nonhuman through a variety of standard identification mechanisms.
  • IVT - Manipulated Behavior (ivt_bot_category_mb): The number of invalid bid requests that were driven by a browser, application, or other program that triggers ad interactions without a user’s consent.
  • IVT - Misleading User Interface (ivt_bot_category_mui):The number of invalid bid requests that resulted from a webpage, application, or other interface that was modified to falsely include one or more ads in an unintended location.
  • IVT - Undisclosed Classification (ivt_bot_category_uc):The number of invalid bid requests that could not be classified as any other categories listed here, or any invalid bid requests discovered used sensitive techniques that HUMAN cannot disclose.
  • IVT Categories (ivt_bot_category, ivt_bot_category_str): The IVT categories associated with the bid request.
  • Media Type (media_type): The media type, as provided in your request to MediaGuard.
  • Publisher ID (publisher_id): The publisher ID, as provided in your request to MediaGuard.
  • SIVT (sivt_bots): The number of bid requests that were identified as Sophisticated IVT (SIVT).
  • Supplier ID (supplier_id): The supplier ID, as provided in your request to MediaGuard.
  • Timestamp (timestamp): The date and time that HUMAN recorded the bid request.
  • Total Requests (requests): The total number of bid requests.
  • Valid Requests (valid_requests): The number of valid bid requests.