# Get all PRs authored AND reviewed by the engineer across all relevant repos in one query
# Adjust repos based on engineer's team (see Team-to-Repo Mapping below)
GH_HOST=github.plaid.com gh api graphql -f query='
{
  authored: search(
    query: "author:{username} is:pr is:merged merged:2025-01-01..2025-12-31"
    type: ISSUE
    first: 100
  ) {
    issueCount
    pageInfo {
      hasNextPage
      endCursor
    }
    edges {
      node {
        ... on PullRequest {
          number
          title
          createdAt
          mergedAt
          additions
          deletions
          changedFiles
          repository {
            name
          }
        }
      }
    }
  }
  reviewed: search(
    query: "reviewed-by:{username} is:pr is:merged merged:2025-01-01..2025-12-31"
    type: ISSUE
    first: 1
  ) {
    issueCount
  }
}
'

# For subsequent pages
GH_HOST=github.plaid.com gh api graphql -f query='
{
  authored: search(
    query: "author:{username} is:pr is:merged merged:2025-01-01..2025-12-31"
    type: ISSUE
    first: 100
    after: "{endCursor_from_previous_page}"
  ) {
    # same fields as above
  }
}
'

# Developer Productivity Analysis: {Full Name}

**Analysis Period:** January 2025 - January 2026
**Tenure Period:** {start_date} - January 2026 ({X} months) ← USE THIS FOR AVERAGES
**Data Source:** GitHub Enterprise API
**Generated:** {date}
**GitHub Username:** {username}

---

## Executive Summary

| Metric | Value |
|--------|-------|
| **Start Date** | {start_date} |
| **Tenure** | {X} months |
| **Total PRs Authored** | {count} |
| **Total PRs Reviewed** | {review_count} |
| **Total Lines Added** | {loc_added} |
| **Total Lines Deleted** | {loc_deleted} |
| **Net Lines of Code** | +{net_loc} |
| **Average PRs/month** | {avg} ← CALCULATE FROM TENURE, NOT 13 MONTHS |
| **Average LOC/PR** | {avg_loc} |
| **Review Ratio** | {reviews/authored} |
| **Peak PR month** | {month} ({count} PRs) |
| **Peak LOC month** | {month} ({loc} lines) |

---

## Monthly Metrics

| Month | PRs | LOC Added | LOC Deleted | Net LOC | Complexity |
|-------|-----|-----------|-------------|---------|------------|
| Jan '25 | X | Y | Z | +N | 2.X |
...

---

## PR Count Trend (Visual) - WITH PROJECT ANNOTATIONS

**REQUIRED ANNOTATIONS:**
- Label each spike with the project/initiative that drove it
- Note gaps and explain (vacation, training, blocked, etc.)
- Mark onboarding period for new hires
- Indicate delivery milestones

---

## Lines of Code Trend (Visual) - WITH PROJECT ANNOTATIONS

**CRITICAL:** Every row should have a Project/Initiative annotation explaining what drove that month's output. This is essential context for calibration.

### How to Identify Projects for Annotations

1. **Group PRs by title patterns** - Look for common prefixes or keywords
2. **Check Work Categories section** - Map categories to months
3. **Use PR titles** - Extract project names from PR titles
4. **Cross-reference with peer feedback** - Peers often mention specific projects
5. **Ask Unblocked** - Query for "{engineer} projects {month} 2025"

---

## Repository Breakdown

| Repository | PRs | % of Total | LOC Added | LOC Deleted | Net LOC |
|------------|-----|------------|-----------|-------------|---------|
| go         | X   | Y%         | Z         | A           | +B      |
...

---

## Work Categories

Analyze PR titles to categorize work:
- Feature development
- Bug fixes
- Infrastructure/tooling
- KTLO/maintenance
- Testing
- Documentation

---

## PR Size Distribution

| Size | LOC Range | Count | % |
|------|-----------|-------|---|
| XS   | <50       | X     | Y% |
| S    | 50-200    | X     | Y% |
| M    | 200-500   | X     | Y% |
| L    | 500-1000  | X     | Y% |
| XL   | >1000     | X     | Y% |

---

## Key Projects & Impact

Use Unblocked to enrich with project context:
1. {Project 1}: {description of contribution and impact}
2. {Project 2}: {description of contribution and impact}

---

## Key Observations

### Strengths
1. ...
2. ...

### Patterns
- Q1 2025: ...
- Q2 2025: ...
- Q3 2025: ...
- Q4 2025: ...

### Areas for Discussion
- ...

---

## DORA/Productivity Metrics (if available)

| Metric | Value | Interpretation |
|--------|-------|----------------|
| **Output Consistency Score** | X% | variance analysis |
| **Monthly Velocity** | X LOC/month | relative to peers |
| **PR Frequency** | X PRs/month | cadence assessment |
| **Average PR Size** | X LOC | reviewability |

---

## Calibration Notes

**Pre-calibrated Rating:** {if known}
**Productivity Data Supports:** {assessment based on data}
**Flags for Discussion:** {any concerns or discrepancies}

---

*Analysis generated by Claude Code using GitHub Enterprise API data and Unblocked context.*