This repo contains scripts for gathering GitHub API data pertaining to Code.gov and federal government repositories. These engagement metrics in code-gov-repo-metrics and government-wide-repo-metrics are slightly different but generally include forks, starts, watchers, and issues per repository. Furthermore, the process to run the metrics is different with specific instructions per type of metric included here.

To obtain code-gov-repo-metrics and government-wide-repo-metrics, begin by cloning the repo.

git clone https://github.com/GSA/code-gov-github-metrics.git

This folder compiles GitHub metrics across the different repos that make up Code.gov.

This portion of the project uses the GitHub GraphQL API v4.

After cloning the entire repo, move into the repo's directory and folder and install the NPM dependencies.

cd code-gov-github-metrics/code-gov-repo-metrics
npm install

Next, create a .env file based on the template.

cp .env.example .env

Now, create a GitHub Personal Access Token. You should only need to enable the "repo" scope (the first checkbox) when creating your token. Once you have your token, insert it into the newly created .env file, replacing <INSERT YOUR PERSONAL ACCESS TOKEN HERE>. Don't include curved brackets (<>), spaces (" "), or quotes ("") in the .env file!

The main script will query the GitHub repositories specified in config.json. In this file, owner refers to the GitHub organization that owns the repositories (in this case, GSA) and repoList is the list of repositories to include in the report. This script should be reusable for different organizations/repositories by changing config.json accordingly.

To generate a report, run the following command.

npm run start <START OF TIME PERIOD TO QUERY> <END OF TIME PERIOD TO QUERY>

The two command line arguments are the start date and end date of the specific time period for generating the data. Both dates should be in the format YYYY-MM-DD. The script will convert these dates to Date objects that correspond to midnight GMT on those days. If you fail to specify dates or specify invalid dates, the script should let you know. For example, the following command would generate a report for December 2018:

npm run start 2018-12-01 2018-12-31

Running this script will create a .csv file report in the reports folder with the name <CURRENT DATE> | <START OF TIME PERIOD TO QUERY> -> <END OF TIME PERIOD TO QUERY>.csv. For instance, if you ran the script on July 9, 2019 to query data about the month of June 2019 (6/1/2019 - 7/1/2019), the report file name would be 2019-7-9 | 2019-6-1 -> 2019-7-1.csv.

Note: An .xls version is provided for reference (see example_report_2020-5-2 | 2020-4-1 -> 2020-4-30.xls). Normal naming convention would exclude example_report_.

The report contains a number of metrics about the repositories for all time and for the specified time period. The definitions of these metrics can be found in DATASCHEMA.

For the Code.gov team, reports should be run monthly on a regular schedule to keep track of these metrics over time. These reports should be uploaded to the GitHub Metrics Google Sheet in the Code.gov team drive. To upload a new report:

• In the Google Sheet, click on File > Import
• Click Upload
• Select the report that was just generated
• Choose Insert new sheet(s) as Import location
• Copy the last line of the report into a new line in the Data Over Time sheet
• Change TOTAL to the month the report was generated for (e.g. June 2019)

After following these steps, the report will be saved in Google Sheets (which is important because the reports are included in the .gitignore and therefore not committed to GitHub). The new data will also be automatically added to the visualizations in the corresponding sheets.

This folder compiles GitHub metrics across all known federal government repos. The most current list of organizations is maintained by the GitHub Government team.

This portion of the project uses the GitHub API v3.

After cloning the entire repo, move into the repo's directory and folder and install the NPM dependencies:

cd code-gov-github-metrics/government-wide-repo-metrics
npm install

Next, create a .env file based on the template.

cp .env.example .env

Now, create a GitHub Personal Access Token. You may already have this token if you ran the code-gov-repo-metrics. Insert your token into the newly created .env file, replacing <INSERT YOUR PERSONAL ACCESS TOKEN HERE>. Don't include any angle brackets (<>), spaces (" "), or quotes ("") in the .env file! (Note: You could copy your .env file to use with either metrics folder.)

The main script will query all GitHub repositories specified in agencies-full.json. In this file, each agency is listed with associated organizations on GitHub. In most cases, agencies have multiple GitHub organizations with numerous repositories.

To generate a new report, run the following command.

node index.js

Note: To see an output of the API to the terminal as the script is running, run the following command in lieu of the one immediately above.

node index.js debug

Running this script will create a .csv file titled 'current-date.csv' and will be located in the exports folder.

The report contains a number of metrics about the repositories and definitions of these metrics and can be found in index.js.

Go to the local file directory (e.g., finder on Mac, explore on Windows) to obtain the CSV file outside your code editor.

See CONTRIBUTING

See LICENSE

If you have questions, please feel free to contact us:

• Open an issue
• LinkedIn
• Twitter
• Email
• Join our #opensource-public channel on Slack: https://chat.18f.gov/