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
* 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
Ofer Arazy, 08/12/2016 07:50:
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).
Something like https://web.archive.org/web/20091018082131/http://stats.wikimedia.org/wikiqu... with some breakdown?
Nemo
Hi Ofer,
Have you found what you are looking for ? For the site Wikiscan I calculate number of IP and edits for each day, then display average per month and year to show evolution, for example on English Wikipedia : http://en.wikiscan.org
Akeron.
2016-12-08 9:06 GMT+01:00 Federico Leva (Nemo) nemowiki@gmail.com:
Ofer Arazy, 08/12/2016 07:50:
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).
Something like https://web.archive.org/web/20 091018082131/http://stats.wikimedia.org/wikiquote/EN/TablesW ikipediaEN.htm#anonymous with some breakdown?
Nemo
Wiki-research-l mailing list Wiki-research-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wiki-research-l
wiki-research-l@lists.wikimedia.org