Hi, Could someone advise how I could do Quarry queries on user activity? I'd like to monitor the following on en-wiki: All for unblocked humans -Number of active, confirmed editors (Done, https://quarry.wmflabs.org/query/34268) -Number of active editors with only 1 edit -Number of active editors with only 1 mainspace edit -Number of active non-conformirmed Editors
Definitions: Active : 1 edit in last 30 days Human : No bot flag Confirmed : 4 days / 10 edits
Hello,
Questions about quarry querying are best left on the Quarry talk page here: https://www.mediawiki.org/wiki/Talk:Quarry
And here's some example pseudo-code that looks at active editors over a rolling window:
https://github.com/wikimedia/analytics-wikimetrics/blob/master/wikimetrics/m...
It's not quite what you need, but it should help get you thinking about what's involved. For example, looking at the archive and revision tables together, aggregating, etc. For your namespace filters, you'd have to join to the page table as well, and look at page_namespace. There are also lots of other similar questions you can search for on the Quarry talk page.
Hi RhinosF1,
There are a ton of relevant example queries here too: https://wikitech.wikimedia.org/wiki/Help:MySQL_queries#Example_queries
Also, my HostBot sampling query uses may of the conditions that you're looking to filter by, and may be useful as a template for that reason: https://quarry.wmflabs.org/query/30143
If by "confirmed" you mean "autoconfirmed", that's probably something you'll need to filter for manually; I don't believe there's a flag for this in any of the dbs, because it's an arbitrary Enwiki-only pseudogroup https://en.wikipedia.org/wiki/Wikipedia:User_access_levels#Autoconfirmed_and_confirmed_users .
Finally, I *think* that putting /*SLOW_OK*/ at the top of your query will prevent timeout for longer-running queries, so you may want to do that.
Hope that helps, Jonathan
On Thu, Mar 14, 2019 at 2:23 AM RhinosF1 Wikipedia rhinosf1@gmail.com wrote:
Hi, Could someone advise how I could do Quarry queries on user activity? I'd like to monitor the following on en-wiki: All for unblocked humans -Number of active, confirmed editors (Done, https://quarry.wmflabs.org/query/34268) -Number of active editors with only 1 edit -Number of active editors with only 1 mainspace edit -Number of active non-conformirmed Editors
Definitions: Active : 1 edit in last 30 days Human : No bot flag Confirmed : 4 days / 10 edits _______________________________________________ Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics