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 NameDescription
Type
May be Null
click_campaignThe Kochava-specific ID of the campaign to which the click was attributed.
string
click_campaign_nameThe user defined name for the campaign to which the click was attributed.
string
click_country_code2-digit country designation where the click originated, based on IP lookup.
string
click_creativeData received on click in the creative_id parameter.
string
click_custom_parametersCustom parameters passed with the click.
string
click_date_adjustedDate and time of the click (Selected Time Zone).
string (datetime)
click_date_utcDate and time of the click (Coordinated Universal Time).
string (datetime)
click_device_idAn internal identifier used for mapping purposes.
string (int)
click_device_uaUser Agent of the device gathered upon click.
string
click_device_verThe device type and version of the device received on click.
string
click_duplicateThe ID assigned to duplicate clicks.
string
click_identifiersAn array of all device identifiers received on the click.
json (strings)
click_identifiers_adidRaw ADID provided on the click (Android specific).
string
click_identifiers_android_idRaw Android_ID received on the click (Android specific).
string
click_identifiers_android_id_md5MD5 encrypted Android_ID received on the click (Android specific).
string
click_identifiers_android_id_sha1SHA1 encrypted Android_ID received on the click (Android specific).
string
click_identifiers_customCustom provided identifier received with the click.
string
click_identifiers_email_0Primary email address delivered with the click.
string
click_identifiers_email_1Secondary email address delivered with the click.
string
click_identifiers_idfaRaw IDFA received on the click (iOS specific).
string
click_identifiers_ipRaw IP address where the click originated.
string
click_identifiers_waidRaw WAID received on the click (Windows specific).
string
click_ipThe IP address from which the click originated.
string
click_matched_impressionID representation of the impression which the click was matched to.
string (int)
click_matched_installID representation of the install which matched to the click.
string (int)
click_networkThe Kochava-specific ID of the Network to which the click originated.
string (int)
click_network_nameThe name of the Network to which the click originated.
string
click_original_requestRaw URL which was received for specific click.

NOTE: API call will return data in JSON format.

string
click_priceThe price per click.
string (float)
click_from_qr_codeThe total number of clicks generated from the qr code during the selected time frame.
int
click_siteIdentifies the site to which the click was served within the publisher partner.
string
click_statusIndicator to define if the click has simply been received (publish) or matched to an install.
string
click_tierThe tier/segment to which the click is associated.
string
click_trackerThe Kochava-specific ID of the tracker to which the click originated.
string (int)
click_tracker_nameThe user defined name for the tracker to which the click originated.
string
clickgeo_area_codeThe area code where the click originated, based on IP lookup.
string (int)
clickgeo_cityThe name of the city where the click originated, based on IP lookup.
string
clickgeo_continent_codeThe region where the click originated, based on IP lookup.
string
clickgeo_country_code2-digit country designation where the click originated, based on IP lookup.
string
clickgeo_country_code33-digit country designation where the click originated, based on IP lookup.
string
clickgeo_country_nameThe name of the country where the click originated, based on IP lookup.
string
clickgeo_dma_codeThe code for the designated marketing area where the click originated, based on IP lookup.
string (int)
clickgeo_latitudeThe 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_longitudeThe 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_codeThe postal code of the region where the click originated, based on IP lookup.
string (int)
clickgeo_regionAn alpha-numeric code identifying the geographic region where the click originated, based on IP lookup.
string
impression_campaignThe Kochava-specific ID of the campaign to which the click was attributed.
string (int)
impression_campaign_nameThe user defined name for the campaign to which the click was attributed.
string
impression_country_code2-digit country designation where the impression originated, based on IP lookup.
string
impression_creativeData received on impression in the creative_id parameter.
string
impression_date_adjustedThe date the impression occurred (Selected Time Zone).
string (date)
impression_date_utcThe date the impression occurred in UTC.
string (date)
impression_device_verThe device type and version of the device received on impression.
string
impression_identifiersAn array of all device identifiers received on the impression.
json (strings)
impression_imp_idUnique identifier associated with the impression which has been received.
string (int)
impression_ipThe IP address from which the impression originated.
string
impression_kochava_imp_idKochava generated unique identifier associated with the impression which has been received.
string
impression_matched_clickID representation of the click which the impression was matched to.
string (int)
impression_matched_installID representation of the install which matched to the impression.
string (int)
impression_networkThe Kochava-specific ID of the Network to which the impression originated.
string (int)
impression_network_nameThe name of the Network to which the impression originated.
string
impression_original_requestRaw URL which was received for specific impression.

NOTE: API call will return data in JSON format.

string
impression_siteIdentifies the site to which the impression was served within the publisher partner.
string
impression_trackerThe Kochava-specific ID of the tracker to which the impression was attributed.
string (int)
impression_tracker_nameThe user defined name for the tracker to which the click was attributed.
string
kochava_click_idClick ID assigned by Kochava.
string
partner_click_idClick ID as received from the partner.
string
reengagement_tierThe tier/segment to which the reengagement is associated.
string
traffic_click_verification_statusIndicator if the click traffic was valid or invalid based on Traffic Verification rules.
json (string)
traffic_verification_statusIndicator if the click traffic was valid or invalid based on Traffic Verification rules.
string
click_attThe device ATT status.
string
click_att_detailATT 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_timeUser 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 NameDescription
Type
May be Null
install_idThe internally generated unique ID to which the install is attributed.
string (int)
install_date_utcDate and time of install (Coordinated Universal Time).
string (datetime)
install_date_adjustedDate and time of install (Selected Time Zone).
string (datetime)
clickwin_idThe ID of the click that won attribution.
string (int)
clickwin_networkThe ID of the network awarded the winning click.
string (int)
clickwin_network_nameThe name of the network awarded the winning click.
string
clickwin_siteIdentifies the site to which the winning click was served within the publisher partner.
string
clickwin_creative_idThe ID/name of the creative which drove the winning click.
string
clickwin_date_utcDate and time of the winning click (Coordinated Universal Time).
string (datetime)
clickwin_date_adjustedDate and time of the winning click (Selected Time Zone).
string (datetime)
clickwin_matched_onProvides the actual piece of data that the click was matched on; that is, the device ID.
string
clickwin_match_typeThe ID type to which the winning click is attributed.
string
clickwin_from_qr_codeThe total number of winning clicks generated from the qr code during the selected time frame.
int
influencer_idUnique identifier associated with the influencer which has been received.
string (int)
influencer_networkThe ID of the network which influenced the winning click.
string (int)
influencer_network_nameThe name of the network which influenced the winning click.
string
inf_siteIdentifies the site to which the influencer was served within the publisher partner.
string
inf_creative_idThe ID/name of the creative which influenced the click.
string
influencer_date_utcDate and time the influencer was served (Coordinated Universal Time).
string (datetime)
influencer_date_adjustedDate and time the influencer was served (Selected Time Zone).
string (datetime)
influencer_matched_onProvides the actual piece of data the influencer was matched on; for example, the device ID.
string
influencer_match_typeDescription of how we matched the install to the influencer; for example, device ID, Facebook, etc
string
kochava_click_idClick ID assigned by Kochava.
string
rejected_becauseThe 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 NameDescription
Type
May be Null
job_idThe Kochava-specific ID of the Cost Configuration job.
string
configuration_nameThe user-defined name for the Cost Configuration.
string
cost_dateThe network defined 24 hour period for the cost window.
datetime
date_from_UTCThe UTC start date of the cost window.
datetime
date_to_UTCThe UTC end date of the cost window.
datetime
network_partner_idThe ID of the company networks e.g., unity ios, unity android, etc., are all under the same ID.
string (int)
network_partner_nameThe name of the network the configuration is associated to.
string
platformThe device platform.
string
ad_accountThe client advertiser account with the network company.
string
partner_campaign_nameThe user-defined name to which the configuration is associated to at the network level.
string
partner_campaign_idThe user-defined ID of the campaign the configuration is associated to at the network level.
string
countryThe country code retrieved by Kochava from the network.
string
creative_nameThe name representing the ad creative served by the network.
string
creative_idThe ID representing the ad creative served by the network.
string
ad_typeThe type of ad being served by the network.
string
ad_sizeThe dimensions of the ad being served by the network.
string
site_nameThe internal code (name or ID) used by the network for the site to which the campaign is associated to.
string
site_idThe internal ID used by the network for the site to which the campaign is associated to.
string
total_impressionsThe number of impressions associated with the configuration.
number
total_clicksThe total number of clicks associated with the configuration.
number
total_installsThe total number of installs associated with the configuration.
number
original_total_spendThe total spend in the user-defined currency at the network level.
number
original_currencyThe original currency for the associated configuration.
string
total_spend_usdThe total spend in USD.
number
network_timezoneThe timezone reported by the network.
string
collected_day_afterHow many day after the cost date, Kochava retrieved the cost data.
number
time_collectedThe datetime when Kochava retrieved the cost data.
datetime
sub_campaign_nameThe 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_idThe 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
channelSet at the network level and retrieved by Kochava.
string
sub_site_idThe sub-site ID of the app where the ad was served, retrieved from the network.
string
placement_idThe ID for the ad location within the app where the ad was served.
string
keywordCampaign keywords.
string
keyword_idThe ID for the campaign keywords.
string
bid_strategyThe bid strategy defined by the advertiser in the media partner’s dashboard.
string
bid_typeBid type set by the media partner.
string
campaign_objectiveObjective 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 NameDescription
Type
May be Null
Filter
Group
partner_campaign_keyUnique 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_nameThe 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_idThe numeric ID of the advertiser’s app in Kochava.
string (int)
ko_app_nameThe name of the advertiser’s app within Kochava.
string
cost_network_partner_idThe numeric ID of the company network partner in Kochava.
string (int)
cost_network_partner_nameThe name of the company network partner in Kochava.
string
cost_total_impressionsThe total number of impressions for the associated configuration.
number
cpmThe cost per thousand impressions.
number
cost_total_clicksThe total number of clicks for the associated configuration
number
cpcThe cost per click.
number
ctrThe click-through rate.
number
cost_total_installsThe total number of installs for the associated configuration reported by the network.
number
cpiThe cost per install.
number
cvrThe conversion rate.
number
cost_total_spend_usdThe total spend in USD for the associated configuration.
number
ko_cpiCost per Install using Kochava install count.
number
ko_total_installsInstall 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 NameDescription
Type
May be Null
Filter
Group
partner_campaign_keyUnique 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_nameThe 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_idThe numeric ID of the integrated cost company network partner in Kochava.
number
cost_network_partner_nameThe name of the integrated cost company network partner in Kochava.
string
skad_host_nameSKAd report host name
string
ko_app_idThe numeric ID of the advertiser’s app in Kochava.
string (int)
ko_app_nameThe name of the advertiser’s app within Kochava.
string
skad_total_installsCount of SKAdNetwork-reported installs.
number
skad_total_redownload_installsCount of SKAdNetwork-reported installs that were flagged as redownloads by SKAdNetwork.
number
cost_original_currencyThe original currency for the associated configuration.
string
cost_total_impressionsThe total number of impressions for the associated configuration retrieved from the network.
number
cost_total_clicksThe total number of clicks for the associated configuration retrieved from the network.
number
cost_total_installsThe 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_usdThe total spend in USD.
number
cpmThe cost per thousand impressions.
number
cpcThe cost per click.
number
ctrThe click-through rate.
number
cpiThe cost per install.
number
ipmInstall per mille, the number of times your app or game is installed per thousand ad impressions.
number

Field NameDescription
Type
May be Null
Filter
Group
configuration_nameThe user-defined name for the Cost Configuration.
string
cost_dateThe network defined 24 hour period for the cost window.
datetime
date_from_UTCThe UTC start date of the cost window.
datetime
date_to_UTCThe UTC end date of the cost window.
datetime
network_partner_idThe ID of the company networks e.g., unity ios, unity android, etc., are all under the same ID.
string (int)
network_partner_nameThe name of the network the configuration is associated to.
string
platformThe device platform.
string
ad_accountThe client advertiser account with the network company.
string
partner_campaign_nameThe user-defined name to which the configuration is associated to at the network level.
string
partner_campaign_idThe user-defined ID of the campaign the configuration is associated to at the network level.
string
countryThe country code retrieved by Kochava from the network.
string
creative_nameThe name representing the ad creative served by the network.
string
creative_idThe ID representing the ad creative served by the network.
string
ad_typeThe type of ad being served by the network.
string
ad_sizeThe dimensions of the ad being served by the network.
string
site_nameThe name of the site to which the campaign is associated to.
string
site_idThe internal ID used by the network for the site to which the campaign is associated to.
string
network_timezoneThe timezone reported by the network.
string
sub_campaign_nameThe 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_idThe 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
channelSet at the network level and retrieved by Kochava.
string
sub_site_idTThe sub-site ID of the app where the ad was served, retrieved from the network.
string
placement_idThe ID for the ad location within the app where the ad was served.
string
keywordCampaign keywords.
string
keyword_idThe ID for the campaign keywords.
string
bid_strategyThe bid strategy defined by the advertiser in the media partner’s dashboard.
string
bid_typeBid type set by the media partner.
string
campaign_objectiveObjective of campaign set in media partner dashboard.
string
original_currencyThe original currency for the associated configuration.
string
original_total_spendThe total spend in the user-defined currency at the network level.
number
total_spend_USDThe total spend in USD.
number
total_impressionsThe number of impressions associated with the configuration.
number
total_clicksThe total number of clicks associated with the configuration.
number
total_installsThe total number of installs associated with the configuration.
number
cpmThe cost per thousand impressions.
number
cpcThe cost per click.
number
ctrThe click-through rate.
number
cpiThe cost per install.
number
ipmInstall 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 NameDescription
Type
May be Null
attribution_attribution_actionThe action through which attribution was achieved, install or event.
string
attribution_campaignThe user defined name for the campaign to which the event was attributed.
string
attribution_campaign_idThe Kochava-specific ID of the campaign to which the event was attributed.
string
attribution_creativeData received on event in the creative_id parameter.
string
attribution_date_adjustedThe date and time of attribution (Adjusted to the Selected Time Zone).
string (datetime)
attribution_date_utcThe date and time of attribution. (Coordinated Universal Time).
string (datetime)
attribution_identity_link_bridge_linkIf 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_byThe means by which the user was attributed(click/impression).
string
attribution_matched_toThe initial action by which attribution was matched, impression or click or impression with click.
string
attribution_networkThe Kochava-specific ID of the Network to which the event was attributed.
string
attribution_network_idUnique identifier associated with the network to which the event was attributed.
string (int)
attribution_seconds_sinceThe number of seconds since attribution was made.
integer
attribution_site_idIdentifies the site to which the event was attributed within the publisher partner.
string
attribution_tierThe tier/segment to which the attribution is associated.
string
attribution_timestampThe date and time of attribution(Coordinated Universal Time).
string (datetime)
attribution_timestamp_adjustedThe date and time of attribution (Adjusted to the Selected Time Zone).
string (datetime)
attribution_trackerThe Kochava-specific ID of the tracker to which the event was attributed.
string
attribution_tracker_idThe Kochava-specific ID of the tracker to which the event was attributed.
string
attribution_tracker_nameThe user defined name for the tracker to which the event was attributed.
string
click_campaignThe Kochava-specific ID of the campaign to which the click was attributed.
string
click_campaign_nameThe user defined name for the campaign to which the click was attributed.
string
click_country_code2-digit country designation where the click originated, based on IP lookup.
string
click_creativeData received on click in the creative_id parameter.
string
click_custom_parametersCustom parameters passed with the click.
string
click_date_adjustedDate and time of the click (Selected Time Zone)
string (datetime)
click_date_utcDate and time of the click (Coordinated Universal Time).
string (datetime)
click_device_idAn internal identifier used for mapping purposes.
string (int)
click_device_uaUser Agent of the device gathered upon click.
string
click_duplicateThe ID assigned to duplicate clicks.
string (int)
click_device_verThe device type and version of the device received on click.
string
click_identifiersAn array of all device identifiers received on the click.
json (str)
click_identifiers_adidRaw ADID provided on the click (Android specific).
string
click_identifiers_android_idRaw Android_ID received on the click (Android specific).
string
click_identifiers_android_id_md5MD5 encrypted Android_ID received on the click (Android specific).
string
click_identifiers_android_id_sha1SHA1 encrypted Android_ID received on the click (Android specific).
string
click_identifiers_customCustom provided identifier received with the click.
string
click_identifiers_email_0Primary email address delivered with the click.
string
click_identifiers_email_1Secondary email address delivered with the click.
string
click_identifiers_idfaRaw IDFA received on the click (iOS specific).
string
click_identifiers_ipRaw IP address where the click originated.
string
click_identifiers_waidRaw WAID received on the click (Windows specific).
string
click_ipThe IP address from which the click originated.
string
click_matched_impressionID representation of the impression which the click was matched to.
string (int)
click_matched_installID representation of the install which matched to the click.
string (int)
click_monthThe numeric value of the month the install was received.
string (int)
click_networkThe Kochava-specific ID of the Network to which the click originated.
string (int)
click_network_nameThe name of the Network to which the click originated.
string
click_original_requestRaw URL which was received for specific click.

NOTE: API call will return data in JSON format.

string
click_from_qr_codeThe total number of clicks generated from the qr code during the selected time frame.
integer
click_siteIdentifies the site to which the click was served within the publisher partner.
string
click_statusIndicator to define if the click has simply been received (publish) or matched to an install.
string
click_trackerThe Kochava-specific ID of the tracker to which the click originated.
string (int)
click_tracker_nameThe user defined name for the tracker to which the click originated.
string
clickgeo_area_codeThe area code where the click originated, based on IP lookup.
string (int)
clickgeo_cityThe name of the city where the click originated, based on IP lookup.
string
clickgeo_continent_code2-digit continent designation where the click originated, based on IP lookup.
string
clickgeo_country_code2-digit country designation where the click originated, based on IP lookup.
string
clickgeo_country_code33-digit country designation where the click originated, based on IP lookup.
string
clickgeo_country_nameThe name of the country where the click originated, based on IP lookup.
string
clickgeo_dma_codeThe code for the designated marketing area where the click originated, based on IP lookup.
string
clickgeo_latitudeThe 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_longitudeThe 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_codeThe postal code of the region where the click originated, based on IP lookup.
string (int)
clickgeo_regionAn alpha-numeric code identifying the geographic region where the click originated, based on IP lookup.
string
countNumber of events (based on selection) during defined time frame.
integer
custom_dimensionsCustom provided dimensions received with the event.
array (string)
device_id_adidRaw ADID provided on the event (Android specific).
string
device_id_android_idRaw Android_ID received on the event (Android specific).
string
device_id_customCustom provided identifier received with the event .
string
device_id_idfaRaw IDFA provided on the event (iOS specific)
string
device_id_idfvRaw IDFV provided on the event (iOS specific)
string
device_id_kochavaKochva generated Unique ID assigned to device.
string
device_osThe operating system of the device.
string
device_typeThe device type of the device.
string
device_versionThe device version of the mobile device.
string
dimension_countNumber of custom events (based on selection).
integer
dimension_dataData provided dimensions received with the event.
string
dimension_sumThe sum of event data.
float
event_nameThe name of the advertiser defined and integrated event.
string
event_time_registeredThe time that the event was performed by the mobile device.
string
geo_cityThe name of the city where the event originated, based on IP lookup.
string
geo_countryThe two digit code where the event originated, based on IP lookup.
string
geo_latThe 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_lonThe 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_regionAn alpha-numeric code identifying the geographic region where the event originated, based on IP lookup.
string
iad.campaign_idThe iAd specific campaign ID.
string
iad.iad-attributionIndicates whether iAd has claimed and won attribution (1).
string
iad.iad-legacyIndicates whether the legacy iAd is attribution logic was utilized (1).
string
iad.network_idThe Kochava-specific ID of the network to which the iAd attribution is attributed.
string
identity_linkA customer defined unique identifier for linking devices.
string
impression_campaignThe Kochava-specific ID of the campaign to which the impression is associated.
string (int)
impression_campaign_nameThe user defined name for the campaign to which the impression is associated.
string
impression_country_code2-digit country designation where the impression originated, based on IP lookup.
string
impression_creativeThe ID/name of the creative which was served with the impression.
string
impression_date_adjustedThe date the impression occurred (Selected Time Zone).
string (date)
impression_date_utcDate and time of the impression (Coordinated Universal Time).
string (date)
impression_device_verThe device type and version of the device which received on impression.
string
impression_identifiersAn array of all device identifiers received on the impression.
json (string)
impression_imp_idUnique identifier associated with the impression which has been received.
string (int)
impression_ipThe IP address from which the impression originated.
string
impression_kochava_imp_idKochava generated unique identifier associated with the impression which has been received.
string
impression_matched_clickID representation of the click which the impression was matched to.
string (int)
impression_matched_installID representation of the install which matched to the impression.
string (int)
impression_networkThe Kochava-specific ID of the Network to which the impression originated.
string (int)
impression_network_nameThe name of the Network to which the impression originated.
string
impression_original_requestRaw URL which was received for specific impression.

NOTE: API call will return data in JSON format.

string
impression_siteIdentifies the site to which the impression was served within the publisher partner.
string
impression_trackerThe Kochava-specific ID of the tracker to which the impression is associated.
string (int)
impression_tracker_nameThe user defined name for the tracker to which the impression is associated.
string
install_date_adjustedThe date the install occurred (Selected Time Zone).
string (datetime)
install_date_utcDate and time of the install (Coordinated Universal Time).
string (datetime)
install_device_uaUser Agent of the device gathered upon install.
string
install_device_versionThe device type and version of the device received on install.
string
install_devices_adidRaw ADID provided on the install (Android specific).
string
install_devices_android_idRaw Android_ID provided on the install (Android specific).
string
install_devices_customCustom provided identifier received with the install.
string
install_devices_email_0Primary email address delivered with the install.
string
install_devices_email_1Secondary email address delivered with the install.
string
install_devices_idfaRaw IDFA provided on the install (iOS specific).
string
install_devices_idsAn array of the device identifiers received on install.
json (string)
install_devices_ipThe IP address from which the install originated.
string
install_devices_waidRaw WAID received on install (Windows specific).
string
install_matched_byDefines the nature of the data point on which the click was matched to the install.
string
install_matched_onID representation of the install which matched to the click.
string
install_receipt_statusIndication 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_originalThe original Self Attributing Network to which the install is attributed.
string
install_statusIndicator to define if an install has been simply been received (publish) or matched to a click.
string
is_reengagementIndicator if event is being attributed to the last reengagment.
string (int)
kochava_click_idClick ID assigned by Kochava.
string
partner_click_idClick ID as received from the partner.
string
request_ipThe IP address from which the request originated.
string
request_uaUser Agent from which the request originated.
string
timestamp_adjustedThe date and time of the event (Selected Time Zone).
string (datetime)
timestamp_utcThe date and time of the event (Coordinated Universal Time).
string (datetime)
traffic_click_verification_statusIndicator if the click traffic was valid or invalid based on Traffic Verification rules.
json (string)
traffic_impression_verification_statusIndicator if the impression traffic was valid or invalid based on Traffic Verification rules.
string
event_attThe device ATT status.
string
event_att_detailATT 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_timeUser 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 NameDescription
Type
May be Null
fractional_awardThe percentage awarded to the network for the install.
string (int)
fractional_datethe date and time of the install (Coordinated Universal Time).
string (datetime)
fractional_date_adjustedThe date and time of the install (Selected Time Zone).
string (datetime)
fractional_idFractional ID assigned by Kochava.
string (int)
fractional_networkThe Kochava-specific ID of the Network to which the click originated.
string (int)
fractional_typeThe identifier by which the fractional attribution was credited.
string
match_idThe Kochava-specific ID of the match that won attribution.
string (int)
match_typeThe identifier by which the fractional attribution was matched.
string
traffic_dateDate and Time of traffic (Coordinated Universal Time).
string (datetime)
traffic_date_adjustedDate and time of traffic(Selected Time Zone).
string (datetime)
traffic_idThe Kochava-specific ID of the traffic to which the install was fractional attributed.
string (int)
traffic_monthThe numeric value of the month the install was received.
string (int)
traffic_typeThe 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 NameDescription
Type
May be Null
idRandom internal identifier.
string (int)
match_idThe Kochava-specific ID of the match that won attribution.
string (int)
match_date_utcThe date and time of attribution (Coordinated Universal Time).
string (datetime)
match_date_adjustedThe date and time of attribution (Selected Time Zone).
string (datetime)
match_monthThe number of the month in which attribution occurred.
string (int)
match_typeDescription of how attribution was performed; for example, device ID, Facebook, etc.
string
imp_match_idThe Kochava-specific ID of the impression which led to install.
string (int)
imp_match_networkThe Kochava-specific ID of the Network to which the impression originated.
string (int)
imp_match_network_nameThe name of the Network to which the impression originated.
string
imp_match_typeThe type of attribution the impression was matched on.
string
imp_matched_onThe ID which the impression was matched on.
string
influencer_idUnique identifier associated with the influencer.
string (int)
influencer_networkThe Kochava-specific ID of the Network to which the influencer originated.
string (int)
influencer_network_nameThe name of the network in which the influencer occurred.
string
influencer_date_utcThe date and time of the influencer (Corrdinated Universal Time)
string (datetime)
influencer_date_adjustedThe date and time of the influencer (Selected Time Zone).
string (datetime)
influencer_match_typeDescription of how we matched the click to the influencer; for example, device ID, Facebook, etc.
string
influencer_matched_onProvides the actual piece of data the influencer was matched on; for example, the device ID.
string
rejected_becauseThe 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 NameDescription
Type
May be Null
attribution_campaignThe Kochava-specific ID of the campaign to which the the install was attributed.
string
attribution_campaign_nameThe user defined name for the campaign to which the install was attributed.
string
attribution_creativeData received on install in the creative_id parameter.
string
attribution_identity_link_bridge_linkIf true, identity link bridge values helped with the attribution match. If false, identity link bridge did not assist with the attribution match.
string
attribution_networkThe Kochava-specific ID of the Network to which the install was attributed.
string
attribution_network_nameThe name of the Network to which the install was attributed.
string
attribution_siteIdentifies the site to which the install was attributed within the publisher partner.
string
attribution_tierThe tier/segment to which the attribution is associated.
string
attribution_trackerThe Kochava-specific ID of the tracker to which the install was attributed.
string (int)
attribution_tracker_nameThe user defined name for the tracker to which the install was attributed.
string
click_campaignThe Kochava-specific ID of the campaign to which the click was attributed.
string
click_campaign_nameThe user defined name for the campaign to which the click was attributed.
string
click_country_code2-digit country designation where the click originated, based on IP lookup.
string
click_creativeData received on click in the creative_id parameter.
string
click_custom_parametersCustom parameters passed with the click.
string
click_device_idAn internal identifier used for mapping purposes.
string (int)
click_device_uaUser Agent of the device gathered upon click.
string
click_device_verThe device type and version of the device received on click.
string
click_duplicateThe ID assigned to duplicate clicks.
string (int)
click_identifiersAn array of all device identifiers received on the click.
json (string)
click_identifiers_adidRaw ADID provided on the click (Android specific).
string
click_identifiers_android_idRaw Android_ID received on the click (Android specific).
string
click_identifiers_android_id_md5MD5 encrypted Android_ID received on the click (Android specific).
string
click_identifiers_android_id_sha1SHA1 encrypted Android_ID received on the click (Android specific).
string
click_identifiers_customCustom provided identifier received with the click.
string
click_identifiers_email_0Primary email address delivered with the click.
string
click_identifiers_email_1Secondary email address delivered with the click.
string
click_identifiers_idfaRaw IDFA received on the click (iOS specific).
string
click_identifiers_ipRaw IP address where the click originated.
string
click_identifiers_waidRaw WAID received on the click (Windows specific).
string
click_ipThe IP address from which the click originated.
string
click_matched_impressionID representation of the impression which the click was matched to.
string (int)
click_matched_installID representation of the install which matched to the click.
string (int)
click_monthThe numeric value of the month the install was received.
string (int)
click_networkThe Kochava-specific ID of the Network to which the click originated.
string (int)
click_network_nameThe name of the Network to which the click originated.
string
click_from_qr_codeThe total number of clicks generated from the qr code during the selected time frame.
integer
click_original_requestRaw URL which was received for specific click.

NOTE: API call will return data in JSON format.

string
click_siteIdentifies the site to which the click was served within the publisher partner.
string
click_statusIndicator to define if the click has simply been received (publish) or matched to an install.
string
click_tierThe tier/segment to which the click is associated.
string
click_trackerThe Kochava-specific ID of the tracker to which the click originated.
string (int)
click_tracker_nameThe user defined name for the tracker to which the click originated.
string
clickgeo_area_codeThe area code where the click originated, based on IP lookup.
string (int)
clickgeo_cityThe name of the city where the click originated, based on IP lookup.
string
clickgeo_continent_code2-digit continent designation where the click originated, based on IP lookup.
string
clickgeo_country_code2-digit country designation where the click originated, based on IP lookup.
string
clickgeo_country_code33-digit continent designation where the click originated, based on IP lookup.
string
clickgeo_country_nameThe name of the country where the click originated, based on IP lookup.
string
clickgeo_dma_codeThe code for the designated marketing area where the click originated, based on IP lookup.
string (int)
clickgeo_latitudeThe 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_longitudeThe 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_codeThe postal code of the region where the click originated, based on IP lookup.
string (int)
clickgeo_regionAn alpha-numeric code identifying the geographic region where the click originated, based on IP lookup.
string
identity_linkA customer defined unique identifier for linking devices.
string
impression_campaignThe Kochava-specific ID of the campaign to which the impression is associated.
string (int)
impression_campaign_nameThe user defined name for the campaign to which the impression is associated.
string
impression_country_code2-digit country designation where the impression originated, based on IP lookup.
string
AccountThe ID/name of the creative which was served with the impression.
string
impression_device_verThe device type and version of the device which received on impression.
string
impression_identifiersAn array of all device identifiers received on the impression.
json (strings)
impression_imp_idUnique identifier associated with the impression which has been received.
string (int)
impression_ipThe IP address from which the impression originated.
string
impression_kochava_imp_idKochava generated unique identifier associated with the impression which has been received.
string (int)
impression_matched_clickID representation of the click which the impression was matched to.
string (int)
impression_matched_installID representation of the install which matched to the impression.
string (int)
impression_networkThe Kochava-specific ID of the Network to which the impression originated.
string (int)
impression_network_nameThe name of the Network to which the impression originated.
string
impression_original_requestRaw URL which was received for specific impression.

NOTE: API call will return data in JSON format.

string
impression_siteIdentifies the site to which the impression was served within the publisher partner.
string
impression_tierThe tier/segment to which the impression is associated.
string
impression_tracker_nameThe user defined name for the tracker to which the impression is associated.
string
impression_tracker_nameThe user defined name for the tracker to which the impression is associated.
string
install_channel_typeThe channel type to which the install is attributed.
string
install_click_date_adjustedThe date and time the click occurred which led to install (Selected Time Zone).
string (datetime)
install_click_date_utcThe date and time the click occurred which led to install (Coordinated Universal Time).
string (datetime)
install_date_adjustedThe date and time of install (Selected Time Zone).
string (datetime)
install_date_utcThe date and time of install (Coordinated Universal Time).
string (datetime)
install_device_uaUser Agent of the device gathered upon install.
string
install_device_versionThe device version of the mobile device.
string
install_devices_adidRaw ADID provided on install (Android specific).
string
install_devices_android_idRaw Android_ID received on install (Android specific).
string
install_devices_customCustom provided identifier received with install.
string
install_devices_custom_idUnique identifier associated with the custom provided identifier.
string
install_devices_email_0Primary email address delivered with install.
string
click_identifiers_email_1Secondary email address delivered with the click.
string
install_devices_idfaRaw IDFA received on install (iOS specific).
string
install_devices_idsAn array of all device identifiers received on install.
string
install_devices_ipThe IP address from which the install originated.
string
install_devices_waidRaw WAID received on the click (Windows specific).
string
install_impression_date_adjustedThe date and time the impression occurred which led to install (Selected Time Zone).
string (datetime)
install_impression_date_utcThe date and time the impression occurred which led to install (Coordinated Universal Time).
string (datetime)
install_kochava_device_idInstall ID assigned by Kochava
string
install_matched_byThe ID type to which installation is attributed.
string
install_matched_onUnique identifier to which the install is matched on.
string
install_original_requestRaw URL which was received for specific install.

NOTE: API call will return data in JSON format.

string
install_priceThe user defined price per click or price per install.
string (float)
install_receipt_statusIndication 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_forIf a value is present this signifies that the install was a reprocessed install(not the first install from the device).
string
install_statusIndicator to define if an install has been simply been received (publish) or matched to a click.
string
installgeo_area_codeThe area code where the install originated, based on IP lookup.
string (int)
installgeo_cityThe name of the city where the install originated, based on IP lookup.
string
installgeo_continent_code2-digit continent designation where the impression originated, based on IP lookup.
string
installgeo_country_code2-digit continent designation where the install originated, based on IP lookup.
string
installgeo_country_code33-digit continent designation where the impression originated, based on IP lookup.
string
installgeo_country_nameThe name of the country where the install originated, based on IP lookup.
string
installgeo_dma_codeThe code for the designated marketing area where the install originated, based on IP lookup.
string (int)
installgeo_latitudeThe 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_longitudeThe 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_codeThe postal code of the region where the install originated, based on IP lookup.
string (int)
installgeo_regionAn alpha-numeric code identifying the geographic region where the install originated, based on IP lookup.
string
kochava_click_idClick ID assigned by Kochava.
string
partner_click_idClick ID as received from the partner.
string
traffic_click_verification_statusIndicator if the click traffic was valid or invalid based on Traffic Verification rules.
json (strings)
traffic_install_verification_statusIndicator if the install traffic was valid or invalid based on Traffic Verification rules.
json (strings)
install_attThe device ATT status.
string
install_att_detailATT 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_timeUser 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 NameDescription
Type
May be Null
kochava_click_idClick ID assigned by Kochava.
string
kochava_device_idKochava generated Unique ID assigned to device.
string
reengage_event_date_utcDate and time of the event (Coordinated Universal Time).
string (datetime)
reengage_event_date_adjustedDate and time of the event (Selected Time Zone).
string (datetime)
reengage_click_monthThe numeric value of the month the click was received.
string (int)
reengage_click_date_utcDate and time of the click (Coordinated Universal Time).
string (datetime)
reengage_click_date_adjustedDate and time of the click (Selected Time Zone).
string (datetime)
reengage_event_nameThe name of the advertiser defined and integrated event for reengagement.
string
reengage_statusIndicator to define if the click has been matched to an event for reengagement.
string
reengage_networkThe Kochava-specific ID of the Network to which the reengagement originated.
string (int)
reengage_network_nameThe name of the Network to which the reengagement originated.
string
reengage_trackerThe Kochava-specific ID of the tracker to which the reengagement originated.
string (int)
reengage_tracker_nameThe user defined name for the tracker to which the reengagement originated.
string
reengage_campaignThe Kochava-specific ID of the campaign to which the reengagement was attributed.
string
reengage_campaign_nameThe user defined name for the campaign to which the reengagement was attributed.
string
reengage_siteIdentifies the site to which the reengagement was served within the publisher partner.
string
string
reengage_creativeData received on reengagement in the creative_id parameter.
string
reengage_country_code2-digit country designation where the reengagement originated, based on IP lookup.
string
reengage_ipRaw IP address where the reengagement originated.
string
reengage_device_verThe device type and version of the device received on reengagement.
string
reengage_device_idThe primary device ID received on reengagement.
string
reengage_original_requestRaw URL which was received for specific reengagement.

NOTE: API call will return data in JSON format.

string
reengage_matched_impressionID representation of the impression which the reengagement was matched to.
string (int)
reengage_matched_installID representation of the install which matched to the reengagement.
string (int)
reengage_identifiersIdentifiers available for attribution on the reengagement.
string
reengage_duplicateThe ID assigned to duplicate reengagements.
string (int)
click_original_requestRaw URL which was received for specific click.

NOTE: API call will return data in JSON format.

string
reengagegeo_continent_code2-digit continent designation where the reengagement originated, based on IP lookup.
string
reengagegeo_country_code2-digit country designation where the reengagement originated, based on IP lookup.
string
reengagegeo_country_code33-digit country designation where the reengagement originated, based on IP lookup.
string
reengagegeo_country_nameThe name of the country where the reengagement originated, based on IP lookup.
string
reengagegeo_regionAn alpha-numeric code identifying the geographic region where the reengagement originated, based on IP lookup.
string
reengagegeo_postal_codeThe postal code of the region where the reengagement originated, based on IP lookup.
string (int)
reengagegeo_dma_codeThe code for the designated marketing area where the reengagement originated, based on IP lookup.
string (int)
reengagegeo_cityThe name of the city where the reengagement originated, based on IP lookup.
string
reengagegeo_area_codeThe area code where the reengagement originated, based on IP lookup.
string (int)
reengagegeo_longitudeThe 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_latitudeThe 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_tierThe tier/segment to which the reengagement is associated.
string
click_from_qr_codeThe 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 NameDescription
Type
May be Null
starting_dateThe date and time that the restated cost data began being collected.
string (datetime)
ending_dateThe date and time that the restated cost data ended being collected.
string (datetime)
tracker_idThe Kochava-specific ID of the tracker to which the restated cost was attributed.
string
cost_network_idThe Kochava-specific ID of the network to which the restated cost data is attributed.
string (integer)
network_campaign_idUnique identifier associated with the network to which the restated cost data is attributed.
string (integer)
network_campaign_nameThe user defined name for the campaign to which the restated cost data is attributed.
string
typeThe type of ad being served.
string
total_daily_spend_restated_1_DayThe total restated daily spend day 1.
string (integer)
total_daily_spend_restated_2_DayThe total restated daily spend day 2.
string (integer)
total_daily_spend_restated_7_DayThe total restated daily spend day 7.
string (integer)
total_daily_spend_restated_14_DayThe total restated daily spend day 14.
string (integer)
string
total_daily_spend_restated_30_DayThe total restated daily spend day 30.
string (integer)
total_daily_spend_restated_60_DayThe total restated daily spend day 60.
string (integer)
deviceThe users device type.
string
genderthe gender of the user.
string
geographyThe geographic region of the device.
string
group_idThe campaign or ad group id of the device.
string
group_nameThe campaign or ad group name of the device.
string
imageThe ID/name of the creative which influenced the device.
string
nameGeneric placeholder, used if data not grouped by campaign or ad.
string
network_ad_idThe ID for the network ad.
string
string
platformThe device platform.
string
targetThe user group which the ad or campaign is targeting.
string
urlThe raw URL which was received from the device.
string
api_groupbyThe 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 NameDescription
Type
May be Null
RuleIDThe unique rule ID which can be used for reference in the full optimization rule set.
string (integer)
AppIDThe app ID assigned by Kochava.
string (integer)
NetworkIDThe Kochava-specific ID of the Network to which the impression originated.
string (integer)
NetworkNameThe name of the Network to which the impression originated.
string
TrackerNameThe user defined name for the tracker to which the impression was attributed.
string
ValueThe value of the targeted data point.
string
ValueThe value of the targeted data point.
string
NumberImpressionsThe number of impressions served matching that rule.
string (integer)
FullSetLiftThe 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 NameDescription
Type
May be Null
datetime_utcThe date and time of install (Coordinated Universal Time).
string (datetime)
datetime_adjustedThe date and time of install (Selected Time Zone).
string (datetime)
networkThe Kochava-specific ID of the Network to which the install is attributed.
string (integer)
network_nameThe name of the Network to which the install is attributed.
string
campaignThe Kochava-specific ID of the campaign to which the install was attributed.
string (integer)
campaign_nameThe user defined name for the campaign to which the install was attributed.
string
trackerThe Kochava-specific ID of the tracker to which the install was attributed.
string (integer)
tracker_nameThe user defined name for the tracker to which the install was attributed.
string
siteThe site on which the campaign was run.
string
creativeThe user defined name of the creative used in the campaign.
string
dmaThe code for the designated marketing area where the install originated, based on IP lookup.
string (integer)
stateAn alpha-numeric code identifying the geographic region where the click originated, based on IP lookup.
string
cityThe name of the city to which the install is attributed.
string
country2-digit country designation where the click originated, based on IP lookup.
string
cp_0 to cp_9Custom parameters passed with the click.
string
click_countThe total number of clicks during the selected time frame.
string (integer)
click_matched_to_imp_countThe total number of clicks matched to impressions.
string (integer)
click_duplicate_countThe total number of duplicate clicks during the selected time frame.
string (integer)
click_spendMoney spent per click, based on data received on the click.
string (float)
install_countThe number of install of the app during the selected time frame.
string (integer)
install_matched_to_click_countThe number of clicks matched to installs for the selected time frame.
string (integer)
install_matched_to_imp_countThe number of impressions matched to installs for the selected time frame.
string (integer)
install_matched_to_click_from_qrcode_countThe number of qr codes clicks matched to installs for the selected time frame.
string (integer)
install_spendMoney spent per install, based on data received on the install.
string (float)
impression_countThe number of impressions during the selected time frame.
string (integer)
impression_spendMoney spent per impression, based on data received on the click.
string (float)
click_from_qrcode_countThe total number of clicks generated from the QR code during the selected time frame.
integer
total_spend_on_traffic_selectedAssuming 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_reportedThis 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 NameDescription
Type
May be Null
datetime_utcThe date and time of install (Coordinated Universal Time).
string (datetime)
datetime_adjustedThe date and time of install (Selected Time Zone).
string (datetime)
networkThe Kochava-specific ID of the Network to which the install was attributed.
string (integer)
network_nameThe name of the Network to which the install was attributed.
string
campaignThe Kochava-specific ID of the campaign to which the install is associated.
string (integer)
campaign_nameThe user defined name of the campaign.
string
trackerThe Kochava-specific ID of the tracker to which the click was attributed.
string (integer)
tracker_nameThe user defined name for the tracker to which the click originated.
string
siteIdentifies the site to which the install was served within the publisher partner.
string
creativeThe user defined name of the creative used in the campaign.
string
dmaThe code for the designated marketing area where the install originated, based on IP lookup.
string (integer)
stateAn alpha-numeric code identifying the geographic region where the click originated, based on IP lookup.
string
cityThe name of the city to which the install is attributed.
string
country2-digit country designation where the click originated, based on IP lookup.
string
click_countThe total number of clicks during the selected time frame.
string (integer)
click_matched_to_imp_countThe number of impressions matched to clicks for the selected time frame.
string (integer)
click_duplicate_countThe total number of duplicate clicks during the selected time frame.
string (integer)
click_spendTotal spend data received on the click
string (float)
install_countThe number of installs of the app during the selected time frame.
string (integer)
install_matched_to_imp_countThe number of impressions matched to installs for the selected time frame.
string (integer)
install_matched_to_imp_countThe number of impressions matched to installs for the selected time frame.
string (integer)
install_spendMoney spent per install, based on data received on the install.
string (float)
impression_countThe number of impressions of the app during the selected time frame.
string (integer)
click_from_qrcode_countThe total number of clicks generated from the QR code during the selected time frame.
integer
install_matched_to_click_from_qrcode_countThe number of qr codes clicks matched to installs for the selected time frame.
string (integer)
total_spend_network_reportedThis 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_selectedAssuming 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 NameDescription
Type
May be Null
i_network_idThe Kochava-specific ID of the Network to which the event was attributed.
string (integer)
i_network_nameThe name of the Network to which the event originated.
string (integer)
installsThe number of installs of the app during the selected time frame.
integer
d1_retentionNumber of active users exactly 1 day after install.
integer
d2_retentionNumber of active users exactly 2 days after install.
integer
d3_retentionNumber of active users exactly 3 days after install.
integer
d5_retentionNumber of active users exactly 5 days after install.
integer
d7_retentionNumber of active users exactly 7 days after install.
integer
d14_retentionNumber of active users exactly 14 days after install.
integer
d21_retentionNumber of active users exactly 21 days after install.
integer
d30_retentionNumber 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 NameDescription
Type
May be Null
i_network_idThe Kochava-specific ID of the Network to which the event was attributed.
string (integer)
i_network_nameThe name of the Network to which the event originated.
string (integer)
installsThe number of installs of the app during the selected time frame.
integer
d1_retentionNumber of active users exactly 1 day after install.
integer
d2_retentionNumber of active users exactly 2 days after install.
integer
d3_retentionNumber of active users exactly 3 days after install.
integer
d5_retentionNumber of active users between 4 and 5 days after install.
integer
d7_retentionNumber of active users between 6 and 7 days after install.
integer
d14_retentionNumber of active users between 8 and 14 days after install.
integer
d21_retentionNumber of active users between 15 and 21 days after install.
integer
d30_retentionNumber 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 NameDescription
Type
May be Null
Filter
Group
date_range_start_utcThe start date for sk_installs based on install date and impression/click counts.
datetime
date_range_end_utcThe end date for sk_installs based on install date and impression/click counts.
datetime
ko_account_nameThe name of the advertiser’s account within Kochava.
string
ko_account_idThe numeric ID of the advertiser’s account in Kochava.
number
advertiser_app_store_idThe numeric ID of the app on the app store.
number
ko_app_nameThe name of the advertiser’s app in Kochava.
string
ko_app_idThe numeric ID of the advertiser’s app in Kochava.
number
ko_app_guidThe GUID of the advertiser’s app in Kochava.
string
sk_versionThe version of the SKAdNetwork API.
number
sk_ad_network_idThe ID assigned to the media partner by Apple when integrating with SKAdNetwork.
string
ko_media_partner_nameThe name of the integrated media partner in Kochava.
string
ko_media_partner_idThe numeric ID of the integrated media partner in Kochava.
number
sk_campaign_idThe numeric ID of the campaign was reported to SKAdNetwork on the loadproduct call. Integer between 1 and 100.
number
campaign_nameThe name of the campaign as specified in the media partner’s dashboard.
string
conversion_modelThe name of the conversion model chosen on the SKAdNetwork Settings page in Kochava.
string
measurement_windowThe 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_descriptionThe 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_valueThe user’s numerical conversion value. Integer between 0-63.
number
exchange_idThe ID of the ad exchange that served the bid request.
string
sk_publisher_app_store_idThe numeric ID of the app on the app store, where the ad was served.
number
site_idThe site ID of the app where the ad was served, shared by the media partner on the ad signal.
string
sub_site_idThe sub-site ID of the app where the ad was served, shared by the media partner on the ad signal.
string
campaign_idThe ID of the campaign as specified in the media partner’s dashboard.
string
sub_campaign_nameThe 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_idThe 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_amountAmount the advertiser bid for the ad to be served.
string
bid_currencyCurrency of bid amount.
string
bid_strategyThe bid strategy defined by the advertiser in the media partner’s dashboard.
string
bid_typeBid type set by the media partner.
string
campaign_objectiveObjective of campaign set in media partner dashboard.
string
campaign_statusStatus of a campaign in the media partner dashboard.
string
creative_idThe numerical id representing the ad creative served.
string
creative_nameThe name representing the ad creative served.
string
keywordThe keyword searched by the user that clicked the ad.
string
countryParameter passed by the media partner to Kochava in the payload.
string
sk_countryIf 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_installsCount of SKAdNetwork-reported installs.
number
sk_redownloadsCount 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 NameDescription
Type
May be Null
Filter
Group
date_range_start_utcThe start date for sk_installs based on install date and impression/click counts.
datetime
date_range_end_utcThe end date for sk_installs based on install date and impression/click counts.
datetime
ko_account_nameThe name of the advertiser’s account within Kochava.
string
ko_account_idThe numeric ID of the advertiser’s account in Kochava.
number
advertiser_app_store_idThe numeric ID of the app on the app store.
number
ko_app_nameThe name of the advertiser’s app in Kochava.
string
ko_app_idThe numeric ID of the advertiser’s app in Kochava.
number
ko_app_guidThe GUID of the advertiser’s app in Kochava.
string
sk_ad_network_idThe ID assigned to the media partner by Apple when integrating with SKAdNetwork.
string
ko_media_partner_nameThe name of the integrated media partner in Kochava.
string
ko_media_partner_idThe numeric ID of the integrated media partner in Kochava.
number
sk_campaign_idThe numeric ID of the campaign was reported to SKAdNetwork on the loadproduct call. Integer between 1 and 100.
number

campaign_nameThe name of the campaign as specified in the media partner’s dashboard.
string
sk_influencersCount of SKAdNetwork reported influencers.
number
sk_influencer_matched_to_clickCount of SKAdNetwork reported click-through influencers.
number
sk_influencer_matched_to_impressionCount of SKAdNetwork reported view-through influencers.
number
exchange_idThe ID of the ad exchange that served the bid request.
string
site_idThe site ID of the app where the ad was served, shared by the media partner on the ad signal.
string
sub_site_idThe sub-site ID of the app where the ad was served, shared by the media partner on the ad signal.
string
campaign_idThe ID of the campaign as specified in the media partner’s dashboard.
string
sub_campaign_nameThe 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_idThe 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_amountAmount the advertiser bid for the ad to be served.
string
bid_currencyCurrency of bid amount.
string
bid_strategyThe bid strategy defined by the advertiser in the media partner’s dashboard.
string
bid_typeBid type set by the media partner.
string
campaign_objectiveObjective of campaign set in media partner dashboard.
string
campaign_statusStatus of a campaign in the media partner dashboard.
string
creative_idThe numerical id representing the ad creative served.
string
creative_nameThe name representing the ad creative served.
string
keywordThe keyword searched by the user that clicked the ad.
string
countryParameter passed by the media partner to Kochava in the payload.
string
impressionsCount of impressions.
number
clicksCount of clicks.
number
sk_installsCount of SKAdNetwork-reported installs.
number
CTI (%)Percent of SKAdNetwork-reported installs to clicks. Up to 2 decimals
decimal
IPMInstalls per Mille. Count of SKAdNetwork-reported installs per 1000 impressions. Up to 4 decimals.
decimal
sk_redownloadsCount of SKAdNetwork-reported installs that were flagged as redownloads by SKAdNetwork.
number
inapp_conversionCount 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 NameDescription
Type
May be Null
entitlement_labelThe entitlement label(s) associated to entitlement_id set up by the user in Entitlements.
string
providerThe App Store associated to the entitlement_id.
string
ko_app_nameThe name of the advertiser’s app in Kochava and all associated apps in account that have Store Credentials saved.
string
in_trialIndication 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
durationThe subscription renewal duration entered by the user in Entitlements.
string
renewal_costCost of the subscription renewal, entered in Entitlements.
float
cancelguard_statusReason for subscription being in pending cancel state (billing issue, auto renew turned off).
float
cancelguard_date_occurredThe date the subscription first changed to pending cancel.
date
cancelguard_churn_dateThe date the subscription will be canceled if not recovered.
date
customer_idAny identities sent via SDK with the subscription event. Can be username, email or CRM ID.
string
original_receipt_idThe receipt id from the original receipt at the beginning of the subscription
string

Field NameDescription
Type
May be Null
entitlement_labelThe entitlement label(s) associated to entitlement_id set up by the user in Entitlements
string
providerThe App Store associated to the entitlement_id.
string
ko_app_nameThe name of the app in Kochava and all associated apps in account
string
in_trialIndication 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
durationThe subscription renewal duration entered by the user in Entitlements.
string
renewal_costCost of the subscription renewal, entered in Entitlements.
float
cancelguard_statusReason for subscription being in pending cancel state (billing issue, auto renew turned off).
string
cancelguard_date_occurredThe date the subscription first changed to pending cancel.
date
cancelguard_churn_dateThe date the subscription will be canceled if not recovered.
date
entitlement_idThe entitlement_ID the user entered in Entitlements that is associated with the receipt from the payment provider.
string
subscriber_id
string
receipt_idThe most recent receipt id for the subscription
string
subscription_activeSubscription is still active for the reporting period.
boolean
subscription_trialThe subscription is in a free trial.
boolean
subscription_ltvThe total sum of revenue generated for this subscription
float
renewal_dateThe date of the next renewal.
date
renewal_annual_mrrThe annual monthly recurring revenue for the renewal.
float
membership_started_firstThe date the membership first started.
date
membership_started_continuousThe earliest date for the current subscription started without any lapse.
date
membership_one_year_customerIndicates if the customer has a 1 year subscription.
boolean

 
 

Last Modified: Oct 26, 2022 at 3:03 pm