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, Cost and SKAdNetwork.

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.

NOTE: There are several sources of Restricted data you will see across views in Query, Reporting and Analytics. This is data the media channel prohibits Kochava from sharing at the row level, but you will find the channel information contained in your summary reporting. Please reach out to your Kochava Client Success Management Team for more information.

 

IMPORTANT NOTE: Latitude and Longitude values are populated based on a 3rd party IP lookup service and are associated with a general city center location.

Audience Export

The Audience Export report provides a list of audience device IDs in either CSV or JSON format based upon audience filter setup with Analytics. Audience Export reports can be setup as a onetime report or repeatedly on a daily, weekly or monthly basis.

NOTE: For more information about creating filters within Kochava Analytics, refer to our Analytics Page Tools support documentation.

NOTE: Fore more information about pulling a Audience Export report, refer to out Pulling Reports support documentation.

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

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

NOTE: API call will return data in JSON format.
string
 ✔
click_price The price per click.
string (float)
 ✔
click_from_qr_code The total number of clicks generated from the qr code during the selected time frame.
int
click_site Identifies the site to which the click was served within the publisher partner.
string
 ✔
click_status Indicator to define if the click has simply been received (publish) or matched to an install.
string
click_tier The tier/segment to which the click is associated.
string
 ✔
click_tracker The Kochava-specific ID of the tracker to which the click originated.
string (int)
click_tracker_name The user defined name for the tracker to which the click originated.
string
 ✔
clickgeo_area_code The area code where the click originated, based on IP lookup.
string (int)
 ✔
clickgeo_city The name of the city where the click originated, based on IP lookup.
string
 ✔
clickgeo_continent_code The region where the click originated, based on IP lookup.
string
 ✔
clickgeo_country_code 2-digit country designation where the click originated, based on IP lookup.
string
 ✔
clickgeo_country_code3 3-digit country designation where the click originated, based on IP lookup.
string
 ✔
clickgeo_country_name The name of the country where the click originated, based on IP lookup.
string
 ✔
clickgeo_dma_code The code for the designated marketing area where the click originated, based on IP lookup.
string (int)
 ✔
clickgeo_latitude The latitude where the click originated, based on IP lookup.

Latitude values are populated based on a 3rd party IP lookup service and are associated with a general city center location.
string (float)
 ✔
clickgeo_longitude The longitude where the click originated, based on IP lookup.

Longitude values are populated based on a 3rd party IP lookup service and are associated with a general city center location.
string (float)
 ✔
clickgeo_postal_code The postal code of the region where the click originated, based on IP lookup.
string (int)
 ✔
clickgeo_region An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup.
string
 ✔
impression_campaign The Kochava-specific ID of the campaign to which the click was attributed.
string (int)
 ✔
impression_campaign_name The user defined name for the campaign to which the click was attributed.
string
 ✔
impression_country_code 2-digit country designation where the impression originated, based on IP lookup.
string
 ✔
impression_creative Data received on impression in the creative_id parameter.
string
 ✔
impression_date_adjusted The date the impression occurred (Selected Time Zone).
string (date)
 ✔
impression_date_utc The date the impression occurred in UTC.
string (date)
 ✔
impression_device_ver The device type and version of the device received on impression.
string
 ✔
impression_identifiers An array of all device identifiers received on the impression.
json (strings)
 ✔
impression_imp_id Unique identifier associated with the impression which has been received.
string (int)
 ✔
impression_ip The IP address from which the impression originated.
string
 ✔
impression_kochava_imp_id Kochava generated unique identifier associated with the impression which has been received.
string
 ✔
impression_matched_click ID representation of the click which the impression was matched to.
string (int)
 ✔
impression_matched_install ID representation of the install which matched to the impression.
string (int)
 ✔
impression_network The Kochava-specific ID of the Network to which the impression originated.
string (int)
 ✔
impression_network_name The name of the Network to which the impression originated.
string
 ✔
impression_original_request Raw URL which was received for specific impression.

NOTE: API call will return data in JSON format.
string
 ✔
impression_site Identifies the site to which the impression was served within the publisher partner.
string
 ✔
impression_tracker The Kochava-specific ID of the tracker to which the impression was attributed.
string (int)
 ✔
impression_tracker_name The user defined name for the tracker to which the click was attributed.
string
 ✔
kochava_click_id Click ID assigned by Kochava.
string
 ✔
partner_click_id Click ID as received from the partner.
string
 ✔
reengagement_tier The tier/segment to which the reengagement is associated.
string
 ✔
traffic_click_verification_status Indicator if the click traffic was valid or invalid based on Traffic Verification rules.
json (string)
 ✔
traffic_verification_status Indicator if the click traffic was valid or invalid based on Traffic Verification rules.
string
 ✔
click_att The device ATT status.
string
 ✔
click_att_detail ATT status 1 –
authorized

ATT status 0 –
was prompted and answered no
notDetermined
user was not prompted
restricted
user cannot be prompted due to global or app level setting
string
 ✔
click_att_time User response timestamp.
string (datetime)
 ✔
click_att_duration_sec
string (datetime)
 ✔

NOTE: Some columns within the report may contain JSON encoded data. “_querystring” can be appended to the column name to 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.

The Click MTA Report provides a row-level view of the influencers that led to a click for a given campaign. (see iOS 14+ restrictions)

Field Name Description
Type
May be Null
install_id The internally generated unique ID to which the install is attributed.
string (int)
install_date_utc Date and time of install (Coordinated Universal Time).
string (datetime)
install_date_adjusted Date and time of install (Selected Time Zone).
string (datetime)
clickwin_id The ID of the click that won attribution.
string (int)
clickwin_network The ID of the network awarded the winning click.
string (int)
clickwin_network_name The name of the network awarded the winning click.
string
 ✔
clickwin_site Identifies the site to which the winning click was served within the publisher partner.
string
 ✔
clickwin_creative_id The ID/name of the creative which drove the winning click.
string
 ✔
clickwin_date_utc Date and time of the winning click (Coordinated Universal Time).
string (datetime)
clickwin_date_adjusted Date and time of the winning click (Selected Time Zone).
string (datetime)
clickwin_matched_on Provides the actual piece of data that the click was matched on; that is, the device ID.
string
clickwin_match_type The ID type to which the winning click is attributed.
string
clickwin_from_qr_code The total number of winning clicks generated from the qr code during the selected time frame.
int
influencer_id Unique identifier associated with the influencer which has been received.
string (int)
influencer_network The ID of the network which influenced the winning click.
string (int)
 ✔
influencer_network_name The name of the network which influenced the winning click.
string
 ✔
inf_site Identifies the site to which the influencer was served within the publisher partner.
string
 ✔
inf_creative_id The ID/name of the creative which influenced the click.
string
 ✔
influencer_date_utc Date and time the influencer was served (Coordinated Universal Time).
string (datetime)
influencer_date_adjusted Date and time the influencer was served (Selected Time Zone).
string (datetime)
influencer_matched_on Provides the actual piece of data the influencer was matched on; for example, the device ID.
string
influencer_match_type Description of how we matched the install to the influencer; for example, device ID, Facebook, etc
string
kochava_click_id Click ID assigned by Kochava.
string
 ✔
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

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.

NOTE: exclude0rows has been added to the Traffic Including filter which removes rows without data which can significantly decreasing the size of this report.

Field Name Description
Type
May be Null
job_id The Kochava-specific ID of the Cost Configuration job.
string
configuration_name The user-defined name for the Cost Configuration.
string
cost_date The network defined 24 hour period for the cost window.
datetime
date_from_UTC The UTC start date of the cost window.
datetime
date_to_UTC The UTC end date of the cost window.
datetime
network_partner_id The ID of the company networks e.g., unity ios, unity android, etc., are all under the same ID.
string (int)
network_partner_name The name of the network the configuration is associated to.
string
platform The device platform.
string
 ✔
ad_account The client advertiser account with the network company.
string
 ✔
partner_campaign_name The user-defined name to which the configuration is associated to at the network level.
string
partner_campaign_id The user-defined ID of the campaign the configuration is associated to at the network level.
string
country The country code retrieved by Kochava from the network.
string
 ✔
creative_name The name representing the ad creative served by the network.
string
 ✔
creative_id The ID representing the ad creative served by the network.
string
 ✔
ad_type The type of ad being served by the network.
string
 ✔
ad_size The dimensions of the ad being served by the network.
string
 ✔
site_name The internal code (name or ID) used by the network for the site to which the campaign is associated to.
string
 ✔
site_id The internal ID used by the network for the site to which the campaign is associated to.
string
 ✔
total_impressions The number of impressions associated with the configuration.
number
total_clicks The total number of clicks associated with the configuration.
number
total_installs The total number of installs associated with the configuration.
number
original_total_spend The total spend in the user-defined currency at the network level.
number
original_currency The original currency for the associated configuration.
string
total_spend_usd The total spend in USD.
number
network_timezone The timezone reported by the network.
string
collected_day_after How many day after the cost date, Kochava retrieved the cost data.
number
time_collected The datetime when Kochava retrieved the cost data.
datetime
sub_campaign_name The name of the sub-campaign level layer as specified in the media partner’s dashboard. May represent ad group, ad set, line item, etc.
string
sub_campaign_id The ID of the sub-campaign level layer as specified in the media partner’s dashboard. May represent ad group, ad set, line item, etc.
string
channel Set at the network level and retrieved by Kochava.
string
sub_site_id The sub-site ID of the app where the ad was served, retrieved from the network.
string
placement_id The ID for the ad location within the app where the ad was served.
string
keyword Campaign keywords.
string
keyword_id The ID for the campaign keywords.
string
bid_strategy The bid strategy defined by the advertiser in the media partner’s dashboard.
string
bid_type Bid type set by the media partner.
string
campaign_objective Objective of campaign set in media partner dashboard.
string

NOTE: exclude0rows has been added to the Traffic Including filter which removes rows without data which can significantly decreasing the size of this report.

Field Name Description
Type
May be Null
Filter
Group
partner_campaign_key Unique identifier associated with the the campaign. Used to join the data sets and is normally the partner_campaign_id. This value may also be the partner_campaign_name in the absence of the partner_campaign_id.
string
 ✔
partner_campaign_name The user-defined name for the Cost Configuration at the network level. Multiple partner campaign names may be present within this field if more than one campaign name is tied to a partner_campaign_id.
string
 ✔ ✔
ko_app_id The numeric ID of the advertiser’s app in Kochava.
string (int)
 ✔
ko_app_name The name of the advertiser’s app within Kochava.
string
 ✔
cost_network_partner_id The numeric ID of the company network partner in Kochava.
string (int)
 ✔
cost_network_partner_name The name of the company network partner in Kochava.
string
 ✔ ✔
cost_total_impressions The total number of impressions for the associated configuration.
number
 ✔
cpm The cost per thousand impressions.
number
 ✔
cost_total_clicks The total number of clicks for the associated configuration
number
 ✔
cpc The cost per click.
number
 ✔
ctr The click-through rate.
number
 ✔
cost_total_installs The total number of installs for the associated configuration reported by the network.
number
 ✔
cpi The cost per install.
number
 ✔
cvr The conversion rate.
number
cost_total_spend_usd The total spend in USD for the associated configuration.
number
 ✔
ko_cpi Cost per Install using Kochava install count.
number
 ✔
ko_total_installs Install count from Kochava measurement data.
number
 ✔
total_events* Count of all events found in Kochava measurement.
number
 ✔
cost_per_event* Cost per Kochava event (total events).
number
 ✔
total_event_users* Distinct user count with an event in Kochava measurement.
number
 ✔
total_revenue_event* Count of revenue flagged events in Kochava measurement.
number
 ✔
total_revenue_users* Distinct user count with a revenue flagged event.
number
 ✔
revenue_per_user* Average value for revenue flagged events.
number
 ✔
revenue_per_user* Average revenue value per distinct user with a revenue event.
number
 ✔
total_revenue_usd* Sum of event value sent on revenue events in USD.
number
 ✔
gross_margin* Total revenue USD – total spend USD/ total revenue USD
number
 ✔
ROAS* total revenue USD / total spend USD
number
 ✔
ltv** Latest event value sent on custom LTV event.
number
 ✔

* Revenue must be added to Traffic Includes.
** LTV must be added to Traffic Includes.

NOTE: exclude0rows has been added to the Traffic Including filter which removes rows without data which can significantly decreasing the size of this report.

Field Name Description
Type
May be Null
Filter
Group
partner_campaign_key Unique identifier associated with the the campaign. Used to join the data sets and is normally the partner_campaign_id. This value may also be the partner_campaign_name in the absence of the partner_campaign_id.
string
partner_campaign_name The user-defined name for the Cost Configuration at the network level. Multiple partner campaign names may be present within this field if more than one campaign name is tied to a partner_campaign_id.
string
 ✔ ✔
cost_network_partner_id The numeric ID of the integrated cost company network partner in Kochava.
number
 ✔
cost_network_partner_name The name of the integrated cost company network partner in Kochava.
string
 ✔ ✔
skad_host_name SKAd report host name
string
 ✔
ko_app_id The numeric ID of the advertiser’s app in Kochava.
string (int)
 ✔
ko_app_name The name of the advertiser’s app within Kochava.
string
 ✔
skad_total_installs Count of SKAdNetwork-reported installs.
number
 ✔
skad_total_redownload_installs Count of SKAdNetwork-reported installs that were flagged as redownloads by SKAdNetwork.
number
 ✔
cost_original_currency The original currency for the associated configuration.
string
 ✔
cost_total_impressions The total number of impressions for the associated configuration retrieved from the network.
number
 ✔
cost_total_clicks The total number of clicks for the associated configuration retrieved from the network.
number
 ✔
cost_total_installs The total number of installs for the associated configuration reported by the network.
string (int)
 ✔
cost_original_total_spend The total spend in the user-defined currency at the network level.
number
 ✔
cost_total_spend_usd The total spend in USD.
number
 ✔
cpm The cost per thousand impressions.
number
 ✔
cpc The cost per click.
number
 ✔
ctr The click-through rate.
number
 ✔
cpi The cost per install.
number
 ✔
ipm Install per mille, the number of times your app or game is installed per thousand ad impressions.
number
 ✔

Field Name Description
Type
May be Null
Filter
Group
configuration_name The user-defined name for the Cost Configuration.
string
 ✔
cost_date The network defined 24 hour period for the cost window.
datetime
date_from_UTC The UTC start date of the cost window.
datetime
date_to_UTC The UTC end date of the cost window.
datetime
network_partner_id The ID of the company networks e.g., unity ios, unity android, etc., are all under the same ID.
string (int)
network_partner_name The name of the network the configuration is associated to.
string
 ✔
platform The device platform.
string
 ✔
ad_account The client advertiser account with the network company.
string
 ✔
partner_campaign_name The user-defined name to which the configuration is associated to at the network level.
string
 ✔
partner_campaign_id The user-defined ID of the campaign the configuration is associated to at the network level.
string
country The country code retrieved by Kochava from the network.
string
 ✔
creative_name The name representing the ad creative served by the network.
string
 ✔
creative_id The ID representing the ad creative served by the network.
string
 ✔
ad_type The type of ad being served by the network.
string
 ✔
ad_size The dimensions of the ad being served by the network.
string
 ✔
site_name The name of the site to which the campaign is associated to.
string
 ✔
site_id The internal ID used by the network for the site to which the campaign is associated to.
string
 ✔
network_timezone The timezone reported by the network.
string
sub_campaign_name The name of the sub-campaign level layer as specified in the media partner’s dashboard. May represent ad group, ad set, line item, etc.
string
 ✔
sub_campaign_id The ID of the sub-campaign level layer as specified in the media partner’s dashboard. May represent ad group, ad set, line item, etc.
string
 ✔
channel Set at the network level and retrieved by Kochava.
string
sub_site_id TThe sub-site ID of the app where the ad was served, retrieved from the network.
string
 ✔
placement_id The ID for the ad location within the app where the ad was served.
string
 ✔
keyword Campaign keywords.
string
 ✔
keyword_id The ID for the campaign keywords.
string
bid_strategy The bid strategy defined by the advertiser in the media partner’s dashboard.
string
 ✔
bid_type Bid type set by the media partner.
string
 ✔
campaign_objective Objective of campaign set in media partner dashboard.
string
 ✔
original_currency The original currency for the associated configuration.
string
original_total_spend The total spend in the user-defined currency at the network level.
number
 ✔
total_spend_USD The total spend in USD.
number
total_impressions The number of impressions associated with the configuration.
number
total_clicks The total number of clicks associated with the configuration.
number
total_installs The total number of installs associated with the configuration.
number
cpm The cost per thousand impressions.
number
 ✔
cpc The cost per click.
number
 ✔
ctr The click-through rate.
number
 ✔
cpi The cost per install.
number
 ✔
ipm Install per mille, the number of times your app or game is installed per thousand ad impressions.
number
 ✔

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

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

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

NOTE: API call will return data in JSON format.
string
 ✔
click_from_qr_code The total number of clicks generated from the qr code during the selected time frame.
integer
click_site Identifies the site to which the click was served within the publisher partner.
string
 ✔
click_status Indicator to define if the click has simply been received (publish) or matched to an install.
string
 ✔
click_tracker The Kochava-specific ID of the tracker to which the click originated.
string (int)
 ✔
click_tracker_name The user defined name for the tracker to which the click originated.
string
 ✔
clickgeo_area_code The area code where the click originated, based on IP lookup.
string (int)
 ✔
clickgeo_city The name of the city where the click originated, based on IP lookup.
string
 ✔
clickgeo_continent_code 2-digit continent designation where the click originated, based on IP lookup.
string
 ✔
clickgeo_country_code 2-digit country designation where the click originated, based on IP lookup.
string
 ✔
clickgeo_country_code3 3-digit country designation where the click originated, based on IP lookup.
string
 ✔
clickgeo_country_name The name of the country where the click originated, based on IP lookup.
string
 ✔
clickgeo_dma_code The code for the designated marketing area where the click originated, based on IP lookup.
string
 ✔
clickgeo_latitude The latitude where the click originated, based on IP lookup.

Latitude values are populated based on a 3rd party IP lookup service and are associated with a general city center location.
string (float)
 ✔
clickgeo_longitude The longitude where the click originated, based on IP lookup.

Longitude values are populated based on a 3rd party IP lookup service and are associated with a general city center location.
string (float)
 ✔
clickgeo_postal_code The postal code of the region where the click originated, based on IP lookup.
string (int)
 ✔
clickgeo_region An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup.
string
 ✔
count Number of events (based on selection) during defined time frame.
integer
custom_dimensions Custom provided dimensions received with the event.
array (string)
 ✔
device_id_adid Raw ADID provided on the event (Android specific).
string
 ✔
device_id_android_id Raw Android_ID received on the event (Android specific).
string
 ✔
device_id_custom Custom provided identifier received with the event .
string
 ✔
device_id_idfa Raw IDFA provided on the event (iOS specific)
string
 ✔
device_id_idfv Raw IDFV provided on the event (iOS specific)
string
 ✔
device_id_kochava Kochva generated Unique ID assigned to device.
string
device_os The operating system of the device.
string
 ✔
device_type The device type of the device.
string
 ✔
device_version The device version of the mobile device.
string
 ✔
dimension_count Number of custom events (based on selection).
integer
dimension_data Data provided dimensions received with the event.
string
 ✔
dimension_sum The sum of event data.
float
 ✔
event_name The name of the advertiser defined and integrated event.
string
 ✔
event_time_registered The time that the event was performed by the mobile device.
string
geo_city The name of the city where the event originated, based on IP lookup.
string
 ✔
geo_country The two digit code where the event originated, based on IP lookup.
string
 ✔
geo_lat The latitude where the event originated, based on IP lookup.

Latitude values are populated based on a 3rd party IP lookup service and are associated with a general city center location.
string
 ✔
geo_lon The longitude where the event originated, based on IP lookup.

Longitude values are populated based on a 3rd party IP lookup service and are associated with a general city center location.
string (float)
 ✔
geo_region An alpha-numeric code identifying the geographic region where the event originated, based on IP lookup.
string
 ✔
iad.campaign_id The iAd specific campaign ID.
string
 ✔
iad.iad-attribution Indicates whether iAd has claimed and won attribution (1).
string
 ✔
iad.iad-legacy Indicates whether the legacy iAd is attribution logic was utilized (1).
string
 ✔
iad.network_id The Kochava-specific ID of the network to which the iAd attribution is attributed.
string
 ✔
identity_link A customer defined unique identifier for linking devices.
string
 ✔
impression_campaign The Kochava-specific ID of the campaign to which the impression is associated.
string (int)
 ✔
impression_campaign_name The user defined name for the campaign to which the impression is associated.
string
 ✔
impression_country_code 2-digit country designation where the impression originated, based on IP lookup.
string
 ✔
impression_creative The ID/name of the creative which was served with the impression.
string
 ✔
impression_date_adjusted The date the impression occurred (Selected Time Zone).
string (date)
 ✔
impression_date_utc Date and time of the impression (Coordinated Universal Time).
string (date)
 ✔
impression_device_ver The device type and version of the device which received on impression.
string
 ✔
impression_identifiers An array of all device identifiers received on the impression.
json (string)
 ✔
impression_imp_id Unique identifier associated with the impression which has been received.
string (int)
 ✔
impression_ip The IP address from which the impression originated.
string
 ✔
impression_kochava_imp_id Kochava generated unique identifier associated with the impression which has been received.
string
 ✔
impression_matched_click ID representation of the click which the impression was matched to.
string (int)
 ✔
impression_matched_install ID representation of the install which matched to the impression.
string (int)
 ✔
impression_network The Kochava-specific ID of the Network to which the impression originated.
string (int)
 ✔
impression_network_name The name of the Network to which the impression originated.
string
 ✔
impression_original_request Raw URL which was received for specific impression.

NOTE: API call will return data in JSON format.
string
 ✔
impression_site Identifies the site to which the impression was served within the publisher partner.
string
 ✔
impression_tracker The Kochava-specific ID of the tracker to which the impression is associated.
string (int)
 ✔
impression_tracker_name The user defined name for the tracker to which the impression is associated.
string
 ✔
install_date_adjusted The date the install occurred (Selected Time Zone).
string (datetime)
 ✔
install_date_utc Date and time of the install (Coordinated Universal Time).
string (datetime)
 ✔
install_device_ua User Agent of the device gathered upon install.
string
 ✔
install_device_version The device type and version of the device received on install.
string
 ✔
install_devices_adid Raw ADID provided on the install (Android specific).
string
 ✔
install_devices_android_id Raw Android_ID provided on the install (Android specific).
string
 ✔
install_devices_custom Custom provided identifier received with the install.
string
 ✔
install_devices_email_0 Primary email address delivered with the install.
string
 ✔
install_devices_email_1 Secondary email address delivered with the install.
string
 ✔
install_devices_idfa Raw IDFA provided on the install (iOS specific).
string
 ✔
install_devices_ids An array of the device identifiers received on install.
json (string)
 ✔
install_devices_ip The IP address from which the install originated.
string
 ✔
install_devices_waid Raw WAID received on install (Windows specific).
string
 ✔
install_matched_by Defines the nature of the data point on which the click was matched to the install.
string
 ✔
install_matched_on ID representation of the install which matched to the click.
string
 ✔
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
install_san_original The original Self Attributing Network to which the install is attributed.
string
 ✔
install_status Indicator to define if an install has been simply been received (publish) or matched to a click.
string
is_reengagement Indicator if event is being attributed to the last reengagment.
string (int)
kochava_click_id Click ID assigned by Kochava.
string
 ✔
partner_click_id Click ID as received from the partner.
string
 ✔
request_ip The IP address from which the request originated.
string
 ✔
request_ua User Agent from which the request originated.
string
 ✔
timestamp_adjusted The date and time of the event (Selected Time Zone).
string (datetime)
timestamp_utc The date and time of the event (Coordinated Universal Time).
string (datetime)
 ✔
traffic_click_verification_status Indicator if the click traffic was valid or invalid based on Traffic Verification rules.
json (string)
 ✔
traffic_impression_verification_status Indicator if the impression traffic was valid or invalid based on Traffic Verification rules.
string
 ✔
event_att The device ATT status.
string
 ✔
event_att_detail ATT status 1 –
authorized

ATT status 0 –
was prompted and answered no
notDetermined
user was not prompted
restricted
user cannot be prompted due to global or app level setting
string
 ✔
event_att_time User response timestamp.
string (datetime)
 ✔
event_att_duration_sec
string (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.

NOTE: The “mtr_rejected”:”86400″ flag being present in the custom_dimensions column in an event detail report indicates that that instance of the event did not meet the minimum time to reengagement requirements and that it is not eligible for reengagement. This feature can be configured in the dashboard under the “Events” tab. By default, it is set to 24 hours, which is why you see “mtr_rejected”:”86400”, 86400 = amount of seconds in 24 hours.

Field Name Description
Type
May be Null
fractional_award The percentage awarded to the network for the install.
string (int)
fractional_date the date and time of the install (Coordinated Universal Time).
string (datetime)
fractional_date_adjusted The date and time of the install (Selected Time Zone).
string (datetime)
fractional_id Fractional ID assigned by Kochava.
string (int)
fractional_network The Kochava-specific ID of the Network to which the click originated.
string (int)
fractional_type The identifier by which the fractional attribution was credited.
string
match_id The Kochava-specific ID of the match that won attribution.
string (int)
match_type The identifier by which the fractional attribution was matched.
string
traffic_date Date and Time of traffic (Coordinated Universal Time).
string (datetime)
 ✔
traffic_date_adjusted Date and time of traffic(Selected Time Zone).
string (datetime)
 ✔
traffic_id The Kochava-specific ID of the traffic to which the install was fractional attributed.
string (int)
traffic_month The numeric value of the month the install was received.
string (int)
 ✔
traffic_type The type of traffic the fractional attribution is accredited to.
string

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.

(see iOS 14+ restrictions)

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

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.

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

Field Name Description
Type
May be Null
attribution_campaign The Kochava-specific ID of the campaign to which the the install was attributed.
string
attribution_campaign_name The user defined name for the campaign to which the install was attributed.
string
 ✔
attribution_creative Data received on install in the creative_id parameter.
string
 ✔
attribution_identity_link_bridge_link If true, identity link bridge values helped with the attribution match. If false, identity link bridge did not assist with the attribution match.
string
 ✔
attribution_network The Kochava-specific ID of the Network to which the install was attributed.
string
attribution_network_name The name of the Network to which the install was attributed.
string
 ✔
attribution_site Identifies the site to which the install was attributed within the publisher partner.
string
attribution_tier The tier/segment to which the attribution is associated.
string
 ✔
attribution_tracker The Kochava-specific ID of the tracker to which the install was attributed.
string (int)
attribution_tracker_name The user defined name for the tracker to which the install was attributed.
string
 ✔
click_campaign The Kochava-specific ID of the campaign to which the click was attributed.
string
click_campaign_name The user defined name for the campaign to which the click was attributed.
string
 ✔
click_country_code 2-digit country designation where the click originated, based on IP lookup.
string
 ✔
click_creative Data received on click in the creative_id parameter.
string
 ✔
click_custom_parameters Custom parameters passed with the click.
string
click_device_id An internal identifier used for mapping purposes.
string (int)
 ✔
click_device_ua User Agent of the device gathered upon click.
string
 ✔
click_device_ver The device type and version of the device received on click.
string
 ✔
click_duplicate The ID assigned to duplicate clicks.
string (int)
 ✔
click_identifiers An array of all device identifiers received on the click.
json (string)
 ✔
click_identifiers_adid Raw ADID provided on the click (Android specific).
string
 ✔
click_identifiers_android_id Raw Android_ID received on the click (Android specific).
string
 ✔
click_identifiers_android_id_md5 MD5 encrypted Android_ID received on the click (Android specific).
string
 ✔
click_identifiers_android_id_sha1 SHA1 encrypted Android_ID received on the click (Android specific).
string
 ✔
click_identifiers_custom Custom provided identifier received with the click.
string
 ✔
click_identifiers_email_0 Primary email address delivered with the click.
string
 ✔
click_identifiers_email_1 Secondary email address delivered with the click.
string
 ✔
click_identifiers_idfa Raw IDFA received on the click (iOS specific).
string
 ✔
click_identifiers_ip Raw IP address where the click originated.
string
 ✔
click_identifiers_waid Raw WAID received on the click (Windows specific).
string
 ✔
click_ip The IP address from which the click originated.
string
click_matched_impression ID representation of the impression which the click was matched to.
string (int)
 ✔
click_matched_install ID representation of the install which matched to the click.
string (int)
 ✔
click_month The numeric value of the month the install was received.
string (int)
click_network The Kochava-specific ID of the Network to which the click originated.
string (int)
click_network_name The name of the Network to which the click originated.
string
 ✔
click_from_qr_code The total number of clicks generated from the qr code during the selected time frame.
integer
click_original_request Raw URL which was received for specific click.

NOTE: API call will return data in JSON format.
string
click_site Identifies the site to which the click was served within the publisher partner.
string
 ✔
click_status Indicator to define if the click has simply been received (publish) or matched to an install.
string
click_tier The tier/segment to which the click is associated.
string
 ✔
click_tracker The Kochava-specific ID of the tracker to which the click originated.
string (int)
click_tracker_name The user defined name for the tracker to which the click originated.
string
 ✔
clickgeo_area_code The area code where the click originated, based on IP lookup.
string (int)
 ✔
clickgeo_city The name of the city where the click originated, based on IP lookup.
string
 ✔
clickgeo_continent_code 2-digit continent designation where the click originated, based on IP lookup.
string
 ✔
clickgeo_country_code 2-digit country designation where the click originated, based on IP lookup.
string
 ✔
clickgeo_country_code3 3-digit continent designation where the click originated, based on IP lookup.
string
 ✔
clickgeo_country_name The name of the country where the click originated, based on IP lookup.
string
 ✔
clickgeo_dma_code The code for the designated marketing area where the click originated, based on IP lookup.
string (int)
 ✔
clickgeo_latitude The latitude where the click originated, based on IP lookup.

Latitude values are populated based on a 3rd party IP lookup service and are associated with a general city center location.
string (float)
 ✔
clickgeo_longitude The longitude where the click originated, based on IP lookup.

Longitude values are populated based on a 3rd party IP lookup service and are associated with a general city center location.
string (float)
 ✔
clickgeo_postal_code The postal code of the region where the click originated, based on IP lookup.
string (int)
 ✔
clickgeo_region An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup.
string
 ✔
identity_link A customer defined unique identifier for linking devices.
string
 ✔
impression_campaign The Kochava-specific ID of the campaign to which the impression is associated.
string (int)
 ✔
impression_campaign_name The user defined name for the campaign to which the impression is associated.
string
 ✔
impression_country_code 2-digit country designation where the impression originated, based on IP lookup.
string
 ✔
Account The ID/name of the creative which was served with the impression.
string
 ✔
impression_device_ver The device type and version of the device which received on impression.
string
 ✔
impression_identifiers An array of all device identifiers received on the impression.
json (strings)
 ✔
impression_imp_id Unique identifier associated with the impression which has been received.
string (int)
 ✔
impression_ip The IP address from which the impression originated.
string
 ✔
impression_kochava_imp_id Kochava generated unique identifier associated with the impression which has been received.
string (int)
 ✔
impression_matched_click ID representation of the click which the impression was matched to.
string (int)
 ✔
impression_matched_install ID representation of the install which matched to the impression.
string (int)
 ✔
impression_network The Kochava-specific ID of the Network to which the impression originated.
string (int)
 ✔
impression_network_name The name of the Network to which the impression originated.
string
 ✔
impression_original_request Raw URL which was received for specific impression.

NOTE: API call will return data in JSON format.
string
 ✔
impression_site Identifies the site to which the impression was served within the publisher partner.
string
 ✔
impression_tier The tier/segment to which the impression is associated.
string
 ✔
impression_tracker_name The user defined name for the tracker to which the impression is associated.
string
 ✔
impression_tracker_name The user defined name for the tracker to which the impression is associated.
string
 ✔
install_channel_type The channel type to which the install is attributed.
string
 ✔
install_click_date_adjusted The date and time the click occurred which led to install (Selected Time Zone).
string (datetime)
 ✔
install_click_date_utc The date and time the click occurred which led to install (Coordinated Universal Time).
string (datetime)
 ✔
install_date_adjusted The date and time of install (Selected Time Zone).
string (datetime)
install_date_utc The date and time of install (Coordinated Universal Time).
string (datetime)
 ✔
install_device_ua User Agent of the device gathered upon install.
string
 ✔
install_device_version The device version of the mobile device.
string
 ✔
install_devices_adid Raw ADID provided on install (Android specific).
string
 ✔
install_devices_android_id Raw Android_ID received on install (Android specific).
string
 ✔
install_devices_custom Custom provided identifier received with install.
string
 ✔
install_devices_custom_id Unique identifier associated with the custom provided identifier.
string
 ✔
install_devices_email_0 Primary email address delivered with install.
string
 ✔
click_identifiers_email_1 Secondary email address delivered with the click.
string
 ✔
install_devices_idfa Raw IDFA received on install (iOS specific).
string
 ✔
install_devices_ids An array of all device identifiers received on install.
string
 ✔
install_devices_ip The IP address from which the install originated.
string
 ✔
install_devices_waid Raw WAID received on the click (Windows specific).
string
 ✔
install_impression_date_adjusted The date and time the impression occurred which led to install (Selected Time Zone).
string (datetime)
 ✔
install_impression_date_utc The date and time the impression occurred which led to install (Coordinated Universal Time).
string (datetime)
 ✔
install_kochava_device_id Install ID assigned by Kochava
string
install_matched_by The ID type to which installation is attributed.
string
install_matched_on Unique identifier to which the install is matched on.
string
install_original_request Raw URL which was received for specific install.

NOTE: API call will return data in JSON format.
string
install_price The user defined price per click or price per install.
string (float)
 ✔
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
install_reprocessed_for If a value is present this signifies that the install was a reprocessed install(not the first install from the device).
string
install_status Indicator to define if an install has been simply been received (publish) or matched to a click.
string
installgeo_area_code The area code where the install originated, based on IP lookup.
string (int)
 ✔
installgeo_city The name of the city where the install originated, based on IP lookup.
string
 ✔
installgeo_continent_code 2-digit continent designation where the impression originated, based on IP lookup.
string
 ✔
installgeo_country_code 2-digit continent designation where the install originated, based on IP lookup.
string
 ✔
installgeo_country_code3 3-digit continent designation where the impression originated, based on IP lookup.
string
 ✔
installgeo_country_name The name of the country where the install originated, based on IP lookup.
string
 ✔
installgeo_dma_code The code for the designated marketing area where the install originated, based on IP lookup.
string (int)
 ✔
installgeo_latitude The latitude where the install originated, based on IP lookup.

Latitude values are populated based on a 3rd party IP lookup service and are associated with a general city center location.
string (float)
 ✔
installgeo_longitude The longitude where the install originated, based on IP lookup.

Longitude values are populated based on a 3rd party IP lookup service and are associated with a general city center location.
string (float)
 ✔
installgeo_postal_code The postal code of the region where the install originated, based on IP lookup.
string (int)
 ✔
installgeo_region An alpha-numeric code identifying the geographic region where the install originated, based on IP lookup.
string
 ✔
kochava_click_id Click ID assigned by Kochava.
string
partner_click_id Click ID as received from the partner.
string
 ✔
traffic_click_verification_status Indicator if the click traffic was valid or invalid based on Traffic Verification rules.
json (strings)
 ✔
traffic_install_verification_status Indicator if the install traffic was valid or invalid based on Traffic Verification rules.
json (strings)
 ✔
install_att The device ATT status.
string
 ✔
install_att_detail ATT status 1 –
authorized

ATT status 0 –
was prompted and answered no
notDetermined
user was not prompted
restricted
user cannot be prompted due to global or app level setting
string
 ✔
install_att_time User response timestamp.
string (datetime)
 ✔
install_att_duration_sec
string (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.

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

NOTE: API call will return data in JSON format.
string
reengage_matched_impression ID representation of the impression which the reengagement was matched to.
string (int)
 ✔
reengage_matched_install ID representation of the install which matched to the reengagement.
string (int)
reengage_identifiers Identifiers available for attribution on the reengagement.
string
 ✔
reengage_duplicate The ID assigned to duplicate reengagements.
string (int)
 ✔
click_original_request Raw URL which was received for specific click.

NOTE: API call will return data in JSON format.
string
reengagegeo_continent_code 2-digit continent designation where the reengagement originated, based on IP lookup.
string
 ✔
reengagegeo_country_code 2-digit country designation where the reengagement originated, based on IP lookup.
string
 ✔
reengagegeo_country_code3 3-digit country designation where the reengagement originated, based on IP lookup.
string
 ✔
reengagegeo_country_name The name of the country where the reengagement originated, based on IP lookup.
string
 ✔
reengagegeo_region An alpha-numeric code identifying the geographic region where the reengagement originated, based on IP lookup.
string
 ✔
reengagegeo_postal_code The postal code of the region where the reengagement originated, based on IP lookup.
string (int)
 ✔
reengagegeo_dma_code The code for the designated marketing area where the reengagement originated, based on IP lookup.
string (int)
 ✔
reengagegeo_city The name of the city where the reengagement originated, based on IP lookup.
string
 ✔
reengagegeo_area_code The area code where the reengagement originated, based on IP lookup.
string (int)
 ✔
reengagegeo_longitude The longitude where the reengagement originated, based on IP lookup.

Longitude values are populated based on a 3rd party IP lookup service and are associated with a general city center location.
string (float)
 ✔
reengagegeo_latitude The latitude where the reengagement originated, based on IP lookup.

Latitude values are populated based on a 3rd party IP lookup service and are associated with a general city center location.
string (float)
 ✔
reengagement_tier The tier/segment to which the reengagement is associated.
string
 ✔
click_from_qr_code The total number of clicks generated from the QR code during the selected time frame.
integer

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.

Field Name Description
Type
May be Null
starting_date The date and time that the restated cost data began being collected.
string (datetime)
ending_date The date and time that the restated cost data ended being collected.
string (datetime)
tracker_id The Kochava-specific ID of the tracker to which the restated cost was attributed.
string
cost_network_id The Kochava-specific ID of the network to which the restated cost data is attributed.
string (integer)
 ✔
network_campaign_id Unique identifier associated with the network to which the restated cost data is attributed.
string (integer)
network_campaign_name The user defined name for the campaign to which the restated cost data is attributed.
string
 ✔
type The type of ad being served.
string
 ✔
total_daily_spend_restated_1_Day The total restated daily spend day 1.
string (integer)
 ✔
total_daily_spend_restated_2_Day The total restated daily spend day 2.
string (integer)
 ✔
total_daily_spend_restated_7_Day The total restated daily spend day 7.
string (integer)
 ✔
total_daily_spend_restated_14_Day The total restated daily spend day 14.
string (integer)
 ✔
string
 ✔
total_daily_spend_restated_30_Day The total restated daily spend day 30.
string (integer)
 ✔
total_daily_spend_restated_60_Day The total restated daily spend day 60.
string (integer)
 ✔
device The users device type.
string
 ✔
gender the gender of the user.
string
 ✔
geography The geographic region of the device.
string
 ✔
group_id The campaign or ad group id of the device.
string
 ✔
group_name The campaign or ad group name of the device.
string
 ✔
image The ID/name of the creative which influenced the device.
string
 ✔
name Generic placeholder, used if data not grouped by campaign or ad.
string
 ✔
network_ad_id The ID for the network ad.
string
string
 ✔
platform The device platform.
string
 ✔
target The user group which the ad or campaign is targeting.
string
 ✔
url The raw URL which was received from the device.
string
 ✔
api_groupby The grouping of data returned by the network’s API.
string
 ✔

The insight report is delivered in two reports, the first is the buy report which details the impressions that are performing stronger than the established median, and the donotbuy which details the impressions that are performing weaker than the established median. The insight reports will be delivered inside a zipped folder.

Field Name Description
Type
May be Null
RuleID The unique rule ID which can be used for reference in the full optimization rule set.
string (integer)
AppID The app ID assigned by Kochava.
string (integer)
NetworkID The Kochava-specific ID of the Network to which the impression originated.
string (integer)
NetworkName The name of the Network to which the impression originated.
string
TrackerName The user defined name for the tracker to which the impression was attributed.
string
Value The value of the targeted data point.
string
Value The value of the targeted data point.
string
NumberImpressions The number of impressions served matching that rule.
string (integer)
FullSetLift The expected lift. Historical conversion rate divided by expected conversion rate. This lift will only be reached if implementing the full optimization rule set.
string

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)
datetime_adjusted The date and time of install (Selected Time Zone).
string (datetime)
network The Kochava-specific ID of the Network to which the install is attributed.
string (integer)
 ✔
network_name The name of the Network to which the install is attributed.
string
 ✔
campaign The Kochava-specific ID of the campaign to which the install was attributed.
string (integer)
campaign_name The user defined name for the campaign to which the install was attributed.
string
 ✔
tracker The Kochava-specific ID of the tracker to which the install was attributed.
string (integer)
tracker_name The user defined name for the tracker to which the install was attributed.
string
 ✔
site The site on which the campaign was run.
string
 ✔
creative The user defined name of the creative used in the campaign.
string
 ✔
dma The code for the designated marketing area where the install originated, based on IP lookup.
string (integer)
 ✔
state An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup.
string
 ✔
city The name of the city to which the install is attributed.
string
 ✔
country 2-digit country designation where the click originated, based on IP lookup.
string
 ✔
cp_0 to cp_9 Custom parameters passed with the click.
string
click_count The total number of clicks during the selected time frame.
string (integer)
click_matched_to_imp_count The total number of clicks matched to impressions.
string (integer)
click_duplicate_count The total number of duplicate clicks during the selected time frame.
string (integer)
click_spend Money spent per click, based on data received on the click.
string (float)
install_count The number of install of the app during the selected time frame.
string (integer)
install_matched_to_click_count The number of clicks matched to installs for the selected time frame.
string (integer)
install_matched_to_imp_count The number of impressions matched to installs for the selected time frame.
string (integer)
install_matched_to_click_from_qrcode_count The number of qr codes clicks matched to installs for the selected time frame.
string (integer)
install_spend Money spent per install, based on data received on the install.
string (float)
impression_count The number of impressions during the selected time frame.
string (integer)
impression_spend Money spent per impression, based on data received on the click.
string (float)
click_from_qrcode_count The total number of clicks generated from the QR code during the selected time frame.
integer
total_spend_on_traffic_selected Assuming you select click and impression or install, this is what we have calculated as the total spent for that network for the given type of traffic
string (integer)
total_spend_network_reported This is what the network has told Kochava via the API how much was spent in total for the network. It is required to have the Kochava tracker GUIDs entered in the network_campaign_name within the network dashboard, if tracker GUID is not entered, then this field is blank.
**need to include “network_spend” as part of the traffic array in order for column to be returned**
string (integer)

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)
datetime_adjusted The date and time of install (Selected Time Zone).
string (datetime)
network The Kochava-specific ID of the Network to which the install was attributed.
string (integer)
 ✔
network_name The name of the Network to which the install was attributed.
string
 ✔
campaign The Kochava-specific ID of the campaign to which the install is associated.
string (integer)
campaign_name The user defined name of the campaign.
string
 ✔
tracker The Kochava-specific ID of the tracker to which the click was attributed.
string (integer)
tracker_name The user defined name for the tracker to which the click originated.
string
 ✔
site Identifies the site to which the install was served within the publisher partner.
string
 ✔
creative The user defined name of the creative used in the campaign.
string
 ✔
dma The code for the designated marketing area where the install originated, based on IP lookup.
string (integer)
 ✔
state An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup.
string
 ✔
city The name of the city to which the install is attributed.
string
 ✔
country 2-digit country designation where the click originated, based on IP lookup.
string
 ✔
click_count The total number of clicks during the selected time frame.
string (integer)
click_matched_to_imp_count The number of impressions matched to clicks for the selected time frame.
string (integer)
click_duplicate_count The total number of duplicate clicks during the selected time frame.
string (integer)
click_spend Total spend data received on the click
string (float)
 ✔
install_count The number of installs of the app during the selected time frame.
string (integer)
install_matched_to_imp_count The number of impressions matched to installs for the selected time frame.
string (integer)
install_matched_to_imp_count The number of impressions matched to installs for the selected time frame.
string (integer)
install_spend Money spent per install, based on data received on the install.
string (float)
impression_count The number of impressions of the app during the selected time frame.
string (integer)
click_from_qrcode_count The total number of clicks generated from the QR code during the selected time frame.
integer
install_matched_to_click_from_qrcode_count The number of qr codes clicks matched to installs for the selected time frame.
string (integer)
total_spend_network_reported This is what the network has told Kochava via the API how much was spent in total for the network. It is required to have the Kochava tracker GUIDs entered in the network_campaign_name within the network dashboard, if tracker GUID is not entered, then this field is blank.

**need to include “network_spend” as part of the traffic array in order for column to be returned**
string (integer)
total_spend_on_traffic_selected Assuming you select click and impression or install, this is what we have calculated as the total spent for that network for the given type of traffic
string (integer)

Identify how many users are active within your app by campaign for various time periods after they have installed. The standard retention query shows active users on each day after install (1, 2, 3, 5, 7, 21, 30).

Field Name Description
Type
May be Null
i_network_id The Kochava-specific ID of the Network to which the event was attributed.
string (integer)
i_network_name The name of the Network to which the event originated.
string (integer)
installs The number of installs of the app during the selected time frame.
integer
d1_retention Number of active users exactly 1 day after install.
integer
d2_retention Number of active users exactly 2 days after install.
integer
d3_retention Number of active users exactly 3 days after install.
integer
d5_retention Number of active users exactly 5 days after install.
integer
d7_retention Number of active users exactly 7 days after install.
integer
d14_retention Number of active users exactly 14 days after install.
integer
d21_retention Number of active users exactly 21 days after install.
integer
d30_retention Number of active users exactly 30 days after install.
integer

Identify how many users are active within your app by campaign for various time periods after they have installed. The windowed retention query shows how many users are active in each window representing days after install (1, 2, 3, 4-5, 6-7, 8-14, 15-21, 22-30).

Field Name Description
Type
May be Null
i_network_id The Kochava-specific ID of the Network to which the event was attributed.
string (integer)
i_network_name The name of the Network to which the event originated.
string (integer)
installs The number of installs of the app during the selected time frame.
integer
d1_retention Number of active users exactly 1 day after install.
integer
d2_retention Number of active users exactly 2 days after install.
integer
d3_retention Number of active users exactly 3 days after install.
integer
d5_retention Number of active users between 4 and 5 days after install.
integer
d7_retention Number of active users between 6 and 7 days after install.
integer
d14_retention Number of active users between 8 and 14 days after install.
integer
d21_retention Number of active users between 15 and 21 days after install.
integer
d30_retention Number of active users between 22 and 30 days after install.
integer

This report provides an aggregated summary of user conversion values sourced from SKAdNetwork signals. Provides meaning of conversion values based on the app’s conversion model setting.

Field Name Description
Type
May be Null
Filter
Group
date_range_start_utc The start date for sk_installs based on install date and impression/click counts.
datetime
 ✔ ✔
date_range_end_utc The end date for sk_installs based on install date and impression/click counts.
datetime
 ✔ ✔
ko_account_name The name of the advertiser’s account within Kochava.
string
ko_account_id The numeric ID of the advertiser’s account in Kochava.
number
advertiser_app_store_id The numeric ID of the app on the app store.
number
ko_app_name The name of the advertiser’s app in Kochava.
string
ko_app_id The numeric ID of the advertiser’s app in Kochava.
number
ko_app_guid The GUID of the advertiser’s app in Kochava.
string
sk_version The version of the SKAdNetwork API.
number
sk_ad_network_id The ID assigned to the media partner by Apple when integrating with SKAdNetwork.
string
 ✔ ✔
ko_media_partner_name The name of the integrated media partner in Kochava.
string
 ✔ ✔
ko_media_partner_id The numeric ID of the integrated media partner in Kochava.
number
 ✔
sk_campaign_id The numeric ID of the campaign was reported to SKAdNetwork on the loadproduct call. Integer between 1 and 100.
number
 ✔ ✔
campaign_name The name of the campaign as specified in the media partner’s dashboard.
string
 ✔ ✔
conversion_model The name of the conversion model chosen on the SKAdNetwork Settings page in Kochava.
string
measurement_window The length of time the user’s activity was observed (in days). Values can be: Undefined, Install Only, D0, D0-1, D0-2, D0-3, D0-4, D0-5, D0-6, D0-7 D0 = within 24 hrs of install.
string
conversion_value_description The meaning of the conversion value based on the conversion model used; reflects the user’s activity in the app after install.

Highest Value Event: single event name

User Journey: list of comma separated event names

Revenue: range of revenue in USD

Engagement: number of times the target event occurred and the target event name

string
conversion_value The user’s numerical conversion value. Integer between 0-63.
number
exchange_id The ID of the ad exchange that served the bid request.
string
 ✔
sk_publisher_app_store_id The numeric ID of the app on the app store, where the ad was served.
number
 ✔ ✔
site_id The site ID of the app where the ad was served, shared by the media partner on the ad signal.
string
 ✔
sub_site_id The sub-site ID of the app where the ad was served, shared by the media partner on the ad signal.
string
 ✔
campaign_id The ID of the campaign as specified in the media partner’s dashboard.
string
 ✔
sub_campaign_name The name of the sub-campaign level layer as specified in the media partner’s dashboard. May represent ad group, ad set, line item, etc.
string
 ✔
sub_campaign_id The ID of the sub-campaign level layer as specified in the media partner’s dashboard. May represent ad group, ad set, line item, etc.
string
 ✔
bid_amount Amount the advertiser bid for the ad to be served.
string
 ✔
bid_currency Currency of bid amount.
string
 ✔
bid_strategy The bid strategy defined by the advertiser in the media partner’s dashboard.
string
 ✔
bid_type Bid type set by the media partner.
string
 ✔
campaign_objective Objective of campaign set in media partner dashboard.
string
 ✔
campaign_status Status of a campaign in the media partner dashboard.
string
 ✔
creative_id The numerical id representing the ad creative served.
string
 ✔
creative_name The name representing the ad creative served.
string
 ✔
keyword The keyword searched by the user that clicked the ad.
string
 ✔
country Parameter passed by the media partner to Kochava in the payload.
string
 ✔ ✔
sk_country If the payload has an IP address field, it is the country associated to that IP. If no IP field in the payload, it is the country of the IP from where the payload was sent to Kochava.
string
 ✔
sk_installs Count of SKAdNetwork-reported installs.
number
sk_redownloads Count of SKAdNetwork-reported installs that were flagged as redownloads by SKAdNetwork.
number

An aggregated summary of user install data sourced from SKAdNetwork signals.

NOTE: Influencers are not included in the default report. To include influencers in your report, select Customize and be sure to add Influencers within the TRAFFIC INCLUDES section.

 

Field Name Description
Type
May be Null
Filter
Group
date_range_start_utc The start date for sk_installs based on install date and impression/click counts.
datetime
 ✔ ✔
date_range_end_utc The end date for sk_installs based on install date and impression/click counts.
datetime
 ✔ ✔
ko_account_name The name of the advertiser’s account within Kochava.
string
ko_account_id The numeric ID of the advertiser’s account in Kochava.
number
advertiser_app_store_id The numeric ID of the app on the app store.
number
ko_app_name The name of the advertiser’s app in Kochava.
string
ko_app_id The numeric ID of the advertiser’s app in Kochava.
number
ko_app_guid The GUID of the advertiser’s app in Kochava.
string
sk_ad_network_id The ID assigned to the media partner by Apple when integrating with SKAdNetwork.
string
 ✔ ✔
ko_media_partner_name The name of the integrated media partner in Kochava.
string
 ✔ ✔
ko_media_partner_id The numeric ID of the integrated media partner in Kochava.
number
 ✔
sk_campaign_id The numeric ID of the campaign was reported to SKAdNetwork on the loadproduct call. Integer between 1 and 100.
number

 ✔ ✔
campaign_name The name of the campaign as specified in the media partner’s dashboard.
string
 ✔ ✔
sk_influencers Count of SKAdNetwork reported influencers.
number
sk_influencer_matched_to_click Count of SKAdNetwork reported click-through influencers.
number
sk_influencer_matched_to_impression Count of SKAdNetwork reported view-through influencers.
number
exchange_id The ID of the ad exchange that served the bid request.
string
 ✔
site_id The site ID of the app where the ad was served, shared by the media partner on the ad signal.
string
 ✔
sub_site_id The sub-site ID of the app where the ad was served, shared by the media partner on the ad signal.
string
 ✔
campaign_id The ID of the campaign as specified in the media partner’s dashboard.
string
 ✔
sub_campaign_name The name of the sub-campaign level layer as specified in the media partner’s dashboard. May represent ad group, ad set, line item, etc.
string
 ✔
sub_campaign_id The ID of the sub-campaign level layer as specified in the media partner’s dashboard. May represent ad group, ad set, line item, etc.
string
 ✔
bid_amount Amount the advertiser bid for the ad to be served.
string
 ✔
bid_currency Currency of bid amount.
string
 ✔
bid_strategy The bid strategy defined by the advertiser in the media partner’s dashboard.
string
 ✔
bid_type Bid type set by the media partner.
string
 ✔
campaign_objective Objective of campaign set in media partner dashboard.
string
 ✔
campaign_status Status of a campaign in the media partner dashboard.
string
 ✔
creative_id The numerical id representing the ad creative served.
string
 ✔
creative_name The name representing the ad creative served.
string
 ✔
keyword The keyword searched by the user that clicked the ad.
string
 ✔
country Parameter passed by the media partner to Kochava in the payload.
string
 ✔ ✔
impressions Count of impressions.
number
clicks Count of clicks.
number
sk_installs Count of SKAdNetwork-reported installs.
number
CTI (%) Percent of SKAdNetwork-reported installs to clicks. Up to 2 decimals
decimal
IPM Installs per Mille. Count of SKAdNetwork-reported installs per 1000 impressions. Up to 4 decimals.
decimal
sk_redownloads Count of SKAdNetwork-reported installs that were flagged as redownloads by SKAdNetwork.
number
inapp_conversion Count of sk_installs where the user triggered an updateConversion call with an in-app action.
number
inapp_conversion_rate (%) Percent of sk_installs where the user triggered an updateConversion call with an in-app action to total sk_installs. Up to 2 decimals.
decimal

Field Name Description
Type
May be Null
entitlement_label The entitlement label(s) associated to entitlement_id set up by the user in Entitlements.
string
 ✔
provider The App Store associated to the entitlement_id.
string
ko_app_name The name of the advertiser’s app in Kochava and all associated apps in account that have Store Credentials saved.
string
in_trial Indication if subscription is within a free trial period. The logic is based on the date_occured for the event SubscriptionTrialBegin using the Trial duration from the Entitlement setup by the user.
boolean
duration The subscription renewal duration entered by the user in Entitlements.
string
renewal_cost Cost of the subscription renewal, entered in Entitlements.
float
 ✔
cancelguard_status Reason for subscription being in pending cancel state (billing issue, auto renew turned off).
float
 ✔
cancelguard_date_occurred The date the subscription first changed to pending cancel.
date
cancelguard_churn_date The date the subscription will be canceled if not recovered.
date
 ✔
customer_id Any identities sent via SDK with the subscription event. Can be username, email or CRM ID.
string
original_receipt_id The receipt id from the original receipt at the beginning of the subscription
string

Field Name Description
Type
May be Null
entitlement_label The entitlement label(s) associated to entitlement_id set up by the user in Entitlements
string
 ✔
provider The App Store associated to the entitlement_id.
string
ko_app_name The name of the app in Kochava and all associated apps in account
string
in_trial Indication if subscription is within a free trial period. The logic is based on the date_occured for the event SubscriptionTrialBegin using the Trial duration from the Entitlement setup by the user.
boolean
duration The subscription renewal duration entered by the user in Entitlements.
string
renewal_cost Cost of the subscription renewal, entered in Entitlements.
float
cancelguard_status Reason for subscription being in pending cancel state (billing issue, auto renew turned off).
string
 ✔
cancelguard_date_occurred The date the subscription first changed to pending cancel.
date
 ✔
cancelguard_churn_date The date the subscription will be canceled if not recovered.
date
 ✔
entitlement_id The entitlement_ID the user entered in Entitlements that is associated with the receipt from the payment provider.
string
subscriber_id
string
receipt_id The most recent receipt id for the subscription
string
 ✔
subscription_active Subscription is still active for the reporting period.
boolean
subscription_trial The subscription is in a free trial.
boolean
subscription_ltv The total sum of revenue generated for this subscription
float
 ✔
renewal_date The date of the next renewal.
date
 ✔
renewal_annual_mrr The annual monthly recurring revenue for the renewal.
float
 ✔
membership_started_first The date the membership first started.
date
membership_started_continuous The earliest date for the current subscription started without any lapse.
date
 ✔
membership_one_year_customer Indicates if the customer has a 1 year subscription.
boolean

 
 
Last Modified: Nov 11, 2022 at 1:46 pm