Get uniquevisitors per month from database.

[MoJo]

I just wonder is it possible to get uniquevisitors per month from database something like analytics:pageviews:month.

Right now i tried:

>>> import pymongo
>>> import urllib.parse
>>> username = urllib.parse.quote_plus('nodebb')
>>> password = urllib.parse.quote_plus('password')
>>> database = 'nodebb'
>>> client = pymongo.MongoClient('mongodb://{0}:{1}@localhost:1035/{2}'.format(username, password, database))
>>> db = client['nodebb']
>>> x = db.objects.find( {"_key":"analytics:uniquevisitors"} )
[{'_id': ObjectId('5df09a9e55282ba145584758'), '_key': 'analytics:uniquevisitors', 'value': '1576047600000', 'score': 1}, 
{'_id': ObjectId('5def922055282ba14556cd62'), '_key': 'analytics:uniquevisitors', 'value': '1575979200000', 'score': 1},
{'_id': ObjectId('5def76e655282ba1455600fb'), '_key': 'analytics:uniquevisitors', 'value': '1575972000000', 'score': 1}, 
{'_id': ObjectId('5def5cec55282ba14555556c'), '_key': 'analytics:uniquevisitors', 'value': '1575964800000', 'score': 1}, 
{'_id': ObjectId('5def46f855282ba14554d247'), '_key': 'analytics:uniquevisitors', 'value': '1575961200000', 'score': 1}, 
{'_id': ObjectId('5def3bc255282ba1455499b0'), '_key': 'analytics:uniquevisitors', 'value': '1575957600000', 'score': 1}, 
{'_id': ObjectId('5dede3b21bf4964726f25229'), '_key': 'analytics:uniquevisitors', 'value': '1575871200000', 'score': 1}, 
{'_id': ObjectId('5dead6403d0bdde682e68827'), '_key': 'analytics:uniquevisitors', 'value': '1575669600000', 'score': 1}, 
{'_id': ObjectId('5deacab009d45de8c62faaa0'), '_key': 'analytics:uniquevisitors', 'value': '1575666000000', 'score': 2}, 
{'_id': ObjectId('5de6e706453021d4cc7aeee4'), '_key': 'analytics:uniquevisitors', 'value': '1575410400000', 'score': 1}, 
{'_id': ObjectId('5de6ced8453021d4cc7a7515'), '_key': 'analytics:uniquevisitors', 'value': '1575406800000', 'score': 1}, 
{'_id': ObjectId('5de59c2a721e4123b1946894'), '_key': 'analytics:uniquevisitors', 'value': '1575327600000', 'score': 1}]

But I don't know how to process this data further to get unique visitors per month.

Is value a timestamp? So i would check witch timestamp match previous month.

[baris]

@MoJo said in Get uniquevisitors per month from database.:

Is value a timestamp? So i would check witch timestamp match previous month.

Yes and then sum the scores.

[Carlito Santiago]

Correct me if I'm wrong. I'm really not sure if what you're trying to do. Are you trying to create a unique visitor graph or are you simply trying to display the unique Visitors for that current month? However, I think MongoDB timestamp is much similar to javascript time stamp. MongoDB has some built-in command to convert it however you can just as easily do this with javaScript.

var objectIdFromDate = function (date) {
	return Math.floor(date.getTime() / 1000).toString(16) + "0000000000000000";
};

var dateFromObjectId = function (objectId) {
	return new Date(parseInt(objectId.substring(0, 8), 16) * 1000);
};