There's discussion at https://bugzilla.wikimedia.org/show_bug.cgi?id=44448 about how skin usage correlates with who's an active editor.
It would be great to know what percentage of active editor (5+ edits in the main namespace) uses each skin on English Wikipedia. Perhaps for the last three months.
Matt Flaschen
On Tue, Jan 29, 2013 at 3:30 PM, Matthew Flaschen mflaschen@wikimedia.orgwrote:
There's discussion at https://bugzilla.wikimedia.org/show_bug.cgi?id=44448 about how skin usage correlates with who's an active editor.
It would be great to know what percentage of active editor (5+ edits in the main namespace) uses each skin on English Wikipedia. Perhaps for the last three months.
Matt Flaschen
Adding James F. in case he's not on this list. He has data on this, though I don't think for the last three months.
Hey,
Indeed, I [was] not on this list; now fixed. :-)
There is some data that Oliver Keyes is about to present as part of considering plans to dump the particularly-old skins from the Wikimedia cluster (see https://gerrit.wikimedia.org/r/#/c/25170/ and discussion there).
Oliver?
J.
On 29 January 2013 15:39, Steven Walling swalling@wikimedia.org wrote:
On Tue, Jan 29, 2013 at 3:30 PM, Matthew Flaschen mflaschen@wikimedia.org wrote:
There's discussion at https://bugzilla.wikimedia.org/show_bug.cgi?id=44448 about how skin usage correlates with who's an active editor.
It would be great to know what percentage of active editor (5+ edits in the main namespace) uses each skin on English Wikipedia. Perhaps for the last three months.
Matt Flaschen
Adding James F. in case he's not on this list. He has data on this, though I don't think for the last three months.
-- Steven Walling https://wikimediafoundation.org/
Sure. So, if you're just looking for the English-language Wikipedia it's pretty easy to get up-to-date info. The SQL query is just running now - I'll let you know when I have a detailed breakdown and pretty graphs (read: about 40 minutes, unless I get distracted).
On 30 January 2013 01:14, James Forrester jforrester@wikimedia.org wrote:
Hey,
Indeed, I [was] not on this list; now fixed. :-)
There is some data that Oliver Keyes is about to present as part of considering plans to dump the particularly-old skins from the Wikimedia cluster (see https://gerrit.wikimedia.org/r/#/c/25170/ and discussion there).
Oliver?
J.
On 29 January 2013 15:39, Steven Walling swalling@wikimedia.org wrote:
On Tue, Jan 29, 2013 at 3:30 PM, Matthew Flaschen <
mflaschen@wikimedia.org>
wrote:
There's discussion at https://bugzilla.wikimedia.org/show_bug.cgi?id=44448 about how skin usage correlates with who's an active editor.
It would be great to know what percentage of active editor (5+ edits in the main namespace) uses each skin on English Wikipedia. Perhaps for the last three months.
Matt Flaschen
Adding James F. in case he's not on this list. He has data on this,
though I
don't think for the last three months.
-- Steven Walling https://wikimediafoundation.org/
-- James D. Forrester Product Manager, VisualEditor Wikimedia Foundation, Inc.
jforrester@wikimedia.org | @jdforrester
Alright, I got distracted. Attached:
1. Pretty ggplot2 graph of users by skin in percentage terms; 2. data of skin/number of users/percentage overall; 3. SQL query used to get the results; 4. R file used to process them.
The data covers anyone who has triggered user_touched in the last month; hope it's helpful. If you're looking for more precise numbers on *editors*rather than people-who-are-logged-in that's also fairly trivial to retrieve.
On 30 January 2013 01:30, Oliver Keyes okeyes@wikimedia.org wrote:
Sure. So, if you're just looking for the English-language Wikipedia it's pretty easy to get up-to-date info. The SQL query is just running now - I'll let you know when I have a detailed breakdown and pretty graphs (read: about 40 minutes, unless I get distracted).
On 30 January 2013 01:14, James Forrester jforrester@wikimedia.orgwrote:
Hey,
Indeed, I [was] not on this list; now fixed. :-)
There is some data that Oliver Keyes is about to present as part of considering plans to dump the particularly-old skins from the Wikimedia cluster (see https://gerrit.wikimedia.org/r/#/c/25170/ and discussion there).
Oliver?
J.
On 29 January 2013 15:39, Steven Walling swalling@wikimedia.org wrote:
On Tue, Jan 29, 2013 at 3:30 PM, Matthew Flaschen <
mflaschen@wikimedia.org>
wrote:
There's discussion at https://bugzilla.wikimedia.org/show_bug.cgi?id=44448 about how skin usage correlates with who's an active editor.
It would be great to know what percentage of active editor (5+ edits in the main namespace) uses each skin on English Wikipedia. Perhaps for the last three months.
Matt Flaschen
Adding James F. in case he's not on this list. He has data on this,
though I
don't think for the last three months.
-- Steven Walling https://wikimediafoundation.org/
-- James D. Forrester Product Manager, VisualEditor Wikimedia Foundation, Inc.
jforrester@wikimedia.org | @jdforrester
-- Oliver Keyes Community Liaison, Product Development Wikimedia Foundation
On 01/29/2013 11:13 PM, Oliver Keyes wrote:
Alright, I got distracted. Attached:
- Pretty ggplot2 graph of users by skin in percentage terms;
- data of skin/number of users/percentage overall;
- SQL query used to get the results;
- R file used to process them.
The data covers anyone who has triggered user_touched in the last month; hope it's helpful. If you're looking for more precise numbers on /editors/ rather than people-who-are-logged-in that's also fairly trivial to retrieve.
That is useful (active, but either reader or editor), but I would appreciate if you could do the same for people who have made 5 or more mainspace edits in the same time period.
Matt Flaschen
On 01/29/2013 11:47 PM, Matthew Flaschen wrote:
That is useful (active, but either reader or editor), but I would appreciate if you could do the same for people who have made 5 or more mainspace edits in the same time period.
I see now that your query is 5+ lifetime edits in any namespace (based on user_editcount).
If you can do people who made 5+ mainspace edits during that period, that would be great. If not, some other measure of active editing would be good.
Sorry I wasn't clear originally.
Matt Flaschen
Sure; that's fairly trivial (thank the lord for the recentchanges table). I'll get on it when it's not 5am.
On 30 January 2013 04:54, Matthew Flaschen mflaschen@wikimedia.org wrote:
On 01/29/2013 11:47 PM, Matthew Flaschen wrote:
That is useful (active, but either reader or editor), but I would appreciate if you could do the same for people who have made 5 or more mainspace edits in the same time period.
I see now that your query is 5+ lifetime edits in any namespace (based on user_editcount).
If you can do people who made 5+ mainspace edits during that period, that would be great. If not, some other measure of active editing would be good.
Sorry I wasn't clear originally.
Matt Flaschen
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
So: attached, data - everyone with >5 actions in the recentchanges table. Now, the result-set is only ~7,000 entries long, which I'm *preeetty* sure is unreliable somehow, but I've applied a decade and a half of collected comp sci studies and around 3 decades of practical experience to the problem and they've all gone 'er. no idea. It should work'. If anyone else can spot what's going wrong, most appreciated :).
On 30 January 2013 05:11, Oliver Keyes okeyes@wikimedia.org wrote:
Sure; that's fairly trivial (thank the lord for the recentchanges table). I'll get on it when it's not 5am.
On 30 January 2013 04:54, Matthew Flaschen mflaschen@wikimedia.orgwrote:
On 01/29/2013 11:47 PM, Matthew Flaschen wrote:
That is useful (active, but either reader or editor), but I would appreciate if you could do the same for people who have made 5 or more mainspace edits in the same time period.
I see now that your query is 5+ lifetime edits in any namespace (based on user_editcount).
If you can do people who made 5+ mainspace edits during that period, that would be great. If not, some other measure of active editing would be good.
Sorry I wasn't clear originally.
Matt Flaschen
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
-- Oliver Keyes Community Liaison, Product Development Wikimedia Foundation
On 01/30/2013 06:43 PM, Oliver Keyes wrote:
So: attached, data - everyone with >5 actions in the recentchanges table. Now, the result-set is only ~7,000 entries long, which I'm /preeetty/ sure is unreliable somehow, but I've applied a decade and a half of collected comp sci studies and around 3 decades of practical experience to the problem and they've all gone 'er. no idea. It should work'. If anyone else can spot what's going wrong, most appreciated :).
I asked Ryan Faulkner to take a look, and he did indeed get higher numbers of users:
User ids that had at least 5 edits in the last 30 days
select count(*) from (select rc_user, count(*) as revs from enwiki.recentchanges where rc_timestamp >= '20130101000000' and rc_timestamp < '20130131000000' group by 1 having revs >= 5) as t
He said it was 32511 for ns0 (main namespace).
He didn't try to check the skin info in the query, so far.
I think the issue is that there is no row in user_properties if they did not change their skin. From https://www.mediawiki.org/wiki/Manual:User_properties_table:
"Only non-default settings are stored, so changes to the defaults are now reflected for everybody that hasn't saved an alternative preference, not only new accounts."
So the query seems to miss people who just always left the default skin. If I'm understanding this correctly, it has to be an outer join, defaulting to vector (the default on enwiki).
Matt Flaschen
On 31 January 2013 03:55, Matthew Flaschen mflaschen@wikimedia.org wrote:
On 01/30/2013 06:43 PM, Oliver Keyes wrote:
So: attached, data - everyone with >5 actions in the recentchanges table. Now, the result-set is only ~7,000 entries long, which I'm /preeetty/ sure is unreliable somehow, but I've applied a decade and a half of collected comp sci studies and around 3 decades of practical experience to the problem and they've all gone 'er. no idea. It should work'. If anyone else can spot what's going wrong, most appreciated :).
I asked Ryan Faulkner to take a look, and he did indeed get higher numbers of users:
User ids that had at least 5 edits in the last 30 days
select count(*) from (select rc_user, count(*) as revs from enwiki.recentchanges where rc_timestamp >= '20130101000000' and rc_timestamp < '20130131000000' group by 1 having revs >= 5) as t
He said it was 32511 for ns0 (main namespace).
He didn't try to check the skin info in the query, so far.
Tried a LEFT OUTER JOIN and it produced all of 5k more results :/. I'll
look at it with fresh eyes in the morning, unless anyone wants to get there first (sorry for taking so much of your time with what *should* be a pretty simple issue)
I think the issue is that there is no row in user_properties if they did not change their skin. From https://www.mediawiki.org/wiki/Manual:User_properties_table:
"Only non-default settings are stored, so changes to the defaults are now reflected for everybody that hasn't saved an alternative preference, not only new accounts."
So the query seems to miss people who just always left the default skin. If I'm understanding this correctly, it has to be an outer join, defaulting to vector (the default on enwiki).
Matt Flaschen
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Alright, having screwed with it I've got it up to...21k (and I replicated Ryan's work, with a couple of tweaks to explicitly exclude log actions and namespace !0 - same results. So something is hooky here :/). At this stage I'm genuinely not sure what could be going wrong; working attached if anyone wants to point out my blunder.
On 31 January 2013 06:23, Oliver Keyes okeyes@wikimedia.org wrote:
On 31 January 2013 03:55, Matthew Flaschen mflaschen@wikimedia.orgwrote:
On 01/30/2013 06:43 PM, Oliver Keyes wrote:
So: attached, data - everyone with >5 actions in the recentchanges table. Now, the result-set is only ~7,000 entries long, which I'm /preeetty/ sure is unreliable somehow, but I've applied a decade and a half of collected comp sci studies and around 3 decades of practical experience to the problem and they've all gone 'er. no idea. It should work'. If anyone else can spot what's going wrong, most appreciated :).
I asked Ryan Faulkner to take a look, and he did indeed get higher numbers of users:
User ids that had at least 5 edits in the last 30 days
select count(*) from (select rc_user, count(*) as revs from enwiki.recentchanges where rc_timestamp >= '20130101000000' and rc_timestamp < '20130131000000' group by 1 having revs >= 5) as t
He said it was 32511 for ns0 (main namespace).
He didn't try to check the skin info in the query, so far.
Tried a LEFT OUTER JOIN and it produced all of 5k more results :/. I'll
look at it with fresh eyes in the morning, unless anyone wants to get there first (sorry for taking so much of your time with what *should* be a pretty simple issue)
I think the issue is that there is no row in user_properties if they did not change their skin. From https://www.mediawiki.org/wiki/Manual:User_properties_table:
"Only non-default settings are stored, so changes to the defaults are now reflected for everybody that hasn't saved an alternative preference, not only new accounts."
So the query seems to miss people who just always left the default skin. If I'm understanding this correctly, it has to be an outer join, defaulting to vector (the default on enwiki).
Matt Flaschen
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
-- Oliver Keyes Community Liaison, Product Development Wikimedia Foundation
Hey guys,
I took a look and I'm not familiar with the schema, but I believe you need this clause as part of the LEFT JOIN instead of the WHERE clause:
user_properties.up_property = 'skin'
Because otherwise it would eliminate anyone who doesn't have a 'skin' property. If I understand correctly, those people would default to 'vector'. I've attached what I think is the right query, though I'd love a mirror to test these types of things on.
Hope that helps
Dan
On Thu, Jan 31, 2013 at 11:46 AM, Oliver Keyes okeyes@wikimedia.org wrote:
Alright, having screwed with it I've got it up to...21k (and I replicated Ryan's work, with a couple of tweaks to explicitly exclude log actions and namespace !0 - same results. So something is hooky here :/). At this stage I'm genuinely not sure what could be going wrong; working attached if anyone wants to point out my blunder.
On 31 January 2013 06:23, Oliver Keyes okeyes@wikimedia.org wrote:
On 31 January 2013 03:55, Matthew Flaschen mflaschen@wikimedia.orgwrote:
On 01/30/2013 06:43 PM, Oliver Keyes wrote:
So: attached, data - everyone with >5 actions in the recentchanges table. Now, the result-set is only ~7,000 entries long, which I'm /preeetty/ sure is unreliable somehow, but I've applied a decade and a half of collected comp sci studies and around 3 decades of practical experience to the problem and they've all gone 'er. no idea. It should work'. If anyone else can spot what's going wrong, most appreciated :).
I asked Ryan Faulkner to take a look, and he did indeed get higher numbers of users:
User ids that had at least 5 edits in the last 30 days
select count(*) from (select rc_user, count(*) as revs from enwiki.recentchanges where rc_timestamp >= '20130101000000' and rc_timestamp < '20130131000000' group by 1 having revs >= 5) as t
He said it was 32511 for ns0 (main namespace).
He didn't try to check the skin info in the query, so far.
Tried a LEFT OUTER JOIN and it produced all of 5k more results :/. I'll
look at it with fresh eyes in the morning, unless anyone wants to get there first (sorry for taking so much of your time with what *should* be a pretty simple issue)
I think the issue is that there is no row in user_properties if they did not change their skin. From https://www.mediawiki.org/wiki/Manual:User_properties_table:
"Only non-default settings are stored, so changes to the defaults are now reflected for everybody that hasn't saved an alternative preference, not only new accounts."
So the query seems to miss people who just always left the default skin. If I'm understanding this correctly, it has to be an outer join, defaulting to vector (the default on enwiki).
Matt Flaschen
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
-- Oliver Keyes Community Liaison, Product Development Wikimedia Foundation
-- Oliver Keyes Community Liaison, Product Development Wikimedia Foundation
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
That *over*reaches :/. So, for example, it pulls out prefs for http://en.wikipedia.org/wiki/Special:Contributions/Kpjas - who's made 2-3 contributions at most in that timeframe. This is going to bug me, I can tell.
On 31 January 2013 23:11, Dan Andreescu dandreescu@wikimedia.org wrote:
Hey guys,
I took a look and I'm not familiar with the schema, but I believe you need this clause as part of the LEFT JOIN instead of the WHERE clause:
user_properties.up_property = 'skin'
Because otherwise it would eliminate anyone who doesn't have a 'skin' property. If I understand correctly, those people would default to 'vector'. I've attached what I think is the right query, though I'd love a mirror to test these types of things on.
Hope that helps
Dan
On Thu, Jan 31, 2013 at 11:46 AM, Oliver Keyes okeyes@wikimedia.orgwrote:
Alright, having screwed with it I've got it up to...21k (and I replicated Ryan's work, with a couple of tweaks to explicitly exclude log actions and namespace !0 - same results. So something is hooky here :/). At this stage I'm genuinely not sure what could be going wrong; working attached if anyone wants to point out my blunder.
On 31 January 2013 06:23, Oliver Keyes okeyes@wikimedia.org wrote:
On 31 January 2013 03:55, Matthew Flaschen mflaschen@wikimedia.orgwrote:
On 01/30/2013 06:43 PM, Oliver Keyes wrote:
So: attached, data - everyone with >5 actions in the recentchanges table. Now, the result-set is only ~7,000 entries long, which I'm /preeetty/ sure is unreliable somehow, but I've applied a decade and a half of collected comp sci studies and around 3 decades of practical experience to the problem and they've all gone 'er. no idea. It should work'. If anyone else can spot what's going wrong, most appreciated
:).
I asked Ryan Faulkner to take a look, and he did indeed get higher numbers of users:
User ids that had at least 5 edits in the last 30 days
select count(*) from (select rc_user, count(*) as revs from enwiki.recentchanges where rc_timestamp >= '20130101000000' and rc_timestamp < '20130131000000' group by 1 having revs >= 5) as t
He said it was 32511 for ns0 (main namespace).
He didn't try to check the skin info in the query, so far.
Tried a LEFT OUTER JOIN and it produced all of 5k more results :/. I'll
look at it with fresh eyes in the morning, unless anyone wants to get there first (sorry for taking so much of your time with what *should* be a pretty simple issue)
I think the issue is that there is no row in user_properties if they did not change their skin. From https://www.mediawiki.org/wiki/Manual:User_properties_table:
"Only non-default settings are stored, so changes to the defaults are now reflected for everybody that hasn't saved an alternative preference, not only new accounts."
So the query seems to miss people who just always left the default skin. If I'm understanding this correctly, it has to be an outer join, defaulting to vector (the default on enwiki).
Matt Flaschen
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
-- Oliver Keyes Community Liaison, Product Development Wikimedia Foundation
-- Oliver Keyes Community Liaison, Product Development Wikimedia Foundation
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Was an answer to the question here found and published somewhere?
Nemo
On 03/21/2013 10:54 AM, Federico Leva (Nemo) wrote:
Was an answer to the question here found and published somewhere?
No, but your timing is good. Dan Andreescu has started looking at it again just recently today.
Let's use https://bugzilla.wikimedia.org/show_bug.cgi?id=45179 .
Matt Flaschen
Da; Dan and I be discussing it as we speak.
On 21 March 2013 21:45, Matthew Flaschen mflaschen@wikimedia.org wrote:
On 03/21/2013 10:54 AM, Federico Leva (Nemo) wrote:
Was an answer to the question here found and published somewhere?
No, but your timing is good. Dan Andreescu has started looking at it again just recently today.
Let's use https://bugzilla.wikimedia.org/show_bug.cgi?id=45179 .
Matt Flaschen
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
I started looking because of your message Federico, so thank you for sending that to remind me :)
On Thu, Mar 21, 2013 at 5:47 PM, Oliver Keyes okeyes@wikimedia.org wrote:
Da; Dan and I be discussing it as we speak.
On 21 March 2013 21:45, Matthew Flaschen mflaschen@wikimedia.org wrote:
On 03/21/2013 10:54 AM, Federico Leva (Nemo) wrote:
Was an answer to the question here found and published somewhere?
No, but your timing is good. Dan Andreescu has started looking at it again just recently today.
Let's use https://bugzilla.wikimedia.org/show_bug.cgi?id=45179 .
Matt Flaschen
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
-- Oliver Keyes Community Liaison, Product Development Wikimedia Foundation
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
For those of you interested in this but not on the bugzilla thread, I believe Oliver and I found an answer:
+-------------+------------+ | skin | skin_users | +-------------+------------+ | | 2525 | | 0 | 32 | | chick | 21 | | cologneblue | 104 | | default | 26582 | | modern | 329 | | monobook | 2810 | | myskin | 8 | | nostalgia | 15 | | simple | 21 | | standard | 98 | | vector | 74 | +-------------+------------+
On Thu, Mar 21, 2013 at 5:50 PM, Dan Andreescu dandreescu@wikimedia.orgwrote:
I started looking because of your message Federico, so thank you for sending that to remind me :)
On Thu, Mar 21, 2013 at 5:47 PM, Oliver Keyes okeyes@wikimedia.orgwrote:
Da; Dan and I be discussing it as we speak.
On 21 March 2013 21:45, Matthew Flaschen mflaschen@wikimedia.org wrote:
On 03/21/2013 10:54 AM, Federico Leva (Nemo) wrote:
Was an answer to the question here found and published somewhere?
No, but your timing is good. Dan Andreescu has started looking at it again just recently today.
Let's use https://bugzilla.wikimedia.org/show_bug.cgi?id=45179 .
Matt Flaschen
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
-- Oliver Keyes Community Liaison, Product Development Wikimedia Foundation
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Nemo are you on the Analytics List? CC-ing to be safe.
On Thu, Mar 28, 2013 at 9:31 AM, Dan Andreescu dandreescu@wikimedia.orgwrote:
For those of you interested in this but not on the bugzilla thread, I believe Oliver and I found an answer:
+-------------+------------+ | skin | skin_users | +-------------+------------+ | | 2525 | | 0 | 32 | | chick | 21 | | cologneblue | 104 | | default | 26582 | | modern | 329 | | monobook | 2810 | | myskin | 8 | | nostalgia | 15 | | simple | 21 | | standard | 98 | | vector | 74 | +-------------+------------+
On Thu, Mar 21, 2013 at 5:50 PM, Dan Andreescu dandreescu@wikimedia.orgwrote:
I started looking because of your message Federico, so thank you for sending that to remind me :)
On Thu, Mar 21, 2013 at 5:47 PM, Oliver Keyes okeyes@wikimedia.orgwrote:
Da; Dan and I be discussing it as we speak.
On 21 March 2013 21:45, Matthew Flaschen mflaschen@wikimedia.orgwrote:
On 03/21/2013 10:54 AM, Federico Leva (Nemo) wrote:
Was an answer to the question here found and published somewhere?
No, but your timing is good. Dan Andreescu has started looking at it again just recently today.
Let's use https://bugzilla.wikimedia.org/show_bug.cgi?id=45179 .
Matt Flaschen
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
-- Oliver Keyes Community Liaison, Product Development Wikimedia Foundation
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Dan Andreescu, 28/03/2013 14:31:
For those of you interested in this but not on the bugzilla thread, I believe Oliver and I found an answer:
Interesting! What's that 2525? The sum of the other numbers seem to match the 5+ edits/month user count on WikiStats, so I suppose it's not additional users.
Nemo
+-------------+------------+ | skin | skin_users | +-------------+------------+ | | 2525 | | 0 | 32 | | chick | 21 | | cologneblue | 104 | | default | 26582 | | modern | 329 | | monobook | 2810 | | myskin | 8 | | nostalgia | 15 | | simple | 21 | | standard | 98 | | vector | 74 | +-------------+------------+
On Thu, Mar 21, 2013 at 5:50 PM, Dan Andreescu <dandreescu@wikimedia.org mailto:dandreescu@wikimedia.org> wrote:
I started looking because of your message Federico, so thank you for sending that to remind me :) On Thu, Mar 21, 2013 at 5:47 PM, Oliver Keyes <okeyes@wikimedia.org <mailto:okeyes@wikimedia.org>> wrote: Da; Dan and I be discussing it as we speak. On 21 March 2013 21:45, Matthew Flaschen <mflaschen@wikimedia.org <mailto:mflaschen@wikimedia.org>> wrote: On 03/21/2013 10:54 AM, Federico Leva (Nemo) wrote: > Was an answer to the question here found and published somewhere? No, but your timing is good. Dan Andreescu has started looking at it again just recently today. Let's use https://bugzilla.wikimedia.org/show_bug.cgi?id=45179 . Matt Flaschen _______________________________________________ Analytics mailing list Analytics@lists.wikimedia.org <mailto:Analytics@lists.wikimedia.org> https://lists.wikimedia.org/mailman/listinfo/analytics -- Oliver Keyes Community Liaison, Product Development Wikimedia Foundation _______________________________________________ Analytics mailing list Analytics@lists.wikimedia.org <mailto:Analytics@lists.wikimedia.org> https://lists.wikimedia.org/mailman/listinfo/analytics
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
No indeed, so my query does coalesce(user_properties.up_value, 'default') as skin, then groups by skin. So that means the 2525 users literally have a user_properties record that's the empty string. Not sure what that means. Any mediawiki guys care to comment? If I had a gun to my head I'd guess they would get the default skin. But then if I had a gun to my head I'd have much bigger problems.
On Thu, Mar 28, 2013 at 10:16 AM, Federico Leva (Nemo) nemowiki@gmail.comwrote:
Dan Andreescu, 28/03/2013 14:31:
For those of you interested in this but not on the bugzilla thread, I
believe Oliver and I found an answer:
Interesting! What's that 2525? The sum of the other numbers seem to match the 5+ edits/month user count on WikiStats, so I suppose it's not additional users.
Nemo
+-------------+------------+ | skin | skin_users | +-------------+------------+ | | 2525 | | 0 | 32 | | chick | 21 | | cologneblue | 104 | | default | 26582 | | modern | 329 | | monobook | 2810 | | myskin | 8 | | nostalgia | 15 | | simple | 21 | | standard | 98 | | vector | 74 | +-------------+------------+
On Thu, Mar 21, 2013 at 5:50 PM, Dan Andreescu <dandreescu@wikimedia.org <mailto:dandreescu@wikimedia.**org dandreescu@wikimedia.org>> wrote:
I started looking because of your message Federico, so thank you for sending that to remind me :) On Thu, Mar 21, 2013 at 5:47 PM, Oliver Keyes <okeyes@wikimedia.org <mailto:okeyes@wikimedia.org>> wrote: Da; Dan and I be discussing it as we speak. On 21 March 2013 21:45, Matthew Flaschen <mflaschen@wikimedia.org <mailto:mflaschen@wikimedia.**org<mflaschen@wikimedia.org>>>wrote:
On 03/21/2013 10:54 AM, Federico Leva (Nemo) wrote: > Was an answer to the question here found and published somewhere? No, but your timing is good. Dan Andreescu has started looking at it again just recently today. Let's use https://bugzilla.wikimedia.**org/show_bug.cgi?id=45179https://bugzilla.wikimedia.org/show_bug.cgi?id=45179.
Matt Flaschen ______________________________**_________________ Analytics mailing list Analytics@lists.wikimedia.org <mailto:Analytics@lists.**wikimedia.org<Analytics@lists.wikimedia.org>https://lists.wikimedia.org/**mailman/listinfo/analytics<https://lists.wikimedia.org/mailman/listinfo/analytics> -- Oliver Keyes Community Liaison, Product Development Wikimedia Foundation ______________________________**_________________ Analytics mailing list Analytics@lists.wikimedia.org <mailto:Analytics@lists.**wikimedia.org Analytics@lists.wikimedia.org> https://lists.wikimedia.org/**mailman/listinfo/analyticshttps://lists.wikimedia.org/mailman/listinfo/analytics
______________________________**_________________ Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/**mailman/listinfo/analyticshttps://lists.wikimedia.org/mailman/listinfo/analytics
I believe it's default skin, yep, which is vector in most (or all) places.
Some of this data is about to become outdated, I'm afraid, since we're pushing ahead with turning off some of the really old skins :).
On 28 March 2013 14:21, Dan Andreescu dandreescu@wikimedia.org wrote:
No indeed, so my query does coalesce(user_properties.up_value, 'default') as skin, then groups by skin. So that means the 2525 users literally have a user_properties record that's the empty string. Not sure what that means. Any mediawiki guys care to comment? If I had a gun to my head I'd guess they would get the default skin. But then if I had a gun to my head I'd have much bigger problems.
On Thu, Mar 28, 2013 at 10:16 AM, Federico Leva (Nemo) <nemowiki@gmail.com
wrote:
Dan Andreescu, 28/03/2013 14:31:
For those of you interested in this but not on the bugzilla thread, I
believe Oliver and I found an answer:
Interesting! What's that 2525? The sum of the other numbers seem to match the 5+ edits/month user count on WikiStats, so I suppose it's not additional users.
Nemo
+-------------+------------+ | skin | skin_users | +-------------+------------+ | | 2525 | | 0 | 32 | | chick | 21 | | cologneblue | 104 | | default | 26582 | | modern | 329 | | monobook | 2810 | | myskin | 8 | | nostalgia | 15 | | simple | 21 | | standard | 98 | | vector | 74 | +-------------+------------+
On Thu, Mar 21, 2013 at 5:50 PM, Dan Andreescu <dandreescu@wikimedia.org <mailto:dandreescu@wikimedia.**org dandreescu@wikimedia.org>> wrote:
I started looking because of your message Federico, so thank you for sending that to remind me :) On Thu, Mar 21, 2013 at 5:47 PM, Oliver Keyes <okeyes@wikimedia.org <mailto:okeyes@wikimedia.org>> wrote: Da; Dan and I be discussing it as we speak. On 21 March 2013 21:45, Matthew Flaschen <mflaschen@wikimedia.org <mailto:mflaschen@wikimedia.**org<mflaschen@wikimedia.org>>>wrote:
On 03/21/2013 10:54 AM, Federico Leva (Nemo) wrote: > Was an answer to the question here found and published somewhere? No, but your timing is good. Dan Andreescu has started looking at it again just recently today. Let's use https://bugzilla.wikimedia.**org/show_bug.cgi?id=45179https://bugzilla.wikimedia.org/show_bug.cgi?id=45179.
Matt Flaschen ______________________________**_________________ Analytics mailing list Analytics@lists.wikimedia.org <mailto:Analytics@lists.**wikimedia.org<Analytics@lists.wikimedia.org>https://lists.wikimedia.org/**mailman/listinfo/analytics<https://lists.wikimedia.org/mailman/listinfo/analytics> -- Oliver Keyes Community Liaison, Product Development Wikimedia Foundation ______________________________**_________________ Analytics mailing list Analytics@lists.wikimedia.org <mailto:Analytics@lists.**wikimedia.org Analytics@lists.wikimedia.org> https://lists.wikimedia.org/**mailman/listinfo/analyticshttps://lists.wikimedia.org/mailman/listinfo/analytics
______________________________**_________________ Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/**mailman/listinfo/analyticshttps://lists.wikimedia.org/mailman/listinfo/analytics
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
