I was curious and I ran some queries* to size up this problem. For future reference:
select count(*) from wmf_raw.mediawiki_externallinks where snapshot='2024-06' and el_to_domain_index like '%gl.goo.%'; 44011 was the total across all wikis. On just enwiki it's 28554. As far as how many of these are maps, I grouped by `el_to_path like '/maps%'` and on enwiki that looks like: 19820 NOT maps and 8734 maps. Spot checking I saw a bunch of /forms links. If the need arose, we could export this data for a bot to use or think of some maintenance script that did these kinds of things. * this was run on our internal snapshot replica so as to not bother the production databases. The query in production would be similar. On Tue, Jul 23, 2024 at 8:43 AM Count Count <countvoncount123...@gmail.com> wrote: > That is the gist of it, yes. If, contrary to expectations, Google > sunsets goo.gl maps links we will still have time to revisit this. > > Am Di., 23. Juli 2024 um 09:54 Uhr schrieb Bináris <wikipo...@gmail.com>: > > > > So in your opinion there is nothing to do and everything goes well? > Really, for me it easy very easy not to do anything. :-) > > > > Count Count <countvoncount123...@gmail.com> ezt írta (időpont: 2024. > júl. 23., K, 8:23): > >> > >> > >> The intended audience of the announcement on the Google Developer > >> Blog[3], which made the news recently, are "developers using links > >> built with the Google URL Shortener in the form https://goo.gl/*";. I > >> assume that links given out by Google itself are not affected. To this > >> day Google Maps links are given out using the goo.gl domain and it > >> seems highly unlikely that Google will turn those off any time soon. > >> They are using a different scheme nowadays (maps.apps.goo.gl vs. > >> goo.gl/maps/) but I think it is very likely that old-style links will > >> continue to work for the foreseeable future as well. > >> > >> [1] > https://meta.wikimedia.org/w/index.php?title=Talk:Spam_blacklist&oldid=1767754#goo.gl > >> [2] > https://meta.wikimedia.org/wiki/Talk:Spam_blacklist/Archives/2012-06#Goo.gl%2Fmaps > >> [3] > https://developers.googleblog.com/en/google-url-shortener-links-will-no-longer-be-available/ > >> > >> Count Count > >> > >> > >> Am Mo., 22. Juli 2024 um 18:23 Uhr schrieb Bináris <wikipo...@gmail.com > >: > >> > > >> > "Starting August 23, 2024, goo.gl links will start displaying an > interstitial page for a percentage of existing links notifying your users > that the link will no longer be supported after August 25th, 2025 prior to > navigating to the original target page." > >> > In the next year the goo.gl links may cause problems, while as of > August 25th, 2025 they cease working. > >> > Do you think this issue needs any central action? Of course, it may > be handled locally, but not every wiki has bot owners for that. At least a > global warning would be useful for communities. > >> > > >> > My idea is to install an abuse filter that warns users to avoid new > goo.gl links, and change the existing ones by bot. > >> > > >> > Bináris > >> > _______________________________________________ > >> > Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org > >> > To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org > >> > > https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/ > >> _______________________________________________ > >> Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org > >> To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org > >> > https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/ > > > > > > > > -- > > Bináris > > _______________________________________________ > > Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org > > To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org > > > https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/ > _______________________________________________ > Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org > To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org > https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/
_______________________________________________ Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/
