# Github: Weekly Metrics

## Description

* Summary numbers for issues and pull requests by week

## Supported Data Sources

* <img src="https://fivetran.com/integrations/github/resources/github.svg" alt="" data-size="line"> GitHub

## Columns

| Type     | Name                                | Description                                                                       |
| -------- | ----------------------------------- | --------------------------------------------------------------------------------- |
| DATETIME | week                                | The reporting week                                                                |
| STRING   | repository                          | The name of the repository                                                        |
| INTEGER  | number\_issues\_opened              | The total number of issues created during this time period                        |
| INTEGER  | number\_issues\_closed              | The total number of issues closed during this time period                         |
| DECIMAL  | avg\_days\_issue\_open              | The average number of days an issue opened during this time period was open       |
| DECIMAL  | longest\_days\_issue\_open          | The longest number of days an issue opened during this time period was open       |
| INTEGER  | number\_prs\_opened                 | The total number of pull requests created during this time period                 |
| INTEGER  | number\_prs\_merged                 | The total number of pull requests merged during this time period                  |
| INTEGER  | number\_prs\_closed\_without\_merge | The total number of pull requests closed without a merge during this time period  |
| DECIMAL  | avg\_days\_pr\_open                 | The average number of days a pull request opened during this time period was open |
| DECIMAL  | longest\_days\_pr\_open             | The longest number of days a pull request opened during this time period was open |
