Reports Overview

This document provides a detailed description of the reports available from the Kochava Reports UI. The different types of reports that can be generated include, but are not limited to, Click, Event, Install, Campaign Summary, Network Summary.

For more information on how to pull reports, refer to our Pulling Reports support documentation.

 

NOTE: The Click, Event and Install reports are fully customizable allowing the user to decide which data is present and the order that the data is presented within the report. For more information about customizing the Click, Event and Install reports, refer to our Pulling Reports support documentation.

NOTE: Detail Reports that exceed 5.0 gigabytes in size will be compressed to enable accelerated download.

NOTE: For a sample of each of the reports listed below, download our KochavaReportsDemo document.


Click Report

The Click Report provides a row-level view of clicks for a given campaign.

 

Field Name Description Type May be
Null
Character Limit
attribution_tier The tier/segment to which the attribution is associated. string yes 100
click_campaign The Kochava-specific ID of the campaign to which the click was attributed. string no longtext
click_campaign_name The user defined name for the campaign to which the click was attributed. string yes 255
click_country_code 2-digit country designation where the click originated, based on IP lookup. string yes 2
click_creative Data received on click in the creative_id parameter. string yes 128
click_custom_parameters Custom parameters passed with the click. string no
click_date_adjusted Date and time of the click (Selected Time Zone). string (datetime) no datetime
click_date_utc Date and time of the click (Coordinated Universal Time). string (datetime) no datetime
click_device_id The primary device ID received on click. string (int) yes 255
click_device_ua User Agent of the device gathered upon click.
string yes longtext
click_device_ver The device type and version of the device received on click. string yes 128
click_duplicate The ID assigned to duplicate clicks. string yes 20
click_identifiers An array of all device identifiers received on the click. json (strings) yes text
click_identifiers_adid Raw ADID provided on the click (Android specific). string yes 255
click_identifiers_android_id Raw Android_ID received on the click (Android specific).
string yes 255
click_identifiers_android_id_md5 MD5 encrypted Android_ID received on the click (Android specific).
string yes 255
click_identifiers_android_id_sha1 SHA1 encrypted Android_ID received on the click (Android specific). string yes 255
click_identifiers_custom Custom provided identifier received with the click.
string yes 255
click_identifiers_email_0 Primary email address delivered with the click.
string yes 255
click_identifiers_email_1 Secondary email address delivered with the click.
string yes 255
click_identifiers_idfa Raw IDFA received on the click (iOS specific). string yes 255
click_identifiers_ip Raw IP address where the click originated. string yes 255
click_identifiers_waid Raw WAID received on the click (Windows specific). string yes 255
click_ip The IP address from which the click originated. string no 16
click_matched_impression ID representation of the impression which the click was matched to.
string (int) yes 20
click_matched_install ID representation of the install which matched to the click.
string (int) yes 20
click_network The Kochava-specific ID of the Network to which the click originated. string (int) no 11
click_network_name The name of the Network to which the click originated. string yes 256
click_original_request Raw URL which was received for specific click.

NOTE: API call will return data in JSON format.

string yes longtext
click_price The price per click. string (float) yes 2
click_site Identifies the site to which the click was served within the publisher partner. string yes 512
click_status Indicator to define if the click has simply been received (publish) or matched to an install.
string no 16
click_tier The tier/segment to which the click is associated. string yes 100
click_tracker The Kochava-specific ID of the tracker to which the click originated. string (int) no 20
click_tracker_name The user defined name for the tracker to which the click originated. string yes 100
clickgeo_area_code The area code where the click originated, based on IP lookup. string (int) yes 16
clickgeo_city The name of the city where the click originated, based on IP lookup. string yes 32
clickgeo_continent_code 2-digit continent designation where the click originated, based on IP lookup. string yes 2
clickgeo_country_code 2-digit country designation where the click originated, based on IP lookup. string yes 2
clickgeo_country_code3 3-digit country designation where the click originated, based on IP lookup. string yes 3
clickgeo_country_name The name of the country where the click originated, based on IP lookup. string yes 32
clickgeo_dma_code The code for the designated marketing area where the click originated, based on IP lookup. string (int) yes 16
clickgeo_latitude The latitude where the click originated, based on IP lookup. string (float) yes 18,14
clickgeo_longitude The longitude where the click originated, based on IP lookup. string (float) yes 18,14
clickgeo_postal_code The postal code of the region where the click originated, based on IP lookup. string (int) yes 16
clickgeo_region An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup. string yes 32
impression_campaign The Kochava-specific ID of the campaign to which the click was attributed. string (int) yes 20
impression_campaign_name The user defined name for the campaign to which the click was attributed. string yes 255
impression_country_code 2-digit country designation where the impression originated, based on IP lookup. string yes 2
impression_creative Data received on impression in the creative_id parameter. string yes 64
impression_date_adjusted The date the impression occurred (Selected Time Zone). string (date) yes datetime
impression_date_utc The date the impression occurred in UTC. string (date) yes datetime
impression_device_ver The device type and version of the device received on impression. string yes 64
impression_identifiers An array of all device identifiers received on the impression. json (strings) yes text
impression_imp_id Unique identifier associated with the impression which has been received. string (int) yes 11
impression_ip The IP address from which the impression originated. string yes 16
impression_kochava_imp_id Kochava generated unique identifier associated with the impression which has been received.
string yes 50
impression_matched_click ID representation of the click which the impression was matched to. string (int) yes 20
impression_matched_install ID representation of the install which matched to the impression. string (int) yes 20
impression_network The Kochava-specific ID of the Network to which the impression originated. string (int) yes 7
impression_network_name The name of the Network to which the impression originated. string yes 256
impression_original_request Raw URL which was received for specific impression.

NOTE: API call will return data in JSON format.

string yes text
impression_site Identifies the site to which the impression was served within the publisher partner. string yes 255
impression_tracker The Kochava-specific ID of the tracker to which the impression was attributed. string (int) yes 20
impression_tier The tier/segment to which the impression is associated. string yes 100
impression_tracker_name The user defined name for the tracker to which the click was attributed. string yes 100
kochava_click_id Click ID assigned by Kochava. string yes longtext
partner_click_id Click ID as received from the partner. string yes longtext
reengagement_tier The tier/segment to which the reengagement is associated. string yes 100
traffic_click_verification_status Indicator if the click traffic was valid or invalid based on Traffic Verification rules. json (strings) yes 16
traffic_verification_status Indicator if the click traffic was valid or invalid based on Traffic Verification rules.
string yes 1

 

NOTE: Some columns within the report may contain JSON encoded data. These columns will have “*_querystring” versions that will provide a URL QueryString encoded version of these columns. The JSON path for each value in the JSON will be used as the querystring key for that value.


Click MTA Report

The Click MTA Report provides a row-level view of the influencers that led to a click for a given campaign.

 

Field Name Description Type May be
Null
Character
Limit
install_id The internally generated unique ID to which the install is attributed. string (int) no 11
install_date_utc Date and time of install (Coordinated Universal Time). string (datetime) no datetime
install_date_adjusted Date and time of install (Selected Time Zone). string (datetime) no datetime
clickwin_id The ID of the click that won attribution. string (int) no 11
clickwin_network The ID of the network awarded the winning click. string (int) no 11
clickwin_network_name The name of the network awarded the winning click. string yes 256
clickwin_site Identifies the site to which the winning click was served within the publisher partner. string yes 512
clickwin_creative_id The ID/name of the creative which drove the winning click. string yes 512
clickwin_date_utc Date and time of the winning click (Coordinated Universal Time). string (datetime) no datetime
clickwin_date_adjusted Date and time of the winning click (Selected Time Zone). string (datetime) no datetime
clickwin_matched_on Provides the actual piece of data that the click was mtched on; that is, the device ID. string no 64
clickwin_match_type The ID type to which the winning click is attributed. string no 32
influencer_id Unique identifier associated with the influencer which has been received. string (int) no 20
influencer_network The ID of the network which influenced the winning click. string (int) no 11
influencer_network_name The name of the network which influenced the winning click. string yes 256
inf_site Identifies the site to which the influencer was served within the publisher partner. string yes 512
inf_creative_id The ID/name of the creative which influenced the click. string yes 512
influencer_date_utc Date and time the influencer was served (Coordinated Universal Time). string (datetime) no datetime
influencer_date_adjusted Date and time the influencer was served (Selected Time Zone). string (datetime) no datetime
influencer_matched_on Provides the actual piece of data the influencer was matched on; for example, the device ID. string no 64
influencer_match_type Description of how we matched the install to the influencer; for example, device ID, Facebook, etc string no 32
rejected_because The reason the install was attributed to another Network (for example, another network was credited with last-click).

device_id_inclusive – Reconciliation settings are set to default, the click had a mismatched device_id but would have been eligible to win attribution on fingerprint if inclusive had been set.

fingerprint_equalizer_lookback – Fingerprint Equalizer was activated and the click would have been eligible to win attribution, but the click occurred outside the configured Fingerprint Equalizer lookback window.

ip_disabled – The click would have been eligible to match on IP if that setting was enabled.

last_click – The click was eligible to win attribution, but there was a more recent click closer to the install that won attribution.

lookback_disabled – The click would have been eligible to match, but the lookback setting was disabled.

lookback_enforced – The click would have matched but it occurred outside the configured lookback window (ex: click was at 10 days prior to the install but lookback was set to 9 days).

partial_ip_disabled – The click would have been eligible to match on partial IP if that setting was enabled.

string no 64
attribution_tier The tier/segment to which the attribution is associated. string yes 100
click_tier The tier/segment to which the click is associated. string yes 100
impression_tier The tier/segment to which the impression is associated. string yes 100
reengagement_tier The tier/segment to which the reengagement is associated. string yes 100

 

NOTE: Some columns within the report may contain JSON encoded data. These columns will have “*_querystring” versions that will provide a URL QueryString encoded version of these columns. The JSON path for each value in the JSON will be used as the querystring key for that value.


Collected Cost Report

 

Field Name Description Type May be
Null
Character
Limit
date_retrieved The timeframe from the network for pricing data. string
(datetime)
no datetime
starting_date The date and time that the cost data began being collected. string
(datetime)
no datetime
ending_date The date and time that the cost data ended being collected. string
(datetime)
no datetime
cost_network_id The Kochava-specific ID of the network to which the cost data is attributed. string
(int)
yes 20
cost_network_name The name of the network to which the cost data is attributed. string yes 256
network_campaign_id Unique identifier associated with the network to which the cost data is attributed. string
(int)
no 100
network_campaign_name The user defined name for the campaign to which the cost data is attributed. string yes 256
type The type of ad being served. string yes 256
click_thru_rate The ratio of users who click on an ad to the number of total users who view the ad. string
(int)
yes float
cost_per_click The cost of a click on the served ad. string
(int)
yes float
cost_per_completed_view The cost for a completed view of a served ad. string
(int)
yes float
cost_per_impression The cost of an impression served. string
(int)
yes float
cost_per_install The cost of an install. string
(int)
yes float
cost_per_view The cost per view of video ads. string
(int)
yes float
total_daily_cumulative_spend The network reported cumulative spend from 00:00 to 24:59 UTC for a given criteria line item. string
(int)
yes float
device The users device type. string yes 256
gender The gender of the user. string yes 256
geography The geographic region of the device. string yes 256
group_id The campaign or ad group id of the device. string yes 100
group_name The campaign or ad group name of the device. string yes 100
image The ID/name of the creative which influenced the device. string yes 256
keywords Campaign keywords. string yes 256
name Generic placeholder, used if data not grouped by campaign or ad. string yes 256
network_ad_id The ID for the network ad. string no 20
platform The device platform. string yes 256
target The user group which the ad or campaign is targeting. string yes 256
url The raw URL which was received from the device. string yes 256
attribution_tier The tier/segment to which the attribution is associated. string yes 100
click_tier The tier/segment to which the click is associated. string yes 100
impression_tier The tier/segment to which the impression is associated. string yes 100
reengagement_tier The tier/segment to which the reengagement is associated. string yes 100

 

NOTE: Some columns within the report may contain JSON encoded data. These columns will have “*_querystring” versions that will provide a URL QueryString encoded version of these columns. The JSON path for each value in the JSON will be used as the querystring key for that value.


Event Report

The Event Report provides a row-level report on events.

 

NOTE: Details for currency normalization can be found within the custom_dimensions field.

 

Raw IDFV provided on the event (iOS specific)
Field Name Description Type May be
Null
Character
Limit
attribution_attribution_action The action through which attribution was achieved, install or event.
string no 32
attribution_campaign The user defined name for the campaign to which the event was attributed. string yes 255
attribution_campaign_id The Kochava-specific ID of the campaign to which the event was attributed. string no 20
attribution_creative Data received on event in the creative_id parameter. string yes 64
attribution_date_adjusted Date and time of the event (Selected Time Zone). string (datetime) no datetime
attribution_date_utc Date and time of the event (Coordinated Universal Time) string (datetime) yes datetime
attribution_matched_by The identifier by which attribution was matched. string no 32
attribution_matched_to The initial action by which attribution was matched, impression or click or impression with click.
string no 32
attribution_network The Kochava-specific ID of the Network to which the event was attributed. string no 11
attribution_network_id Unique identifier associated with the network to which the event was attributed. string (int) no 64
attribution_seconds_since The number of seconds since attribution was made. int no 8
attribution_site_id Identifies the site to which the event was attributed within the publisher partner. string yes 512
attribution_tier The tier/segment to which the attribution is associated. string yes 100
attribution_timestamp The date and time of attribution. string (datetime) no datetime
attribution_timestamp_adjusted The date and time of attribution (Selected Time Zone). string (datetime) no datetime
attribution_tracker The Kochava-specific ID of the tracker to which the event was attributed. string yes 100
attribution_tracker_id The Kochava-specific ID of the tracker to which the event was attributed. string no 20
attribution_tracker_name The user defined name for the tracker to which the event was attributed. string yes 100
click_campaign The Kochava-specific ID of the campaign to which the click was attributed. string yes longtext
click_campaign_name The user defined name for the campaign to which the click was attributed. string yes 255
click_country_code 2-digit country designation where the click originated, based on IP lookup. string yes 2
click_creative Data received on click in the creative_id parameter. string yes 128
click_custom_parameters Custom parameters passed with the click. string no
click_date_adjusted Date and time of the click (Selected Time Zone) string (datetime) yes datetime
click_date_utc Date and time of the click (Coordinated Universal Time). string (datetime) yes datetime
click_device_id The primary device ID received on click. string (int) yes 255
click_device_ua User Agent of the device gathered upon click. string yes longtext
click_device_ver The device type and version of the device received on click. string yes 128
click_duplicate The ID assigned to duplicate clicks. string (int) yes 20
click_identifiers An array of all device identifiers received on the click. json (strings) yes text
click_identifiers_adid Raw ADID provided on the click (Android specific). string yes 255
click_identifiers_android_id Raw Android_ID received on the click (Android specific). string yes 255
click_identifiers_android_id_md5 MD5 encrypted Android_ID received on the click (Android specific). string yes 255
click_identifiers_android_id_sha1 SHA1 encrypted Android_ID received on the click (Android specific). string yes 255
click_identifiers_custom Custom provided identifier received with the click. string yes 255
click_identifiers_email_0 Primary email address delivered with the click. string yes 255
click_identifiers_email_1 Secondary email address delivered with the click. string yes 255
click_identifiers_idfa Raw IDFA received on the click (iOS specific). string yes 255
click_identifiers_ip Raw IP address where the click originated. string yes 255
click_identifiers_waid Raw WAID received on the click (Windows specific). string yes 255
click_ip The IP address from which the click originated. string yes 16
click_matched_impression ID representation of the impression which the click was matched to. string (int) yes 20
click_matched_install ID representation of the install which matched to the click. string (int) yes 20
click_month The numeric value of the month the install was received. string (int) yes 1
click_network The Kochava-specific ID of the Network to which the click originated. string (int) yes 11
click_network_name The name of the Network to which the click originated. string yes 255
click_original_request Raw URL which was received for specific click.

NOTE: API call will return data in JSON format.

string yes longtext
click_site Identifies the site to which the click was served within the publisher partner. string yes 512
click_status Indicator to define if the click has simply been received (publish) or matched to an install. string yes 16
click_tier The tier/segment to which the click is associated. string yes 100
click_tracker The Kochava-specific ID of the tracker to which the click originated. string (int) yes 20
click_tracker_name The user defined name for the tracker to which the click originated. string yes 100
clickgeo_area_code The area code where the click originated, based on IP lookup. string (int) yes 16
clickgeo_city The name of the city where the click originated, based on IP lookup. string yes 32
clickgeo_continent_code 2-digit continent designation where the click originated, based on IP lookup. string yes 2
clickgeo_country_code 2-digit country designation where the click originated, based on IP lookup. string yes 2
clickgeo_country_code3 3-digit country designation where the click originated, based on IP lookup. string yes 3
clickgeo_country_name The name of the country where the click originated, based on IP lookup. string yes 32
clickgeo_dma_code The code for the designated marketing area where the click originated, based on IP lookup. string (int) yes 16
clickgeo_latitude The latitude where the click originated, based on IP lookup. string (float) yes 18,14
clickgeo_longitude The longitude where the click originated, based on IP lookup. string (float) yes 18,14
clickgeo_postal_code The postal code of the region where the click originated, based on IP lookup. string (int) yes 16
clickgeo_region An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup. string yes 32
count Number of events (based on selection) during defined time frame. int no 11
custom_dimensions Custom provided dimensions received with the event. array (strings) yes text
device_id_adid Raw ADID provided on the event (Android specific). string yes 64
device_id_android_id Raw Android_ID received on the event (Android specific). string yes 64
device_id_custom Custom provided identifier received with the event . string yes 64
device_id_idfa Raw IDFA provided on the event (iOS specific) string yes 64
device_id_idfv string yes 64
device_id_kochava Kochva generated Unique ID assigned to device. string no 60
device_os The operating system of the device. string yes 100
device_type The device type of the device. string yes 200
device_version The device version of the mobile device. string yes 100
dimension_count Number of custom events (based on selection). int no 11
dimension_data Data provided dimensions received with the event. string yes text
dimension_sum The sum of event data. float yes 128
event_name The name of the advertiser defined and integrated event. string yes 128
event_time_registered The time that the event was performed by the mobile device. (Unix ???) string (int) no 11
geo_city The name of the city where the event originated, based on IP lookup. string yes 32
geo_country The name of the country where the event originated, based on IP lookup. string yes 32
geo_lat The latitude where the event originated, based on IP lookup. string (float) yes 18,14
geo_lon The longitude where the event originated, based on IP lookup. string (float) yes 18,14
geo_region An alpha-numeric code identifying the geographic region where the event originated, based on IP lookup. string yes 32
identity_link A customer defined unique identifier for linking devices. string yes 255
impression_campaign The Kochava-specific ID of the campaign to which the impression is associated.
string (int) yes 20
impression_campaign_name The user defined name for the campaign to which the impression is associated. string yes 255
impression_country_code 2-digit country designation where the impression originated, based on IP lookup. string yes 2
impression_creative The ID/name of the creative which was served with the impression. string yes 64
impression_date_adjusted The date the impression occurred (Selected Time Zone). string (date) yes datetime
impression_date_utc Date and time of the impression (Coordinated Universal Time). string (date) yes datetime
impression_device_ver The device type and version of the device which received on impression. string yes 64
impression_identifiers An array of all device identifiers received on the impression. json (strings) yes text
impression_imp_id Unique identifier associated with the impression which has been received. string (int) yes 11
impression_ip The IP address from which the impression originated. string yes 16
impression_kochava_imp_id Kochava generated unique identifier associated with the impression which has been received. string yes 50
impression_matched_click ID representation of the click which the impression was matched to. string (int) yes 20
impression_matched_install ID representation of the install which matched to the impression. string (int) yes 20
impression_network The Kochava-specific ID of the Network to which the impression originated. string (int) yes 7
impression_network_name The name of the Network to which the impression originated. string yes 256
impression_original_request Raw URL which was received for specific impression.

NOTE: API call will return data in JSON format.

string yes text
impression_site Identifies the site to which the impression was served within the publisher partner. string yes 255
impression_tier The tier/segment to which the impression is associated. string yes 100
impression_tracker The Kochava-specific ID of the tracker to which the impression is associated. string (int) yes 20
impression_tracker_name The user defined name for the tracker to which the impression is associated. string yes 100
install_date_adjusted The date the install occurred (Selected Time Zone). string (datetime) yes datetime
install_date_utc Date and time of the install (Coordinated Universal Time). string (datetime) yes datetime
install_device_ua User Agent of the device gathered upon install. string yes longtext
install_device_version The device type and version of the device received on install. string yes longtext
install_devices_adid Raw ADID provided on the install (Android specific). string yes longtext
install_devices_android_id Raw Android_ID provided on the install (Android specific). string yes longtext
install_devices_custom Custom provided identifier received with the install. string yes longtext
install_devices_email_0 Primary email address delivered with the install. string yes longtext
install_devices_email_1 Secondary email address delivered with the install. string yes longtext
install_devices_idfa Raw IDFA provided on the install (iOS specific). string yes longtext
install_devices_ids An array of the device identifiers received on install. json (strings) yes longtext
install_devices_ip The IP address from which the install originated. string yes longtext
install_devices_waid Raw WAID received on install (Windows specific). string yes longtext
install_matched_by Defines the nature of the data point on which the click was matched to the install. string yes longtext
install_matched_on ID representation of the install which matched to the click. string yes 64
install_receipt_status Indication whether a receipt was received from the app store for the associated install as well as the level of authentication of the receipt. string no longtext
install_san_original The original Self Attributing Network to which the install is attributed. string yes 64
install_status Indicator to define if an install has been simply been received (publish) or matched to a click. string no 20
kochava_click_id Click ID assigned by Kochava. string yes longtext
partner_click_id Click ID as received from the partner. string yes longtext
reengagement_tier The tier/segment to which the reengagement is associated. string yes 100
request_ip The IP address from which the request originated. string yes longtext
request_ua User Agent from which the request originated. string yes longtext
timestamp_adjusted The date and time of the event (Selected Time Zone). string (datetime) no datetime
timestamp_utc The date and time of the event (Coordinated Universal Time). string (datetime) yes datetime

 

NOTE: Some columns within the report may contain JSON encoded data. These columns will have “*_querystring” versions that will provide a URL QueryString encoded version of these columns. The JSON path for each value in the JSON will be used as the querystring key for that value.


Impression MTA Report

 

Field Name Description Type May be
Null
Character
Limit
id Random internal identifier
string (int) no 11
match_id The Kochava-specific ID of the match that won attribution. sting (int) no 11
match_date_utc The date and time of attribution (Coordinated Universal Time). string (datetime) no datetime
match_date_adjusted The date and time of attribution (Selected Time Zone). string (datetime) no datetime
match_month The number of the month in which attribution occurred. string (int) no 11
match_type Description of how attribution was performed; for example, device ID, Facebook, etc string no 32
imp_match_id The Kochava-specific ID of the impression which led to install. string (int) no 64
imp_match_network The Kochava-specific ID of the Network to which the impression originated. string (int) no 11
imp_match_network_name The name of the Network to which the impression originated. string yes 256
imp_match_type The type of attribution the impression was matched on. string no 45
imp_matched_on The ID which the impression was matched on. string no 64
influencer_id Unique identifier associated with the influencer. string (int) no 64
influencer_network The Kochava-specific ID of the Network to which the influencer originated. string (int) no 11
influencer_network_name The name of the network in which the influencer occurred. string yes 256
influencer_date_utc The date and time of the influencer (Corrdinated Universal Time) string (datetime) no datetime
influencer_date_adjusted The date and time of the influencer (Selected Time Zone). string (datetime) no datetime
influencer_match_type Description of how we matched the click to the influencer; for example, device ID, Facebook, etc string no 45
influencer_matched_on Provides the actual piece of data the influencer was matched on; for example, the device ID. string no 64
rejected_because The reason the install was attributed to another Network (for example, another network was credited with last-click) string no 45
attribution_tier The tier/segment to which the attribution is associated. string yes 100
click_tier The tier/segment to which the click is associated. string yes 100
impression_tier The tier/segment to which the impression is associated. string yes 100
reengagement_tier The tier/segment to which the reengagement is associated. string yes 100

 

NOTE: Some columns within the report may contain JSON encoded data. These columns will have “*_querystring” versions that will provide a URL QueryString encoded version of these columns. The JSON path for each value in the JSON will be used as the querystring key for that value.


Install Report

The Install Report provides a row-level view of installs for a given campaign.

 

Field Name Description Type May be
Null
Character
Limit
attribution_campaign The Kochava-specific ID of the campaign to which the the install was attributed. string no 20
attribution_campaign_name The user defined name for the campaign to which the install was attributed. string yes 255
attribution_creative Data received on install in the creative_id parameter. string yes 64
attribution_network The Kochava-specific ID of the Network to which the install was attributed. string (int) no 11
attribution_network_name The name of the Network to which the install was attributed. string yes 256
attribution_site Identifies the site to which the install was served within the publisher partner. string no 64
attribution_tier The tier/segment to which the attribution is associated. string yes 100
attribution_tracker The Kochava-specific ID of the tracker to which the install was attributed. string (int) no 20
attribution_tracker_name The user defined name for the tracker to which the install was attributed. string yes 100
click_campaign The Kochava-specific ID of the campaign to which the click was attributed. string no longtext
click_campaign_name The user defined name for the campaign to which the click was attributed. string yes 255
click_country_code 2-digit country designation where the click originated, based on IP lookup. string yes 2
click_creative Data received on click in the creative_id parameter. string yes 128
click_custom_parameters Custom parameters passed with the click. string no
click_device_id The primary device ID received on click. string (int) yes 255
click_device_ua User Agent of the device gathered upon click. string yes longtext
click_device_ver The device type and version of the device received on click. string yes 128
click_duplicate The ID assigned to duplicate clicks. string (int) yes 20
click_identifiers An array of all device identifiers received on the click. json (strings) yes text
click_identifiers_adid Raw ADID provided on the click (Android specific). string yes 255
click_identifiers_android_id Raw Android_ID received on the click (Android specific). string yes 255
click_identifiers_android_id_md5 MD5 encrypted Android_ID received on the click (Android specific). string yes 255
click_identifiers_android_id_sha1 SHA1 encrypted Android_ID received on the click (Android specific). string yes 255
click_identifiers_custom Custom provided identifier received with the click. string yes 255
click_identifiers_email_0 Primary email address delivered with the click. string yes 255
click_identifiers_email_1 Secondary email address delivered with the click. string yes 255
click_identifiers_idfa Raw IDFA received on the click (iOS specific). string yes 255
click_identifiers_ip Raw IP address where the click originated. string yes 255
click_identifiers_waid Raw WAID received on the click (Windows specific). string yes 255
click_ip The IP address from which the click originated. string no 16
click_matched_impression ID representation of the impression which the click was matched to. string (int) yes 20
click_matched_install ID representation of the install which matched to the click. string (int) yes 20
click_month The numeric value of the month the install was received. string (int) no 1
click_network The Kochava-specific ID of the Network to which the click originated. string (int) no 11
click_network_name The name of the Network to which the click originated. string yes 256
click_original_request Raw URL which was received for specific click.

NOTE: API call will return data in JSON format.

string no longtext
click_site Identifies the site to which the click was served within the publisher partner. string yes 512
click_status Indicator to define if the click has simply been received (publish) or matched to an install. string no 16
click_tier The tier/segment to which the click is associated. string yes 100
click_tracker The Kochava-specific ID of the tracker to which the click originated. string (int) no 20
click_tracker_name The user defined name for the tracker to which the click originated. string yes 100
clickgeo_area_code The area code where the click originated, based on IP lookup. string (int) yes 16
clickgeo_city The name of the city where the click originated, based on IP lookup. string yes 32
clickgeo_continent_code 2-digit continent designation where the click originated, based on IP lookup. string yes 2
clickgeo_country_code 2-digit country designation where the click originated, based on IP lookup. string yes 2
clickgeo_country_code3 3-digit continent designation where the click originated, based on IP lookup. string yes 3
clickgeo_country_name The name of the country where the click originated, based on IP lookup. string yes 32
clickgeo_dma_code The code for the designated marketing area where the click originated, based on IP lookup. string (int) yes 16
clickgeo_latitude The latitude where the click originated, based on IP lookup. string (float) yes 18,14
clickgeo_longitude The longitude where the click originated, based on IP lookup. string (float) yes 18,14
clickgeo_postal_code The postal code of the region where the click originated, based on IP lookup. string (int) yes 16
clickgeo_region An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup. string yes 32
identity_link A customer defined unique identifier for linking devices. string yes 255
impression_campaign The Kochava-specific ID of the campaign to which the impression is associated. string (int) yes 20
impression_campaign_name The user defined name for the campaign to which the impression is associated. string yes 255
impression_country_code 2-digit country designation where the impression originated, based on IP lookup. string yes 2
impression_creative The ID/name of the creative which was served with the impression. string yes 64
impression_device_ver The device type and version of the device which received on impression. string yes 64
impression_identifiers An array of all device identifiers received on the impression. json (strings) yes text
impression_imp_id Unique identifier associated with the impression which has been received. string (int) yes 11
impression_ip The IP address from which the impression originated. string yes 16
impression_kochava_imp_id Kochava generated unique identifier associated with the impression which has been received. string (int) yes 11
impression_matched_click ID representation of the click which the impression was matched to. string (int) yes 20
impression_matched_install ID representation of the install which matched to the impression. string (int) yes 20
impression_network The Kochava-specific ID of the Network to which the impression originated. string (int) yes 7
impression_network_name The name of the Network to which the impression originated. string yes 256
impression_original_request Raw URL which was received for specific impression.

NOTE: API call will return data in JSON format.

string yes text
impression_site Identifies the site to which the impression was served within the publisher partner. string yes 255
impression_tier The tier/segment to which the impression is associated. string yes 100
impression_tracker The Kochava-specific ID of the tracker to which the impression is associated. string (int) yes 20
impression_tracker_name The user defined name for the tracker to which the impression is associated. string yes 100
install_click_date_adjusted The date and time the click occurred which led to install (Selected Time Zone). string (datetime) yes datetime
install_click_date_utc The date and time the click occurred which led to install (Coordinated Universal Time). string (datetime) yes datetime
install_date_adjusted The date and time of install (Selected Time Zone). string (datetime) no datetime
install_date_utc The date and time of install (Coordinated Universal Time). string (datetime) yes datetime
install_device_ua User Agent of the device gathered upon install. string yes longtext
install_device_version The device version of the mobile device. string yes longtext
install_devices_adid Raw ADID provided on install (Android specific). string yes longtext
install_devices_android_id Raw Android_ID received on install (Android specific). string yes longtext
install_devices_custom Custom provided identifier received with install. string yes longtext
install_devices_email_0 Primary email address delivered with install. string yes longtext
install_devices_email_1 Secondary email address delivered with the click. string yes longtext
install_devices_idfa Raw IDFA received on install (iOS specific). string yes longtext
install_devices_ids An array of all device identifiers received on install. string yes longtext
install_devices_ip The IP address from which the install originated. string yes longtext
install_devices_waid Raw WAID received on the click (Windows specific). string yes longtext
install_impression_date_adjusted The date and time the impression occurred which led to install (Selected Time Zone). string (datetime) yes datetime
install_impression_date_utc The date and time the impression occurred which led to install (Coordinated Universal Time). string (datetime) yes datetime
install_kochava_device_id Install ID assigned by Kochava string no longtext
install_matched_by The ID type to which installation is attributed. string no longtext
install_matched_on Unique identifier to which the install is matched on. string no 64
install_original_request Raw URL which was received for specific install.

NOTE: API call will return data in JSON format.

string no longtext
install_price The user defined price per click or price per install. string (float) yes 10,6
install_receipt_status Indication whether a receipt was received from the app store for the associated install as well as the level of authentication of the receipt. string no longtext
install_status Indicator to define if an install has been simply been received (publish) or matched to a click. string no 20
installgeo_area_code The area code where the install originated, based on IP lookup. string (int) yes 16
installgeo_city The name of the city where the install originated, based on IP lookup. string yes 32
installgeo_continent_code 2-digit continent designation where the impression originated, based on IP lookup. string yes 2
installgeo_country_code 2-digit continent designation where the install originated, based on IP lookup. stting yes 2
installgeo_country_code3 3-digit continent designation where the impression originated, based on IP lookup. string yes 3
installgeo_country_name The name of the country where the install originated, based on IP lookup. string yes 32
installgeo_dma_code The code for the designated marketing area where the install originated, based on IP lookup. string (int) yes 16
installgeo_latitude The latitude where the install originated, based on IP lookup. string (float) yes 18,14
installgeo_longitude The longitude where the install originated, based on IP lookup. string (float) yes 18,14
installgeo_postal_code The postal code of the region where the install originated, based on IP lookup. string (int) yes 16
installgeo_region An alpha-numeric code identifying the geographic region where the install originated, based on IP lookup. string yes 32
kochava_click_id Click ID assigned by Kochava. string no longtext
partner_click_id Click ID as received from the partner. string yes longtext
reengagement_tier The tier/segment to which the reengagement is associated. string yes 100
traffic_click_verification_status Indicator if the click traffic was valid or invalid based on Traffic Verification rules. json (strings) yes 16
traffic_install_verification_status Indicator if the install traffic was valid or invalid based on Traffic Verification rules. json (strings) yes 20

 

NOTE: Some columns within the report may contain JSON encoded data. These columns will have “*_querystring” versions that will provide a URL QueryString encoded version of these columns. The JSON path for each value in the JSON will be used as the querystring key for that value.


Reengagement Report

 

Field Name Description Type May be
Null
Character
Limit
kochava_click_id Click ID assigned by Kochava. string yes longtext
device_id_kochava Kochva generated Unique ID assigned to device. string no 60
reengage_event_date_utc Date and time of the event (Coordinated Universal Time). string (datetime) no datetime
reengage_event_date_adjusted Date and time of the event (Selected Time Zone). string (datetime) no datetime
reengage_click_month The numeric value of the month the click was received. string (int) no 1
reengage_click_date_utc Date and time of the click (Coordinated Universal Time). string (datetime) no datetime
reengage_click_date_adjusted Date and time of the click (Selcted Time Zone). string (datetime) no datetime
reengage_event_name The name of the advertiser defined and integrated event for reengagement. string yes 128
reengage_status Indicator to define if the click has been matched to an event for reengagment. string no 16
reengage_network The Kochava-specific ID of the Network to which the reengagment originated. string (int) no 11
reengage_network_name The name of the Network to which the reengagment originated. string yes 256
reengage_tracker The Kochava-specific ID of the tracker to which the reengagment originated. string (int) no 20
reengage_tracker_name The user defined name for the tracker to which the reengagment originated. string yes 100
reengage_campaign The Kochava-specific ID of the campaign to which the reengagment was attributed. string no 20
reengage_campaign_name The user defined name for the campaign to which the reengagement was attributed. string yes 255
reengage_site Identifies the site to which the reengagment was served within the publisher partner. string yes 512
reengage_creative Data received on reengagment in the creative_id parameter. string yes 128
reengage_country_code 2-digit country designation where the reengagment originated, based on IP lookup. string yes 2
reengage_device_ver The device type and version of the device received on reengagement. string yes 128
reengage_device_id The primary device ID received on reengagment. string yes 20
reengage_original_request Raw URL which was received for specific reengagment.

NOTE: API call will return data in JSON format.

string no longtext
reengage_matched_impression ID representation of the impression which the reengagment was matched to. string (int) yes 20
reengage_matched_install ID representation of the install which matched to the reengagment. string (int) no 20
reengage_identifiers Identifiers available for attribution on the reengagement. string yes text
reengage_duplicate The ID assigned to duplicate rengagments. string (int) yes 20
click_original_request Raw URL which was received for specific click.

NOTE: API call will return data in JSON format.

string no longtext
reengagegeo_continent_code 2-digit continent designation where the reengagment originated, based on IP lookup. string yes 2
reengagegeo_country_code 2-digit country designation where the reengagment originated, based on IP lookup. string yes 2
reengagegeo_country_code3 3-digit country designation where the reengagment originated, based on IP lookup. string yes 3
reengagegeo_country_name The name of the country where the reengagment originated, based on IP lookup. string yes 32
reengagegeo_region An alpha-numeric code identifying the geographic region where the reengagement originated, based on IP lookup. string yes 32
reengagegeo_postal_code The postal code of the region where the reengagement originated, based on IP lookup. string (int) yes 16
reengagegeo_dma_code The code for the designated marketing area where the reengagment originated, based on IP lookup. string (int) yes 16
reengagegeo_city The name of the city where the reengagement originated, based on IP lookup. string yes 32
reengagegeo_area_code The area code where the reengagement originated, based on IP lookup. string (int) yes 16
reengagegeo_longitude The longitude where the reengagement originated, based on IP lookup. string (float) yes 18,14
reengagegeo_latitude The latitude where the reengagment originated, based on IP lookup. string (float) yes 18,14
attribution_tier The tier/segment to which the attribution is associated. string yes 100
click_tier The tier/segment to which the click is associated. string yes 100
impression_tier The tier/segment to which the impression is associated. string yes 100
reengagement_tier The tier/segment to which the reengagement is associated. string yes 100

 

NOTE: Some columns within the report may contain JSON encoded data. These columns will have “*_querystring” versions that will provide a URL QueryString encoded version of these columns. The JSON path for each value in the JSON will be used as the querystring key for that value.


Campaign Summary Report

The Campaign Summary Report provides a granular level of reporting and segment by campaign.

 

Field Name Description Type May be Null
datetime_utc The date and time of install (Coordinated Universal Time). string (datetime) no
datetime_adjusted The date and time of install (Selected Time Zone). string (datetime) no
network The Kochava-specific ID of the Network to which the install is attributed. string (int) yes
network_name The name of the Network to which the install is attributed. string yes
campaign The Kochava-specific ID of the campaign to which the install was attributed. string (int) no
campaign_name The user defined name for the campaign to which the install was attributed. string yes
tracker The Kochava-specific ID of the tracker to which the install was attributed. string (int) no
tracker_name The user defined name for the tracker to which the install was attributed. string yes
site The site on which the campaign was run. string yes
creative The user defined name of the creative used in the campaign. string yes
dma The code for the designated marketing area where the install originated, based on IP lookup. string (int) yes
state An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup. string yes
city The name of the city to which the install is attributed. string yes
click_count The total number of clicks during the selected time frame. string (int) no
click_matched_to_imp_count The total number of clicks matched to impressions. string (int) no
click_duplicate_count The total number of duplicate clicks during the selected time frame. string (int) no
click_spend Money spent per click, based on data received on the click. string (float) no
install_count The number of install of the app during the selected time frame. sting (int) no
install_matched_to_click_count The number of clicks matched to installs for the selected time frame. string (int) no
install_matched_to_imp_count The number of impressions matched to installs for the selected time frame. string (int) no
install_spend Money spent per install, based on data received on the install. string (float) no
impression_count The number of impressions during the selected time frame. string (int) no
impression_spend Money spent per impression, based on data received on the click. string (float) no
impression_tv_verified_count The number of impressions that have been checked and verified. string (int) no (0 for null)
click_tv_verified_count The number of clicks that have been checked and verified. string (int) no (0 for null)
impression_tv_failed_count The number of impressions that have been checked and failed. string (int) no (0 for null)
click_tv_failed_count The number of clicks that have been checked and failed. string (int) no (0 for null)

Network Summary Report

The Network Summary Report provides a summary of network performance across a variety of metrics.

 

Field Name Description Type May be Null
datetime_utc The date and time of install (Coordinated Universal Time). string (datetime) no
datetime_adjusted The date and time of install (Selected Time Zone). string (datetime) no
network The Kochava-specific ID of the Network to which the install was attributed. string (int) yes
network_name The name of the Network to which the install was attributed. string yes
campaign The Kochava-specific ID of the campaign to which the install is associated. string (int) no
campaign_name The user defined name of the campaign. string yes
tracker The Kochava-specific ID of the tracker to which the click was attributed. string (int) no
tracker_name The user defined name for the tracker to which the click originated. string yes
site Identifies the site to which the install was served within the publisher partner. string yes
creative The user defined name of the creative used in the campaign. string yes
dma The code for the designated marketing area where the install originated, based on IP lookup. string (int) yes
state An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup. string yes
city The name of the city to which the install is attributed. string yes
country 2-digit country designation where the click originated, based on IP lookup. string yes
click_count The total number of clicks during the selected time frame. string (int) no
click_matched_to_imp_count The number of impressions matched to clicks for the selected time frame. string (int) no
click_duplicate_count The total number of duplicate clicks during the selected time frame. string (int) no
click_spend Total spend data received on the click string (float) yes
install_count The number of installs of the app during the selected time frame. string (int) no
install_matched_to_click_count The number of clicks matched to installs for the selected time frame. string (int) no
install_matched_to_imp_count The number of impressions matched to installs for the selected time frame. string (int) no
install_spend Money spent per install, based on data received on the install. string (float) no
impression_count The number of impressions of the app during the selected time frame. string(int) no
impression_spend Total spend data received on the impression string (float) yes
impression_tv_verified_count The number of impressions that have been checked and verified. string (int) no (0 for null)
click_tv_verified_count The number of clicks that have been checked and verified. string (int) no (0 for null)
impression_tv_failed_count The number of impressions that have been checked and failed. string (int) no (0 for null)
click_tv_failed_count The number of clicks that have been checked and failed. string (int) no (0 for null)

 
 

Last Modified: May 17, 2017 at 8:57 am