This document provides a detailed description of the reports available from the Kochava Reports UI. The different types of reports that can be generated include, but are not limited to, Click, Event, Install, Campaign Summary, Network Summary.
For more information on how to pull reports, refer to our Pulling Reports support documentation.
NOTE: The Click, Event and Install reports are fully customizable allowing the user to decide which data is present and the order that the data is presented within the report. For more information about customizing the Click, Event and Install reports, refer to our Pulling Reports support documentation.
NOTE: Detail Reports that exceed 5.0 gigabytes in size will be compressed to enable accelerated download.
NOTE: For a sample of each of the reports listed below, download our KochavaReportsDemo document.
NOTE: There are several sources of Restricted data you’ll 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.
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.
Click Report
The Click Report provides a row-level view of clicks for a given campaign.
| Field Name | Description | Type | May be Null |
Character Limit |
|---|---|---|---|---|
| click_campaign | The Free App Analytics-specific ID of the campaign to which the click was attributed. | string | no | longtext |
| click_campaign_name | The user defined name for the campaign to which the click was attributed. | string | yes | 255 |
| click_country_code | 2-digit country designation where the click originated, based on IP lookup. | string | yes | 2 |
| click_creative | Data received on click in the creative_id parameter. | string | yes | 128 |
| click_custom_parameters | Custom parameters passed with the click. | string | no | |
| click_date_adjusted | Date and time of the click (Selected Time Zone). | string (datetime) | no | datetime |
| click_date_utc | Date and time of the click (Coordinated Universal Time). | string (datetime) | no | datetime |
| click_device_id | An internal identifier used for mapping purposes. | string (int) | yes | 255 |
| click_device_ua | User Agent of the device gathered upon click. |
string | yes | longtext |
| click_device_ver | The device type and version of the device received on click. | string | yes | 128 |
| click_duplicate | The ID assigned to duplicate clicks. | string | yes | 20 |
| click_id | Click ID assigned by Free App Analytics. | string | yes | longtext |
| click_identifiers | An array of all device identifiers received on the click. | json (strings) | yes | text |
| click_identifiers_adid | Raw ADID provided on the click (Android specific). | string | yes | 255 |
| click_identifiers_android_id | Raw Android_ID received on the click (Android specific). |
string | yes | 255 |
| click_identifiers_android_id_md5 | MD5 encrypted Android_ID received on the click (Android specific). |
string | yes | 255 |
| click_identifiers_android_id_sha1 | SHA1 encrypted Android_ID received on the click (Android specific). | string | yes | 255 |
| click_identifiers_custom | Custom provided identifier received with the click. |
string | yes | 255 |
| click_identifiers_email_0 | Primary email address delivered with the click. |
string | yes | 255 |
| click_identifiers_email_1 | Secondary email address delivered with the click. |
string | yes | 255 |
| click_identifiers_idfa | Raw IDFA received on the click (iOS specific). | string | yes | 255 |
| click_identifiers_ip | Raw IP address where the click originated. | string | yes | 255 |
| click_identifiers_waid | Raw WAID received on the click (Windows specific). | string | yes | 255 |
| click_ip | The IP address from which the click originated. | string | no | 16 |
| click_matched_impression | ID representation of the impression which the click was matched to. |
string (int) | yes | 20 |
| click_matched_install | ID representation of the install which matched to the click. |
string (int) | yes | 20 |
| click_network | The Free App Analytics-specific ID of the Network to which the click originated. | string (int) | no | 11 |
| click_network_name | The name of the Network to which the click originated. | string | yes | 256 |
| click_original_request | Raw URL which was received for specific click.
NOTE: API call will return data in JSON format. |
string | yes | longtext |
| click_price | The price per click. | string (float) | yes | 2 |
| click_site | Identifies the site to which the click was served within the publisher partner. | string | yes | 512 |
| click_status | Indicator to define if the click has simply been received (publish) or matched to an install. |
string | no | 16 |
| click_tier | The tier/segment to which the click is associated. | string | yes | 100 |
| click_tracker | The Free App Analytics-specific ID of the tracker to which the click originated. | string (int) | no | 20 |
| click_tracker_name | The user defined name for the tracker to which the click originated. | string | yes | 100 |
| clickgeo_area_code | The area code where the click originated, based on IP lookup. | string (int) | yes | 16 |
| clickgeo_city | The name of the city where the click originated, based on IP lookup. | string | yes | 32 |
| clickgeo_continent_code | 2-digit continent designation where the click originated, based on IP lookup. | string | yes | 2 |
| clickgeo_country_code | 2-digit country designation where the click originated, based on IP lookup. | string | yes | 2 |
| clickgeo_country_code3 | 3-digit country designation where the click originated, based on IP lookup. | string | yes | 3 |
| clickgeo_country_name | The name of the country where the click originated, based on IP lookup. | string | yes | 32 |
| clickgeo_dma_code | The code for the designated marketing area where the click originated, based on IP lookup. | string (int) | yes | 16 |
| clickgeo_latitude | The latitude where the click originated, based on IP lookup. | string (float) | yes | 18,14 |
| clickgeo_longitude | The longitude where the click originated, based on IP lookup. | string (float) | yes | 18,14 |
| clickgeo_postal_code | The postal code of the region where the click originated, based on IP lookup. | string (int) | yes | 16 |
| clickgeo_region | An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup. | string | yes | 32 |
| impression_campaign | The Free App Analytics-specific ID of the campaign to which the click was attributed. | string (int) | yes | 20 |
| impression_campaign_name | The user defined name for the campaign to which the click was attributed. | string | yes | 255 |
| impression_country_code | 2-digit country designation where the impression originated, based on IP lookup. | string | yes | 2 |
| impression_creative | Data received on impression in the creative_id parameter. | string | yes | 64 |
| impression_date_adjusted | The date the impression occurred (Selected Time Zone). | string (date) | yes | datetime |
| impression_date_utc | The date the impression occurred in UTC. | string (date) | yes | datetime |
| impression_device_ver | The device type and version of the device received on impression. | string | yes | 64 |
| impression_identifiers | An array of all device identifiers received on the impression. | json (strings) | yes | text |
| impression_imp_id | Unique identifier associated with the impression which has been received. | string (int) | yes | 11 |
| impression_ip | The IP address from which the impression originated. | string | yes | 16 |
| impression_kochava_imp_id | Free App Analytics generated unique identifier associated with the impression which has been received. |
string | yes | 50 |
| impression_matched_click | ID representation of the click which the impression was matched to. | string (int) | yes | 20 |
| impression_matched_install | ID representation of the install which matched to the impression. | string (int) | yes | 20 |
| impression_network | The Free App Analytics-specific ID of the Network to which the impression originated. | string (int) | yes | 7 |
| impression_network_name | The name of the Network to which the impression originated. | string | yes | 256 |
| impression_original_request | Raw URL which was received for specific impression.
NOTE: API call will return data in JSON format. |
string | yes | text |
| impression_site | Identifies the site to which the impression was served within the publisher partner. | string | yes | 255 |
| impression_tracker | The Free App Analytics-specific ID of the tracker to which the impression was attributed. | string (int) | yes | 20 |
| impression_tier | The tier/segment to which the impression is associated. | string | yes | 100 |
| impression_tracker_name | The user defined name for the tracker to which the click was attributed. | string | yes | 100 |
| kochava_click_id | Click ID assigned by Free App Analytics. | string | yes | longtext |
| partner_click_id | Click ID as received from the partner. | string | yes | longtext |
| reengagement_tier | The tier/segment to which the reengagement is associated. | string | yes | 100 |
| traffic_click_verification_status | Indicator if the click traffic was valid or invalid based on Traffic Verification rules. | json (strings) | yes | 16 |
| traffic_verification_status | Indicator if the click traffic was valid or invalid based on Traffic Verification rules. |
string | yes | 1 |
| click_att | The device ATT status. | string | yes | 5 |
| click_att_detail | ATT status 1 – authorized ATT status 0 – |
string | yes | 58 |
| click_att_time | User response timestamp. | string (datetime) |
yes | datetime |
| click_att_duration_sec | string (datetime) |
yes | datetime |
NOTE: Some columns within the report may contain JSON encoded data. These columns will have “*_querystring” versions that will provide a URL QueryString encoded version of these columns. The JSON path for each value in the JSON will be used as the querystring key for that value.
Click MTA Report
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 |
Character Limit |
|---|---|---|---|---|
| install_id | The internally generated unique ID to which the install is attributed. | string (int) | no | 11 |
| install_date_utc | Date and time of install (Coordinated Universal Time). | string (datetime) | no | datetime |
| install_date_adjusted | Date and time of install (Selected Time Zone). | string (datetime) | no | datetime |
| clickwin_id | The ID of the click that won attribution. | string (int) | no | 11 |
| clickwin_network | The ID of the network awarded the winning click. | string (int) | no | 11 |
| clickwin_network_name | The name of the network awarded the winning click. | string | yes | 256 |
| clickwin_site | Identifies the site to which the winning click was served within the publisher partner. | string | yes | 512 |
| clickwin_creative_id | The ID/name of the creative which drove the winning click. | string | yes | 512 |
| clickwin_date_utc | Date and time of the winning click (Coordinated Universal Time). | string (datetime) | no | datetime |
| clickwin_date_adjusted | Date and time of the winning click (Selected Time Zone). | string (datetime) | no | datetime |
| clickwin_matched_on | Provides the actual piece of data that the click was mtched on; that is, the device ID. | string | no | 64 |
| clickwin_match_type | The ID type to which the winning click is attributed. | string | no | 32 |
| influencer_id | Unique identifier associated with the influencer which has been received. | string (int) | no | 20 |
| influencer_network | The ID of the network which influenced the winning click. | string (int) | no | 11 |
| influencer_network_name | The name of the network which influenced the winning click. | string | yes | 256 |
| inf_site | Identifies the site to which the influencer was served within the publisher partner. | string | yes | 512 |
| inf_creative_id | The ID/name of the creative which influenced the click. | string | yes | 512 |
| influencer_date_utc | Date and time the influencer was served (Coordinated Universal Time). | string (datetime) | no | datetime |
| influencer_date_adjusted | Date and time the influencer was served (Selected Time Zone). | string (datetime) | no | datetime |
| influencer_matched_on | Provides the actual piece of data the influencer was matched on; for example, the device ID. | string | no | 64 |
| influencer_match_type | Description of how we matched the install to the influencer; for example, device ID, Facebook, etc | string | no | 32 |
| kochava_click_id | Click ID assigned by Free App Analytics. | string | yes | longtext |
| rejected_because | The reason the install was attributed to another Network (for example, another network was credited with last-click).
device_id_inclusive – Reconciliation settings are set to default, the click had a mismatched device_id but would have been eligible to win attribution on fingerprint if inclusive had been set. fingerprint_equalizer_lookback – Fingerprint Equalizer was activated and the click would have been eligible to win attribution, but the click occurred outside the configured Fingerprint Equalizer lookback window. ip_disabled – The click would have been eligible to match on IP if that setting was enabled. last_click – The click was eligible to win attribution, but there was a more recent click closer to the install that won attribution. lookback_disabled – The click would have been eligible to match, but the lookback setting was disabled. lookback_enforced – The click would have matched but it occurred outside the configured lookback window (ex: click was at 10 days prior to the install but lookback was set to 9 days). partial_ip_disabled – The click would have been eligible to match on partial IP if that setting was enabled.
|
string | no | 64 |
| attribution_tier | The tier/segment to which the attribution is associated. | string | yes | 100 |
| click_tier | The tier/segment to which the click is associated. | string | yes | 100 |
| impression_tier | The tier/segment to which the impression is associated. | string | yes | 100 |
| reengagement_tier | The tier/segment to which the reengagement is associated. | string | yes | 100 |
NOTE: Some columns within the report may contain JSON encoded data. These columns will have “*_querystring” versions that will provide a URL QueryString encoded version of these columns. The JSON path for each value in the JSON will be used as the querystring key for that value.
Cost Report
| Field Name | Description | Type | May be Null |
Character Limit |
|---|---|---|---|---|
| date_retrieved | The timeframe from the network for pricing data. | string (datetime) |
no | datetime |
| starting_date | The date and time that the cost data began being collected. | string (datetime) |
no | datetime |
| ending_date | The date and time that the cost data ended being collected. | string (datetime) |
no | datetime |
| cost_network_id | The Free App Analytics-specific ID of the network to which the cost data is attributed. | string (int) |
yes | 20 |
| cost_network_name | The name of the network to which the cost data is attributed. | string | yes | 256 |
| network_campaign_id | Unique identifier associated with the network to which the cost data is attributed. | string (int) |
no | 100 |
| network_campaign_name | The user defined name for the campaign to which the cost data is attributed. | string | yes | 256 |
| type | The type of ad being served. | string | yes | 256 |
| click_thru_rate | The ratio of users who click on an ad to the number of total users who view the ad. | string (int) |
yes | float |
| cost_per_click | The cost of a click on the served ad. | string (int) |
yes | float |
| cost_per_completed_view | The cost for a completed view of a served ad. | string (int) |
yes | float |
| cost_per_impression | The cost of an impression served. | string (int) |
yes | float |
| cost_per_install | The cost of an install. | string (int) |
yes | float |
| cost_per_view | The cost per view of video ads. | string (int) |
yes | float |
| total_daily_cumulative_spend | This is what the network has told Free App Analytics via the API by hour in aggregate (this is a 24 hour rolling aggregation based when the network cycles their spend cycle) how much was spent in total for the network. It is required to have the Free App Analytics tracker GUIDs entered in the network_campaign_name within the network dashboard, if tracker GUID is not entered, then this field is blank. | string (int) |
yes | float |
| device | The users device type. | string | yes | 256 |
| gender | The gender of the user. | string | yes | 256 |
| geography | The geographic region of the device. | string | yes | 256 |
| group_id | The campaign or ad group id of the device. | string | yes | 100 |
| group_name | The campaign or ad group name of the device. | string | yes | 100 |
| image | The ID/name of the creative which influenced the device. | string | yes | 256 |
| keywords | Campaign keywords. | string | yes | 256 |
| name | Generic placeholder, used if data not grouped by campaign or ad. | string | yes | 256 |
| network_ad_id | The ID for the network ad. | string | no | 20 |
| platform | The device platform. | string | yes | 256 |
| target | The user group which the ad or campaign is targeting. | string | yes | 256 |
| url | The raw URL which was received from the device. | string | yes | 256 |
NOTE: Some columns within the report may contain JSON encoded data. These columns will have “*_querystring” versions that will provide a URL QueryString encoded version of these columns. The JSON path for each value in the JSON will be used as the querystring key for that value.
Event Report
The Event Report provides a row-level report on events.
NOTE: Details for currency normalization can be found within the custom_dimensions field.
| Field Name | Description | Type | May be Null |
Character Limit |
|---|---|---|---|---|
| attribution_attribution_action | The action through which attribution was achieved, install or event. |
string | no | 32 |
| attribution_campaign | The user defined name for the campaign to which the event was attributed. | string | yes | 255 |
| attribution_campaign_id | The Free App Analytics-specific ID of the campaign to which the event was attributed. | string | no | 20 |
| attribution_creative | Data received on event in the creative_id parameter. | string | yes | 64 |
| attribution_date_adjusted | The date and time of attribution (Adjusted to the Selected Time Zone). | string (datetime) | no | datetime |
| attribution_date_utc | The date and time of attribution. (Coordinated Universal Time). | string (datetime) | yes | 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 | yes | 5 |
| attribution_matched_by | The identifier by which attribution was matched. | string | no | 32 |
| attribution_matched_to | The initial action by which attribution was matched, impression or click or impression with click. |
string | no | 32 |
| attribution_network | The Free App Analytics-specific ID of the Network to which the event was attributed. | string | no | 11 |
| attribution_network_id | Unique identifier associated with the network to which the event was attributed. | string (int) | no | 64 |
| attribution_seconds_since | The number of seconds since attribution was made. | int | no | 8 |
| attribution_site_id | Identifies the site to which the event was attributed within the publisher partner. | string | yes | 512 |
| attribution_tier | The tier/segment to which the attribution is associated. | string | yes | 100 |
| attribution_timestamp | The date and time of attribution(Coordinated Universal Time). | string (datetime) | no | datetime |
| attribution_timestamp_adjusted | The date and time of attribution (Adjusted to the Selected Time Zone). | string (datetime) | no | datetime |
| attribution_tracker | The Free App Analytics-specific ID of the tracker to which the event was attributed. | string | yes | 100 |
| attribution_tracker_id | The Free App Analytics-specific ID of the tracker to which the event was attributed. | string | no | 20 |
| attribution_tracker_name | The user defined name for the tracker to which the event was attributed. | string | yes | 100 |
| click_campaign | The Free App Analytics-specific ID of the campaign to which the click was attributed. | string | yes | longtext |
| click_campaign_name | The user defined name for the campaign to which the click was attributed. | string | yes | 255 |
| click_country_code | 2-digit country designation where the click originated, based on IP lookup. | string | yes | 2 |
| click_creative | Data received on click in the creative_id parameter. | string | yes | 128 |
| click_custom_parameters | Custom parameters passed with the click. | string | no | |
| click_date_adjusted | Date and time of the click (Selected Time Zone) | string (datetime) | yes | datetime |
| click_date_utc | Date and time of the click (Coordinated Universal Time). | string (datetime) | yes | datetime |
| click_device_id | An internal identifier used for mapping purposes. | string (int) | yes | 255 |
| click_device_ua | User Agent of the device gathered upon click. | string | yes | longtext |
| click_device_ver | The device type and version of the device received on click. | string | yes | 128 |
| click_duplicate | The ID assigned to duplicate clicks. | string (int) | yes | 20 |
| click_identifiers | An array of all device identifiers received on the click. | json (strings) | yes | text |
| click_identifiers_adid | Raw ADID provided on the click (Android specific). | string | yes | 255 |
| click_identifiers_android_id | Raw Android_ID received on the click (Android specific). | string | yes | 255 |
| click_identifiers_android_id_md5 | MD5 encrypted Android_ID received on the click (Android specific). | string | yes | 255 |
| click_identifiers_android_id_sha1 | SHA1 encrypted Android_ID received on the click (Android specific). | string | yes | 255 |
| click_identifiers_custom | Custom provided identifier received with the click. | string | yes | 255 |
| click_identifiers_email_0 | Primary email address delivered with the click. | string | yes | 255 |
| click_identifiers_email_1 | Secondary email address delivered with the click. | string | yes | 255 |
| click_identifiers_idfa | Raw IDFA received on the click (iOS specific). | string | yes | 255 |
| click_identifiers_ip | Raw IP address where the click originated. | string | yes | 255 |
| click_identifiers_waid | Raw WAID received on the click (Windows specific). | string | yes | 255 |
| click_ip | The IP address from which the click originated. | string | yes | 16 |
| click_matched_impression | ID representation of the impression which the click was matched to. | string (int) | yes | 20 |
| click_matched_install | ID representation of the install which matched to the click. | string (int) | yes | 20 |
| click_month | The numeric value of the month the install was received. | string (int) | yes | 1 |
| click_network | The Free App Analytics-specific ID of the Network to which the click originated. | string (int) | yes | 11 |
| click_network_name | The name of the Network to which the click originated. | string | yes | 255 |
| click_original_request | Raw URL which was received for specific click.
NOTE: API call will return data in JSON format. |
string | yes | longtext |
| click_site | Identifies the site to which the click was served within the publisher partner. | string | yes | 512 |
| click_status | Indicator to define if the click has simply been received (publish) or matched to an install. | string | yes | 16 |
| click_tier | The tier/segment to which the click is associated. | string | yes | 100 |
| click_tracker | The Free App Analytics-specific ID of the tracker to which the click originated. | string (int) | yes | 20 |
| click_tracker_name | The user defined name for the tracker to which the click originated. | string | yes | 100 |
| clickgeo_area_code | The area code where the click originated, based on IP lookup. | string (int) | yes | 16 |
| clickgeo_city | The name of the city where the click originated, based on IP lookup. | string | yes | 32 |
| clickgeo_continent_code | 2-digit continent designation where the click originated, based on IP lookup. | string | yes | 2 |
| clickgeo_country_code | 2-digit country designation where the click originated, based on IP lookup. | string | yes | 2 |
| clickgeo_country_code3 | 3-digit country designation where the click originated, based on IP lookup. | string | yes | 3 |
| clickgeo_country_name | The name of the country where the click originated, based on IP lookup. | string | yes | 32 |
| clickgeo_dma_code | The code for the designated marketing area where the click originated, based on IP lookup. | string (int) | yes | 16 |
| clickgeo_latitude | The latitude where the click originated, based on IP lookup. | string (float) | yes | 18,14 |
| clickgeo_longitude | The longitude where the click originated, based on IP lookup. | string (float) | yes | 18,14 |
| clickgeo_postal_code | The postal code of the region where the click originated, based on IP lookup. | string (int) | yes | 16 |
| clickgeo_region | An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup. | string | yes | 32 |
| count | Number of events (based on selection) during defined time frame. | int | no | 11 |
| custom_dimensions | Custom provided dimensions received with the event. | array (strings) | yes | text |
| device_id_adid | Raw ADID provided on the event (Android specific). | string | yes | 64 |
| device_id_android_id | Raw Android_ID received on the event (Android specific). | string | yes | 64 |
| device_id_custom | Custom provided identifier received with the event . | string | yes | 64 |
| device_id_idfa | Raw IDFA provided on the event (iOS specific) | string | yes | 64 |
| device_id_idfv | Raw IDFV provided on the event (iOS specific) | string | yes | 64 |
| device_id_kochava | Kochva generated Unique ID assigned to device. | string | no | 60 |
| device_os | The operating system of the device. | string | yes | 100 |
| device_type | The device type of the device. | string | yes | 200 |
| device_version | The device version of the mobile device. | string | yes | 100 |
| dimension_count | Number of custom events (based on selection). | int | no | 11 |
| dimension_data | Data provided dimensions received with the event. | string | yes | text |
| dimension_sum | The sum of event data. | float | yes | 128 |
| event_name | The name of the advertiser defined and integrated event. | string | yes | 128 |
| event_time_registered | The time that the event was performed by the mobile device. | string (int) | no | 11 |
| geo_city | The name of the city where the event originated, based on IP lookup. | string | yes | 32 |
| geo_country | The name of the country where the event originated, based on IP lookup. | string | yes | 32 |
| geo_lat | The latitude where the event originated, based on IP lookup. | string (float) | yes | 18,14 |
| geo_lon | The longitude where the event originated, based on IP lookup. | string (float) | yes | 18,14 |
| geo_region | An alpha-numeric code identifying the geographic region where the event originated, based on IP lookup. | string | yes | 32 |
| iad.campaign_id | The iAd specific campaign ID. | string | yes | |
| iad.iad-attribution | Indicates whether iAd has claimed and won attribution (1). | string | yes | |
| iad.iad-legacy | Indicates whether the legacy iAd is attribution logic was utilized (1). | string | yes | |
| iad.network_id | The Free App Analytics-specific ID of the network to which the iAd attribution is attributed. | string | yes | |
| identity_link | A customer defined unique identifier for linking devices. | string | yes | 255 |
| impression_campaign | The Free App Analytics-specific ID of the campaign to which the impression is associated. |
string (int) | yes | 20 |
| impression_campaign_name | The user defined name for the campaign to which the impression is associated. | string | yes | 255 |
| impression_country_code | 2-digit country designation where the impression originated, based on IP lookup. | string | yes | 2 |
| impression_creative | The ID/name of the creative which was served with the impression. | string | yes | 64 |
| impression_date_adjusted | The date the impression occurred (Selected Time Zone). | string (date) | yes | datetime |
| impression_date_utc | Date and time of the impression (Coordinated Universal Time). | string (date) | yes | datetime |
| impression_device_ver | The device type and version of the device which received on impression. | string | yes | 64 |
| impression_identifiers | An array of all device identifiers received on the impression. | json (strings) | yes | text |
| impression_imp_id | Unique identifier associated with the impression which has been received. | string (int) | yes | 11 |
| impression_ip | The IP address from which the impression originated. | string | yes | 16 |
| impression_kochava_imp_id | Free App Analytics generated unique identifier associated with the impression which has been received. | string | yes | 50 |
| impression_matched_click | ID representation of the click which the impression was matched to. | string (int) | yes | 20 |
| impression_matched_install | ID representation of the install which matched to the impression. | string (int) | yes | 20 |
| impression_network | The Free App Analytics-specific ID of the Network to which the impression originated. | string (int) | yes | 7 |
| impression_network_name | The name of the Network to which the impression originated. | string | yes | 256 |
| impression_original_request | Raw URL which was received for specific impression.
NOTE: API call will return data in JSON format. |
string | yes | text |
| impression_site | Identifies the site to which the impression was served within the publisher partner. | string | yes | 255 |
| impression_tier | The tier/segment to which the impression is associated. | string | yes | 100 |
| impression_tracker | The Free App Analytics-specific ID of the tracker to which the impression is associated. | string (int) | yes | 20 |
| impression_tracker_name | The user defined name for the tracker to which the impression is associated. | string | yes | 100 |
| install_date_adjusted | The date the install occurred (Selected Time Zone). | string (datetime) | yes | datetime |
| install_date_utc | Date and time of the install (Coordinated Universal Time). | string (datetime) | yes | datetime |
| install_device_ua | User Agent of the device gathered upon install. | string | yes | longtext |
| install_device_version | The device type and version of the device received on install. | string | yes | longtext |
| install_devices_adid | Raw ADID provided on the install (Android specific). | string | yes | longtext |
| install_devices_android_id | Raw Android_ID provided on the install (Android specific). | string | yes | longtext |
| install_devices_custom | Custom provided identifier received with the install. | string | yes | longtext |
| install_devices_email_0 | Primary email address delivered with the install. | string | yes | longtext |
| install_devices_email_1 | Secondary email address delivered with the install. | string | yes | longtext |
| install_devices_idfa | Raw IDFA provided on the install (iOS specific). | string | yes | longtext |
| install_devices_ids | An array of the device identifiers received on install. | json (strings) | yes | longtext |
| install_devices_ip | The IP address from which the install originated. | string | yes | longtext |
| install_devices_waid | Raw WAID received on install (Windows specific). | string | yes | longtext |
| install_city | The name of the city where the install originated, based on IP lookup. | string | yes | 32 |
| install_country | The name of the country where the install originated, based on IP lookup. | string | yes | 32 |
| install_lat | The latitude where the install originated, based on IP lookup. | string (float) | yes | 18,14 |
| install_lon | The longitude where the install originated, based on IP lookup. | string (float) | yes | 18,14 |
| install_region | An alpha-numeric code identifying the geographic region where the install originated, based on IP lookup. | string | yes | 32 |
| install_matched_by | Defines the nature of the data point on which the click was matched to the install. | string | yes | longtext |
| install_matched_on | ID representation of the install which matched to the click. | string | yes | 64 |
| install_receipt_status | Indication whether a receipt was received from the app store for the associated install as well as the level of authentication of the receipt. | string | no | longtext |
| install_san_original | The original Self Attributing Network to which the install is attributed. | string | yes | 64 |
| install_status | Indicator to define if an install has been simply been received (publish) or matched to a click. | string | no | 20 |
| is_reengagement | Indicator if event is being attributed to the last reengagment. | string (int) |
no | 1 |
| kochava_click_id | Click ID assigned by Free App Analytics. | string | yes | longtext |
| partner_click_id | Click ID as received from the partner. | string | yes | longtext |
| reengagement_tier | The tier/segment to which the reengagement is associated. | string | yes | 100 |
| request_ip | The IP address from which the request originated. | string | yes | longtext |
| request_ua | User Agent from which the request originated. | string | yes | longtext |
| timestamp_adjusted | The date and time of the event (Selected Time Zone). | string (datetime) | no | datetime |
| timestamp_utc | The date and time of the event (Coordinated Universal Time). | string (datetime) | yes | datetime |
| event_att | The device ATT status. | string | yes | 5 |
| event_att_detail | ATT status 1 – authorized ATT status 0 – |
string | yes | 58 |
| event_att_time | User response timestamp. | string (datetime) |
yes | datetime |
| event_att_duration_sec | string (datetime) |
yes | datetime |
NOTE: Some columns within the report may contain JSON encoded data. These columns will have “*_querystring” versions that will provide a URL QueryString encoded version of these columns. The JSON path for each value in the JSON will be used as the querystring key for that value.
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.
Fractional Report
| Field Name | Description | Type | May be Null |
Character Limit |
|---|---|---|---|---|
| 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) |
no | datetime |
| fractional_date_adjusted | The date and time of the install (Selected Time Zone). | string (datetime) |
no | datetime |
| fractional_id | Fractional ID assigned by Free App Analytics. | string (int) |
||
| fractional_network | The Free App Analytics-specific ID of the Network to which the click originated. | string (int) |
||
| fractional_type | The identifier by which the fractional attribution was credited. | string | no | |
| match_id | The Free App Analytics-specific ID of the match that won attribution. | string (int) |
no | 11 |
| match_type | The identifier by which the fractional attribution was matched. | string | ||
| traffic_date | Date and Time of traffic (Coordinated Universal Time). | string (datetime) |
datetime | |
| traffic_date_adjusted | Date and time of traffic(Selected Time Zone). | string (datetime) |
datetime | |
| traffic_id | The Free App Analytics-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) |
yes | |
| 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.
Impression Multi-Touch Attribution Report
(see iOS 14+ restrictions)
| Field Name | Description | Type | May be Null |
Character Limit |
|---|---|---|---|---|
| id | Random internal identifier |
string (int) | no | 11 |
| match_id | The Free App Analytics-specific ID of the match that won attribution. | sting (int) | no | 11 |
| match_date_utc | The date and time of attribution (Coordinated Universal Time). | string (datetime) | no | datetime |
| match_date_adjusted | The date and time of attribution (Selected Time Zone). | string (datetime) | no | datetime |
| match_month | The number of the month in which attribution occurred. | string (int) | no | 11 |
| match_type | Description of how attribution was performed; for example, device ID, Facebook, etc | string | no | 32 |
| imp_match_id | The Free App Analytics-specific ID of the impression which led to install. | string (int) | no | 64 |
| imp_match_network | The Free App Analytics-specific ID of the Network to which the impression originated. | string (int) | no | 11 |
| imp_match_network_name | The name of the Network to which the impression originated. | string | yes | 256 |
| imp_match_type | The type of attribution the impression was matched on. | string | no | 45 |
| imp_matched_on | The ID which the impression was matched on. | string | no | 64 |
| influencer_id | Unique identifier associated with the influencer. | string (int) | no | 64 |
| influencer_network | The Free App Analytics-specific ID of the Network to which the influencer originated. | string (int) | no | 11 |
| influencer_network_name | The name of the network in which the influencer occurred. | string | yes | 256 |
| influencer_date_utc | The date and time of the influencer (Corrdinated Universal Time) | string (datetime) | no | datetime |
| influencer_date_adjusted | The date and time of the influencer (Selected Time Zone). | string (datetime) | no | datetime |
| influencer_match_type | Description of how we matched the click to the influencer; for example, device ID, Facebook, etc | string | no | 45 |
| influencer_matched_on | Provides the actual piece of data the influencer was matched on; for example, the device ID. | string | no | 64 |
| rejected_because | The reason the install was attributed to another Network (for example, another network was credited with last-click) | string | no | 45 |
NOTE: Some columns within the report may contain JSON encoded data. These columns will have “*_querystring” versions that will provide a URL QueryString encoded version of these columns. The JSON path for each value in the JSON will be used as the querystring key for that value.
Install Report
The Install Report provides a row-level view of installs for a given campaign.
| Field Name | Description | Type | May be Null |
Character Limit |
|---|---|---|---|---|
| attribution_campaign | The Free App Analytics-specific ID of the campaign to which the the install was attributed. | string | no | 20 |
| attribution_campaign_name | The user defined name for the campaign to which the install was attributed. | string | yes | 255 |
| attribution_creative | Data received on install in the creative_id parameter. | string | yes | 64 |
| attribution_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 | yes | 5 |
| attribution_network | The Free App Analytics-specific ID of the Network to which the install was attributed. | string (int) | no | 11 |
| attribution_network_name | The name of the Network to which the install was attributed. | string | yes | 256 |
| attribution_site | Identifies the site to which the install was attributed within the publisher partner. | string | no | 64 |
| attribution_tier | The tier/segment to which the attribution is associated. | string | yes | 100 |
| attribution_tracker | The Free App Analytics-specific ID of the tracker to which the install was attributed. | string (int) | no | 20 |
| attribution_tracker_name | The user defined name for the tracker to which the install was attributed. | string | yes | 100 |
| click_campaign | The Free App Analytics-specific ID of the campaign to which the click was attributed. | string | no | longtext |
| click_campaign_name | The user defined name for the campaign to which the click was attributed. | string | yes | 255 |
| click_country_code | 2-digit country designation where the click originated, based on IP lookup. | string | yes | 2 |
| click_creative | Data received on click in the creative_id parameter. | string | yes | 128 |
| click_custom_parameters | Custom parameters passed with the click. | string | no | |
| click_device_id | An internal identifier used for mapping purposes. | string (int) | yes | 255 |
| click_device_ua | User Agent of the device gathered upon click. | string | yes | longtext |
| click_device_ver | The device type and version of the device received on click. | string | yes | 128 |
| click_duplicate | The ID assigned to duplicate clicks. | string (int) | yes | 20 |
| click_identifiers | An array of all device identifiers received on the click. | json (strings) | yes | text |
| click_identifiers_adid | Raw ADID provided on the click (Android specific). | string | yes | 255 |
| click_identifiers_android_id | Raw Android_ID received on the click (Android specific). | string | yes | 255 |
| click_identifiers_android_id_md5 | MD5 encrypted Android_ID received on the click (Android specific). | string | yes | 255 |
| click_identifiers_android_id_sha1 | SHA1 encrypted Android_ID received on the click (Android specific). | string | yes | 255 |
| click_identifiers_custom | Custom provided identifier received with the click. | string | yes | 255 |
| click_identifiers_email_0 | Primary email address delivered with the click. | string | yes | 255 |
| click_identifiers_email_1 | Secondary email address delivered with the click. | string | yes | 255 |
| click_identifiers_idfa | Raw IDFA received on the click (iOS specific). | string | yes | 255 |
| click_identifiers_ip | Raw IP address where the click originated. | string | yes | 255 |
| click_identifiers_waid | Raw WAID received on the click (Windows specific). | string | yes | 255 |
| click_ip | The IP address from which the click originated. | string | no | 16 |
| click_matched_impression | ID representation of the impression which the click was matched to. | string (int) | yes | 20 |
| click_matched_install | ID representation of the install which matched to the click. | string (int) | yes | 20 |
| click_month | The numeric value of the month the install was received. | string (int) | no | 1 |
| click_network | The Free App Analytics-specific ID of the Network to which the click originated. | string (int) | no | 11 |
| click_network_name | The name of the Network to which the click originated. | string | yes | 256 |
| click_original_request | Raw URL which was received for specific click.
NOTE: API call will return data in JSON format. |
string | no | longtext |
| click_site | Identifies the site to which the click was served within the publisher partner. | string | yes | 512 |
| click_status | Indicator to define if the click has simply been received (publish) or matched to an install. | string | no | 16 |
| click_tier | The tier/segment to which the click is associated. | string | yes | 100 |
| click_tracker | The Free App Analytics-specific ID of the tracker to which the click originated. | string (int) | no | 20 |
| click_tracker_name | The user defined name for the tracker to which the click originated. | string | yes | 100 |
| clickgeo_area_code | The area code where the click originated, based on IP lookup. | string (int) | yes | 16 |
| clickgeo_city | The name of the city where the click originated, based on IP lookup. | string | yes | 32 |
| clickgeo_continent_code | 2-digit continent designation where the click originated, based on IP lookup. | string | yes | 2 |
| clickgeo_country_code | 2-digit country designation where the click originated, based on IP lookup. | string | yes | 2 |
| clickgeo_country_code3 | 3-digit continent designation where the click originated, based on IP lookup. | string | yes | 3 |
| clickgeo_country_name | The name of the country where the click originated, based on IP lookup. | string | yes | 32 |
| clickgeo_dma_code | The code for the designated marketing area where the click originated, based on IP lookup. | string (int) | yes | 16 |
| clickgeo_latitude | The latitude where the click originated, based on IP lookup. | string (float) | yes | 18,14 |
| clickgeo_longitude | The longitude where the click originated, based on IP lookup. | string (float) | yes | 18,14 |
| clickgeo_postal_code | The postal code of the region where the click originated, based on IP lookup. | string (int) | yes | 16 |
| clickgeo_region | An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup. | string | yes | 32 |
| identity_link | A customer defined unique identifier for linking devices. | string | yes | 255 |
| impression_campaign | The Free App Analytics-specific ID of the campaign to which the impression is associated. | string (int) | yes | 20 |
| impression_campaign_name | The user defined name for the campaign to which the impression is associated. | string | yes | 255 |
| impression_country_code | 2-digit country designation where the impression originated, based on IP lookup. | string | yes | 2 |
| impression_creative | The ID/name of the creative which was served with the impression. | string | yes | 64 |
| impression_device_ver | The device type and version of the device which received on impression. | string | yes | 64 |
| impression_identifiers | An array of all device identifiers received on the impression. | json (strings) | yes | text |
| impression_imp_id | Unique identifier associated with the impression which has been received. | string (int) | yes | 11 |
| impression_ip | The IP address from which the impression originated. | string | yes | 16 |
| impression_kochava_imp_id | Free App Analytics generated unique identifier associated with the impression which has been received. | string (int) | yes | 11 |
| impression_matched_click | ID representation of the click which the impression was matched to. | string (int) | yes | 20 |
| impression_matched_install | ID representation of the install which matched to the impression. | string (int) | yes | 20 |
| impression_network | The Free App Analytics-specific ID of the Network to which the impression originated. | string (int) | yes | 7 |
| impression_network_name | The name of the Network to which the impression originated. | string | yes | 256 |
| impression_original_request | Raw URL which was received for specific impression.
NOTE: API call will return data in JSON format. |
string | yes | text |
| impression_site | Identifies the site to which the impression was served within the publisher partner. | string | yes | 255 |
| impression_tier | The tier/segment to which the impression is associated. | string | yes | 100 |
| impression_tracker | The Free App Analytics-specific ID of the tracker to which the impression is associated. | string (int) | yes | 20 |
| impression_tracker_name | The user defined name for the tracker to which the impression is associated. | string | yes | 100 |
| install_click_date_adjusted | The date and time the click occurred which led to install (Selected Time Zone). | string (datetime) | yes | datetime |
| install_click_date_utc | The date and time the click occurred which led to install (Coordinated Universal Time). | string (datetime) | yes | datetime |
| install_date_adjusted | The date and time of install (Selected Time Zone). | string (datetime) | no | datetime |
| install_date_utc | The date and time of install (Coordinated Universal Time). | string (datetime) | yes | datetime |
| install_device_ua | User Agent of the device gathered upon install. | string | yes | longtext |
| install_device_version | The device version of the mobile device. | string | yes | longtext |
| install_devices_adid | Raw ADID provided on install (Android specific). | string | yes | longtext |
| install_devices_android_id | Raw Android_ID received on install (Android specific). | string | yes | longtext |
| install_devices_custom | Custom provided identifier received with install. | string | yes | longtext |
| install_devices_custom_id | Unique identifier associated with the custom provided identifier. | string | yes | longtext |
| install_devices_email_0 | Primary email address delivered with install. | string | yes | longtext |
| install_devices_email_1 | Secondary email address delivered with the click. | string | yes | longtext |
| install_devices_idfa | Raw IDFA received on install (iOS specific). | string | yes | longtext |
| install_devices_ids | An array of all device identifiers received on install. | string | yes | longtext |
| install_devices_ip | The IP address from which the install originated. | string | yes | longtext |
| install_devices_waid | Raw WAID received on the click (Windows specific). | string | yes | longtext |
| install_impression_date_adjusted | The date and time the impression occurred which led to install (Selected Time Zone). | string (datetime) | yes | datetime |
| install_impression_date_utc | The date and time the impression occurred which led to install (Coordinated Universal Time). | string (datetime) | yes | datetime |
| install_kochava_device_id | Install ID assigned by Kochava | string | no | longtext |
| install_matched_by | The ID type to which installation is attributed. | string | no | longtext |
| install_matched_on | Unique identifier to which the install is matched on. | string | no | 64 |
| install_original_request | Raw URL which was received for specific install.
NOTE: API call will return data in JSON format. |
string | no | longtext |
| install_price | The user defined price per click or price per install. | string (float) | yes | 10,6 |
| install_receipt_status | Indication whether a receipt was received from the app store for the associated install as well as the level of authentication of the receipt. | string | no | longtext |
| install_reprocessed_for | If a value is present this signifies that the install was a reprocessed install(not the first install from the device). | string | no | 20 |
| install_status | Indicator to define if an install has been simply been received (publish) or matched to a click. | string | no | 20 |
| installgeo_area_code | The area code where the install originated, based on IP lookup. | string (int) | yes | 16 |
| installgeo_city | The name of the city where the install originated, based on IP lookup. | string | yes | 32 |
| installgeo_continent_code | 2-digit continent designation where the impression originated, based on IP lookup. | string | yes | 2 |
| installgeo_country_code | 2-digit continent designation where the install originated, based on IP lookup. | stting | yes | 2 |
| installgeo_country_code3 | 3-digit continent designation where the impression originated, based on IP lookup. | string | yes | 3 |
| installgeo_country_name | The name of the country where the install originated, based on IP lookup. | string | yes | 32 |
| installgeo_dma_code | The code for the designated marketing area where the install originated, based on IP lookup. | string (int) | yes | 16 |
| installgeo_latitude | The latitude where the install originated, based on IP lookup. | string (float) | yes | 18,14 |
| installgeo_longitude | The longitude where the install originated, based on IP lookup. | string (float) | yes | 18,14 |
| installgeo_postal_code | The postal code of the region where the install originated, based on IP lookup. | string (int) | yes | 16 |
| installgeo_region | An alpha-numeric code identifying the geographic region where the install originated, based on IP lookup. | string | yes | 32 |
| kochava_click_id | Click ID assigned by Free App Analytics. | string | no | longtext |
| partner_click_id | Click ID as received from the partner. | string | yes | longtext |
| reengagement_tier | The tier/segment to which the reengagement is associated. | string | yes | 100 |
| traffic_click_verification_status | Indicator if the click traffic was valid or invalid based on Traffic Verification rules. | json (strings) | yes | 16 |
| traffic_install_verification_status | Indicator if the install traffic was valid or invalid based on Traffic Verification rules. | json (strings) | yes | 20 |
| install_att | The device ATT status. | string | yes | 5 |
| install_att_detail | ATT status 1 – authorized ATT status 0 – |
string | yes | 58 |
| install_att_time | User response timestamp. | string (datetime) |
yes | datetime |
| install_att_duration_sec | string (datetime) |
yes | datetime |
NOTE: Some columns within the report may contain JSON encoded data. These columns will have “*_querystring” versions that will provide a URL QueryString encoded version of these columns. The JSON path for each value in the JSON will be used as the querystring key for that value.
Matched Impression Report
| Field Name | Description | Type | May be Null |
Character Limit |
|---|---|---|---|---|
| impression_date_utc | Date and time of the impression (Coordinated Universal Time). | string (date) | yes | datetime |
| impression_date_adjusted | The date the impression occurred (Selected Time Zone). | string (date) | yes | datetime |
| impression_app_id | The Free App Analytics-specific ID of the app which the impression is associated. | |||
| impression_network | The Free App Analytics-specific ID of the Network to which the impression originated. | string (int) | no | 11 |
| impression_network_name | The name of the Network to which the impression originated. | string | yes | 256 |
| impression_tracker | The Free App Analytics-specific ID of the tracker to which the impression originated. | string (int) | no | 20 |
| impression_tracker_name | The user defined name for the tracker to which the impression originated. | string | yes | 100 |
| impression_campaign | The Free App Analytics-specific ID of the campaign to which the click was attributed. | string (int) | yes | 20 |
| impression_campaign_name | The user defined name for the campaign to which the click was attributed. | string | yes | 255 |
| impression_tier | The tier/segment to which the impression is associated. | string | yes | 100 |
| impression_site | Identifies the site to which the impression was served within the publisher partner. | string | yes | 255 |
| impression_creative | The ID/name of the creative which was served with the impression. | string | yes | 64 |
| impression_country_code | 2-digit country designation where the impression originated, based on IP lookup. | string | yes | 2 |
| impression_original_request | Raw URL which was received for specific impression.
NOTE: API call will return data in JSON format. |
string | yes | text |
| impression_original_request_querystring | ||||
| impression_matched_install | ID representation of the install which matched to the impression. | string (int) | yes | 20 |
| impression_matched_click | ID representation of the click which the impression was matched to. | string (int) | yes | 20 |
| impression_ip | The IP address from which the impression originated. | string | yes | 16 |
| impression_imp_id | Unique identifier associated with the impression which has been received. | string (int) | yes | 11 |
| impression_identifiers | An array of all device identifiers received on the impression. | json (strings) | yes | text |
| impression_identifiers_querystring | ||||
| impression_device_ver | The device type and version of the device received on impression. | string | yes | 64 |
| impression_kochava_imp_id | Free App Analytics generated unique identifier associated with the impression which has been received. | string | yes | 50 |
| traffic_impression_verification_status | Indicator if the impression traffic was valid or invalid based on Traffic Verification rules. | json (strings) | yes | 16 |
Reengagement Report
| Field Name | Description | Type | May be Null |
Character Limit |
|---|---|---|---|---|
| kochava_click_id | Click ID assigned by Free App Analytics. | string | yes | longtext |
| kochava_device_id | Free App Analytics generated Unique ID assigned to device. | string | no | 60 |
| reengage_event_date_utc | Date and time of the event (Coordinated Universal Time). | string (datetime) | no | datetime |
| reengage_event_date_adjusted | Date and time of the event (Selected Time Zone). | string (datetime) | no | datetime |
| reengage_click_month | The numeric value of the month the click was received. | string (int) | no | 1 |
| reengage_click_date_utc | Date and time of the click (Coordinated Universal Time). | string (datetime) | no | datetime |
| reengage_click_date_adjusted | Date and time of the click (Selcted Time Zone). | string (datetime) | no | datetime |
| reengage_event_name | The name of the advertiser defined and integrated event for reengagement. | string | yes | 128 |
| reengage_status | Indicator to define if the click has been matched to an event for reengagment. | string | no | 16 |
| reengage_network | The Free App Analytics-specific ID of the Network to which the reengagment originated. | string (int) | no | 11 |
| reengage_network_name | The name of the Network to which the reengagment originated. | string | yes | 256 |
| reengage_tracker | The Free App Analytics-specific ID of the tracker to which the reengagment originated. | string (int) | no | 20 |
| reengage_tracker_name | The user defined name for the tracker to which the reengagment originated. | string | yes | 100 |
| reengage_campaign | The Free App Analytics-specific ID of the campaign to which the reengagment was attributed. | string | no | 20 |
| reengage_campaign_name | The user defined name for the campaign to which the reengagement was attributed. | string | yes | 255 |
| reengage_site | Identifies the site to which the reengagment was served within the publisher partner. | string | yes | 512 |
| reengage_creative | Data received on reengagment in the creative_id parameter. | string | yes | 128 |
| reengage_country_code | 2-digit country designation where the reengagement originated, based on IP lookup. | string | yes | 2 |
| reengage_ip | Raw IP address where the reengagement originated. | string | yes | 16 |
| reengage_device_ver | The device type and version of the device received on reengagement. | string | yes | 128 |
| reengage_device_id | The primary device ID received on reengagment. | string | yes | 20 |
| reengage_original_request | Raw URL which was received for specific reengagment.
NOTE: API call will return data in JSON format. |
string | no | longtext |
| reengage_matched_impression | ID representation of the impression which the reengagment was matched to. | string (int) | yes | 20 |
| reengage_matched_install | ID representation of the install which matched to the reengagment. | string (int) | no | 20 |
| reengage_identifiers | Identifiers available for attribution on the reengagement. | string | yes | text |
| reengage_duplicate | The ID assigned to duplicate rengagments. | string (int) | yes | 20 |
| click_original_request | Raw URL which was received for specific click.
NOTE: API call will return data in JSON format. |
string | no | longtext |
| reengagegeo_continent_code | 2-digit continent designation where the reengagment originated, based on IP lookup. | string | yes | 2 |
| reengagegeo_country_code | 2-digit country designation where the reengagment originated, based on IP lookup. | string | yes | 2 |
| reengagegeo_country_code3 | 3-digit country designation where the reengagment originated, based on IP lookup. | string | yes | 3 |
| reengagegeo_country_name | The name of the country where the reengagment originated, based on IP lookup. | string | yes | 32 |
| reengagegeo_region | An alpha-numeric code identifying the geographic region where the reengagement originated, based on IP lookup. | string | yes | 32 |
| reengagegeo_postal_code | The postal code of the region where the reengagement originated, based on IP lookup. | string (int) | yes | 16 |
| reengagegeo_dma_code | The code for the designated marketing area where the reengagment originated, based on IP lookup. | string (int) | yes | 16 |
| reengagegeo_city | The name of the city where the reengagement originated, based on IP lookup. | string | yes | 32 |
| reengagegeo_area_code | The area code where the reengagement originated, based on IP lookup. | string (int) | yes | 16 |
| reengagegeo_longitude | The longitude where the reengagement originated, based on IP lookup. | string (float) | yes | 18,14 |
| reengagegeo_latitude | The latitude where the reengagment originated, based on IP lookup. | string (float) | yes | 18,14 |
| reengagement_tier | The tier/segment to which the reengagement is associated. | string | yes | 100 |
NOTE: Some columns within the report may contain JSON encoded data. These columns will have “*_querystring” versions that will provide a URL QueryString encoded version of these columns. The JSON path for each value in the JSON will be used as the querystring key for that value.
Restated Cost Report
| Field Name | Description | Type | May be Null | Character Limit |
|---|---|---|---|---|
| starting_date | The date and time that the restated cost data began being collected. | string (datetime) |
no | datetime |
| ending_date | The date and time that the restated cost data ended being collected. | string (datetime) |
no | datetime |
| tracker_id | The Kochava-specific ID of the tracker to which the restated cost was attributed. | string | no | 20 |
| cost_network_id | The Kochava-specific ID of the network to which the restated cost data is attributed. | string (int) |
yes | 20 |
| network_campaign_id | Unique identifier associated with the network to which the restated cost data is attributed. | string (int) |
no | 100 |
| network_campaign_name | The user defined name for the campaign to which the restated cost data is attributed. | string | yes | 256 |
| type | The type of ad being served. | string | yes | 256 |
| total_daily_spend_restated_1_Day | The total restated daily spend day 1. | string (int) |
yes | float | total_daily_spend_restated_2_Day | The total restated daily spend day 2. | string (int) |
yes | float | total_daily_spend_restated_7_Day | The total restated daily spend day 7. | string (int) |
yes | float | total_daily_spend_restated_14_Day | The total restated daily spend day 14. | string (int) |
yes | float | total_daily_spend_restated_30_Day | The total restated daily spend day 30. | string (int) |
yes | float | total_daily_spend_restated_60_Day | The total restated daily spend day 60. | string (int) |
yes | float |
| device | The users device type. | string | yes | 256 |
| gender | the gender of the user. | string | yes | 256 |
| geography | The geographic region of the device. | string | yes | 256 |
| group_id | The campaign or ad group id of the device. | string | yes | 100 |
| group_name | The campaign or ad group name of the device. | string | yes | 100 |
| image | The ID/name of the creative which influenced the device. | string | yes | 256 |
| keywords | Campaign keywords. | string | yes | 256 |
| name | Generic placeholder, used if data not grouped by campaign or ad. | string | yes | 256 |
| network_ad_id | The ID for the network ad. | string | no | 20 |
| platform | The device platform. | string | yes | 256 |
| target | The user group which the ad or campaign is targeting. | string | yes | 256 |
| url | The raw URL which was received from the device. | string | yes | 256 |
| api_groupby | The grouping of data returned by the network’s API. | string | yes | 100 |
Insight Report
The insight report is delivered in two reports, the first is the buy report which details the impressions that are performing stronger than the established median, and the donotbuy which details the impressions that are performing weaker than the established median. The insight reports will be delivered inside a zipped folder.
| Field Name | Description | Type | May be Null |
|---|---|---|---|
| RuleID | The unique rule ID which can be used for reference in the full optimization rule set. | string (int) |
no |
| AppID | The app ID assigned by Free App Analytics. | string (int) |
no |
| NetworkID | The Free App Analytics-specific ID of the Network to which the impression originated. | string (int) |
no |
| NetworkName | The name of the Network to which the impression originated. | string | no |
| TrackerName | The user defined name for the tracker to which the impression was attributed. | string | no |
| Column | The targeted data point for the impression. | string | no |
| Value | The value of the targeted data point. | string | no |
| NumberImpressions | The number of impressions served matching that rule. | string (int) |
no |
| FullSetLift | The expected lift. Historical conversion rate divided by expected conversion rate. This lift will only be reached if implementing the full optimization rule set. | string (int) |
no |
Campaign Summary Report
The Campaign Summary Report provides a granular level of reporting and segment by campaign.
| Field Name | Description | Type | May be Null | |
|---|---|---|---|---|
| datetime_utc | The date and time of install (Coordinated Universal Time). | string (datetime) | no | |
| datetime_adjusted | The date and time of install (Selected Time Zone). | string (datetime) | no | |
| network | The Free App Analytics-specific ID of the Network to which the install is attributed. | string (int) | yes | |
| network_name | The name of the Network to which the install is attributed. | string | yes | |
| campaign | The Free App Analytics-specific ID of the campaign to which the install was attributed. | string (int) | no | |
| campaign_name | The user defined name for the campaign to which the install was attributed. | string | yes | |
| tracker | The Free App Analytics-specific ID of the tracker to which the install was attributed. | string (int) | no | |
| tracker_name | The user defined name for the tracker to which the install was attributed. | string | yes | |
| site | The site on which the campaign was run. | string | yes | |
| creative | The user defined name of the creative used in the campaign. | string | yes | |
| dma | The code for the designated marketing area where the install originated, based on IP lookup. | string (int) | yes | |
| state | An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup. | string | yes | |
| city | The name of the city to which the install is attributed. | string | yes | |
| country | 2-digit country disignation where the click originated, based on IP lookup. | string | yes | |
| 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 (int) | no | |
| click_matched_to_imp_count | The total number of clicks matched to impressions. | string (int) | no | |
| click_duplicate_count | The total number of duplicate clicks during the selected time frame. | string (int) | no | |
| click_spend | Money spent per click, based on data received on the click. | string (float) | no | |
| install_count | The number of install of the app during the selected time frame. | sting (int) | no | |
| install_matched_to_click_count | The number of clicks matched to installs for the selected time frame. | string (int) | no | |
| install_matched_to_imp_count | The number of impressions matched to installs for the selected time frame. | string (int) | no | |
| install_spend | Money spent per install, based on data received on the install. | string (float) | no | |
| impression_count | The number of impressions during the selected time frame. | string (int) | no | |
| impression_spend | Money spent per impression, based on data received on the click. | string (float) | no | |
| 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 (int) | no (0 for null) | |
| total_spend_network_reported | This is what the network has told Free App Analytics via the API how much was spent in total for the network. It is required to have the Free App Analytics 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 (int) | no (0 for null) |
Network Summary Report
The Network Summary Report provides a summary of network performance across a variety of metrics.
NOTE: If adding network_restated_cost in a summary report the below will need to be selected:
- Time_zone must be set to UTC.
- Traffic grouping can only be set to “network”.
| Field Name | Description | Type | May be Null |
|---|---|---|---|
| datetime_utc | The date and time of install (Coordinated Universal Time). | string (datetime) | no |
| datetime_adjusted | The date and time of install (Selected Time Zone). | string (datetime) | no |
| network | The Free App Analytics-specific ID of the Network to which the install was attributed. | string (int) | yes |
| network_name | The name of the Network to which the install was attributed. | string | yes |
| campaign | The Free App Analytics-specific ID of the campaign to which the install is associated. | string (int) | no |
| campaign_name | The user defined name of the campaign. | string | yes |
| tracker | The Free App Analytics-specific ID of the tracker to which the click was attributed. | string (int) | no |
| tracker_name | The user defined name for the tracker to which the click originated. | string | yes |
| site | Identifies the site to which the install was served within the publisher partner. | string | yes |
| creative | The user defined name of the creative used in the campaign. | string | yes |
| dma | The code for the designated marketing area where the install originated, based on IP lookup. | string (int) | yes |
| state | An alpha-numeric code identifying the geographic region where the click originated, based on IP lookup. | string | yes |
| city | The name of the city to which the install is attributed. | string | yes |
| country | 2-digit country designation where the click originated, based on IP lookup. | string | yes |
| click_count | The total number of clicks during the selected time frame. | string (int) | no |
| click_matched_to_imp_count | The number of impressions matched to clicks for the selected time frame. | string (int) | no |
| click_duplicate_count | The total number of duplicate clicks during the selected time frame. | string (int) | no |
| click_spend | Total spend data received on the click | string (float) | yes |
| install_count | The number of installs of the app during the selected time frame. | string (int) | no |
| install_matched_to_click_count | The number of clicks matched to installs for the selected time frame. | string (int) | no |
| install_matched_to_imp_count | The number of impressions matched to installs for the selected time frame. | string (int) | no |
| install_spend | Money spent per install, based on data received on the install. | string (float) | no |
| impression_count | The number of impressions of the app during the selected time frame. | string(int) | no |
| impression_spend | Total spend data received on the impression | string (float) | yes |
| total_spend_network_reported | This is what the network has told Free App Analytics via the API how much was spent in total for the network. It is required to have the Free App Analytics 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 (int) | no (0 for null) |
| 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 (int) | no (0 for null) |
Retention Standard Report
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 (int) |
no |
| i_network_name | The name of the Network to which the event originated. | string (int) |
no |
| installs | The number of installs of the app during the selected time frame. | int | no |
| d1_retention | Number of active users exactly 1 day after install. | int | no |
| d2_retention | Number of active users exactly 2 days after install. | int | no |
| d3_retention | Number of active users exactly 3 days after install. | int | no |
| d5_retention | Number of active users exactly 5 days after install. | int | no |
| d7_retention | Number of active users exactly 7 days after install. | int | no |
| d14_retention | Number of active users exactly 14 days after install. | int | no |
| d21_retention | Number of active users exactly 21 days after install. | int | no |
| d30_retention | Number of active users exactly 30 days after install. | int | no |
Retention Windowed Report
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 (int) |
no |
| i_network_name | The name of the Network to which the event originated. | string (int) |
no |
| installs | The number of installs of the app during the selected time frame. | int | no |
| d1_retention | Number of active users exactly 1 day after install. | int | no |
| d2_retention | Number of active users exactly 2 days after install. | int | no |
| d3_retention | Number of active users exactly 3 days after install. | int | no |
| d5_retention | Number of active users between 4 and 5 days after install. | int | no |
| d7_retention | Number of active users between 6 and 7 days after install. | int | no |
| d14_retention | Number of active users between 8 and 14 days after install. | int | no |
| d21_retention | Number of active users between 15 and 21 days after install. | int | no |
| d30_retention | Number of active users between 22 and 30 days after install. | int | no |
SKAdNetwork Conversion Value
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. | date/ time |
no | ✔ | ✔ |
| date_range_end_utc | The end date for sk_installs based on install date and impression/click counts. | date/ time |
no | ✔ | ✔ |
| ko_account_name | The name of the advertiser’s account within Kochava. | str | no | ||
| ko_account_id | The numeric ID of the advertiser’s account in Kochava. | nmbr | no | ||
| advertiser_app_store_id | The numeric ID of the app on the app store. | nmbr | no | ||
| ko_app_name | The name of the advertiser’s app in Kochava. | str | no | ||
| ko_app_id | The numeric ID of the advertiser’s app in Kochava. | nmbr | no | ||
| ko_app_guid | The GUID of the advertiser’s app in Kochava. | str | no | ||
| sk_version | The version of the SKAdNetwork API. | nmbr | no | ||
| sk_ad_network_id | The ID assigned to the media partner by Apple when integrating with SKAdNetwork. | str | no | ✔ | ✔ |
| ko_media_partner_name | The name of the integrated media partner in Kochava. | str | no | ✔ | ✔ |
| ko_media_partner_id | The numeric ID of the integrated media partner in Kochava. | nmbr | no | ✔ | |
| sk_campaign_id | The numeric ID of the campaign was reported to SKAdNetwork on the loadproduct call. Integer between 1 and 100. | nmbr | no | ✔ | ✔ |
| campaign_name | The name of the campaign as specified in the media partner’s dashboard. | str | no | ✔ | ✔ |
| conversion_model | The name of the conversion model chosen on the SKAdNetwork Settings page in Kochava. | str | no | ||
| 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. | str | no | ||
| 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 |
str | no | ||
| conversion_value | The user’s numerical conversion value. Integer between 0-63. | nmbr | no | ||
| exchange_id | The ID of the ad exchange that served the bid request. | str | no | ✔ | |
| sk_publisher_app_store_id | The numeric ID of the app on the app store, where the ad was served. | nmbr | no | ✔ | ✔ |
| site_id | The site ID of the app where the ad was served, shared by the media partner on the ad signal. | str | no | ✔ | |
| sub_site_id | The sub-site ID of the app where the ad was served, shared by the media partner on the ad signal. | str | no | ✔ | |
| campaign_id | The ID of the campaign as specified in the media partner’s dashboard. | str | no | ✔ | |
| 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. | str | no | ✔ | |
| 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. | str | no | ✔ | |
| bid_amount | Amount the advertiser bid for the ad to be served. | str | no | ✔ | |
| bid_currency | Currency of bid amount. | str | no | ✔ | |
| bid_strategy | The bid strategy defined by the advertiser in the media partner’s dashboard. | str | no | ✔ | |
| bid_type | Bid type set by the media partner. | str | no | ✔ | |
| campaign_objective | Objective of campaign set in media partner dashboard. | str | no | ✔ | |
| campaign_status | Status of a campaign in the media partner dashboard. | str | no | ✔ | |
| creative_id | The numerical id representing the ad creative served. | str | no | ✔ | |
| creative_name | The name representing the ad creative served. | str | no | ✔ | |
| keyword | The keyword searched by the user that clicked the ad. | str | no | ✔ | |
| country | Parameter passed by the media partner to Kochava in the payload. | str | no | ✔ | ✔ |
| 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. | str | no | ✔ | |
| sk_installs | Count of SKAdNetwork-reported installs. | nmbr | no | ||
| sk_redownloads | Count of SKAdNetwork-reported installs that were flagged as redownloads by SKAdNetwork. | nmbr | no |
SKAdNetwork Install
An aggregated summary of user install data sourced from SKAdNetwork signals.
| 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. | date/ time |
no | ✔ | ✔ |
| date_range_end_utc | The end date for sk_installs based on install date and impression/click counts. | date/ time |
no | ✔ | ✔ |
| ko_account_name | The name of the advertiser’s account within Kochava. | str | no | ||
| ko_account_id | The numeric ID of the advertiser’s account in Kochava. | nmbr | no | ||
| advertiser_app_store_id | The numeric ID of the app on the app store. | nmbr | no | ||
| ko_app_name | The name of the advertiser’s app in Kochava. | str | no | ||
| ko_app_id | The numeric ID of the advertiser’s app in Kochava. | nmbr | no | ||
| ko_app_guid | The GUID of the advertiser’s app in Kochava. | str | no | ||
| sk_ad_network_id | The ID assigned to the media partner by Apple when integrating with SKAdNetwork. | str | no | ✔ | ✔ |
| ko_media_partner_name | The name of the integrated media partner in Kochava. | str | no | ✔ | ✔ |
| ko_media_partner_id | The numeric ID of the integrated media partner in Kochava. | nmbr | no | ✔ | |
| sk_campaign_id | The numeric ID of the campaign was reported to SKAdNetwork on the loadproduct call. Integer between 1 and 100. | nmbr | no | ✔ | ✔ |
| campaign_name | The name of the campaign as specified in the media partner’s dashboard. | str | no | ✔ | ✔ |
| exchange_id | The ID of the ad exchange that served the bid request. | str | no | ✔ | |
| site_id | The site ID of the app where the ad was served, shared by the media partner on the ad signal. | str | no | ✔ | |
| sub_site_id | The sub-site ID of the app where the ad was served, shared by the media partner on the ad signal. | str | no | ✔ | |
| campaign_id | The ID of the campaign as specified in the media partner’s dashboard. | str | no | ✔ | |
| 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. | str | no | ✔ | |
| 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. | str | no | ✔ | |
| bid_amount | Amount the advertiser bid for the ad to be served. | str | no | ✔ | |
| bid_currency | Currency of bid amount. | str | no | ✔ | |
| bid_strategy | The bid strategy defined by the advertiser in the media partner’s dashboard. | str | no | ✔ | |
| bid_type | Bid type set by the media partner. | str | no | ✔ | |
| campaign_objective | Objective of campaign set in media partner dashboard. | str | no | ✔ | |
| campaign_status | Status of a campaign in the media partner dashboard. | str | no | ✔ | |
| creative_id | The numerical id representing the ad creative served. | str | no | ✔ | |
| creative_name | The name representing the ad creative served. | str | no | ✔ | |
| keyword | The keyword searched by the user that clicked the ad. | str | no | ✔ | |
| country | Parameter passed by the media partner to Kochava in the payload. | str | no | ✔ | ✔ |
| impressions | Count of impressions. | nmbr | no | ||
| clicks | Count of clicks. | nmbr | no | ||
| CTR (%) | Percent of clicks to impressions. Up to 2 decimals. | decimal | no | ||
| sk_installs | Count of SKAdNetwork-reported installs. | nmbr | no | ||
| CTI (%) | Percent of SKAdNetwork-reported installs to clicks. Up to 2 decimals | decimal | no | ||
| IPM | Installs per Mille. Count of SKAdNetwork-reported installs per 1000 impressions. Up to 4 decimals. | decimal | no | ||
| sk_redownloads | Count of SKAdNetwork-reported installs that were flagged as redownloads by SKAdNetwork. | nmbr | no | ||
| inapp_conversion | Count of sk_installs where the user triggered an updateConversion call with an in-app action. | nmbr | no | ||
| 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 | no |
CancelGuard Report
The CancelGuard Report
| Field Name | Description |
Type
|
May be Null
|
Character Limit
|
|---|---|---|---|---|
| entitlement_label | The entitlement label(s) associated to entitlement_id set up by the user in Entitlements. | string | ✔ | unknown |
| provider | The App Store associated to the entitlement_id | string | unknown | |
| ko_app_name | The name of the advertiser’s app in Kochava and all associated apps in account that have Store Credentials saved. | string | unknown | |
| 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 | 5 | |
| duration | The subscription renewal duration entered by the user in Entitlements. | string | unknown | |
| renewal_cost | Cost of the subscription renewal, entered in Entitlements. | float | ✔ | unknown |
| cancelguard_status | Reason for subscription being in pending cancel state (billing issue, auto renew turned off). | float | ✔ | unknown |
| cancelguard_date_occurred | The date the subscription first changed to pending cancel. | date | 10 | |
| cancelguard_churn_date | The date the subscription will be canceled if not recovered. | date | ✔ | 10 |
| customer_id | Any identities sent via SDK with the subscription event. Can be username, email or CRM ID. | string | unknown | |
| original_receipt_id | The receipt id from the original receipt at the beginning of the subscription | string | unknown |
Customer Profile Report
The Customer Profile Report
| Field Name | Description |
Type
|
May be Null
|
Character Limit
|
|---|---|---|---|---|
| entitlement_label | The entitlement label(s) associated to entitlement_id set up by the user in Entitlements | string | ✔ | unknown |
| provider | The App Store associated to the entitlement_id. | string | unknown | |
| ko_app_name | The name of the app in Kochava and all associated apps in account | string | unknown | |
| 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 | 5 | |
| duration | The subscription renewal duration entered by the user in Entitlements. | string | unknown | |
| renewal_cost | Cost of the subscription renewal, entered in Entitlements. | float | unknown | |
| cancelguard_status | Reason for subscription being in pending cancel state (billing issue, auto renew turned off). | string | ✔ | unknown |
| cancelguard_date_occurred | The date the subscription first changed to pending cancel. | date | ✔ | 10 |
| cancelguard_churn_date | TThe date the subscription will be canceled if not recovered. | date | ✔ | 10 |
| entitlement_id | The entitlement_ID the user entered in Entitlements that is associated with the receipt from the payment provider. | string | unknown | |
| subscriber_id | string | unknown | ||
| receipt_id | The most recent receipt id for the subscription | string | ✔ | unknown |
| subscription_active | Subscription is still active for the reporting period. | boolean | 5 | |
| subscription_trial | The subscription is in a free trial. | boolean | 5 | |
| subscription_ltv | The total sum of revenue generated for this subscription | float | ✔ | unknown |
| renewal_date | The date of the next renewal. | date | ✔ | 10 |
| renewal_annual_mrr | The anual monthly recurring revenue for the renewal. | float | ✔ | unknown |
| membership_started_first | The date the membership first started. | date | 10 | |
| membership_started_continuous | The earliest date for the current subscription started without any lapse. | date | ✔ | 10 |
| membership_one_year_customer | Indicates if the customer has a 1 year subscription. | boolean | 5 |
