Bitbucket Cloud: How to Get Pull Request Metrics for Muliple Repos or at Project Level

[Tara Lynch]

We want to create Grafana dashboards with delivery metrics at a project / team level. We currently have the metrics at a repo level but want aggregate data at a team or project level. The metrics are pretty standard (examples below).

• Open Pull Requests
• Average Time to Merge
• Number of new pull requests/week
• Average lines changed

Has anyone done this? 

[AOT-Administrator]

Hi @Tara Lynch we'd like to do the same thing and I ran across your question.  i want to pull Bitbucket events, including PRs, commits, and deploys (via bitbucket pipeline) into Grafana Cloud.

Did you ever get this sorted out?

Thanks

[Tara Lynch]

Hi, @AOT-Administrator We did end up figuring this out by extending the API. We are putting the data in tables in PostgreSQL and then use Tableau to analyze the data and create dashboards. I'm going to have the engineer who did the hard work pop on and explain what he did. We also created a custom script to grab the data from PostgreSQL and put in a time series DB for Grafana.

[AOT-Administrator]

That would be great, thanks so much @Tara Lynch 

I'm currently looking into Webhook Relay for this use case as well to ingest, transform, and forward webhook events.

[Anuradha Wishmantha]

"We currently have the metrics at a repo level"

Do you use Prometheus as the source?