Product guides

Snowflake Data Fields

Suggest Edits

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.
  • mediaguard_postbid, which includes post-bid FraudSensor data.

📘

Note

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

MediaGuard (pre-bid) fields

  • 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 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 categorized as General IVT (GIVT).
  • IP Address: The IP address where the ad impression (and HUMAN's detection tag) is intended to be delivered.
  • IVT - Automated Browsing (ivt_bot_category_ab): Invalid requests driven by automated programs or scripts that did not declare themselves as crawlers.
  • IVT - Data Center (ivt_bot_category_dc): Invalid requests originating from data center IPs linked to invalid activity.
  • IVT - False Representation (ivt_bot_category_fr): Invalid requests where requested content differed from actual content supplied.
  • IVT - Irregular Pattern (ivt_bot_category_fr): Invalid requests associated with irregular, nonhuman behavior.
  • IVT - Known Crawler (ivt_bot_category_kc): Invalid requests driven by non-malicious automated scripts declaring themselves as nonhuman.
  • IVT - Misleading User Interface (ivt_bot_category_mui): Requests resulting from interfaces falsely including ads in unintended locations.
  • IVT - Undisclosed Classification (ivt_bot_category_uc): Invalid requests that could not be classified into other categories.
  • IVT Categories (ivt_bot_category, ivt_bot_category_str): IVT categories associated with the request.
  • IVT Sub Categories (ivt_bot_subcategory, ivt_bot_subcategory_str): IVT subcategories associated with the request.
  • Media Type (media_type): Media type as provided in your request to MediaGuard.
  • Publisher ID (publisher_id): Publisher ID as provided in your request to MediaGuard.
  • SIVT (sivt_bots): Number of bid requests identified as Sophisticated IVT (SIVT).
  • Supplier ID (supplier_id): Supplier ID as provided in your request to MediaGuard.
  • Timestamp (timestamp): Date and time the request was recorded by HUMAN.
  • Total Requests (requests): Total number of bid requests.
  • User Agent: User agent of the user who drove the request.
  • Valid Requests (valid_requests): Number of valid bid requests.

FraudSensor (post-bid) fields

  • App Mismatch (app_mismatch): Indicates a mismatch between the app ID reported by the device and the actual app ID detected (for in-app mobile environments only).
  • Bot (bot): Indicates if the impression was identified as invalid traffic (IVT).
  • Context (st_ad_context): Context of the ad delivery (e.g., web, in-app).
  • Country (country): Country where the impression originated.
  • Customer ID (customer_id): Unique identifier associated with your HUMAN account.
  • Customer Tag (ct): Parameters passed to HUMAN’s detection tag.
  • Ad ID/Placement ID (pi): Unique identifier for the digital advertisement.
  • Advertiser (ai): Advertiser or brand running the ad campaign.
  • Buy Type (bt): Indicates if the ad was purchased programmatically or directly.
  • Campaign ID (ac): Unique identifier for tracking the campaign.
  • Custom Fields (c1 - c10): Custom parameters passed to HUMAN’s tag.
  • Dimensions (dm): Ad creative dimensions (width x height, in pixels).
  • Domain Intended (di): Domain where the ad was intended to be delivered.
  • Prevention ID (pv): Corresponding MediaGuard prevention ID.
  • Publisher ID (pp): Publisher of the traffic source.
  • Reporting Fields (r1 - r10): Custom data for reporting via HUMAN’s Reporting API.
  • Supplier ID (sr): Supplier domain of the traffic source.
  • Tag ID (dt): Identifier of the detection tag that detected the impression.
  • Transaction ID (ti): Unique identifier for each impression.
  • Detected App ID (detected_app_id): Detected app bundle for the ad delivery (in-app mobile environments only).
  • Device Type (st_device): Software/device type (e.g., Android, Roku).
  • Domain Mismatch (mismatch): Indicates a mismatch between the Intended Domain and True Domain fields.
  • Href Domain (href_domain): Domain of the page or iframe where the impression occurred.
  • Href URL Parameters (href_fields): URL query parameters attached to the page URL.
  • Page (page): Webpage where the impression occurred.
  • Referring Domain (ref_domain): Domain referring the user to the impression site.
  • True Domain (true_domain): Domain where HUMAN's detection tag was attached.
  • Environment (environment): Environment of ad delivery (mobile web, desktop).
  • Event Type (event_type_str): Detected event type (impression or click).
  • GIVT (givt): Indicates if the impression was identified as General IVT (GIVT).
  • Href URL (href_url): Full URL of the page or iframe where the impression occurred.
  • IVT Categories (ivt_bot_category_str): IVT categories associated with the impression.
  • IVT Sub Categories (ivt_bot_subcategory, ivt_bot_subcategory_str): IVT subcategories associated with the request.
  • Media Type (st_media_type): Media type of the inventory (e.g., banner, video).
  • OS Name (ua_os_name): Operating system of the delivery device.
  • Platform Type (platform): Platform type (e.g., desktop, mobile).
  • Session ID (session_id): Unique identifier for each event.
  • SIVT (sivt): Indicates if the impression was identified as Sophisticated IVT (SIVT).
  • SSAI (is_ssai): Indicates if the ad was delivered via server-side ad insertion.
  • Surface (st_surface): Device category (e.g., mobile, desktop).
  • Tag Type (tag_type): Type of FraudSensor tag that detected the event.
  • Timestamp (timestamp): Date and time the impression was recorded.
  • UTM Campaign (utm_campaign): UTM campaign parameter from the impression URL.
  • UTM Content (utm_content): UTM content parameter from the impression URL.
  • UTM Medium (utm_medium): UTM medium parameter from the impression URL.
  • UTM Source (utm_source): UTM source parameter from the impression URL.
  • UTM Term (utm_term): UTM term parameter from the impression URL.

Updated 13 days ago