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 DE
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 of the first session start 1412339494
fac Timestamp of the first api call recorded on device 1412339494
first_sync Timestamp of the first api call received on server 1412339494
ls Timestamp of the last session start


lac Timestamp of the last api call recorded on device 1412339494
last_sync Timestamp of the last api call received on server 1412339494
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
organization User's organization or company
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)
loc Object with location data { gps: true, date: 1516619563010, geo: { type: "Point", coordinates: [10, 20] } }
loc.gps Whether location is provided by developer true 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 user skips a day, then number is not incremented after that day. Maximum value is 30. 15
cawfs Consecutive weeks of retention starting from Week-0. If user skips a week, then number is not incremented after that week. Maximum value is 24. 2
camfs Consecutive months of retention starting from Month-0. If user skips a month, then number is not incremented after that month. 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 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 Flags for other retention types. If a user has data in external retention collection, then existing fields are set as 1 for that user. {
"rd" : 1,
"rw" : 1
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?