Report fields

Introduction

The below table provides all the available fields, and their descriptions.

 

Column / API Name

Display Name Description
event_type Event Type The type of event
property_id Property ID Property ID is an identifier for an app
is_organic Is Organic Organic (1) and non-organic (0) categorisation. Organic installs are not attributed through TrafficGuard to any Partner
transaction_id Transaction ID Unique transaction identifier generated by TrafficGuard
tracking_metadata_agency_id Agency ID Unique identifier of the Agency
tracking_metadata_partner_id Partner ID Unique identifier of the Partner, network or traffic source
tracking_metadata_partner_click_id Partner Click ID

Unique transaction identifier generated by the Partner

tracking_metadata_sub_partner_id Sub Partner ID Sub partner or publisher identifier
tracking_metadata_site_id_raw Site ID Raw Identifier of the site or app where the ad was displayed
tracking_metadata_section_id Section ID Identifier of the section of the site or app where the ad was displayed
tracking_metadata_placement_id Placement ID Identifier of the ad placement
tracking_metadata_sub_param_1 Sub Param 1 Custom parameter defined by the advertiser
tracking_metadata_sub_param_2 Sub Param 2 Custom parameter defined by the advertiser
tracking_metadata_sub_param_3 Sub Param 3 Custom parameter defined by the advertiser
tracking_metadata_sub_param_4 Sub Param 4 Custom parameter defined by the advertiser
tracking_metadata_sub_param_5 Sub Param 5 Custom parameter defined by the advertiser
tracking_metadata_cost_model Cost Model The advertiser's pricing model of the transaction
tracking_metadata_cost_value_usd Cost Value USD Cost if converted in USD
tracking_metadata_campaign_id Campaign ID The advertiser's campaign identifier
tracking_metadata_creative_id Creative ID Ad creative name or identifier
tracking_metadata_creative_type Creative Type The type of ad creative
tracking_metadata_creative_set_id Creative Set ID Name or identifier for a set or group of creatives
tracking_metadata_bundle_id Bundle ID iOS only - string to match either a single app or a group of apps
tracking_metadata_app_id App ID iOS and Android - Unique identifier of the app
tracking_metadata_app_category App Category The category of the app in the app or play store
tracking_metadata_app_developer App Developer The Developer name in the app or play store
tracking_metadata_app_title App Title The title of the app in the app or play store
tracking_metadata_organisation_identifier Organisation ID Unique identifier of the Customer, organisation or advertiser as defined in TrafficGuard
click_event_time Click Event Time The time the click occurred
click_session_id Click Session ID If the end user is in on WIFI based on the install IP (1) or not (0).
click_transaction_id Click Transaction ID Unique transaction identifier of the click generated by TrafficGuard
click_user_ip_info_ip_address_v4_str Click User IP Info IP Address V4 The IP V4 address of the end user
click_user_ip_info_ip_address_v6 Click User IP Info IP Address V6 The IP V6 address of the end user
click_user_ip_info_isp Click User IP Info ISP The ISP of the end user
click_user_ip_info_isp_organization Click User IP Info ISP Organization The ISP oragnisation of the end user
click_user_ip_info_autonomous_system_organization

Click User IP Info Autonomous System Organization

The ASN of the end user
click_user_ip_info_continent_name Click User IP Info Continent Name Continent name based on the click IP of the end user
click_user_ip_info_continent_code Click User IP Info Continent Code Continent code based on the click IP of the end user
click_user_ip_info_country_name Click User IP Info Country Name Country name based on the click IP of the end user
click_user_ip_info_country_iso_code Click User IP Info Country ISO Code Country code based on the click IP of the end user
click_user_ip_info_state_name Click User IP Info State Name State name based on the click IP of the end user
click_user_ip_info_city_name

Click User IP Info City Name

City name based on the click IP of the end user
click_user_ip_info_postal_code Click User IP Info Postal Code Postal code based on the click IP of the end user
click_user_ip_info_is_in_european_union Click User IP Info Is In European Union If the end user is in the EU based on the click IP (1) or not (0)
click_user_ip_info_is_wifi Click User IP Info Is WIFI If the end user is in on WIFI based on the click IP (1) or not (0)
click_user_device_user_agent Click User Device User Agent The end users device user agent string of the click
click_user_device_brand Click User Device Brand Brand based on click user agent
click_user_device_model Click User Device Model Model based on click user agent
click_user_device_platform Click User Device Platform

Platform based on click user agent

 
click_user_device_platform_version Click User Device Platform Version Platform version based on click user agent
click_user_device_browser Click User Device Browser Browser based on click user agent
click_user_device_browser_version

Click User Device Browser Version

 
Browser version based on click user agent
click_user_device_browser_language Click User Device Browser Language Browser Language based on click user agent
click_user_device_device_type Click User Device Type Device type based on click user agent

Device type based on click user agent

Click User Device IDFA iOS only - Advertising Identifier unique to each device
click_user_device_idfv Click User Device IDFV iOS only - Identifier for Vendor uniquly identifes the device to the app's vendor
click_user_device_aaid Click User Device AAID Android only - Google Advertising ID for Android devices
click_request_data_request_url Click Request Data Request URL The raw click URL
click_request_data_http_referrer_url Click Request Data HTTP Referrer URL The Domain of the webpage that linked to the TrafficGuard click tracking URL
click_request_data_http_referrer_domain Click Request Data HTTP Referrer Domain The URL of the webpage that linked to the TrafficGuard click tracking URL
click_request_data_is_do_not_track_enabled Click Request Data Is Do Not Track Enabled The end user requests that they are not tracked (1) or not (0).
click_request_data_is_retargeting Click Request Data Is Retargeting The end user has been retargeted (1) or not (0).
click_request_data_gdpr_consent Click Request Data GDPR Consent GDPR Consent passing - Encodes the consented-to purposes and vendor consent string, as obtained from the CMP JS API or OpenRTB
click_request_data_gdpr_pd Click Request Data GDPR Pd GDPR Consent passing - for generic URL parameters, gdpr_pd=0 indicates none of them contain personal data (from the perspective of the callee). For "defined" URL parameters, their definition should define whether they include personal data
click_request_data_gdpr Click Request Data GDPR GDPR Consent passing - 0=GDPR does not apply 1=GDPR applies If not present, callee should do geoIP lookup, and GDPR applies for EU IP addresses
click_invalid_log_mrc_category Click Invalid Log MRC Category Category of invalid click defined by Media Rating Council measurement standards
click_invalid_log_iab_anti_fraud_taxonomy Click Invalid Log IAB Anti Fraud Taxonomy Category of invalid click defined by IAB measurement standards
click_invalid_log_invalid_reason Click Invalid Log Invalid Reason Audit reason of exactly what fraud attempts were blocked
click_filter_log_filter_reason Click Filter Log Filter Reason Click Filter Log Filter Reason
install_event_time Install Event Time The time when an install occurs
install_event_source Install Event Source The source that notified TrafficGuard of the event
install_mmp_attribution_method Install MMP Attribution Method The method the MMP used to attribute
install_mmp_transaction_id Install MMP Transaction ID The MMP's unique identifer of the transaction
install_mmp_campaign_id Install MMP Campaign ID The MMP's identifer of the campaign, as defined by the advertiser
install_user_ip_info_ip_address_v4_str Install User IP Info IP Address V4 The IP V4 address of the end user based on the install
install_user_ip_info_ip_address_v6 Install User IP Info IP Address V6 The IP V6 address of the end user based on the install
install_user_ip_info_isp Install User IP Info ISP The ISP of the end user based on the install IP
install_user_ip_info_isp_organization Install User IP Info ISP Organization The ISP oragnisation of the end user based on the install IP
install_user_ip_info_autonomous_system_organization Install User IP Info Autonomous System Organization The ASN of the end user based on the install IP
install_user_ip_info_continent_name

Install User IP Info Continent Name

Continent name based on the install IP of the end user
install_user_ip_info_continent_code Install User IP Info Continent Code Continent code based on the install IP of the end user
install_user_ip_info_country_name install_user_ip_info_country_name Country name based on the install IP of the end user
install_user_ip_info_country_iso_code Install User IP Info Country ISO Code Country code based on the install IP of the end user
install_user_ip_info_state_name Install User IP Info State Name State name based on the install IP of the end user
install_user_ip_info_city_name Install User IP Info City Name City name based on the install IP of the end user
install_user_ip_info_time_zone Install User IP Info Time Zone Time zone based on the install IP of the end user
install_user_ip_info_postal_code Install User IP Info Postal Code Postal code based on the install IP of the end user
install_user_ip_info_is_in_european_union Install User IP Info Is In European Union If the end user is in the EU based on the install IP (1) or not (0).
install_user_ip_info_is_wifi Install User IP Info Is WIFI If the end user is in on WIFI based on the install IP (1) or not (0).
install_user_device_user_agent

Install User Device User Agent

The end user's device user agent string of the install

install_user_device_brand

Install User Device Brand

Brand based on install user agent

install_user_device_model

Install User Device Model

Model based on install user agent

install_user_device_platform

Install User Device Platform

Platform based on install user agent

install_user_device_platform_version

Install User Device Platform Version

Platform version based on install user agent

install_user_device_browser

Install User Device Browser

Browser based on install user agent

install_user_device_browser_version

Install User Device Browser Version

Browser version based on install user agent

install_user_device_browser_language

Install User Device Browser Language

Browser Language based on install user agent

install_user_device_device_type

Install User Device Device Type

Device type based on install user agent

install_user_device_idfa

Install User Device IDFA

iOS only - Advertising Identifier unique to each device

 
install_user_device_idfv Install User Device IDFV

iOS only - Identifier for Vendor uniquely identifies the device to the app's vendor

install_user_device_aaid

Install User Device AAID

Android only - Google Advertising ID for Android devices

install_request_data_http_user_agent

Install Request Data HTTP User Agent

Server device user agent string of the install notification

install_request_data_google_play_install_referrer

Install Request Data Google Play Install Referrer

The referrer URL of the installed package

install_request_data_google_play_referrer_click_timestamp

Install Request Data Google Play Referrer Click Timestamp

The timestamp, in seconds, of when the referrer click happened

install_request_data_google_play_install_begin_timestamp Install Request Data Google Play Install Begin Timestamp The timestamp, in seconds, of when the installation began
install_invalid_log_mrc_category

Install Invalid Log MRC Category

Invalid install category as defined by the Media Rating Council measurement standards

install_invalid_log_iab_anti_fraud_taxonomy

Install Invalid Log IAB Anti Fraud Taxonomy

Invalid install category as defined by IAB measurement standards

install_invalid_log_invalid_reason

Install Invalid Log Invalid Reason

Audit reason of exactly what fraud attempts were blocked

install_filter_log_filter_reason

Install Filter Log Filter Reason

Audit reason for exactly what filters were not met

event_event_time

Event Time

The time the event took place

event_event_name

Event Event Name

The name of the event

event_event_param

Event Event Param

Additional information relating to the event

event_event_revenue_usd

Event Event Revenue USD

The value of the event in USD

event_invalid_log_mrc_category

Event Invalid Log MRC Category

Invalid event category as defined by Media Rating Council measurement standards

event_invalid_log_iab_anti_fraud_taxonomy

Event Invalid Log IAB Anti Fraud Taxonomy

Invalid event category as defined by IAB measurement standards

event_invalid_log_invalid_reason

Event Invalid Log Invalid Reason

Audit reason of exactly what fraud attempts were blocked

event_filter_log_filter_reason

Event Filter Log Filter Reason

Audit reason for exactly what filters were not met