This seems to be fine in most cases. If you do try to put in a massive category, like Living people, it can break things. I tried "Living people" for just a 3-day period, and the number of pages was so high it wouldn't fit into a BLOB, even after using bzcompress.

Note: this is a fork of https://en.wikipedia.org/wiki/User:Technical_13/Scripts/OrphanStatus, which is already counted for AutoEdits

Reconfirming that I fully support Daimona having logstash access. He is the foremost developer of AbuseFilter and has been for nearly a year now.

I'm happy to help run the query on some of the top projects if we can't find a better way. @Quiddity Do you plan on publishing this anywhere public, such as the wiki? Meta or the like? I'd love to link to the results from https://tools.wmflabs.org/topviews

In T211827#4822761, @Tbayer wrote:

Actually, a namespace_id field was added to the pageview_hourly during 2017 (T156993), so now is the first time we can try to use it for this purpose. While it is not yet 100% accurate in the sense that there remains a small amount of pageviews that still don't have value set for this field (mainly from the mobile apps IIRC), it should work for the present purpose of excluding most non-mainspace pages from the top 100 or so pages.

I replied at T183903#4822644 but moving discussion here.

In T183903#4818567, @Milimetric wrote:

quickly adding an example for all wikis, in case it's needed in the future (I haven't tested it but I'll edit it if it breaks and you yell at me on IRC :)):

 SELECT CONCAT('https://', project, '.org/wiki/', page_title),
        SUM(view_count) AS views
   FROM wmf.pageview_hourly
  WHERE year = 2018
    AND project = 'zh.wikipedia'
    AND agent_type = 'user'
  GROUP BY project, page_title
  ORDER BY project, views DESC
  LIMIT 100
;

No worries, it was seen in the Automated Edits column :) Moving it back for organization. Indeed I failed to test that the link worked properly. It's a shame these external wikilinks don't work via URL! They work when in wikitext... Oh well.

In T206817#4818662, @Samwilson wrote:

Do the pageviews for pages created and improved also include Wikidata items and Commons uploads? I assume they do.

PR merged https://github.com/wikimedia/eventmetrics/pull/148

PR merged, and cron running.

Done https://xtools.wmflabs.org/autoedits-contributions/en.wikipedia.org/DannyS712?tool=YABBR

Closing as invalid for now, assuming this was only that the results had been cached prior to you making your test edit. If you see this happen again (even after waiting 10 minutes), let us know :)

Most likely because of T211709 (restricted task). Investigation underway.

Interesting. Well if it happens again let us know!

@VIGNERON Could you provide a link? XTools should work for any WMF project. For example, here's the Edit Counter for my Wikidata contributions https://xtools.wmflabs.org/ec/www.wikidata.org/MusikAnimal

I guess @aezell is @MusikAnimal's magager per https://meta.wikimedia.org?oldid=18624969#Team ? (required for step 2)

@jmatazzoni Done, see for example https://eventmetrics-dev.wmflabs.org/programs/81/events/141

Thanks @Framawiki :)

Deployed! See https://xtools.wmflabs.org/autoedits-contributions/en.wikipedia.org/DannyS712?tool=stubsearch