Oh I agree - I was thinking that pagination-plus-filtering might make more sense than having separate pagination for each namespace

This might be simplified by filtering by namespace rather than grouping by namespace

So should we close this?

Do we really want to monitor template-favouriting-use on a continuous basis? If not then a dashboard seems like overkill for this. We can test the hypothesis by querying the db, right? A dashboard that nobody is gonna look at seems like a waste

I created T392896: Add a community-configurable list of "useful templates" to a tab in the template picker to cover the first bullet point under number 2 in the previous comment, so now I think all the ideas contained in this ticket are covered elsewhere. Closing in favour of the more detailed tickets

@Esanders - see @Samwilson 's comment ... basically all the bits of T55590 are now covered by other tickets except for this, so I've created this and am about to close T55590 (unless you have an objection?)

Done

This is done, and the data is currently being gathered and stored in hive in mediawiki_upload_tracking.upload and mediawiki_upload_tracking.commonswiki_deletion_request

Ok updated - it's kind of a tiny task now really

Ok so after talking this through last night we think we're going to have 2 templates - {{focus-area-header}} and {{focus-area-footer}}, and this one will be used in the footer

Covered by T389516: [L] Update ALIS to use wmf_content.mediawiki_content_history_v1 instead of wmf.*

Covered by T389516: [L] Update ALIS to use wmf_content.mediawiki_content_history_v1 instead of wmf.*

Updated to use page id

Removed the PK from community_requests_focus_areas based on the reasoning in https://phabricator.wikimedia.org/T387957#10659061 (i.e. we don't really need a separate auto-incrementing PK as there will always be a corresponding page)

All the above seems reasonable ... I can't remember the reason why I used title instead of the page_id, maybe it was so we wouldn't have to join page to get the title for making the link. Do you remember @Samwilson ?

We can get equivalent data to that in wmf.wikidata_item_page_link and wmf.wikdiata_entity by first defining a udf

Hey Eric - we've had big problems with the data pipeline since Jan (flaky upstream dependencies), and we kinda have to deal with those before we get to this, sorry!

Here's how to replace structured_data.commons_entity ...