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 |