A little late to the reply here but I'm a volunteer for openlibrary.org and I think they'd benefit from trying some of these things so I might share it with you.
What tool are you using to make the age reports?
How do you determine if it's waiting on the submitter or the reviewer? Is it based on last comment? or requesting a review, etc?
There once was a tool similar to this that github bought and it was quite nice even for a small internal team but I'd really like to know what works well at your scale.
We use our open source project Steampipe [1] to query data using the GitHub plugin [2] and mods [3]. We have also opened up the custom mod we built for the specific charts & reports [4].
I hope they help - let us know if you give them a try!
So there is GitHub Scheduled Reminders: https://docs.github.com/en/organizations/managing-organizati... , which has some serious limitations it seems (GitHub will only trigger reminders for up to five repositories per owner and 20 pull requests per repository. Reminders are not sent when changes are merged from upstream into a fork.).
What tool are you using to make the age reports? How do you determine if it's waiting on the submitter or the reviewer? Is it based on last comment? or requesting a review, etc?
There once was a tool similar to this that github bought and it was quite nice even for a small internal team but I'd really like to know what works well at your scale.
Cheers!