{
    "namespace": "mobvista.dmp.datasource.ga.bean",
    "type": "record",
    "name": "GaDeviceTotal",
    "separatorChar": "\t",
    "fields": [
        {
            "name": "device_id",
            "type": "string",
            "doc": "device id,google ad id for android,idfa for ios"
        },
        {
            "name": "device_type",
            "type": "string",
            "doc": "device type, gaid or imei or idfa or android id"
        },
        {
            "name": "platform",
            "type": "string",
            "doc": "android or ios, or unknown"
        },
        {
            "name": "country",
            "type": "string",
            "doc": "2 letter ISO country code"
        },
        {
            "name": "createtime",
            "type": "string",
            "doc": "first seen time"
        },
        {
            "name": "payment_count",
            "type": "int",
            "default": 0,
            "doc": "number of purchases made by this device"
        },
        {
            "name": "first_payed",
            "type": "string",
            "doc": "date this device first made a purchase"
        },
        {
            "name": "total_games",
            "type": "int",
            "default": 0,
            "doc": "total games installed"
        },
        {
            "name": "action_games",
            "type": "int",
            "default": 0,
            "doc": "action games installed"
        },
        {
            "name": "arcade_games",
            "type": "int",
            "default": 0,
            "doc": "arcade games installed"
        },
        {
            "name": "puzzle_games",
            "type": "int",
            "default": 0,
            "doc": "puzzle games installed"
        },
        {
            "name": "adventure_games",
            "type": "int",
            "default": 0,
            "doc": "adventure games installed"
        },
        {
            "name": "casual_games",
            "type": "int",
            "default": 0,
            "doc": "casual games installed"
        },
        {
            "name": "simulation_games",
            "type": "int",
            "default": 0,
            "doc": "simulation games installed"
        },
        {
            "name": "strategy_games",
            "type": "int",
            "default": 0,
            "doc": "strategy games installed"
        },
        {
            "name": "educational_games",
            "type": "int",
            "default": 0,
            "doc": "educational games installed"
        },
        {
            "name": "family_games",
            "type": "int",
            "default": 0,
            "doc": "family games installed"
        },
        {
            "name": "roleplaying_games",
            "type": "int",
            "default": 0,
            "doc": "role playing games installed"
        },
        {
            "name": "session_count_30d",
            "type": "int",
            "default": 0,
            "doc": "sessions played in last 30 days"
        },
        {
            "name": "session_duration_30d",
            "type": "double",
            "default": 0.0,
            "doc": "average session duration in last 30 days"
        },
        {
            "name": "session_count_7d",
            "type": "int",
            "default": 0,
            "doc": "sessions played in last 7 days"
        },
        {
            "name": "session_duration_7d",
            "type": "double",
            "default": 0.0,
            "doc": "average session duration in last 7 days"
        },
        {
            "name": "session_count",
            "type": "int",
            "default": 0,
            "doc": "sessions played ever"
        },
        {
            "name": "session_duration",
            "type": "double",
            "default": 0.0,
            "doc": "average session duration ever"
        },
        {
            "name": "facebook_id",
            "type": "string",
            "doc": "facebook id"
        },
        {
            "name": "google_plus_id",
            "type": "string",
            "doc": "google plus id"
        },
        {
            "name": "gender",
            "type": "string",
            "doc": "gender"
        },
        {
            "name": "birth_year",
            "type": "string",
            "doc": "birth year"
        },
        {
            "name": "revenue_week",
            "type": "double",
            "default": 0.0,
            "doc": "revenue week"
        },
        {
            "name": "revenue_month",
            "type": "double",
            "default": 0.0,
            "doc": "revenue month"
        },
        {
            "name": "average_session_per_app",
            "type": "double",
            "default": 0.0,
            "doc": "average sessions per app ever"
        },
        {
            "name": "average_days_per_app",
            "type": "double",
            "default": 0.0,
            "doc": "average days played per app"
        },
        {
            "name": "update_time",
            "type": "string",
            "doc": "update time"
        }
    ]
}

