* This is a bit tricky for non registered users as they are anonymous, so 2 or more people may share the same IP. * Having said it, you can access the revision table[1], or get all the revision from dumps and query for it with select rev_user_text, YEAR(rev_timestamp), count(*) from revision where rev_user=0 group by rev_user_text, YEAR(rev_timestamp)
(replace year with the required granularity[3])
[1] https://www.mediawiki.org/wiki/Manual:Revision_table [2] https://dumps.wikimedia.org/ [3] https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html
On Thu, Dec 8, 2016 at 8:50 AM, Ofer Arazy ofer.arazy@gmail.com wrote:
Hi all,
I'm seeking assistance in retrieving data regarding the activity of *unregistered contributors* on a year-by-year basis. Namely, I'm looking for stats regarding the count of these IP users at the end of each calendar year, as well as their activity levels (e.g. avg. monthly edits).
I was able to get detailed stats for registered members, but not for those contributors identified through their IP
Help will be appreciated.
Thanks in advance, Ofer
--
Dr. Ofer Arazy http://www.OferArazy.com http://oferarazy.com/ ===================================
Wiki-research-l mailing list Wiki-research-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wiki-research-l