Every year, I need to compile metrics regarding OpenRefine community, either for presentation or grant submission. Every year, I have to go back and check what I did and how I got those number. This year will be the last. Here are the metrics I track, and how I compile them.
 |
| Slide from a presentation from August 2020 |
Metrics
1. Number of downloads per release
The following curl command returns the stats for each package. To know the total download for a release you need to add the windows, mac and linux package.
curl -i https://api.github.com/repos/openrefine/openrefine/releases -H "Accept: application/vnd.github.manifold-preview+json"
Now that OpenRefine documentation is also hosted in the same repo the count includes code contributor, translator and edit to OpenRefine documentation.
From this URL, update the start and end date of your period of analysis in the URL: https://github.com/OpenRefine/OpenRefine/graphs/contributors?from=2021-01-01&to=2022-01-01&type=c
In your browser do ctrl +F and search using the keyword commit. Subtract 4 to that result (excluding dependabot)
3. Number of Pull Requests and Issues
First search all all the PR here https://github.com/OpenRefine/OpenRefine/pulls using
is:pr created:>2021-01-01
Then count how many are from dependabot so we can subtract them.
is:pr created:>2021-01-01 involves:dependabot
Do the same things from the Issue tab.
Note that I was not able to do a time period using GitHub search parameters, so it is county everything up to today.
4. Number of stars and forks on GitHub
From this page https://github.com/OpenRefine/OpenRefine
5. Number of users on the mailing list
search parameters from the discussion home page: https://groups.google.com/g/openrefine/