Task #2679
closedmailing list statistics
Added by Florian Effenberger almost 6 years ago. Updated over 4 years ago.
0%
Description
As per our team meeting in Tirana, we want to
- regularly check subscribers for public lists
- find out which lists are subscribed the most
to see how we can improve our communication channels
Updated by Mike Saunders almost 6 years ago
Just noting that the stats are available here, before I think more about ways to improve communication:
Updated by Florian Effenberger over 5 years ago
- Status changed from New to In Progress
Can you extract a summary of the listing? An easy overview would be good, parsing the table can be tedious if at-a-glance is required ;-)
Updated by Mike Saunders over 5 years ago
So here's a way to make a more readable summary. Take the data from an email - eg https://listarchives.documentfoundation.org/www/moderators/msg00962.html - and save it as mailing_lists.txt. Then run this command:
cat mailing_lists.txt | cut -d " " -f 1,5 | sort -k 2 -nr
This removes all info apart from the list name and total subscribers, then sorts (reverse order), to show the most popular lists. So the results are like this:
announce@documentfoundation.org 4976
users@global.libreoffice.org 1525
users@fr.libreoffice.org 637
announce@de.libreoffice.org 630
discuss@documentfoundation.org 563
nyhedsbrev@da.libreoffice.org 528
users@de.libreoffice.org 512
l10n@global.libreoffice.org 433
usuarios@pt-br.libreoffice.org 392
users@es.libreoffice.org 369
...
I'll post the full list on marketing-priv@ at the start of every month. Or shall we share this more openly, eg on the regular marketing list?
Updated by Florian Effenberger over 5 years ago
I think we can make this more public, and script it
When Guilhem is back, can you check with him if he can run a weekly or monthly script that mails out to marketing@?
This way, we can automate the process
Updated by Mike Saunders over 5 years ago
Florian Effenberger wrote:
I think we can make this more public, and script it
This month, I've posted on the public marketing list instead.
When Guilhem is back, can you check with him if he can run a weekly or monthly script that mails out to marketing@?
This way, we can automate the process
Yep, I've pointed him at this ticket and asked him to investigate...
Updated by Mike Saunders over 5 years ago
- Project changed from Marketing to Infrastructure
- Assignee changed from Mike Saunders to Guilhem Moulin
Reassigning to Guilhem (after talking to him) -- he says he can automate the process!
Updated by Guilhem Moulin over 5 years ago
- Status changed from In Progress to Feedback
Sample automatic message posted to the private marketing list, with deltas from the metrics Mike sent on July 02.
Updated by Guilhem Moulin over 5 years ago
Also wouldn't it make sense to exclude the “nomail” category, ie people who can post but to whom mlmmj doesn't send messages? users@global.libreoffice.org in particular has a significant fraction of these (741 subscribers, 79 digesters, 698 nomailers).
Updated by Florian Effenberger over 4 years ago
- Assignee changed from Guilhem Moulin to Mike Saunders
Mike, can you give feedback on this one?
IMHO we already send something out?
Updated by Mike Saunders over 4 years ago
Florian Effenberger wrote:
Mike, can you give feedback on this one?
IMHO we already send something out?
Yes, it's all working fine, and done every month. No particular feedback to give - the stats could be useful, of course, as we discuss alternative communication platforms.
Updated by Florian Effenberger over 4 years ago
- Status changed from Feedback to Closed