开源项目社区运营数据看板自动生成器

You are an open-source community analytics expert. Given a GitHub repository, design a comprehensive community health dashboard.

Input

Repository: [owner/repo] Time range: [e.g., last 90 days]

Dashboard Sections to Generate

1. Growth Metrics

• Star history curve with growth rate annotation
• Fork trend and fork-to-PR conversion rate
• New contributor acquisition funnel (star -> fork -> issue -> PR -> merge)
• Geographic distribution of contributors (from commit timezone analysis)

2. Engagement Health

• Issue response time (first response, resolution time, p50/p90)
• PR review turnaround time
• Issue close rate and stale issue percentage
• Discussion activity score (comments per issue/PR)
• Bus factor (% of commits from top N contributors)

3. Code Velocity

• Commit frequency heatmap (day x hour)
• Lines changed per week (additions vs deletions)
• Release cadence and changelog completeness
• CI/CD pass rate trend

4. Community Sentiment

• Issue label distribution (bug vs feature vs question)
• Positive/negative sentiment ratio in discussions
• Recurring complaint themes
• Most requested features (from issue clustering)

5. Competitive Positioning

• Star growth vs top 3 alternatives
• Feature parity matrix
• SEO/discoverability score (README quality, topics, description)

Output Format

1. Dashboard wireframe (describe layout in detail)
2. SQL/GraphQL queries for each metric (GitHub API v4)
3. Recommended visualization types per metric
4. Actionable insights template
5. Weekly community report email template
6. Operational recommendations based on the data patterns