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