Query provides unprecedented access and power allowing users to drill-down into data in meaningful ways. Pre-designed queries are provided, as well as the ability to create custom queries accessing all of the row-level data.
NOTE: Query does not allow the creation or manipulation of SQL tables or data.
Query provides drop-down menus to select pre-designed or saved queries, a drop-down menu for selecting recently run queries, an area allowing the creation of custom queries, a text box displaying the query code, as well as the options to save custom queries and email the query results.
NOTE: The query code box can be shown with either a light or a dark background. Adjusting the background can be accomplished by clicking on the current background choice in the upper right corner of the code box.
Once run, the query results will be displayed in a table format at the bottom of the page.
NOTE: Once a query is performed, up to 100 lines of results will be initially displayed. Users may add more data 100 lines at a time. Within each query, an initial limit has been set for the number of lines of data that will be pulled. If a larger amount of data is needed, update the limit field within the query. To receive all data associated with the query, the limit field may be removed, however, removing this field may increase the amount of time the query takes to complete its designated action.
A reminder of the number of days left with access to the Query is displayed in the upper right corner. Accessibility is determined based on the service level purchased.
NOTE: 32 Days is displayed because a single month of service was purchased. For a single month, 32 days of access is provided to account for the number of days in the longest month (31 plus 1 day) to allow for processing a full month of data if desired. For continued access to the Query, contact your Client Success Managers for more details.
A. Query Drop-Down Menu
B. Custom Query App and Field Selection options
C. All code within the Query Code box can be edited and the background changed
D. Custom Queries can be saved
E. Query data can be emailed to one or multiple addresses
Selecting a Saved Query
Kochava Queries are pre-designed queries that have been created to provide useful insights into an account’s data.
- Attribution Settings Loss Summary – This report will show how many installs were attributed as organic due to changes that were made to settings in the Kochava UI.
- Click Counts per Identifier — Returns device IDs from a time period along with the number of clicks that were seen from each device, across all networks.
- Click Detail — Returns all clicks from a given time period.
- Click Influencer Summary — This report shows a summarized view in which campaigns had a higher level of influence on installs for which they did not win attribution based on last click.
- Click IP Mismatch — Identify clicks that contained a different IP address in the header of the click request than what was identified explicitly from a query string parameter. Among other uses, this query could be used to identify clicks being sent to Kochava via S2S.
- Click Stats Health Summary — Summary report that shows common health indicators of clicks that could identify problem areas in your marketing mix.
- Disabled Click Influencers — Summary of attribution misses on influencers where the waterfall level was disabled.
- Event Detail for Google — The event details associated to Google.
- Fraud: Fast-Follow Click Influencer Summary — This report shows the average time between the winning click and the most recent influencer. A very low value might indicate a source that could be injecting fraudulent clicks in order to win last-click attribution.
- Impression Stats Health Summary — Summary report that shows common health indicators of impressions that could identify problem areas in the marketing mix.
- Influencer Clicks per Conversion Summary — Summary report that shows how many influencing clicks contributed to each install within a given date range, grouped by attributed network campaign.
- Install Cohort Retention by Campaign — Summary report that shows which campaigns are more effective at keeping the users active in the app over time.
- Install Detail and Attributed Clicks — Report which returns all attributed clicks from a given time period. The most common install attributes are included along with the most common click attributes of the attributed click. This report would be commonly used to grab a large dump of data about attribution which could then be pulled into Excel or another analytics platform for further examination and analysis.
- Install Detail and Attributed Impressions — Report which returns all attributed impressions from a given time period. The most common install attributes are included along with the most common impression attributes of the attributed impression. This report would be commonly used to grab a large dump of data about attribution which could then be pulled into Excel or another analytics platform for further examination and analysis.
- Install Detail for Google — The install details associated to Google.
- Install Detail for Identifier — Row level install for device ID with attribution data.
- MTTI by Geo — Mean Time to Install by geographical city.
- Recent Installs — Row-level install attribution information for recent installs.
- Revenue Devices/Network — Devices ranked by revenue/network for the last 24 hours.
- Touch-points per Conversion — Summary of influencer count by network.
- Traffic Counts/Hour — Summary of traffic counts ranked by day/hour for the last 24 hours.
- What if: Attribution Change Quick Summary — Returns which network cohorts changed attributed installs the most.
- What if: Attribution Change Before/After Summary — Returns how many installs changed from the network cohort on the parent app to the network cohort on the what if app.
- What if: Clicks per Conversion Summary — Returns how the clicks per conversion shifted from the primary app to the what if app.
- What if: Influencer Change Summary — Returns which network cohorts changed attributed installs the most.
- What if: MTTI Shift Summary — Returns how the average time to install shifted from the primary app to the what if app.
A. Selecting a Kochava Query will insert the associated code into the code box.
- User Queries — Queries saved by the user currently logged in.
- App Queries — Queries saved in association with the currently selected app, and not saved by the currently logged in user.
- Account Queries — Queries saved in association with the currently logged in account, not associated with the currently selected app, or user currently logged in.
A. Saved Queries will be organized under User, App or Account depending on desired access.
Accessing the recent queries will display the last queries that have been run by a user. The recent queries are organized by:
- User Queries — Queries that have been recently run by the current user.
- App Queries — Queries that have been recently run on the current app not by the current user.
- Account Queries — Queries that have been recently run not on the current app and not by the current user.
A. Accessing the drop-down will display the recently run queries
Creating a Custom Query
Custom Queries can be created from any of the apps that are associated with the current account and any of the tables of data that have been collected.
NOTE: Queries should be formatted in accordance with the SQL 2011 Standard. For more information on structuring a SQL Query, refer to MySQL reference material.
- Select an app by clicking on it to enter the app ID into the query code.
- Click on Tables to access associated columns.
- Click on Table Column to enter column call into the query.
- Click Run Query.
A. Currently selected app and table
B. Tables of data available for Custom Queries
C. Columns within the selected table available for Custom Queries
NOTE: Custom Queries can be deleted by selecting the query and Clicking Delete. Use caution – once a custom query has been deleted, it cannot be recovered.