Project

General

Profile

Task #2679

mailing list statistics

Added by Florian Effenberger 4 months ago. Updated 7 days ago.

Status:
In Progress
Priority:
Normal
Assignee:
Target version:
Team - Recurring
Start date:
Due date:
% Done:

0%

Estimated time:

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

History

#1 Updated by Mike Saunders 4 months ago

Just noting that the stats are available here, before I think more about ways to improve communication:

https://listarchives.documentfoundation.org/www/moderators/

#2 Updated by Florian Effenberger 12 days 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 ;-)

#3 Updated by Mike Saunders 7 days 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:

 4976
1525
637
630
563
528
512
433
392
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?

Also available in: Atom PDF