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

  • Overview

  • Using DataMine
    • Interface
      • Overview
      • Add a New Query
      • Renaming a Query
      • Delete a Query
      • Results Panel
      • CSV Format
    • Data Schema
      • Overview
      • Tables
      • Message Attributes
      • Custom Events and Custom Attributes
    • Using Time Partitions
    • Table Column Reference

  • Advanced Features
    • Custom Attributes
    • Push Campaigns
    • Template Functions
    • Custom Table Creation
    • Upsight User Defined Functions (UDFs)
    • UDFs

  • Best Practices
    • General Guidelines
    • Common Mistakes
    • Differences Between SQL/Hive QL

  • Basic Queries
    • Overview
    • Number of install events each a day in a month
    • Total revenue each day in a month
    • Number of users active each day in a month
    • Total number of spenders each day on a month
    • Monthly Active Users
    • Monthly Unique Spenders
    • Revenue Per Virtual Good Item

  • Intermediate Queries
    • Overview
    • ARPPU
    • ARPDAU
    • Number of users who bought each item in the store
    • Number of spenders in each country this month

  • Advanced Queries
    • Overview
    • Day 1 Retention
    • Day 7 Retention With Additional Dimensions
    • Day Over Day Retention
    • Percent Returning Users
    • Last 3 actions of inactive (churned) users
    • Find popular events and pub data keys

  • FAQ

Upsight logo Back to top

DataMine Guide

    • Overview

      • What is DataMine?
      • How Often is Data Loaded into DataMine?
      • How Long Will My Query Take to Run?
    • Using DataMine

      • Interface
      • Data Schema
      • Using Time Partitions
      • Table Column Reference
    • Advanced Features

      • Custom Attributes
      • Push Campaigns
      • Template Functions
      • Custom Table Creation
      • Upsight User Defined Functions (UDFs)
      • UDFs
    • Best Practices

      • General Guidelines
      • Common Mistakes
      • Differences Between SQL/Hive QL
    • Basic Queries

      • Overview
      • Number of install events each a day in a month
      • Total revenue each day in a month
      • Number of users active each day in a month
      • Total number of spenders each day on a month
      • Monthly Active Users
      • Monthly Unique Spenders
      • Revenue Per Virtual Good Item
    • Intermediate Queries

      • Overview
      • ARPPU
      • ARPDAU
      • Number of users who bought each item in the store
      • Number of spenders in each country this month
    • Advanced Queries

      • Overview
      • Day 1 Retention
      • Day 7 Retention With Additional Dimensions
      • Day Over Day Retention
      • Percent Returning Users
      • Last 3 actions of inactive (churned) users
      • Find popular events and pub data keys
    • FAQ

© Upsight | Terms of Service