Development Metrics
Development metrics focus on the time spent in different phases of the development process, helping teams understand and optimize their development workflow.Available Metrics
string
Time spent coding (from first commit to PR open)
string
Median coding time, in seconds. No aggregation parameter. Response column:
coding_time_p50.string
75th-percentile coding time, in seconds. No aggregation parameter. Response column:
coding_time_p75.string
Time between PR open and first review
string
Median pickup time, in seconds. No aggregation parameter. Response column:
pickup_time_p50.string
75th-percentile pickup time, in seconds. No aggregation parameter. Response column:
pickup_time_p75.string
Time from first commit to PR open
string
Time between PR open and first review
string
Time between first review and merge
string
Total time spent in the review phase
string
Median review time, in seconds. No aggregation parameter. Response column:
review_time_p50.string
75th-percentile review time, in seconds. No aggregation parameter. Response column:
review_time_p75.string
Time spent on rework after a review
string
Full cycle time from first commit to merge
string
Time from PR open to the first comment
string
Percentage of PRs that required rework after review
Cycle Time Metric
This example demonstrates how to retrieve the cycle time metric, which measures the full development cycle from initial commit to merge.Review Time Metric
This example demonstrates how to retrieve the review time metric, which measures the total time spent in the review phase.Parameter Notes
string
Development metrics read from the
pull_requests table. Available date fields:pr_merged_at: When the PR was merged (default, recommended for cycle time)pr_created_at: When the PR was createdpr_closed_at: When the PR was closedfirst_commit_at,last_commit_at: First and last commit on the PRfirst_review_at: When the PR received its first reviewfirst_comment_at: When the PR received its first comment
string
Required for all development time metrics except the fixed-percentile ones. Accepted values:
SUM, MAX, MIN, AVG. rework-rate is a ratio and takes none; coding-time-p50, coding-time-p75, pickup-time-p50, pickup-time-p75, review-time-p50 and review-time-p75 are fixed percentiles and take none either.
Response columns are {agg}_coding_time, {agg}_pickup_time, {agg}_commit_to_open, {agg}_open_to_review, {agg}_review_to_merge, {agg}_review_time, {agg}_rework, {agg}_cycle_time, {agg}_time_to_first_comment (all in seconds), rework_rate, and coding_time_p50, coding_time_p75, pickup_time_p50, pickup_time_p75, review_time_p50, review_time_p75 (seconds) for the percentile metrics.object
Applicable filters for development metrics:
repositories: Array of{"repository_name": "..."}objectsmember: Filter by author merged user IDsteam: Filter by team IDssquad_ids: Filter by squad IDssquad_levels: Filter by squad hierarchy levelmanager_ids: Filter by manager user IDsdepartments: Filter by department namessources: VCS source —github,gitlab,bitbucketpr_states: PR states —open,closed,mergedpr_categories: PR category classificationspr_ids: Filter by specific PR IDspull_requests_search_term: Full-text search across PR fieldslocations: Filter by employee locationlevels: Filter by employee level
Common Use Cases
- Track Cycle Time Trends: Monitor how development cycle time changes over time
- Identify Bottlenecks: Find which part of the development process takes the longest
- Compare Team Performance: Compare cycle times across different teams or repositories
- Set Performance Goals: Establish baseline metrics and set improvement goals

