Hi Nemo

That's really great. 

I just love it when Wikimedians pick up on a suggestion and share more and better ways of doing stuff (and then we go off and document it on wiki!)

I've expanded the documentation page 

https://commons.wikimedia.org/wiki/Commons:Wiki_Loves_Monuments/Documentation/Send_a_mass_message

to help those who don't know SQL or Quarry to send a simple Commons message.

You've done some more sophisticated stuff, sending messages to Wikipedia talk pages, and it would be good to document that in an easy-to-follow way, as well.  I wonder whether you'd be able to construct a sample Quarry query based on https://quarry.wmflabs.org/query/38807 that could be used on the English Wikipedia?

It would be good, also, to have a query that focuses on most-needed articles that don't yet have an image. A Quarry query, for example, that extracts users who have edited these articles:

* English and Welsh Grade I listed sites with articles on the English Wikipedia that lack an illustration: http://tinyurl.com/ycvz6qpl

Regards

Michael
Federico Leva (Nemo)
5 September 2019 at 8:00 am


Thank you, I've added a few links over there.

Another strategy I used in the past is to message (Wikipedia) users related to places which take part in WLM:
https://quarry.wmflabs.org/query/38807

This has the advantage that you can send a more personal/interesting message which mentions a topic they're interested in, see for instance:
https://it.wikipedia.org/wiki/Discussioni_utente:Zwobot24

It works in Italy because users are often frustrated by the lack of monuments in their area (for the well known legal issues), so they may miss that new places have been added. To avoid sending a lot of irrelevant messages I focused on users with relatively few contributions but very focused on a relevant place; you may also want to target places without photos, or whatever priorities you have.

Mass messages were likely responsible for the small peaks of attention on September 12, 13 and 21 last year:
<https://tools.wmflabs.org/pageviews/?project=it.wikipedia.org&platform=all-access&agent=user&start=2018-09-01&end=2018-09-30&pages=Progetto:Wiki_Loves_Monuments_2018/Monumenti>

However I don't remember exactly how many of those users actually proceeded to upload something, so if you want to experiment new kinds of mass messaging I suggest you start small (e.g. 1000 messages) and check what impact they have before you proceed with many thousands. For very large deliveries (over 10k targets) you may want to check a sample of your targets to see if they've been messaged by others recently, to avoid fatigue.

Federico

_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org
effe iets anders
3 September 2019 at 9:21 pm
Hi  Michael,

Thanks, this is helpful to document. If you would be willing to update/expand the documentation here, that would be great: https://commons.wikimedia.org/wiki/Commons:Wiki_Loves_Monuments/Documentation/Send_a_mass_message

In general, this is the place where we try to collect these best practices: https://commons.wikimedia.org/wiki/Commons:Wiki_Loves_Monuments/Documentation 

Best,
Lodewijk



_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org
Michael Maggs
3 September 2019 at 8:19 pm
I just copied and edited the original template for the UK situation. Here's the UK version:

https://quarry.wmflabs.org/query/38769

Just stepping through what to do:

1. Fork the above query, using the Fork button

2. Change both sections of yellow text to relate to your situation, the first with your old Commons categories and the single line underneath with your current category.  Note that you need the underlines between the words; spaces won't work
 
3. Copy the results. If too many, download as csv, then open in a text editor, to get raw text with one entry per line

4. Use the results as the target for a mass message on Commons.  Unless you're an admin, you'll need help doing that, as non-admins are limited in the number of messages they can send.

4a. Start a new page on Commons, in your own userspace.  Set out the subject line and body text of the message you want to send.  Also include the list of targets. My example page is here:  https://commons.wikimedia.org/wiki/User:MichaelMaggs/WLM-UK2019Message

4b. Post a request to the Commons Administrator's noticeboard (https://commons.wikimedia.org/wiki/Commons:Administrators%27_noticeboard) for an admin to send the message for you.  Here's my request: https://commons.wikimedia.org/w/index.php?title=Commons:Administrators%27_noticeboard&diff=prev&oldid=364449416

4c. If all's OK, a friendly admin will be along soon to complete the messaging.

Hope that helps

Michael



_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org
Neville Borg
3 September 2019 at 7:50 pm
This sounds fantastic. Is there a foolproof way to do this for those of us with no knowledge of SQL? :)

I've changed the categories to WLM in Malta, as appropriate. Is there anything else I need to change?

Neville



--


_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org
Michael Maggs
3 September 2019 at 4:53 pm
This was really useful information. Thanks!

I have used a modified version of this to invite 2500 people on Commons who previously contributed to WLM in the UK.

Regards

Michael