Collection device_details contains break down of new, total and unique device_details provided in the metrics by time periods, segmented by app versions, OS and OS versions and screen resolutions.
For shorter representation, these stats are abbreviated as:
- n - new
- t - total
- u - unique
There are 4 types of documents available:
- Zero document, which id is formed from {appID}_{year}:0 And it contains stats breakdown by months and weeks for the specified year
- Month document, which id is formed from {appID}_{year}:{month} And it contains stats breakdown by days of the month
- Splitted zero document which id is formed from {appID}{year}:0{shardname}
- Splitted month document which id is formed from {appID}{year}:{month}{shardname}
Here is the list of possible fields
| Field | Description | Example |
|---|---|---|
| _id | ID formed as {appID}{year}:0 or {appID}{year}:{month} or {appID}{year}:0{shardname} or {appID}{year}:{month}{shardname} | 542e95d747f0be510c000004_2014:10 |
| a | App ID | 542e95d747f0be510c000004 |
| d | Data for specific document | { "14": { "1200x800": { "t": 1, "u": 1 }, "1920x1200": { "t": 1, "u": 1 }, "1:0": { "t": 2, "u": 2 }, "1:2": { "t": 2, "u": 2 }, "2048x1564": { "t": 1, "u": 1 }, "800x480": { "t": 1, "u": 1 }, "Android": { "t": 3, "u": 3 }, "a4:1": { "t": 1, "u": 1 }, "a4:4": { "t": 2, "u": 2 }, "i6:1": { "t": 1, "u": 1 }, "iOS": { "t": 1, "u": 1 } }, } |
| m | {year}:{month} for which data is provided | 2014:10 |
| meta | Information about all device_detail values. Note it exists only for Zero documents of each year | "meta": { "app_versions": [ "1:0", "1:2", ], "os": [ "Android", "iOS", "WP8" ], "os_versions": [ "a4:4", "a4:1", "i6:1", "i4:0", "i6:0", "w8:1" ], "resolutions": [ "1200x800", "800x480", "2048x1564", "1920x1200", "800x1280", "360x640", "320x568", "640x1136" ] } |
| meta_v2 | New way to store meta info, much faster writes than using sets | "meta_v2": { "app_versions": { "1:0":true, "1:2":true }, "os": { "Android":true, "iOS":true, "WP8":true }, "os_versions": { "a4:4":true, "a4:1":true, "i6:1":true, "i4:0":true, "i6:0":true, "w8:1":true ], "resolutions": { "1200x800":true, "800x480":true, "2048x1564":true, "1920x1200":true, "800x1280":true, "360x640":true, "320x568":true, "640x1136":true } } |
Here are examples of both document types:
{
"_id": "542e95d747f0be510c000004_2014:0",
"a": "542e95d747f0be510c000004",
"d": {
"10": {
"1080x1920": {
"u": 15
},
"1200x800": {
"u": 1
},
"1536x2048": {
"u": 21
},
"1920x1200": {
"u": 1
},
"1:0": {
"u": 17
},
"1:1": {
"u": 18
},
"1:2": {
"u": 17
},
"2048x1564": {
"u": 1
},
"240x320": {
"u": 14
},
"240x400": {
"u": 18
},
"Android": {
"u": 121
},
"WP8": {
"u": 127
},
"a4:0": {
"u": 5
},
"a4:1": {
"u": 10
},
"a4:2": {
"u": 5
},
"a4:3": {
"u": 7
},
"i5:1": {
"u": 6
},
"i6:0": {
"u": 9
},
"i6:1": {
"u": 7
},
"w8:1": {
"u": 6
}
},
"1080x1920": {
"u": 15
},
"1200x800": {
"u": 1
},
"1536x2048": {
"u": 21
},
"1920x1200": {
"u": 1
},
"1:0": {
"u": 17
},
"1:1": {
"u": 18
},
"1:2": {
"u": 17
},
"2048x1564": {
"u": 1
},
"240x320": {
"u": 14
},
"240x400": {
"u": 18
},
"Android": {
"u": 121
},
"WP8": {
"u": 127
},
"a4:0": {
"u": 5
},
"a4:1": {
"u": 10
},
"a4:2": {
"u": 5
},
"a4:3": {
"u": 7
},
"i5:1": {
"u": 6
},
"i6:0": {
"u": 9
},
"i6:1": {
"u": 7
},
"iOS": {
"u": 94
},
"w2:2": {
"u": 9
},
"w2:3": {
"u": 6
},
"w3:1": {
"u": 10
},
"w3:2": {
"u": 7
},
"w41": {
"1200x800": {
"u": 1
},
"1920x1200": {
"u": 1
},
"1:0": {
"u": 2
},
"1:2": {
"u": 2
},
"2048x1564": {
"u": 1
},
"800x480": {
"u": 1
},
"Android": {
"u": 3
},
"a4:1": {
"u": 1
},
"a4:4": {
"u": 2
},
"i6:1": {
"u": 1
},
"iOS": {
"u": 1
}
},
"w4:0": {
"u": 4
},
"w4:1": {
"u": 11
},
"w4:2": {
"u": 9
},
"w4:3": {
"u": 8
},
"w4:4": {
"u": 5
},
"w5:0": {
"u": 6
},
"w5:1": {
"u": 9
},
"w6:0": {
"u": 14
},
"w6:1": {
"u": 4
},
"w7:0": {
"u": 4
},
"w7:1": {
"u": 6
},
"w8:0": {
"u": 9
},
"w8:1": {
"u": 6
}
},
"m": "2014:0",
"meta": {
"app_versions": [
"1:0",
"1:2"
],
"os": [
"Android",
"iOS",
"WP8"
],
"os_versions": [
"a4:4",
"a4:1",
"i6:1",
"w4:1",
"w2:2",
"i4:0",
"i6:0",
"i3:2",
"a6:1",
"a7:1",
"w3:2",
"i2:2",
"w4:4",
"w8:1",
"a3:1",
"i4:2",
"a8:1",
"w3:1",
"a7:0",
"a4:3",
"a5:0",
"w5:1",
"w6:0",
"w4:2",
"w2:3",
"i8:0",
"w8:0",
"w7:1",
"w4:3",
"a4:0",
"i4:3",
"i5:0",
"a6:0",
"a4:2",
"w5:0",
"i7:1",
"i4:4",
"w6:1",
"i4:1",
"i5:1",
"a5:1",
"i8:1",
"i2:3",
"w7:0",
"i7:0",
"a2:2",
"w4:0",
"a3:2",
"a2:3",
"a8:0",
"i3:1"
],
"resolutions": [
"1200x800",
"800x480",
"2048x1564",
"1920x1200",
"800x1280",
"360x640",
"320x568",
"640x1136",
"600x1024",
"240x400",
"320x480",
"1080x1920",
"480x854",
"640x960",
"1536x2048",
"768x1024",
"480x800",
"720x1280",
"240x320",
"600x800",
"540x960",
"768x1366"
]
}
}{
"_id": "542e95d747f0be510c000004_2014:10",
"a": "542e95d747f0be510c000004",
"d": {
"14": {
"1200x800": {
"t": 1,
"u": 1
},
"1920x1200": {
"t": 1,
"u": 1
},
"1:0": {
"t": 2,
"u": 2
},
"1:2": {
"t": 2,
"u": 2
},
"2048x1564": {
"t": 1,
"u": 1
},
"800x480": {
"t": 1,
"u": 1
},
"Android": {
"t": 3,
"u": 3
},
"a4:1": {
"t": 1,
"u": 1
},
"a4:4": {
"t": 2,
"u": 2
},
"i6:1": {
"t": 1,
"u": 1
},
"iOS": {
"t": 1,
"u": 1
}
},
"20": {
"1080x1920": {
"n": 12,
"t": 12,
"u": 12
},
"1536x2048": {
"n": 15,
"t": 15,
"u": 15
},
"1:0": {
"n": 8,
"t": 8,
"u": 8
},
"1:1": {
"n": 12,
"t": 12,
"u": 12
},
"1:2": {
"n": 7,
"t": 7,
"u": 7
},
"1:3": {
"n": 12,
"t": 12,
"u": 12
},
"1:4": {
"n": 6,
"t": 6,
"u": 6
},
"1:5": {
"n": 8,
"t": 8,
"u": 8
},
"1:6": {
"n": 12,
"t": 12,
"u": 12
},
"1:7": {
"n": 11,
"t": 11,
"u": 11
},
"1:8": {
"n": 18,
"t": 18,
"u": 18
},
"1:9": {
"n": 8,
"t": 8,
"u": 8
},
"240x320": {
"n": 5,
"t": 5,
"u": 5
},
"240x400": {
"n": 11,
"t": 11,
"u": 11
},
"2:0": {
"n": 9,
"t": 9,
"u": 9
},
"2:1": {
"n": 13,
"t": 13,
"u": 13
},
"2:2": {
"n": 14,
"t": 14,
"u": 14
},
"2:3": {
"n": 9,
"t": 9,
"u": 9
},
"2:4": {
"n": 12,
"t": 12,
"u": 12
},
"2:5": {
"n": 12,
"t": 12,
"u": 12
},
"2:6": {
"n": 4,
"t": 4,
"u": 4
},
"2:7": {
"n": 6,
"t": 6,
"u": 6
},
"2:8": {
"n": 4,
"t": 4,
"u": 4
},
"2:9": {
"n": 12,
"t": 12,
"u": 12
},
"320x480": {
"n": 14,
"t": 14,
"u": 14
},
"320x568": {
"n": 18,
"t": 18,
"u": 18
},
"360x640": {
"n": 8,
"t": 8,
"u": 8
},
"3:0": {
"n": 5,
"t": 5,
"u": 5
},
"3:1": {
"n": 10,
"t": 10,
"u": 10
},
"3:2": {
"n": 7,
"t": 7,
"u": 7
},
"480x800": {
"n": 15,
"t": 15,
"u": 15
},
"480x854": {
"n": 12,
"t": 12,
"u": 12
},
"540x960": {
"n": 7,
"t": 7,
"u": 7
},
"600x1024": {
"n": 10,
"t": 10,
"u": 10
},
"600x800": {
"n": 14,
"t": 14,
"u": 14
},
"640x1136": {
"n": 14,
"t": 14,
"u": 14
},
"640x960": {
"n": 17,
"t": 17,
"u": 17
},
"720x1280": {
"n": 11,
"t": 11,
"u": 11
},
"768x1024": {
"n": 14,
"t": 14,
"u": 14
},
"768x1366": {
"n": 9,
"t": 9,
"u": 9
},
"800x1280": {
"n": 13,
"t": 13,
"u": 13
},
"Android": {
"n": 76,
"t": 76,
"u": 76
},
"WP8": {
"n": 82,
"t": 82,
"u": 82
},
"a2:2": {
"n": 3,
"t": 3,
"u": 3
},
"a2:3": {
"n": 5,
"t": 5,
"u": 5
},
"a3:1": {
"n": 3,
"t": 3,
"u": 3
},
"a3:2": {
"n": 2,
"t": 2,
"u": 2
},
"a4:0": {
"n": 4,
"t": 4,
"u": 4
},
"a4:1": {
"n": 7,
"t": 7,
"u": 7
},
"a4:2": {
"n": 4,
"t": 4,
"u": 4
},
"a4:3": {
"n": 5,
"t": 5,
"u": 5
},
"a5:0": {
"n": 6,
"t": 6,
"u": 6
},
"a5:1": {
"n": 5,
"t": 5,
"u": 5
},
"a6:0": {
"n": 4,
"t": 4,
"u": 4
},
"a6:1": {
"n": 3,
"t": 3,
"u": 3
},
"a7:0": {
"n": 7,
"t": 7,
"u": 7
},
"a7:1": {
"n": 9,
"t": 9,
"u": 9
},
"a8:0": {
"n": 3,
"t": 3,
"u": 3
},
"a8:1": {
"n": 6,
"t": 6,
"u": 6
},
"i2:2": {
"n": 1,
"t": 1,
"u": 1
},
"i2:3": {
"n": 2,
"t": 2,
"u": 2
},
"i3:1": {
"n": 1,
"t": 1,
"u": 1
},
"i3:2": {
"n": 3,
"t": 3,
"u": 3
},
"i4:0": {
"n": 4,
"t": 4,
"u": 4
},
"i4:1": {
"n": 5,
"t": 5,
"u": 5
},
"i4:2": {
"n": 2,
"t": 2,
"u": 2
},
"i4:3": {
"n": 6,
"t": 6,
"u": 6
},
"i4:4": {
"n": 6,
"t": 6,
"u": 6
},
"i5:0": {
"n": 4,
"t": 4,
"u": 4
},
"i5:1": {
"n": 5,
"t": 5,
"u": 5
},
"i6:0": {
"n": 7,
"t": 7,
"u": 7
},
"i6:1": {
"n": 4,
"t": 4,
"u": 4
},
"i7:0": {
"n": 2,
"t": 2,
"u": 2
},
"i7:1": {
"n": 2,
"t": 2,
"u": 2
},
"i8:0": {
"n": 5,
"t": 5,
"u": 5
},
"i8:1": {
"n": 2,
"t": 2,
"u": 2
},
"iOS": {
"n": 61,
"t": 61,
"u": 61
},
"w2:2": {
"n": 4,
"t": 4,
"u": 4
},
"w2:3": {
"n": 3,
"t": 3,
"u": 3
},
"w3:1": {
"n": 6,
"t": 6,
"u": 6
},
"w3:2": {
"n": 5,
"t": 5,
"u": 5
},
"w4:0": {
"n": 3,
"t": 3,
"u": 3
},
"w4:1": {
"n": 8,
"t": 8,
"u": 8
},
"w4:2": {
"n": 5,
"t": 5,
"u": 5
},
"w4:3": {
"n": 6,
"t": 6,
"u": 6
},
"w4:4": {
"n": 3,
"t": 3,
"u": 3
},
"w5:0": {
"n": 6,
"t": 6,
"u": 6
},
"w5:1": {
"n": 5,
"t": 5,
"u": 5
},
"w6:0": {
"n": 8,
"t": 8,
"u": 8
},
"w6:1": {
"n": 4,
"t": 4,
"u": 4
},
"w7:0": {
"n": 1,
"t": 1,
"u": 1
},
"w7:1": {
"n": 4,
"t": 4,
"u": 4
},
"w8:0": {
"n": 6,
"t": 6,
"u": 6
},
"w8:1": {
"n": 5,
"t": 5,
"u": 5
}
},
"21": {
"1080x1920": {
"n": 3,
"t": 3,
"u": 3
},
"1536x2048": {
"n": 6,
"t": 6,
"u": 6
},
"1:0": {
"n": 7,
"t": 7,
"u": 7
},
"1:1": {
"n": 6,
"t": 6,
"u": 6
},
"1:2": {
"n": 8,
"t": 8,
"u": 8
},
"480x800": {
"n": 4,
"t": 4,
"u": 4
},
"480x854": {
"n": 5,
"t": 5,
"u": 5
},
"540x960": {
"n": 12,
"t": 12,
"u": 12
},
"600x1024": {
"n": 10,
"t": 10,
"u": 10
},
"600x800": {
"n": 8,
"t": 8,
"u": 8
},
"640x1136": {
"n": 9,
"t": 9,
"u": 9
},
"640x960": {
"n": 9,
"t": 9,
"u": 9
},
"Android": {
"n": 43,
"t": 43,
"u": 43
},
"WP8": {
"n": 45,
"t": 45,
"u": 45
},
"a4:0": {
"n": 1,
"t": 1,
"u": 1
},
"a4:1": {
"n": 2,
"t": 2,
"u": 2
},
"a4:2": {
"n": 1,
"t": 1,
"u": 1
},
"a4:3": {
"n": 2,
"t": 2,
"u": 2
},
"i5:1": {
"n": 1,
"t": 1,
"u": 1
},
"i6:0": {
"n": 2,
"t": 2,
"u": 2
},
"i6:1": {
"n": 2,
"t": 2,
"u": 2
},
"iOS": {
"n": 32,
"t": 32,
"u": 32
},
"w8:1": {
"n": 1,
"t": 1,
"u": 1
}
}
},
"m": "2014:10"
}