我需要正确制定mongodb查询才能获得:
有多少唯一用户登录?
按国家/地区划分的登录独立用户数量是多少?
今天有多少唯一用户登录?
我的集合具有以下数据类型:
{
"_id": {
"$oid": "65e8fa34d11452b28eaf7cff"
},
"domain": "site.com",
"userAgent": "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36",
"ip": "157.55.39.204",
"country": "US",
"pub_id": "analytics",
"date": {
"$date": "2024-03-06T06:03:12.900Z"
},
"__v": 0
},
{
"_id": {
"$oid": "65e8fa37d11452b28eaf7d01"
},
"domain": "site2.com",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36",
"ip": "153.246.189.82",
"country": "JP",
"pub_id": "analytics",
"date": {
"$date": "2024-03-06T06:03:12.900Z"
},
"__v": 0
},
{
"_id": {
"$oid": "65e8fa39d11452b28eaf7d03"
},
"domain": "site3.com",
"userAgent": "Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)",
"ip": "54.36.148.164",
"country": "FR",
"pub_id": "analytics",
"date": {
"$date": "2024-03-06T06:03:12.900Z"
},
"__v": 0
}
笔记:
IP 地址可以重复,因为同一用户可以在同一天的不同时间登录。
如何在 MongoDB 中使用聚合正确查询?
1 个回答