Are there any statistics about skin usage on Wikimedia projects?
For example: * How many people use each skin on each project? * How many accounts that edited before and after the Vector switch have Monobook? * How many accounts that were created after the Vector switch use Monobook?
-- Amir Elisha Aharoni · אָמִיר אֱלִישָׁע אַהֲרוֹנִי http://aharoni.wordpress.com "We're living in pieces, I want to live in peace." - T. Moore
On Fri, Jun 17, 2011 at 10:42 AM, Amir E. Aharoni amir.aharoni@mail.huji.ac.il wrote:
Are there any statistics about skin usage on Wikimedia projects?
For example:
- How many people use each skin on each project?
I've been digging to get some numbers on this, especially accounting for "active" accounts. There's a couple of old legacy skins I'd love to send the way of the dodo if we can prove nobody's using them anymore.
-Chad
On 17.06.2011, 20:20 Chad wrote:
On Fri, Jun 17, 2011 at 10:42 AM, Amir E. Aharoni amir.aharoni@mail.huji.ac.il wrote:
Are there any statistics about skin usage on Wikimedia projects?
For example:
- How many people use each skin on each project?
I've been digging to get some numbers on this, especially accounting for "active" accounts. There's a couple of old legacy skins I'd love to send the way of the dodo if we can prove nobody's using them anymore.
From mw.org:
mysql> select count(*), up_value from user_properties where up_property='skin' group by up_value; +----------+-------------+ | count(*) | up_value | +----------+-------------+ | 150489 | | | 15 | amethyst | | 229 | chick | | 610 | cologneblue | | 894 | modern | | 15072 | monobook | | 126 | myskin | | 140 | nostalgia | | 114 | simple | | 257 | standard | | 3661 | vector | +----------+-------------+ 11 rows in set (11.64 sec)
user_touched is unavailable on Toolserver, so can't make a more detailed query.
We also used this to keep track of specific preferences, some interesting info there..
http://en.wikipedia.org/wiki/Special:PrefStats
- Trevor
On Fri, Jun 17, 2011 at 10:37 AM, Max Semenik maxsem.wiki@gmail.com wrote:
On 17.06.2011, 20:20 Chad wrote:
On Fri, Jun 17, 2011 at 10:42 AM, Amir E. Aharoni amir.aharoni@mail.huji.ac.il wrote:
Are there any statistics about skin usage on Wikimedia projects?
For example:
- How many people use each skin on each project?
I've been digging to get some numbers on this, especially accounting for "active" accounts. There's a couple of old legacy skins I'd love to send the way of the dodo if we can prove nobody's using them anymore.
From mw.org:
mysql> select count(*), up_value from user_properties where up_property='skin' group by up_value; +----------+-------------+ | count(*) | up_value | +----------+-------------+ | 150489 | | | 15 | amethyst | | 229 | chick | | 610 | cologneblue | | 894 | modern | | 15072 | monobook | | 126 | myskin | | 140 | nostalgia | | 114 | simple | | 257 | standard | | 3661 | vector | +----------+-------------+ 11 rows in set (11.64 sec)
user_touched is unavailable on Toolserver, so can't make a more detailed query.
-- Best regards, Max Semenik ([[User:MaxSem]])
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
On Fri, Jun 17, 2011 at 1:46 PM, Trevor Parscal tparscal@wikimedia.org wrote:
We also used this to keep track of specific preferences, some interesting info there..
Cool stuff, but doesn't quite get the "big picture" I'm going for. The most useful data here (as I said elsewhere) would be joining skin choice on user_touched as an indicator of activity, and aggregating those totals per-wiki--maybe in per-year buckets.
-Chad
On Fri, Jun 17, 2011 at 10:50 AM, Chad innocentkiller@gmail.com wrote:
On Fri, Jun 17, 2011 at 1:46 PM, Trevor Parscal tparscal@wikimedia.org wrote:
We also used this to keep track of specific preferences, some interesting info there..
Cool stuff, but doesn't quite get the "big picture" I'm going for. The most useful data here (as I said elsewhere) would be joining skin choice on user_touched as an indicator of activity, and aggregating those totals per-wiki--maybe in per-year buckets.
Beware of user_touched; it's also triggered when _other_ people do things, like editing your talk page, or bulk operations like a batch change of some other user preference.
user_touched could be current on an account that hasn't logged in in years.
-- brion
On Fri, Jun 17, 2011 at 2:11 PM, Brion Vibber brion@pobox.com wrote:
Beware of user_touched; it's also triggered when _other_ people do things, like editing your talk page, or bulk operations like a batch change of some other user preference.
user_touched could be current on an account that hasn't logged in in years.
Right, I know user_touched will definitely overstate our active users. I was choosing it as a metric because I don't really find the "active users" report in MediaWiki to have any merit.
-Chad
On Fri, Jun 17, 2011 at 1:37 PM, Max Semenik maxsem.wiki@gmail.com wrote:
From mw.org:
mysql> select count(*), up_value from user_properties where up_property='skin' group by up_value; [snip results]
Cool, and I've already looked up these stats on a few wikis on an ad-hoc basis. What I really want is WMF-wide stats :)
user_touched is unavailable on Toolserver, so can't make a more detailed query.
Yeah, that's a problem. Ideally I'd love results in the form of (user_touched,up_value), that'd be the most useful.
-Chad
Max Semenik wrote:
From mw.org:
mysql> select count(*), up_value from user_properties where up_property='skin' group by up_value; +----------+-------------+ | count(*) | up_value | +----------+-------------+ | 150489 | | | 15 | amethyst | | 229 | chick | | 610 | cologneblue | | 894 | modern | | 15072 | monobook | | 126 | myskin | | 140 | nostalgia | | 114 | simple | | 257 | standard | | 3661 | vector | +----------+-------------+ 11 rows in set (11.64 sec)
user_touched is unavailable on Toolserver, so can't make a more detailed query.
http://en.wikipedia.org/wiki/Wikipedia:Database_reports/User_preferences
MZMcBride
I could have sworn that the Usability team had some stats on this when they were active on the project.
--tomasz
On Fri, Jun 17, 2011 at 7:42 AM, Amir E. Aharoni amir.aharoni@mail.huji.ac.il wrote:
Are there any statistics about skin usage on Wikimedia projects?
For example:
- How many people use each skin on each project?
- How many accounts that edited before and after the Vector switch
have Monobook?
- How many accounts that were created after the Vector switch use Monobook?
-- Amir Elisha Aharoni · אָמִיר אֱלִישָׁע אַהֲרוֹנִי http://aharoni.wordpress.com "We're living in pieces, I want to live in peace." - T. Moore
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
wikitech-l@lists.wikimedia.org