* 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(a)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(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wiki-research-l