countly.app_users{appID}

Follow

There are multiple app_users{appID} collections, one collection for each specific app.

Collection name is formed using "app_users" string and app ID.

So for example for app with ID "542e95d747f0be510c000004" the collection name would be: "app_users542e95d747f0be510c000004"

Here is the list of possible fields

Field Description Example
_id Unique user ID cb51c8d13bbe95444dde6f14e802d53046eed08e
uid Internal user identifier 1
cc User's country determined by connection IP Germany
rgn User's region Berlin
cty User's city determined by connection IP Berlin
did Unique device ID provided by SDK 8897529E-B7E1-4B6E-BA00-3D8487DE2B19
fs Timestamp when user was first seen 1412339494
ls Timestamp when user was last seen 1412339494
lac Milisecond timestamp of last api call 1412339494000
sc Total session count 2
sd Duration of last session in seconds 120
tsd Total Duration of all sessions in seconds 1200
d User's device Ipad Air
c User's carrier Verizon
p User's platform Android
pv User's platform version prefixed by platform first letter a5:0
av User's app version 1:2
lv Last view person accessed Profile page
vc Views accessed in this session 3
lvt Timestamp when last view was accessed 1460411976
crashes Array of crash Ids current user experiences [3898c736ad344d3ae8cb906b72447595147d93b3]
hasInfo Boolean if there is any additional info about user provided from SDK true
name User's full name Arturs Sosins
username User's username ar2rsawseen
email User's email address email@comain.com
organization User's organization or company Count.ly
phone User's phone number (854) 526-8024
gender User's gender, M for male and F for female M
byear User's birth year 1987
custom Custom properties provided for user {"login":"test"}
lp Timestamp of last purchase 1460411976
tp Total Purchase Amount 2.42
tpc Total Purchase Count 1
lpa Last Purchase Amount 2.42
lo User's locale (ISO Standard) fr_FR
r User's device resolution 600x800
dnst User's device screen density 240dpi
la User's language, 2 letter iso code fr
brw User's browser Opera
src User's source (package name for Android, and referrer for Web Analytics) com.google.vending
loc Object with location data { gps: true, date: 1516619563010, geo: { type: "Point", coordinates: [10, 20] } }
loc.gps Whether location is provided by developer true
loc.date Date of location 1516619563010
loc.geo Mongodb geospatial-compatible object with coordinates { type: "Point", coordinates: [lon, lat] }
fsd First Day Retention bucket 20160426
fsw First Week Retention bucket 20160425
fsm First Month REtention bucket 201604
cdfs Days of Retention 15
cwfs Weeks of Retention 2
cmfs Months of Retention 1
lsid Last session ID from Drill database 571f8be85f7d56a97e9aaa42
lvid Last view ID from Drill database  
tk Object with push notification tokens { ip: "iOS production token", ia: "iOS Ad Hoc token", id: "iOS development token", ap: "Android production token", at: "Android test token" }
msgs Array of arrays representing messages sent to this user: message id & date when it was sent. [ [ObjectId("message id"), 1516619563010] ]
cmp Campaign data { "_id": "9461713e03076a95175dccf4e91bab7511065790", "b": "Chrome", "bv": "75.0.3770.80", "c": "social5ab0c3ef92938d0e61cf77f4", "cnty": "CN", "l": "en-US", "last_click": 1558635152, "m": "false", "os": "Windows 10.0", "pl": "Windows", "r": "unknown", "n": "Social Campaign" },
nxret Retention data  
chr Cohort data, using key as cohort id and i is timestamp of entering cohort, and o is timestamp of existing cohort, and in is "true" if user is currently in the cohort { "f431f38867ee6d8e807d1883692ff7ff": { "i": 1562593543, "o": 1562596497 }, "682cf41a1b24744cb6f6ae67d7c7642a": { "i": 1567610390, "in": "true" } }
consents List of consents { "attribution": true, "clicks": true, "crashes": true, "events": true, "forms": true, "push": true, "scrolls": false, "sessions": true, "users": true, "views": true },

 

Here is an example of user document:

{
    "_id": "cb51c8d13bbe95444dde6f14e802d53046eed08e",
    "uid": "1",
    "cc": "Unknown",
    "cty": "Unknown",
    "did": "1234567890",
    "fs": 1412339494,
    "ls": 1412339494,
    "sc": 2,
    "sd": 120,
    "tsd": 120,
    "lsid": "54f56aa4d2205b1917931c9d",
   	"d" : "iPad Air",
    "c" : "Verizon",
    "p" : "WP8",
    "pv" : "w7:0",
    "av" : "1:9"
}

About internal identifier

uid can be used to match up internal queries about user data with drill and other collections.

Was this article helpful?
0 out of 0 found this helpful

Looking for help?