Hmm, assuming you can find the connection between mailing list name and editor name.

Both are public but often not the same.

 

From: Erik Zachte [mailto:ezachte@wikimedia.org]
Sent: Sunday, May 25, 2014 17:01
To: 'A mailing list for the Analytics Team at WMF and everybody who has an interest in Wikipedia and analytics.'
Subject: RE: [Analytics] Cohort analysis

 

* A list of public mailing lists where members have contributed in the past 12 months

You could start to build from the script used for

http://www.infodisiac.com/Wikipedia/ScanMail/_PowerPosters.html

 

Cheers,

Erik

 

From: analytics-bounces@lists.wikimedia.org [mailto:analytics-bounces@lists.wikimedia.org] On Behalf Of ENWP Pine
Sent: Sunday, May 25, 2014 9:16
To: analytics@lists.wikimedia.org
Subject: [Analytics] Cohort analysis

 

Hi Analytics,

I'm looking for a way to do a cohort analysis for a presentation that I'm drafting.

I want a report that shows:
* A list of languages showing the users who speak each language as identified on their user pages
* A list of projects where users have made at least 5 edits in the past 12 months
* A list of group members that have administrator rights and which wikis are involved
* A list of public mailing lists where members have contributed in the past 12 months
* Number of public emails on those mailing lists in the past 12 months
* Total edits made by the cohort
* Total bytes changed by the cohort
* Total logged-in time for the cohort, if log-in time aggregation is being done

What automated tools could I use to create this report?

Are there any significant editor productivity metrics that are missing from this list?

Thanks,

Pine