ANA-005 recommended Git Analytics

Engineering/git analytics visibility

Visibility into PR activity, cycle time, and contributor metrics. Can answer "What's our average PR cycle time?" and "Who are top contributors?"

Question to ask

"Are your DORA metrics getting better or worse?"

What to check

  • Look for dedicated git analytics tools (LinearB, Sleuth, Swarmia)
  • Check for custom engineering metrics in warehouse
  • Look for DORA metrics tracking
  • Verify ability to track trends over time (not just GitHub Insights)

Verification guide

Severity: Optional

Track PR activity, commit patterns, and contributor metrics to understand engineering health and velocity.

Check automatically:

  1. Check for dedicated git analytics tools:
# Engineering analytics platforms
grep -riE "linearb|sleuth|swarmia|gitprime|pluralsight.*flow|jellyfish|faros|haystack" . 2>/dev/null | grep -v node_modules | head -5
  1. Check for custom engineering metrics:
# Custom PR/commit metrics tracking
grep -riE "pr.*metrics|commit.*metrics|cycle.time|lead.time|deployment.frequency|dora.*metrics" --include="*.ts" --include="*.js" --include="*.py" --include="*.sql" --include="*.sqlx" . 2>/dev/null | grep -v node_modules | head -10

# Engineering dashboards
grep -riE "engineering.*dashboard|developer.*metrics|team.*velocity" . 2>/dev/null | grep -v node_modules | head -5
  1. Check if GitHub data exists in warehouse (from ANA-003):
# GitHub-related tables in Dataform/dbt
grep -riE "github|pull_request|commit" definitions/*.sqlx models/*.sql 2>/dev/null | head -10

If not found in code, ask user:

  • "How do you track PR throughput and cycle time?"
  • "Do you have visibility into who's contributing and how often?"
  • "Can you answer: 'What's our average time from PR open to merge?'"

Cross-reference with:

  • ANA-003 (GitHub data in warehouse enables custom analytics)
  • ANA-004 (dashboards for visualizing git metrics)

Pass criteria:

  • Can answer: "What's our average PR cycle time?"
  • Can answer: "Who are the top contributors this month?"
  • Some form of engineering metrics visibility (dedicated tool OR custom dashboard)

Fail criteria:

  • No visibility into PR activity beyond GitHub's basic Insights tab
  • No way to track engineering trends over time
  • No answer to "how long do PRs take to merge?"

Partial (acceptable):

  • Using GitHub Insights only - provides some visibility but limited customization
  • Manual tracking (spreadsheet) - better than nothing but not scalable

Recommendations:

  • If you have ANA-003 (GitHub → warehouse): Build custom dashboards in Metabase
  • If you want turnkey: LinearB, Sleuth, or Swarmia
  • DORA metrics (deployment frequency, lead time, MTTR, change failure rate) as north star

Evidence to capture:

  • Tool or method used for git analytics
  • Sample metrics available (cycle time, throughput, etc.)
  • Dashboard URL or screenshot

Section

18. Analytics

Performance & Analytics