Support Home > Advanced Tools > Query Reference

Query Reference


The following document defines the tables accessible within Query for the creation of custom queries.

Download (Query-diagram_20180829.pdf) 

Clicks

The following tables associated with Click data are accessible within Query.

 

Click Geo Table:

 

Table Column Description
city The name of the city where the click originated based on IP lookup.
*click_id This is the primary key of this table and is used to join out to other tables within Kochava Query.
country_code 2-digit country designation where the click originated based on IP lookup.
date_received The datetime (10-digit epoch timestamp) the click was received.
latitude The latitude where the click originated based on IP lookup.
longitude The longitude where the click originated based on IP lookup.
postal_code The postal code of the region where the click originated based on IP lookup.
region An alphanumeric code identifying the geographic region where the click originated based on IP lookup.

* Indicates the foreign key for Click Tables JOIN.

 

Click Identifiers Table:

 

Table Column Description
*click_id This is the primary key of this table and is used to join out to other tables within Kochava Query.
date_received The datetime (10-digit epoch timestamp) the click was received.
identifier_type The type of identifier received from the click.
identifier_value A device identifier corresponding to the identifier_type of the row.

* Indicates the foreign key for Click Tables JOIN.

 

Click Properties Table:

 

Table Column Description
app_name The user-defined name for the app from which the click originated.
appstore_id The app-specific ID on the app store sites.
carrier The wireless carrier used on the device where the click originated.
click_cost The user-defined cost per click.
*click_id This is the primary key of this table and is used to join out to other tables within Kochava Query.
cost_type The Cost per Click, Cost per Install, or Cost per Mille.
country_code 2-digit country designation where the click originated, based on IP lookup.
cp1 thru cp15 User-defined custom parameters.

 

NOTE: Custom parameters available in the UI do not match the customer parameters available in Query. However, the click/UI parameters will map to the Query parameters with an offset of 1.

 

Click Key Kochava Query
cp_0 cp1
cp_1 cp2
cp_2 cp3
cp_3 cp4
cp_4 cp5
creative_id The network-supplied network_id value received on the click.
creative_size The dimensions of the served creative.
date_received The datetime (10-digit epoch timestamp) the click was received.
dma The code for the designated marketing area where the click originated, based on IP lookup.
exchange If an ad exchange is utilized, the name of the exchange will be displayed.
http_referrer The raw URL which was received from network referral.
original_request The query parameters and values received on the click.
partner_click_id The click ID as supplied by the network and received on the click.
referrer The Google Referrer parameters passed on the click.
site_id Identifies the site to which the click was served within the publisher partner.

* Indicates the foreign key for Click Tables JOIN.

 

Clicks Table:

 

Table Column Description
campaign_name The user-defined name for the campaign to which the click was attributed.
*click_id This is the primary key of this table and is used to join out to other tables within Kochava Query.
date_received The datetime (10-digit epoch timestamp) the click was received.
device_ua User Agent of the device gathered upon click.
duplicate The click_id of the duplicate click. If the value is 0, there is no duplicate click.
ip_address The IP address from which the click originated.
network_id The Kochava-specific ID of the network from which the click originated.
network_name The name of the network from which the click originated.
tracker_guid The Kochava-specific ID for the tracker from which the click originated. This field is also referred to as the campaign ID within other parts of analytics and reporting.
tracker_name The user defined name for the tracker to which the click originated.

* Indicates the foreign key for Click Tables JOIN.

 

Clicks Primary Table:

 

Table Column Description
adid Raw ADID received on the click (Android specific).
android_id Raw Android_ID received on the click (Android specific).
attribution_module The module (Kochava or SAN) in which attribution was determined.
campaign_name The user-defined name for the campaign to which the install was attributed.
city The name of the city where the click originated based on IP lookup.
*click_id This is the primary key of this table and is used to join out to other tables within Kochava Query.
cost The user-defined cost per click.
cost_type The Cost per Click, Cost per Install, or Cost per Mille.
country_code 2-digit country designation where the click originated, based on IP lookup.
cp1 thru cp15 User-defined custom parameters.

 

NOTE: Custom parameters available in the UI do not match the customer parameters available in Query. However, the click/UI parameters will map to the Query parameters with an offset of 1.

 

Click Key Kochava Query
cp_0 cp1
cp_1 cp2
cp_2 cp3
cp_3 cp4
cp_4 cp5
creative_id The network-supplied network_id value received on the click.
date_received The datetime (10-digit epoch timestamp) the click was received.
device_marketing_name The marketing name used to describe the device by the manufacturer (e.g. Galaxy S7).
device_model The model of the device that installed the app.
device_os_name The name of the operating system installed on the device.
device_os_version The version of the operating system installed on the device.
device_ua User Agent of the device gathered upon click.
device_ver The device type and version of the device received on click.
duplicate The click_id of the duplicate click. If the value is 0, there is no duplicate click.
identifiers An array of all device identifiers received on the click.
idfa Raw IDFA received on the click (iOS specific).
idfv Raw IDFV received on the click (iOS specific).
ip_address The IP address from which the click originated.
kochava_click_id Click ID assigned by Kochava.
latitude The latitude where the click originated based on IP lookup.
longitude The longitude where the click originated based on IP lookup.
matched_to_id The click_id or impression_id of the click/impression which won attribution.
matched_to_type The type of event which triggered the attribution (e.g. click, impression).
network_id The Kochava-specific ID of the network to which the install was attributed.
network_name The name of the network to which the install was attributed.
original_request The query parameters and values received on the click.
partner_click_id The click ID as supplied by the network and received on the click.
postal_code The postal code of the region where the click originated based on IP lookup.
region An alphanumeric code identifying the geographic region where the click originated based on IP lookup.
site_id Identifies the site to which the click was served within the publisher partner.
tracker_guid The Kochava-specific ID for the tracker from which the click originated. This field is also referred to as the campaign ID within other parts of analytics and reporting.
tracker_name The user defined name for the tracker to which the click originated.
traffic_verification_fail_reason The reason traffic has been flagged as invalid based on Traffic Verification rules.
traffic_verified Flag for whether the click passes the user defined Traffic Verification rules.
waterfall_level The location within the attribution waterfall where the winning click/impression occurred.

* Indicates the foreign key for Click Tables JOIN.

 

Click Table Join Example:

Events

 

Event Attribution Table:

 

Table Column Description
attribution_model The module (Kochava or SAN) in which attribution was determined.
campaign_name The user-defined name for the campaign to which the event was attributed.
click_reconciliation_id The internal Kochava ID used to identify the attribution associated with a click.
date_received The datetime (10-digit epoch timestamp) the event was received.
*event_id The internally generated unique ID to which the event is assigned.
imp_reconciliation_id An internal Kochava ID used to identify the attribution associated with a impression.
lookback_seconds The lookback window in seconds.
lookback_used A flag to indicate whether a lookback window has been used.
**matched_to_id The click_id or impression_id of the click/impression which won attribution.
matched_to_type The type of event which triggered the attribution (e.g. click, impression).
network_id The Kochava-specific ID of the network from which the event was attributed.
network_name The name of the network from which the event was attributed.
tracker_guid The Kochava-specific ID for the tracker from which the event was attributed.
tracker_name The user-defined name for the tracker to which the event was attributed.
waterfall_level The location within the attribution waterfall where the winning event occurred.

** Indicates the foreign key for Event Table JOIN.
** Indicates the foreign key for Click or Impression Tables JOIN.

 

Event Dimensions Table:

 

Table Column Description
date_received The datetime (10-digit epoch timestamp) the event was received.
dimension_key The specific keys for data being passed on a post-install event.
dimension_value The values of the dimension keys being passed on a post-install event.
*event_id The internally generated unique ID to which the event is attributed.

* Indicates the foreign key for Event Tables JOIN.

 

Event Geo Table:

 

Table Column Description
city The name of the city where the event originated based on IP lookup.
country_code The 2-digit country designation where the event originated based on IP lookup.
date_received The datetime (10-digit epoch timestamp) the event was recieved.
*event_id The internally generated unique ID to which the event is assigned.
latitude The latitude where the event originated based on IP lookup.
longitude The longitude where the event originated based on IP lookup.
postal_code The postal code of the region where the event originated based on IP lookup.
region An alphanumeric code identifying the geographic region where the event originated, based on IP lookup.

* Indicates the foreign key for Event Tables JOIN.

 

Events Table:

 

Table Column Description
cost The user-defined cost per event.
cost_type The Cost per Click, Cost per Install, or Cost per Mille.
date_occurred The datetime (10-digit epoch timestamp) the event occurred.
date_received The datetime (10-digit epoch timestamp) the event was received.
device_ua User Agent of the device gathered upon event.
*event_id The internally generated unique ID to which the event is attributed.
event_name The name of the advertiser defined event.
event_value The value of the post-install event if a revenue value is being passed.
**install_id The internally generated unique ID to which the install is attributed.
kochava_device_id The device ID assigned by Kochava.
sdk_version The version of the Kochava SDK installed in the app at time of event.
valid_receipt Flag indicating where a valid receipt was received from the app store for the install.

* Indicates the foreign key for Event Tables JOIN.
** Indicates the foreign key for Install Table JOIN.

 

Events Primary Table:

 

Table Column Description
adid Raw ADID received on the click (Android specific).
android_id Raw Android_ID received on the click (Android specific).
app_version The version of the app received on the install.
attribution_module The module (Kochava or SAN) in which attribution was determined.
campaign_name The user-defined name for the campaign to which the install was attributed.
city The name of the city where the click originated based on IP lookup.
cost The user-defined cost per click.
cost_type The Cost per Click, Cost per Install, or Cost per Mille.
country_code 2-digit country designation where the click originated, based on IP lookup.
creative_id The network-supplied network_id value received on the click.
date_occurred The datetime (10-digit epoch timestamp) the install occurred.
date_received The datetime (10-digit epoch timestamp) the event was received.
device_limit_tracking The customer defined ability to receive ads. Value will be 0 or 1.
device_marketing_name The marketing name used to describe the device by the manufacturer (e.g. Galaxy S7).
device_model The model of the device that installed the app.
device_os_name The name of the operating system installed on the device.
device_os_version The version of the operating system installed on the device.
device_ua User Agent of the device gathered upon click.
device_ver The device type and version of the device received on click.
event_dimensions A JSON object containing all custom-defined unique parameters associated with the event.
*event_id The internally generated unique ID to which the event is attributed.
event_name The name of the advertiser defined event.
event_value The value of the post-install event if a revenue value is being passed.
identifiers An array of all device identifiers received on the click.
identity_link A customer defined unique identifier for linking devices.
idfa Raw IDFA received on the click (iOS specific).
idfv Raw IDFV received on the click (iOS specific).
**install_id The internally generated unique ID to which the install is assigned.
ip_address The IP address from which the impression originated.
is_reengagement Indicates whether the event is part of a reengagement campaign.
kochava_device_id The device ID assigned by Kochava.
latitude The latitude where the event originated based on IP lookup.
longitude The longitude where the event originated based on IP lookup.
lookback_seconds The lookback window in seconds.
lookback_used An indicator of where the lookback window used was set (e.g. network, default).
match_object A JSON object containing a variety of details about the attribution of the event.
properties – A JSON object containing a variety of details about the event that may or may not be included in other columns.
matched_to_id The click_id or impression_id of the click/impression which won attribution.
matched_to_type The type of event which triggered the attribution (e.g. click, impression).
network_id The id of the network to which the install was attributed.
network_name The name of the network to which the install was attributed.
postal_code The postal code of the region where the click originated based on IP lookup.
properties
region An alphanumeric code identifying the geographic region where the install originated based on IP lookup.
sdk_version The version of the Kochava SDK installed in the app at time of event.
site_id Identifies the site to which the click was served within the publisher partner.
tracker_guid The Kochava-specific ID for the tracker from which the click originated. This field is also referred to as the campaign ID within other parts of analytics and reporting.
tracker_name The user defined name for the tracker to which the click originated.
traffic_verification_fail_reason The reason traffic has been flagged as invalid based on Traffic Verification rules.
traffic_verified Flag for whether the click passes the user defined traffic verification rules.
valid_receipt Flag indicating where a valid receipt was received from the app store for the install.
waterfall_level The location within the attribution waterfall where the winning event occurred.

* Indicates the foreign key for Event Tables JOIN.
** Indicates the foreign key for Install Table JOIN.

 

Event Table Join Example:

Identity Link

 

Identity Link Table:

 

Table Column Description
date_received The datetime (10-digit epoch timestamp) the click was received.
*event_id The internally generated unique ID to which the event is attributed.
identity_name The custom-defined parameter name of the identity link.
identity_value The custom parameter value associated with the identity_name.
**install_id The internally generated unique ID to which the install is attributed.
kochava_device_id The device ID assigned by Kochava.

* Indicates the foreign key for Event Tables JOIN.
** Indicates the foreign key for Install Tables JOIN.

Impressions

 

Impressions Geo Table:

 

Table Column Description
city The name of the city where the impression originated based on IP lookup.
country_code The 2-digit country designation where the impression originated, based on IP lookup.
date_received The datetime (10-digit epoch timestamp) the impression was received.
*impression_id The internally generated unique ID to which the impression is attributed.
latitude The latitude where the impression originated based on IP lookup.
longitude The longitude where the impression originated based on IP lookup.
region An alphanumeric code identifying the geographic region where the impression originated, based on IP lookup.

* Indicates the foreign key for Impression Tables JOIN.

 

Impression Identifiers Table:

 

Table Column Description
date_received The datetime (10-digit epoch timestamp) the impression was received.
identifier_value The value of the device identifier.
*impression_id The internally generated unique ID to which the impression is attributed.

* Indicates the foreign key for Impression Tables JOIN.

 

Impression Properties Table:

 

Table Column Description
app_name The user-defined name for the app from which the click originated.
appstore_id The app-specific ID on the app store sites.
carrier The wireless carrier used on the device where the click originated.
cost_type The Cost per Click, Cost per Install, or Cost per Mille.
country_code 2-digit country designation where the click originated, based on IP lookup.
cp1 thru cp15 User-defined custom parameters.

 

NOTE: Custom parameters available in the UI do not match the customer parameters available in Query. However, the click/UI parameters will map to the Query parameters with an offset of 1.

 

Click Key Kochava Query
cp_0 cp1
cp_1 cp2
cp_2 cp3
cp_3 cp4
cp_4 cp5
creative_id The network-supplied network_id value received on the click.
creative_size The dimensions of the served creative.
date_received The datetime (10-digit epoch timestamp) the impression was received.
dma The code for the designated marketing area where the click originated, based on IP lookup.
exchange If an ad exchange is utilized, the name of the exchange will be displayed.
imp_cost The Cost per Impression.
imp_type The type of impression that was servered.
*impression_id The internally generated unique ID to which the impression is attributed.
original_request The query parameters and values received on the click.
partner_impression_id The unique ID generated by the partner for the impression.
referrer The Google Referrer parameters passed on the click.
site_id Identifies the site to which the click was served within the publisher partner.

* Indicates the foreign key for Impression Tables JOIN.

 

Impressions Table:

 

Table Column Description
date_received The datetime (10-digit epoch timestamp) the impression was received.
device_ua User Agent of the device gathered upon impression.
*impression_id The internally generated unique ID to which the impression is attributed.
ip_address The IP address from which the impression originated.
network_id The Kochava-specific ID of the network from which the impression originated.
tracker_guid The Kochava-specific ID for the tracker from which the impression originated. This field is also referred to as the campaign ID within other parts of analytics and reporting.
tracker_id The Kochava-specific ID of the tracker from which the impression originated.

* Indicates the foreign key for Impression Tables JOIN.

 

Impressions Primary Table:

 

Table Column Description
campaign_name The user-defined name for the campaign to which the click was attributed.
city The name of the city where the impression originated based on IP lookup.
cost The user-defined cost per click.
cost_type The Cost per Click, Cost per Install, or Cost per Mille.
country_code 2-digit country designation where the click originated, based on IP lookup.
creative_id The network-supplied network_id value received on the click.
date_received The datetime (10-digit epoch timestamp) the impression was received.
device_marketing_name The marketing name used to describe the device by the manufacturer (e.g. Galaxy S7).
device_model The model of the device that installed the app.
device_os_name The name of the operating system installed on the device.
device_os_version The version of the operating system installed on the device.
device_ua User Agent of the device gathered upon click.
device_ver The device type and version of the device received on click.
identifiers An array of all device identifiers received on the click.
imp_type The type of impression that was servered.
*impression_id The internally generated unique ID to which the impression is attributed.
ip_address The IP address from which the impression originated.
kochava_impression_id The impression ID assigned by Kochava.
latitude The latitude where the click originated based on IP lookup.
longitude The longitude where the click originated based on IP lookup.
network_id The Kochava-specific ID of the network from which the click originated.
network_name The name of the network from which the click originated.
original_request The query parameters and values received on the click.
partner_impression_id The impression ID assigned by the partner.
region An alphanumeric code identifying the geographic region where the impression originated, based on IP lookup.
site_id Identifies the site to which the click was served within the publisher partner.
tracker_guid The Kochava-specific ID for the tracker from which the click originated. This field is also referred to as the campaign ID within other parts of analytics and reporting.
tracker_id The Kochava-specific ID of the tracker from which the impression originated.
tracker_name The user defined name for the tracker to which the install was attributed.
traffic_verification_fail_reason The reason traffic has been flagged as invalid based on Traffic Verification rules.
traffic_verified Flag for whether the click passes the user defined traffic verification rules.

* Indicates the foreign key for Impression Tables JOIN.

 

Impression Table Join Example:

Attribution

 

Install Attribution Table:

 

Table Column Description
attribution_module The module (Kochava or SAN) in which attribution was determined.
campaign_name The user-defined name for the campaign to which the install was attributed.
click_reconciliation_id The internal Kochava ID used to identify the attribution associated with a click.
date_received The datetime (10-digit epoch timestamp) the install was received.
imp_reconciliation_id An internal Kochava ID used to identify the attribution associated with a impression.
*install_id The internally generated unique ID to which the install is assigned.
lookback_seconds The lookback window in seconds.
lookback_used An indicator of where the lookback window used was set (e.g. network, default).
**matched_to_id The click_id or impression_id of the click/impression which won attribution.
matched_to_type The type of event which triggered the attribution (e.g. click, impression).
network_id The Kochava-specific ID of the network to which the install was attributed.
network_name The name of the network to which the install was attributed.
tracker_guid The Kochava-specific ID for the tracker to which the install was attributed.
tracker_name The user defined name for the tracker to which the install was attributed.
waterfall_level The location within the attribution waterfall where the winning click/impression occurred.

* Indicates the foreign key for Install Table JOIN.
** Indicates the foreign key for Click or Impression Tables JOIN.

Installs

 

Install Geo Table:

 

Table Column Description
city The name of the city where the install originated based on IP lookup.
country_code The 2-digit country designation where the click originated based on IP lookup.
date_received The datetime (10-digit epoch timestamp) the install was received.
*install_id The internally generated unique ID to which the install is attributed.
latitude The latitude where the install originated based on IP lookup.
longitude The longitude where the install originated based on IP lookup.
postal_code The postal code of the region where the install originated based on IP lookup.
region An alphanumeric code identifying the geographic region where the install originated based on IP lookup.

* Indicates the foreign key for Install Tables JOIN.

 

Install Identifiers Table:

 

Table Column Description
date_received The datetime (10-digit epoch timestamp) the install was received
identifier_type The type of identifier received on the install.
identifier_value A device identifier corresponding to the identifier_type of the row.
*install_id The internally generated unique ID to which the install is attributed.

* Indicates the foreign key for Install Tables JOIN.

 

Install Influencers Table:

 

Table Column Description
*click_id Identifier associated with the influencing click associated to the influenced install. A foreign key which can be used to join out to other tables within Kochava Query.
click_reconciliation_id The internal Kochava ID used to identify the attribution associated with a click.
date_received The datetime (10-digit epoch timestamp) the install was received.
**imp_id Identifier associated with the influencing impression associated to the influenced install. A foreign key which can be used to join out to other tables within Kochava Query.
imp_reconciliation_id The internal Kochava ID used to identify the attribution associated with an impession.
***install_id This is a foreign key of this table and is used to join out to other tables within Kochava Query.
rejected The reason the install was attributed to another Network (for example, another network was credited with last-click).
waterfall_level The location within the attribution waterfall where the winning click/impression occurred.

* Indicates the foreign key for the Click Tables JOIN.
** Indicates the foreign key for Impression Tables JOIN.
*** Indicates the foreign key for Install Tables JOIN.

 

Installs Table:

 

Table Column Description
app_version The version of the app received on the install.
cost The user-defined cost per click.
cost_type The Cost per Click, Cost per Install, or Cost per Mille.
date_occured [sic] The datetime (10-digit epoch timestamp) the click occurred.
date_received The datetime (10-digit epoch timestamp) the install was received.
device_limit_tracking The customer defined ability to receive ads. Value will be 0 or 1.
device_model The model of the device that installed the app.
device_ua User Agent of the device gathered upon install.
device_ver The device type and version of the device received on click.
duplicate The ID assigned to duplicate installs.
*install_id The internally generated unique ID to which the install is attributed.
kochava_device_id The device ID assigned by Kochava.
properties
sdk_version The version of the Kochava SDK installed in the app at time of install.
traffic_verified Flag for whether the click passes the user defined traffic verification rules.
valid_receipt Flag indicating where a valid receipt was received from the app store for the install.

* Indicates the foreign key for Install Tables JOIN.

 

Installs Primary Table:

 

Table Column Description
adid Raw ADID received on the click (Android specific).
android_id Raw Android_ID received on the click (Android specific).
app_version The version of the app received on the install.
attribution_module The module (Kochava or SAN) in which attribution was determined.
campaign_name The user-defined name for the campaign to which the install was attributed.
city The name of the city where the click originated based on IP lookup.
cost The user-defined cost per click.
cost_type The Cost per Click, Cost per Install, or Cost per Mille.
country_code 2-digit country designation where the click originated, based on IP lookup.
creative_id The network-supplied network_id value received on the click.
date_occured [sic] The datetime (10-digit epoch timestamp) the click occurred.
date_received The datetime (10-digit epoch timestamp) the install was received.
device_limit_tracking The customer defined ability to receive ads. Value will be 0 or 1.
device_marketing_name The marketing name used to describe the device by the manufacturer (e.g. Galaxy S7).
device_model The model of the device that installed the app.
device_os_name The name of the operating system installed on the device.
device_os_version The version of the operating system installed on the device.
device_ua User Agent of the device gathered upon click.
device_ver The device type and version of the device received on click.
duplicate The click_id of the duplicate click. If the value is 0, there is no duplicate click.
identifiers An array of all device identifiers received on the click.
identity_link A JSON object containing all custom-defined unique identifiers associated with the device that drove the install.
idfa Raw IDFA received on the click (iOS specific).
idfv Raw IDFV received on the click (iOS specific).
*install_id The internally generated unique ID to which the install is assigned.
ip_address The IP address from which the impression originated.
kochava_device_id The device ID assigned by Kochava.
latitude The latitude where the event originated based on IP lookup.
longitude The longitude where the event originated based on IP lookup.
match_object A JSON object containing a variety of details about the attribution of the install.
properties – A JSON object containing a variety of details about the install that may or may not be included in other columns.
matched_to_id The click_id or impression_id of the click/impression which won attribution.
matched_to_type The type of event which triggered the attribution (e.g. click, impression).
network_id The Kochava-specific ID of the network to which the install was attributed.
network_name The name of the network to which the install was attributed.
postal_code The postal code of the region where the click originated based on IP lookup.
properties
region An alphanumeric code identifying the geographic region where the install originated based on IP lookup.
sdk_version The version of the Kochava SDK installed in the app at time of event.
site_id Identifies the site to which the click was served within the publisher partner.
tracker_guid The Kochava-specific ID for the tracker from which the click originated. This field is also referred to as the campaign ID within other parts of analytics and reporting.
tracker_name The user defined name for the tracker to which the click originated.
traffic_verification_fail_reason The reason traffic has been flagged as invalid based on Traffic Verification rules.
traffic_verified Flag for whether the click passes the user defined traffic verification rules.
valid_receipt Flag indicating where a valid receipt was received from the app store for the install.
waterfall_level The location within the attribution waterfall where the winning click/impression occurred.

* Indicates the foreign key for Install Tables JOIN.

 

Install Table Join Example:

 
 

Last Modified: Aug 29, 2018 at 8:55 am