upsight logo
  • API & SDK Reference
  • Dashboard Overview
  • Marketing Guide
  • Analytics Guide
  • DataMine Guide
  • Legacy Docs

  • Overview
    • What is Data Mine?

  • Interface
    • Overview
    • Scheduled Queries
    • Grouped Queries
    • Shared Queries
    • Table Explorer
    • Mapping Application Tables
    • Query Editor
    • Results Panel
    • Visualize Results
    • Table Creation
    • CSV Uploader
    • Data Mine Push Notifications
    • Data Mine Admin Panel

  • Upsight Analytics Shared Queries
    • Standard Queries
      • Count of Users by Gender
      • Daily Revenue
      • 30 Day Retention Return Rate
      • Day x Retention Approximation
      • Hourly Revenue
      • Install Date By User
      • Joining APA and UCC For Mobile Applications
      • Last 3 Events Before Users Leave The Application - Mobile
      • Last 3 Events Before Uninstall Event From User - Social
      • Monthly Active Users Approximation
      • Monthly Revenue
      • Session Frequency by Users
      • Time to First Monetization
      • Timestamp Transformation
      • Top 1% Monetizing Users
      • Total Time Spent and Number of Users
      • Working with Regular Expressions
      • Working with the JSON Data Column
      • Working with JSON Data - Data Column
      • Revenue by Country
      • 4 Line Custom Retention
      • Monetization Breakdown by Weekly Install Cohort
    • Portfolio Analysis Queries
      • Monetizing Users
      • User Installs
      • User Flow

  • Best Practices
    • General Guidelines
    • Common Mistakes
    • Differences Between SQL/Hive QL
    • UDFs and Macros
      • Overview
      • Use kt_session to Return the Number of Sessions for Each User
      • Get "Total sessions / Total time spent per user"
      • Get "Total sessions / Total time spent per user per day"
      • Use the "Dynamic Month" macro to select a specific time period
    • UDFs
    • CSV Format

  • Technical Reference
    • Mobile Table Reference
    • Social Table References

  • FAQ

Upsight logo Back to top

Legacy Data Mine Guide

    • Overview

      • What is Data Mine?
    • Interface

      • Overview
      • Scheduled Queries
      • Grouped Queries
      • Shared Queries
      • Table Explorer
      • Mapping Application Tables
      • Query Editor
      • Results Panel
      • Visualize Results
      • Table Creation
      • CSV Uploader
      • Data Mine Push Notifications
      • Data Mine Admin Panel
    • Upsight Analytics Shared Queries

      • Standard Queries
      • Portfolio Analysis Queries
    • Best Practices

      • General Guidelines
      • Common Mistakes
      • Differences Between SQL/Hive QL
      • UDFs and Macros
      • UDFs
      • CSV Format
    • Technical Reference

      • Mobile Table Reference
      • Social Table References
    • FAQ

© Upsight | Terms of Service