1. Home
  2. Marketers
  3. Advanced Tools
  4. API v1.4 – Querying API
  1. Home
  2. Marketers
  3. API v1.4 – Querying API

API v1.4 – Querying API


The Data Access API Integration provides additional reporting tools to supplement those available through the Kochava platform.

The Kochava platform provides extensive tools to track everything from impressions thru post-install events for connected devices. The API reporting method provides advertisers with the programmatic tools to gather performance data on an on-demand or scheduled basis.

For clarity, our support documentation for API v1.4 has been divided into the following sections:

The following document defines the structure and the methods for Querying the API.

WARNING: If the provided API Key does not match an existing app, an “error”:”App does not exist.” response will be returned. For further information, contact your Client Success Management team.

CAUTION: If a request is sent that is a duplicate of another report currently queued or running, no token will be returned. The response will be returned with a status of “queued” or “running” for the duplicate report that was requested.

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

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


Structure for Querying API

Parameter Description Format
api_key The api key linked to the user. string
app_guid The name of the app to report on. string
token The token ID of the report that was returned when the report was created. string
max_tokens Maximum number of requests to return. int

Query Authorized Fields for Grouping

Endpoint:

POST: https://reporting.api.kochava.com/v1.4/grouping

Response Data:

{
  "status": "OK",
  "valid_fields": [
    "country",
    "network",
    "campaign",
    "site",
    "tracker",
    "creative",
    "state",
    "dma",
    "city",
    "cp_0",
    "cp_1",
    "cp_2",
    "cp_3",
    "cp_4",
    "cp_5",
    "cp_6",
    "cp_7",
    "cp_8",
    "cp_9"
  ]
}

Query Authorized Fields for Filtering

Endpoint:

POST: https://reporting.api.kochava.com/v1.4/filtering

Response Data:

{ 
    "status": "OK", 
    "valid_fields": [
            "country",
            "network",
            "campaign",  **  ONLY APPLY TO SUMMARY REPORT
            "site",
            "tracker",
            "creative"
    ]
}

Query Authorized Values for Timezones

Endpoint:

POST: https://reporting.api.kochava.com/v1.4/timezones

Response Data:

{
        "status": "OK",
        "valid_fields": [
            "Africa/Abidjan",
            "Africa/Accra",
            "Africa/Addis_Ababa",
            "Africa/Algiers",
            "Africa/Asmara",
            ...
            "US/Indiana-Starke",
            "US/Michigan",
            "US/Mountain",
            "US/Pacific",
            "US/Pacific-New",
            "US/Samoa",
            "UTC",
            "W-SU",
            "WET",
            "Zulu"
        ]
}

Query Report Templates

This call return the list of templates that have been created in the system (and stored in kochava_reports.templates. Each template is returned with the pre-set/default values for all the parameters (traffic, grouping, etc…).

NOTE: If you’re looking for a report type that isn’t documented in our Requesting and Scheduling Reports support documentation, calling this endpoint against your own account will return the exact traffic, grouping, and filtering values currently configured for every report template available to that account — including the correct endpoint (Summary vs. Detail) to submit the request to.

Endpoint:

POST: https://reporting.api.kochava.com/v1.4/templates

Sample Post Data:

{
  "api_key": "YOUR_API_KEY",
  "app_guid": "YOUR_APP_GUID"
}

Response Data:

{
    "status": "OK",
    "template_values": [
        {
            "name": "Click",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "click": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": {
                "campaign": true,
                "country": true,
                "network": true,
                "segment": true,
                "tracker": true
            },
            "traffic_includes": {
                "custom_parameters": false,
                "identity_link": false,
                "traffic_verification": false
            },
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 1,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Row-level log of clicks driven by a given marketing campaign",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Detail",
                "type": "attribution"
            }
        },
        {
            "name": "Click MTA",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "influencer_click": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": {
                "network": true
            },
            "traffic_includes": null,
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Row-level log of clicks identified as influencers on a click that wins install attribution",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Influencer",
                "type": "attribution"
            }
        },
        {
            "name": "Cost",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "cost": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": null,
            "traffic_includes": {
                "include_tracker_id_0": false
            },
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 0,
            "admin_only": 1,
            "available_to_user": true,
            "report_description": "Row-level log of data collected from media partner cost APIs (cost tracking must be enabled)",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Cost & Revenue",
                "section": "",
                "type": "cost_revenue"
            }
        },
        {
            "name": "Cost + Measurement Summary",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "cost_v2_measurement": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": {
                "network_company": true,
                "partner_campaign_name": true
            },
            "traffic_includes": {
                "exclude0rows": false,
                "revenue": false
            },
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Summary of data collected from media partner cost APIs linked with Kochava attribution data by partner_campaign_name or partner_campaign_id (cost tracking must be enabled)",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Cost & Revenue",
                "section": "",
                "type": "cost_revenue"
            }
        },
        {
            "name": "Cost + SKAdNetwork Summary",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "cost_v2_skad": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": {
                "network_company": true,
                "partner_campaign_name": true
            },
            "traffic_includes": {
                "exclude0rows": false
            },
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Summary of data collected from media partner cost APIs linked with SKAdNetwork data by partner_campaign_name or partner_campaign_id (cost tracking must be enabled)",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Cost & Revenue",
                "section": "",
                "type": "cost_revenue"
            }
        },
        {
            "name": "Cost Detail",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "cost_v2": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": {
                "network_company": true,
                "partner_campaign_name": true
            },
            "traffic_includes": {
                "exclude0rows": false
            },
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Row-level log of data collected from media partner cost APIs (cost tracking must be enabled)",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Cost & Revenue",
                "section": "",
                "type": "cost_revenue"
            }
        },
        {
            "name": "Cost Summary",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "cost_v2_group": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": {
                "network_company": true,
                "partner_campaign_name": true
            },
            "traffic_includes": {
                "exclude0rows": false
            },
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Summary of data collected from media partner cost APIs (cost tracking must be enabled)",
            "quick_run": false,
            "ui_section": {
                "filter_name": "Cost & Revenue",
                "section": "",
                "type": "cost_revenue"
            }
        },
        {
            "name": "Event",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "event": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": {
                "campaign": true,
                "event_name": true,
                "network": true,
                "segment": true,
                "tracker": true
            },
            "traffic_includes": {
                "custom_parameters": false,
                "identity_link": false,
                "include_san_claim_data": false,
                "traffic_verification": false,
                "unattributed_traffic": false
            },
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Row-level log of post-install events with full metadata and campaign attribution; unattributed/organic event records also available",
            "quick_run": false,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Detail",
                "type": "attribution"
            }
        },
        {
            "name": "Fractional",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "fractional": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": {
                "network": true
            },
            "traffic_includes": null,
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Row-level log of clicks and/or impressions attributed to installs; includes fractional weight percentage based on attribution position (fractional attribution must be enabled)",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Influencer",
                "type": "attribution"
            }
        },
        {
            "name": "Impression MTA",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "influencer_imp": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": {
                "network": true
            },
            "traffic_includes": null,
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Row-level log of impressions identified as influencers on an install",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Influencer",
                "type": "attribution"
            }
        },
        {
            "name": "Install",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "install": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": {
                "campaign": true,
                "country": true,
                "network": true,
                "segment": true,
                "tracker": true
            },
            "traffic_includes": {
                "custom_parameters": false,
                "identity_link": false,
                "include_san_claim_data": false,
                "traffic_verification": false,
                "traffic_verification_install": false,
                "unattributed_only": false,
                "unattributed_traffic": false
            },
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 1,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Row-level log of installs; unattributed/organic install records also available",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Detail",
                "type": "attribution"
            }
        },
        {
            "name": "Matched Impression",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "impression": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": {
                "campaign": true,
                "country": true,
                "network": true,
                "segment": true,
                "tracker": true
            },
            "traffic_includes": {
                "traffic_verification": false
            },
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Row-level log of impressions from marketing campaigns attributed to installs",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Detail",
                "type": "attribution"
            }
        },
        {
            "name": "Reengagement",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "reengagement": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": {
                "campaign": true,
                "country": true,
                "network": true,
                "segment": true,
                "tracker": true
            },
            "traffic_includes": null,
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Row-level log of clicks driven by reengagement campaigns attributed to in-app conversions",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Detail",
                "type": "attribution"
            }
        },
        {
            "name": "Reengagement Impression",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "reengagement_imp": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": {
                "campaign": true,
                "country": true,
                "network": true,
                "tracker": true
            },
            "traffic_includes": null,
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Row-level log of impressions driven by reengagement campaigns attributed to in-app conversions",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Detail",
                "type": "attribution"
            }
        },
        {
            "name": "Restated Revenue",
            "category": "Detail",
            "endpoint": "detail",
            "traffic": {
                "revenue_restated": true
            },
            "traffic_query": {},
            "grouping": "",
            "filtering": null,
            "traffic_includes": null,
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Restated revenue data collected from media partner cost APIs (restated revenue tracking must be enabled)",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Cost & Revenue",
                "section": "",
                "type": "cost_revenue"
            }
        },
        {
            "name": "Query",
            "category": "Specialized",
            "endpoint": "custom",
            "traffic": null,
            "traffic_query": {},
            "grouping": "",
            "filtering": null,
            "traffic_includes": null,
            "output_format": {
                "csv": true,
                "json": false
            },
            "time_series": "",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Schedule recurring exports of a summary or detail report saved within Kochava Query",
            "quick_run": false,
            "ui_section": {
                "filter_name": "Query",
                "section": "",
                "type": "query"
            }
        },
        {
            "name": "Aggregated Insights (Events)",
            "category": "Summary",
            "endpoint": "summary",
            "traffic": {
                "event": true,
                "install": true
            },
            "traffic_query": {},
            "grouping": "{   \"app\": true, \"network\": true,   \"campaign\": false,   \"tracker\":false,   \"site\": false,   \"creative\": false, \"partner_campaign_name\": false, \"matched_to\": false, \"matched_by\": false  }",
            "filtering": {
                "campaign": true,
                "creative": true,
                "event_name": true,
                "network": true,
                "tracker": true
            },
            "traffic_includes": {
                "associated_event": true,
                "attributed_included": true,
                "reengagement_event": true,
                "restricted_included": true
            },
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "1",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Aggregated summary of key performance metrics by network; can be grouped by time, geo, other attribution variables",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Summary",
                "type": "attribution"
            }
        },
        {
            "name": "Aggregated Insights (Installs)",
            "category": "Summary",
            "endpoint": "summary",
            "traffic": {
                "click": true,
                "impression": true,
                "install": true
            },
            "traffic_query": {},
            "grouping": "{   \"app\": true, \"network\": true,   \"campaign\": false,   \"tracker\":false,   \"site\": false,   \"creative\": false, \"partner_campaign_name\": false, \"matched_to\": false, \"matched_by\": false  }",
            "filtering": {
                "campaign": true,
                "creative": true,
                "network": true,
                "tracker": true
            },
            "traffic_includes": {
                "attributed_included": true,
                "restricted_included": true
            },
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "1",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Aggregated summary of key performance metrics by network; can be grouped by time, geo, other attribution variables",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Summary",
                "type": "attribution"
            }
        },
        {
            "name": "Campaign",
            "category": "Summary",
            "endpoint": "summary",
            "traffic": {
                "click": true,
                "engaged_click": false,
                "engaged_view": false,
                "impression": false,
                "install": true,
                "network_spend": false,
                "qr_code": false,
                "trafficverif": false
            },
            "traffic_query": {},
            "grouping": "{\n  \"network\": true,\n  \"campaign\": true,\n  \"segment\": false,\n   \"tracker\":true,\n  \"site\": false,\n  \"creative\": false,\n  \"country\": false,\n  \"dma\": false,\n  \"state\": false,\n  \"city\": false,\n  \"cp_0\": false,\n  \"cp_1\": false,\n  \"cp_2\": false,\n  \"cp_3\": false,\n  \"cp_4\": false,\n  \"cp_5\": false,\n  \"cp_6\": false,\n  \"cp_7\": false,\n  \"cp_8\": false,\n  \"cp_9\": false }",
            "filtering": {
                "campaign": true,
                "country": true,
                "network": true,
                "segment": true,
                "tracker": true
            },
            "traffic_includes": null,
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "1",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Aggregated summary of key performance metrics by campaign; can be grouped by time, geo, other attribution variables",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Summary",
                "type": "attribution"
            }
        },
        {
            "name": "Network",
            "category": "Summary",
            "endpoint": "summary",
            "traffic": {
                "click": true,
                "engaged_click": false,
                "engaged_view": false,
                "impression": true,
                "install": true,
                "network_spend": false,
                "network_spend_restated": false,
                "qr_code": false,
                "trafficverif": false
            },
            "traffic_query": {},
            "grouping": "{\n  \"network\": true,\n  \"campaign\": false,\n  \"segment\": false,\n   \"tracker\":false,\n  \"site\": false,\n  \"creative\": false,\n  \"country\": false,\n  \"dma\": false,\n  \"state\": false,\n  \"city\": false,\n  \"cp_0\": false,\n  \"cp_1\": false,\n  \"cp_2\": false,\n  \"cp_3\": false,\n  \"cp_4\": false,\n  \"cp_5\": false,\n  \"cp_6\": false,\n  \"cp_7\": false,\n  \"cp_8\": false,\n  \"cp_9\": false\n}",
            "filtering": {
                "campaign": true,
                "country": true,
                "network": true,
                "segment": true,
                "tracker": true
            },
            "traffic_includes": null,
            "output_format": {
                "csv": true,
                "json": true
            },
            "time_series": "1",
            "network_enabled": 1,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Aggregated summary of key performance metrics by network; can be grouped by time, geo, other attribution variables",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Summary",
                "type": "attribution"
            }
        },
        {
            "name": "Retention Standard",
            "category": "Summary",
            "endpoint": "query",
            "traffic": null,
            "traffic_query": {
                "select": "SELECT COUNT(DISTINCT i.kochava_device_id) AS installs, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) = 1 THEN i.kochava_device_id ELSE NULL END)) AS d1_retention, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) = 2 THEN i.kochava_device_id ELSE NULL END)) AS d2_retention, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) = 3 THEN i.kochava_device_id ELSE NULL END)) AS d3_retention, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) = 5 THEN i.kochava_device_id ELSE NULL END)) AS d5_retention, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) = 7 THEN i.kochava_device_id ELSE NULL END)) AS d7_retention, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) = 14 THEN i.kochava_device_id ELSE NULL END)) AS d14_retention, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) = 21 THEN i.kochava_device_id ELSE NULL END)) AS d21_retention, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) = 30 THEN i.kochava_device_id ELSE NULL END)) AS d30_retention",
                "from": "FROM installs_primary as i LEFT JOIN (SELECT install_id, date_occurred FROM events_primary WHERE DATE(date_occurred) BETWEEN DATE(DATE_ADD(CURRENT_TIMESTAMP(), -31, 'day')) AND DATE(DATE_ADD(CURRENT_TIMESTAMP(), -1, 'day')) AND install_id <> '0') as e ON i.install_id = e.install_id ",
                "where": "WHERE DATE(i.date_occurred) BETWEEN DATE(DATE_ADD(CURRENT_TIMESTAMP(), -31, 'day')) AND DATE(DATE_ADD(CURRENT_TIMESTAMP(), -31, 'day'))",
                "orderby": "ORDER BY installs DESC",
                "fieldmapping": {
                    "country": "i.country_code AS country_code",
                    "creative": "i.creative_id AS creative_id",
                    "network": "i.network_id, i.network_name",
                    "site": "i.site_id AS site_id"
                }
            },
            "grouping": "{ \"network\": true, \"site\": false, \"creative\": false, \"country\":false }",
            "filtering": {
                "country": true,
                "network": true,
                "timerange": false
            },
            "traffic_includes": null,
            "output_format": {
                "csv": true,
                "json": false
            },
            "time_series": "1",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Cohort of installs grouped by date, country, network, site, creative; provides count of devices from cohort active in app by day after install",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Retention",
                "type": "attribution"
            }
        },
        {
            "name": "Retention Windowed",
            "category": "Summary",
            "endpoint": "query",
            "traffic": null,
            "traffic_query": {
                "select": "SELECT COUNT(DISTINCT i.kochava_device_id) AS installs, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) BETWEEN 1 AND 1 THEN i.kochava_device_id ELSE NULL END)) AS d1_retention, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) BETWEEN 2 AND 2 THEN i.kochava_device_id ELSE NULL END)) AS d2_retention, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) BETWEEN 3 AND 3 THEN i.kochava_device_id ELSE NULL END)) AS d3_retention, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) BETWEEN 4 AND 5 THEN i.kochava_device_id ELSE NULL END)) AS d5_retention, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) BETWEEN 6 AND 7 THEN i.kochava_device_id ELSE NULL END)) AS d7_retention, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) BETWEEN 8 AND 14 THEN i.kochava_device_id ELSE NULL END)) AS d14_retention, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) BETWEEN 15 AND 21 THEN i.kochava_device_id ELSE NULL END)) AS d21_retention, COUNT(DISTINCT(CASE WHEN DATEDIFF(e.date_occurred, i.date_occurred) BETWEEN 22 AND 30 THEN i.kochava_device_id ELSE NULL END)) AS d30_retention ",
                "from": "FROM installs_primary as i LEFT JOIN (SELECT install_id, date_occurred FROM events_primary WHERE DATE(date_occurred) BETWEEN DATE(DATE_ADD(CURRENT_TIMESTAMP(), -31, 'day')) AND DATE(DATE_ADD(CURRENT_TIMESTAMP(), -1, 'day')) AND install_id <> '0') as e ON i.install_id = e.install_id ",
                "where": "WHERE DATE(i.date_occurred) BETWEEN DATE(DATE_ADD(CURRENT_TIMESTAMP(), -31, 'day')) AND DATE(DATE_ADD(CURRENT_TIMESTAMP(), -31, 'day'))",
                "orderby": "ORDER BY installs DESC",
                "fieldmapping": {
                    "country": "i.country_code AS country_code",
                    "creative": "i.creative_id AS creative_id",
                    "network": "i.network_id, i.network_name",
                    "site": "i.site_id AS site_id"
                }
            },
            "grouping": "{ \"network\": true, \"site\": false, \"creative\": false, \"country\":false }",
            "filtering": {
                "country": true,
                "network": true,
                "timerange": false
            },
            "traffic_includes": null,
            "output_format": {
                "csv": true,
                "json": false
            },
            "time_series": "1",
            "network_enabled": 0,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Cohort of installs grouped by date, country, network, site, creative; provides count of devices from cohort active in app by day range after install",
            "quick_run": true,
            "ui_section": {
                "filter_name": "Attribution",
                "section": "Retention",
                "type": "attribution"
            }
        },
        {
            "name": "SKAdNetwork Conversion Value",
            "category": "Summary",
            "endpoint": "summary",
            "traffic": {
                "skadnetwork": true
            },
            "traffic_query": {},
            "grouping": "{\"date_range_utc\": true, \"ko_account_name\": true, \"ko_account_id\": true, \"advertiser_app_store_id\": true, \"ko_app_name\": true, \"ko_app_id\": true, \"ko_app_guid\": true, \"sk_version\": true, \"exchange_id\": false, \"sk_ad_network_id\": true, \"ko_media_partner_name\": true, \"ko_media_partner_id\": true, \"sk_publisher_app_store_id\": false, \"site_id\": false, \"sub_site_id\": false, \"sk_campaign_id\": true, \"campaign_name\": true, \"campaign_id\": false, \"sub_campaign_name\": false, \"sub_campaign_id\": false, \"bid_amount\": false, \"bid_currency\": false, \"bid_strategy\": false, \"bid_type\": false, \"campaign_objective\": false, \"campaign_status\": false, \"creative_id\": false, \"creative_name\": false, \"keyword\": false, \"country\": false, \"sk_country\": false, \"conversion_model\": true, \"measurement_window\": true, \"conversion_value_description\": true, \"conversion_value\": true, \"revenue_min\": false, \"revenue_max\": false, \"engagement_count\": false, \"events\": false, \"partner_events\": false, \"sk_install_matched_to_click\": false, \"sk_install_matched_to_impression\": false, \"sk_source_identifier\": false, \"sk_coarse_conversion_value\": false, \"sk_postback_sequence_index\": false, \"sk_source_domain\": false}",
            "filtering": {
                "campaign_name": true,
                "ko_media_partner_name": true,
                "measurement_window": true,
                "sk_ad_network_id": true,
                "sk_campaign_id": true,
                "sk_coarse_value": true,
                "sk_postback_sequence_index": true,
                "sk_publisher_app_store_id": true,
                "sk_source_domain": true,
                "sk_source_id": true
            },
            "traffic_includes": null,
            "output_format": {
                "csv": true,
                "json": false
            },
            "time_series": "1",
            "network_enabled": 1,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Aggregated summary of user conversion values sourced from SKAdNetwork signals; provides meaning of conversion values based on app\u2019s conversion model setting",
            "quick_run": true,
            "ui_section": {
                "filter_name": "SKAdNetwork",
                "section": "",
                "type": "skad"
            }
        },
        {
            "name": "SKAdNetwork Install",
            "category": "Summary",
            "endpoint": "summary",
            "traffic": {
                "install": true,
                "skadnetwork": true
            },
            "traffic_query": {},
            "grouping": "{\"date_range_utc\": true, \"ko_account_name\": true, \"ko_account_id\": true, \"advertiser_app_store_id\": true, \"ko_app_name\": true, \"ko_app_id\": true, \"ko_app_guid\": true, \"exchange_id\": false, \"sk_ad_network_id\": true, \"ko_media_partner_name\": true, \"ko_media_partner_id\": true, \"site_id\": false, \"sub_site_id\": false, \"sk_campaign_id\": true, \"campaign_name\": true, \"campaign_id\": false, \"sub_campaign_name\": false, \"sub_campaign_id\": false, \"bid_amount\": false, \"bid_currency\": false, \"bid_strategy\": false, \"bid_type\": false, \"campaign_objective\": false, \"campaign_status\": false, \"creative_id\": false, \"creative_name\": false, \"keyword\": false, \"country\": false,\"sk_install_matched_to_click\": false, \"sk_install_matched_to_impression\": false, \"sk_source_identifier\": false, \"sk_coarse_conversion_value\": false, \"sk_postback_sequence_index\": false, \"sk_source_domain\": false}",
            "filtering": {
                "campaign_name": true,
                "ko_media_partner_name": true,
                "sk_ad_network_id": true,
                "sk_campaign_id": true,
                "sk_coarse_value": true,
                "sk_postback_sequence_index": true,
                "sk_source_domain": true,
                "sk_source_id": true
            },
            "traffic_includes": {
                "influencers": false,
                "winners": true
            },
            "output_format": {
                "csv": true,
                "json": false
            },
            "time_series": "1",
            "network_enabled": 1,
            "admin_only": 0,
            "available_to_user": true,
            "report_description": "Aggregated summary of user install data sourced from SKAdNetwork signals",
            "quick_run": true,
            "ui_section": {
                "filter_name": "SKAdNetwork",
                "section": "",
                "type": "skad"
            }
        }
    ]
}

Query Columns Templates

By default, the Reporting system will generate report with all columns available (>100 in most cases). This may be too much for most request. Each report is broken up into several parts and for each part, colum**

Updated on September 23, 2026

Was this article helpful?