After you’ve imported your HUMAN data into Snowflake, you can view the data fields listed below, which correspond to each Snowflake view.
The following Snowflake views are available:
mediaguard_prebid and mediaguard_prebid_sampled, which include pre-bid MediaGuard data.mediaguard_postbid, which includes post-bid FraudSensor data.mediaguard_prebid_postbid_combined_global, which includes pre-bid MediaGuard and post-bid FraudSensor joined data. This view pulls data from a smaller subset of requests to provide more detailed information about a limited data pool. As a result, certain pre-bid fields are only available for this sampled data.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.
app_id): (sampled data only) App bundle where the ad was intended to be delivered, as provided by the publisher (for in-app mobile environments only).insights_removed_app_last_checked): (sampled data only) Date and time the app was last checked to be present at the relevant app store.insights_removed_app_last_found): (sampled data only) Date and time the app was last seen at the relevant app store.ivt_bots): Number of bid requests identified as invalid traffic (IVT).compact_schain): (sampled data only) SupplyChain Object provided in your request to MediaGuard, with optional fields removed.customer_id): Unique identifier associated with your HUMAN account.device_type): Device type as provided in your request to MediaGuard.domain): (sampled data only) Domain where the ad is intended to be delivered.givt_bots): Number of bid requests categorized as General IVT (GIVT).insights_high_incentivized_app): (sampled data only) App has a high level of traffic with incentivized IPs.insights_high_incentivized_site): (sampled data only) Site has a high level of traffic with incentivized IPs or UTMs.insights_high_paid_or_social_src_site): (sampled data only) Site has a high level of paid or social traffic sourcing.insights_high_paid_src_site): (sampled data only) Site has a high level of paid traffic sourcing.insights_high_social_src_site): (sampled data only) Site has a high level of social traffic sourcing.ip): IP address where the ad impression (and HUMAN’s detection tag) is intended to be delivered.ivt_bot_category_ab): Invalid requests driven by automated programs or scripts that didn’t declare themselves as crawlers.ivt_bot_category_dc): Invalid requests originating from data center IPs linked to invalid activity.ivt_bot_category_fr): Invalid requests where requested content differed from actual content supplied.ivt_bot_category_fr): Invalid requests associated with irregular, nonhuman behavior.ivt_bot_category_kc): Invalid requests driven by non-malicious automated scripts declaring themselves as nonhuman.ivt_bot_category_mui): Requests resulting from interfaces falsely including ads in unintended locations.ivt_bot_category_uc): Invalid requests that couldn’t be classified into other categories.ivt_bot_category, ivt_bot_category_str): IVT categories associated with the request.ivt_bot_subcategory, ivt_bot_subcategory_str): IVT subcategories associated with the request.media_type): Media type as provided in your request to MediaGuard.insights_mfa): (sampled data only) Domain or site show significant evidence of MFA. Set automatically or by manual review.insights_mfa_domain): (sampled data only) Domain shows significant evidence of MFA. Set automatically or by manual review.insights_mfa_flag_overridden_domain): (sampled data only) Domain flagged as MFA through automated indicators but overridden by manual review.insights_mfa_domain_indicators): (sampled data only) Indicators of MFA identified on this domain. “Manual Review” indicates the domain was manually reviewed by HUMAN and significant evidence of MFA was found.insights_mfa_flag_overridden): (sampled data only) Domain or site flagged as MFA through automated indicators but overridden by manual review.insights_mfa_site): (sampled data only) Site shows significant evidence of MFA. Set automatically or by manual review.insights_mfa_flag_overridden_site): (sampled data only) Site flagged as MFA through automated indicators but overridden by manual review.insights_mfa_site_indicators): (sampled data only) Indicators of MFA identified on this site. “Manual Review” indicates the site was manually reviewed by HUMAN and significant evidence of MFA was found.mg_givt): Boolean value that, when true, indicates that the request was identified as General IVT (GIVT).mg_ivt): Boolean value that, when true, indicates that the request was identified as invalid traffic (IVT).mg_device_id): The unique ID of the user’s device.publisher_id): Publisher ID as provided in your request to MediaGuard.insights_removed_app): (sampled data only) App removed from the relevant app store.schain): (sampled data only) SupplyChain object provided in your request to MediaGuard.sivt_bots): Number of bid requests identified as Sophisticated IVT (SIVT).supplier_id): Supplier ID as provided in your request to MediaGuard.timestamp): Date and time the request was recorded by HUMAN.requests): Total number of bid requests.user_agent) User agent of the user who drove the request.valid_requests): Number of valid bid requests.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): Indicates if the impression was identified as invalid traffic (IVT).st_ad_context): Context of the ad delivery (e.g., web, in-app).country): Country where the impression originated.customer_id): Unique identifier associated with your HUMAN account.ct): Parameters passed to HUMAN’s detection tag.pi): Unique identifier for the digital advertisement.ai): Advertiser or brand running the ad campaign.bt): Indicates if the ad was purchased programmatically or directly.ac): Unique identifier for tracking the campaign.c1 - c10): Custom parameters passed to HUMAN’s tag.dm): Ad creative dimensions (width x height, in pixels).di): Domain where the ad was intended to be delivered.pv): Corresponding MediaGuard prevention ID.pp): Publisher of the traffic source.r1 - r10): Custom data for reporting via HUMAN’s Reporting API.sr): Supplier domain of the traffic source.dt): Identifier of the detection tag that detected the impression.ti): Unique identifier for each impression.detected_app_id): Detected app bundle for the ad delivery (in-app mobile environments only).st_device): Software/device type (e.g., Android, Roku).mismatch): Indicates a mismatch between the Intended Domain and True Domain fields.fs_ivt): Boolean value that, when true, indicates that the impression was identified as invalid traffic (IVT).href_domain): Domain of the page or iframe where the impression occurred.href_fields): URL query parameters attached to the page URL.page): Webpage where the impression occurred.ref_domain): Domain referring the user to the impression site.true_domain): Domain where HUMAN’s detection tag was attached.environment): Environment of ad delivery (mobile web, desktop).event_type_str): Detected event type (impression or click).givt): Indicates if the impression was identified as General IVT (GIVT).href_url): Full URL of the page or iframe where the impression occurred.ivt_bot_category_str): IVT categories associated with the impression.ivt_bot_subcategory, ivt_bot_subcategory_str): IVT subcategories associated with the request.st_media_type): Media type of the inventory (e.g., banner, video).ua_os_name): Operating system of the delivery device.platform): Platform type (e.g., desktop, mobile).session_id): Unique identifier for each event.sivt): Indicates if the impression was identified as Sophisticated IVT (SIVT).is_ssai): Indicates if the ad was delivered via server-side ad insertion.st_surface): Device category (e.g., mobile, desktop).tag_type): Type of FraudSensor tag that detected the event.timestamp): Date and time the impression was recorded.utm_campaign): UTM campaign parameter from the impression URL.utm_content): UTM content parameter from the impression URL.utm_medium): UTM medium parameter from the impression URL.utm_source): UTM source parameter from the impression URL.utm_term): UTM term parameter from the impression URL.customer_id): Unique identifier associated with your HUMAN account.mg_supplier_id): Supplier ID as provided in your request to MediaGuard.mg_publisher_id): Publisher ID as provided in your request to MediaGuard.mg_seller_domain): Seller domain from sellers.json.mg_seller_type): Seller type from sellers.json.mg_seller_name): Seller name from sellers.json.mg_domain): Full domain where the ad was intended to be delivered.mg_domain_root): Root domain where the ad was intended to be delivered.mg_app_id): App bundle where the ad was intended to be delivered, as provided by the seller (for in-app mobile environments only).mg_ip): IPv4 address as provided in your request to MediaGuard.mg_device_type): Device type as provided in your request to MediaGuard.mg_user_agent): User agent of the user who drove the request.mg_timestamp): Date and time HUMAN recorded the request.mg_usr_id): A unique identifier for the claimed user viewing the impression. Corresponds to the OpenRTB user object’s id field in the bid request.mg_usr_buyeruid): The buyer’s unique identifier for the claimed user viewing the impression. Corresponds to OpenRTB user object’s buyerid field in the bid request.mg_dev_ifa): An IFA or Identifier for Advertisers (IDFA for iOS, AAID for Android) is used to identify the specific user device. Corresponds to OpenRTB device objects of ifa field in the bid request.fs_tag_id): Identifier of the detection tag that detected the impression.fs_domain): Domain of the page where HUMAN’s detection tag was attached.fs_domain_root): Root domain of the page where HUMAN’s detection tag was attached. If it was attached inside an iframe, this field may not be populated.fs_detected_app_id): Detected app bundle for the ad delivery (in-app mobile environments only).fs_ip, exclusive field per legal approval): The IP address from which the ad impression was visited.fs_xff_ip, exclusive field per legal approval): The end point device IP address.fs_user_agent, exclusive field per legal approval): User agent of the user who drove the request.timestamp): Date and time HUMAN recorded the impression.fs_ivt): A Boolean value that, when true, indicates that the impression was identified as invalid traffic (IVT).fs_givt): A Boolean value that, when true, indicates if the impression was identified as General IVT (GIVT).fs_sivt): A Boolean value that, when true, indicates if the impression was identified as Sophisticated IVT (SIVT).fs_ivt_taxonomy_category): The IVT categories associated with the impression.fs_ivt_taxonomy_category_str): String representations of the IVT taxonomy categories assigned to the request by FraudSensor. Provides a human-readable classification of the type of invalid traffic detected.fs_ivt_taxonomy_subcategory): The IVT subcategories associated with the impression.insights_domain_mismatch): Mismatch between the domain in the URL parameter you passed to MediaGuard and the domain detected by FraudSensor. In some cases, this field may be Null, which means a mismatch couldn’t be determined. This can happen for several reasons:
insights_domain_mismatch_root): Mismatch between the domain in the URL parameter you passed to MediaGuard and the FS Domain detected by HUMAN, where the root domains (eTLD+1) differ. For more details see FS+MG Domain Mismatch.insights_domain_mismatch_sub): Mismatch between the domain in the URL parameter you passed to MediaGuard and the FS Domain detected by HUMAN, where the root domains (eTLD+1) match but the subdomains differ. For more details see FS+MG Domain Mismatch.insights_ip_mismatch): Mismatch between the IP address in the IP parameter you passed to MediaGuard and the IP address detected by HUMAN. A Null value means the mismatch could not be determined, due to one of the following reasons: