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
kochava_imp_id Kochava generated unique identifier associated with the impression which has been received.
string
kochava_device_id Kochava generated Unique ID assigned to device.
string
reengage_event_date_utc Date and time of the reengagement event (Coordinated Universal Time).
string
(datetime)
reengage_event_date_adjusted Date and time of the reengagement event (Selected Time Zone).
string
reengage_imp_month Date and time of the impression (Selected Time Zone).
string
(datetime)
reengage_imp_date_utc Date and time of the reengagement impression (Coordinated Universal Time).
string
(datetime)
reengage_imp_date_adjusted Date and time of the reengagement impression (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
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)
imp_from_qr_code The total number of impressions generated from the qr code during the selected time frame.
int
imp_original_request Raw URL which was received for specific impression.

NOTE: API call will return data in JSON format.

string
reengage_tier The tier/segment to which the reengagement is associated.
string

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 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
revenue_min For the Revenue model, this is the minimum value set in your conversion model configuration.
number
revenue_max For the Revenue model, this is the maximum value set in your conversion model configuration.
number
engagement_count For the Engagement model, this is the number of times that specified event has occurred
number
sk_install_matched_to_click Denotes if the user’s activity driven by a clicked ad interaction.
number
sk_install_matched_to_impression Denotes if the user’s activity driven by a viewed ad interaction.
number
sk_source_identifier Known as the “campaign ID” in previous SKAdNetwork versions, this value relates to the placement detail of the ad-network served inventory.
string
sk_coarse_conversion_value A coarse grained value is a type of hierarchical conversion value and can be low, medium, or high.
string
sk_postback_sequence_index In SKAdNetwork v4, a total of (3) user activities can be attributed by SKAdNetwork and this value indicates which of the 3 conversion windows that conversion occurred in.
number
sk_source_domain For web ads, the postback may include a source-domain instead of a source-app-id, indicating the conversion resulted from a mobile web ad unit.
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
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
sk_install_matched_to_click Denotes if the user’s activity driven by a clicked ad interaction.
number
sk_install_matched_to_impression Denotes if the user’s activity driven by a viewed ad interaction.
number
sk_source_identifier Known as the “campaign ID” in previous SKAdNetwork versions, this value relates to the placement detail of the ad-network served inventory.
string
sk_coarse_conversion_value A coarse grained value is a type of hierarchical conversion value and can be low, medium, or high.
string
sk_postback_sequence_index In SKAdNetwork v4, a total of (3) user activities can be attributed by SKAdNetwork and this value indicates which of the 3 conversion windows that conversion occurred in.
number
sk_source_domain For web ads, the postback may include a source-domain instead of a source-app-id, indicating the conversion resulted from a mobile web ad unit.
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
impressions Count of impressions.
number
clicks Count of clicks.
number
CTR The click-through rate.
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: Oct 26, 2023 at 1:45 pm