PR cycle time report

Q: What is a good PR cycle time?

High-performing teams keep median PR cycle time under 24 hours from open to merge. Going much above 3 days usually signals review-process problems — too few reviewers, too-large PRs, or no on-call ownership.

Weekly automated PR cycle time report. AI surfaces median time-to-merge, stale PRs, and the bottlenecks slowing your engineering team.

Use this template How automations work

Runs weekly Scheduled Delivered to Slack, Email

PR cycle time report

Active

Trigger

Runs weekly

Instructions

Generate a weekly PR cycle time report.

Delivery

Slack · Email

Example output

A realistic sample of what this automation delivers — your version draws on your data.

PR cycle time report Runs weekly · Sent to Slack, Email

Sample output

Median cycle time, last 8 weeks hours

Open → merge Open → first review

Median PR cycle time: 19 hours (down from 24 last week). Lead time to deploy: 31 hours.

Open → first review: 5h (target <6h) ✓
First review → merge: 9h (target <12h) ✓
Merge → production: 5h (target <8h) ✓

Stale PRs (open 5+ days)

#4912 “Refactor source picker” — owner @amelia, last activity 7 days ago. Three reviewers tagged, none responded.
#4880 “Allow workspace-level theme override” — owner @sam, blocked on design review.

Slowest reviewing team. Platform team has a median first-review time of 14 hours (vs. 5 across the org). Worth a quick sync.

The prompt

Copy, paste, customize.

Drop this into a Basedash automation. AI fills in the numbers from every source you've connected.

Instructions

Generate a weekly PR cycle time report.

For PRs merged in the past 7 days, compute:

**Cycle time.** Median time from PR open → merge. Compare to last week and 90-day baseline.

**Review latency.** Median time from "ready for review" → first reviewer comment.

**PR size.** Median additions + deletions per PR.

**Stale PRs.** PRs open > 5 business days. Name them.

**By team / repo.** Same metrics broken down.

Close with the team or repo most worth investigating.

Data sources