[Impact Metric Submission]: Number of Unique Contributors per Project (Monthly, using 'GITHUB' source)

[nutkung1]

Number of Unique Contributors per Project (Monthly, using 'GITHUB' source)

Tags

Add one or more keywords to help us categorize your metric. Don't overthink this!

• Optimism Superchain
• Community Engagement
• Developer Activity

Brief description

Describe how your impact metric is calculated in 2-3 sentences: This metric identifies projects with a larger pool of contributors on GitHub, potentially indicating broader community interest. It calculates the number of unique addresses that forked the project on GitHub

SQL code block

Insert the SQL that we should run to replicate your impact metric:

SELECT
  project_id,
  bucket_month,
  COUNT(DISTINCT from_address) AS unique_github_contributors
FROM `opensource-observer.oso.events_monthly_to_project_by_source`
WHERE event_type = 'FORKED'
  AND from_namespace = 'GITHUB'
GROUP BY project_id, bucket_month
ORDER BY project_id, bucket_month;

Optional: link

Add a link to script/notebook or longer form write-up about the metric: