Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. If you continue browsing the site, you agree to the use of cookies on this website. See our User Agreement and Privacy Policy.

Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. If you continue browsing the site, you agree to the use of cookies on this website. See our Privacy Policy and User Agreement for details.

Open Source Community Metrics LibreOffice Conference

Open Source Community Metrics: Tips and Techniques for Measuring Participation

Do you know what people are really doing in your open source project? Having good community data and metrics for your open source project is a great way to understand what works and what needs improvement over time, and metrics can also be a nice way to highlight contributions from key project members. This session will focus on tips and techniques for collecting and analyzing metrics from tools commonly used by open source projects. It's like people watching, but with data.

2.
Stuff Ill Talk About ● What, why and example metrics ● Coming up with the right metrics ● Tips and techniques for collecting metrics ● Sharing metrics and highlighting community members Photo: http://www.flickr.com/photos/falcifer/3136673599 2

3.
Community Definition ● Community includes all of the people who work on the project ● Product contributors: developers, release managers, quality assurance, localization, etc. ● Other developers: writing applications, modules, extensions, etc. ● Users: people who run your software and provide feedback ● Vendors: companies with products / services based on your project ● Other contributors: promotion, moderation, documentation and more Some people contribute as part of their employment at companies, while others contribute free time. The community includes all of the people who are working on your project. 3

4.
Metrics are Useful for Open Source Projects ● Measure progress in your community over time ● Who contributes ● Where are people contributing ● Spot trends ● Gauge interest ● Learn more about key contributors ● Recognize contributions 4

5.
Example: Components of an Open Source Community 5 http://www.flickr.com/photos/korou/2586472234

8.
What are the Right Metrics for YOUR Project ● Goals ● What are your overall goals for the project? ● How can you measure progress toward those goals? ● What is important to you and your progress? ● Trends ● What should you measure to recognize trends? ● How do you recognize when something is going wrong? ● Do you notice big improvements? Note: I measure way too much 8 http://www.flickr.com/photos/bandfan/5548675317/

9.
Mailing Lists: mlstats Mailing List Stats is a command line tool used to analyze mailing list archives. It downloads the archives, places them in a directory and stores all the information contained in each mailing list post into a database http://libresoft.es/tools/mlstats 9

10.
Mailing Lists: mlstats for LibreOffice Developer List● Grab data from your mailing & store in db (repeat per ML) – mlstats --db-user=root --db-password= http://lists.freedesktop.org/archives/libreoffice/● Top Content Query: All or By Month – select subject, count(*) as c from messages group by subject order by c; – select subject,monthname(first_date) as m, year(first_date) as y, count(*) as c from messages group by subject, month(first_date) order by y, m, c;● Top Poster Query – select p.email_address,count(*) as c from messages as m,messages_people as p where m.message_id=p.message_ID group by p.email_address order by c; 10