countly.app_users{appID}

Follow

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

A collection name is formed using "app_users" string and app ID.

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

Below is a list of all possible fields:

Field Description Example
_id Unique user ID. cb51c8d13bbe95444dde6f14e802d53046eed08e
uid Internal user identifier. Note. 1
cc User's country, determined by connection IP. DE
rgn User's region. Berlin
cty User's city, determined by connection IP. Berlin
did Unique device ID provided by the SDK. 8897529E-B7E1-4B6E-BA00-3D8487DE2B19
fs Timestamp of the first session start. 1412339494
fac Timestamp of the first API call recorded on the device. 1412339494
first_sync Timestamp of the first API call received on the server 1412339494
ls Timestamp of the last session start.

1412339494

lac Timestamp of the last API call recorded on the device. 1412339494
last_sync Timestamp of the last API call received on the server. 1412339494
sc Total session count. 2
sd Duration of the 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 the platform's first letter. a5:0
av User's app version. 1:2
lv Last view accessed by the user. Profile page
vc Views accessed in this session. 3
lvt Timestamp when the last view was accessed. 1460411976
crashes Array of crash IDs the current user experiences. [3898c736ad344d3ae8cb906b72447595147d93b3]
hasInfo Boolean if user is identified. True if identified, false or does not exist if anonymous 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 the user. {"login":"test"}
lp Timestamp of the 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 Boolean of whether the location is provided by the 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
cadfs Consecutive days of retention, starting from Day-0. If the user skips a day, then the number is not incremented after that day. The maximum value is 30. 15
cawfs Consecutive weeks of retention, starting from Week-0. If the user skips a week, then the number is not incremented after that week. The maximum value is 24. 2
camfs Consecutive months of retention, starting from Month-0. If the user skips a month, then the number is not incremented after that month. The maximum value is 13. 1
cdfs Relative retention alternative of cadfs. 13
cwfs Relative retention alternative of cawfs. 1
cmfs Relative retention alternative of camfs. 1
lsid Last session ID from the Drill database. 571f8be85f7d56a97e9aaa42
lvid Last view ID from the Drill database.  
tkip Boolean of whether the user has a production APN token set. true or false
tkia Boolean of whether the user has a TestFlight/AdHoc APN token set. true or false
tkid Boolean of whether the user has a development APN token set. true or false
tkap Boolean of whether the user has a production FCM token set. true or false
tkat Boolean of whether the user has a test FCM token set. true or false
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 Flags for other retention types. If a user has data in external retention collection, then the existing fields are set as 1 for that user. {
"rd" : 1,
"rw" : 1
}
chr Cohort data, using the key as cohort ID; i is the timestamp of entering cohort; o is the timestamp of existing cohort; and in is "true" if the 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 a 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.

Looking for help?