[GCP - XXX] OSO-Gitcoin Collaboration for Advancing Data Infrastructure and GTM Analytics

Summary

This GCP proposes to fund tighter integration and ongoing use of analytics from Open Source Observer (OSO) to track cohorts of grantees before, during, and after they receive funding from grant programs on Grants Stack. We aim to enhance data infrastructure and develop advanced metrics to improve the grants experience and Gitcoin’s go-to-market strategy.

For this, we are requesting a total of $15K GTC from the Gitcoin treasury, equivalent to $2500/mo over 6 months.

Abstract

Open Source Observer (OSO) analytics provides critical insights into grantee impact by capturing data on open source developer activity. This integration will enable more objective impact scoring, efficient fund tracking, and granular post-funding analysis of grantee performance.

There are two primary components:

  • Infrastructure: Tighter integration and collaboration on improving grants data. Gitcoin would benefit from stronger data infrastructure, but should also keep its team lean and focused on growing GMV. OSO’s model of maintaining public datasets and public ETL infrastructure can reduce Gitcoin’s maintenance burden while opening up additional pathways for the analyst / data science community to work on top of Gitcoin data.

  • Data-driven GTM: Development of more advanced metrics to improve the grants experience and go-to-market. In addition to using more data to screen projects and provide impact metrics on Grants Explorer, there is a backlog of data science work the two organizations would like to pursue together. This includes co-developing new measures of builder quality, project momentum, and round success. Gitcoin wants to use data to improve its GTM strategy, help Round Operators configure their grants programs, and show ROI to funders.

Motivation

The Gitcoin ecosystem requires transparent, data-driven insights into funded projects’ impact. Current challenges include:

  • Maintenance of ETL infrastructure
  • Lack of automated data collection for grantee performance
  • Difficulting joining Gitcoin data on other relevant datasets
  • Need for more objective impact metrics, especially back to funders
  • Limited visibility into post-funding outcomes
  • Difficulty in demonstrating ROI and effectiveness of different allocation strategies

Previously, OSO data demonstrated the impact of Gitcoin Grants on open source developer activity. Snapshots of OSO data have been integrated into the application sign-up and screening. Gitcoin also uses OSO’s free API to surface “impact stats” for OSS projects on Grants Explorer. At the same time, Gitcoin and OSO have worked closely in a variety of other contexts, including the Cartographers Syndicate, Optimism Retro Funding, and the Sunny Awards. OSO also maintains raw and indexed Gitcoin data in its public data warehouse.

By expanding this collaboration, we can provide high-resolution analytics for grant operators and program managers using Gitcoin Grants Stack, improving accountability and attracting new ecosystems to the platform.

This collaboration will result in:

  • A single source of truth for Gitcoin project data that’s easy to join on other datasets
  • More automated tracking of developer activity
  • Standardized impact metrics across the grants lifecycle
  • Continuous monitoring of funded projects and cohort-based analysis
  • Data-driven insights for program and GTM optimization

Specifications

Work Components

Infrastructure

Existing Infrastructure:

  • Allo Indexer and RegenData.xyz as ETL and data warehouse for Gitcoin data
  • Regular updates to OSO’s OSS Directory of projects in each Gitcoin grants round
  • Gitcoin’s existing backend infrastructure for serving grant and funder data to users
  • OSO’s project-artifact registration and mapping system, and events indexer for monitoring code contributions and blockchain transactions related to projects
  • OSO’s free API and BigQuery access to metrics (plus easy integration with other public datasets)

New Development:

  1. Alignment on ETL standards
  • Identify the critical data marts to serve business needs
  • Ingest and warehouse the necessary (raw) source data, e.g., from Allo Indexer
  • Implement schemas for processing and normalizing the data
  1. Tighter integration and single (public) source of truth for grants data
  • Implement consistent project, round, and donor namespacing
  • Create automated updates for projects from Grants Stack applications
  • Ensure data synchronization and latency requirements are met

Data-driven GTM

  1. Develop advanced analytics and GTM
  • Design v1 “builder quality” and momentum metrics
  • Create cohort analysis models for different rounds and categories of projects
  • Use metrics to power public dashboards and internal tools, addressing key questions like:
    1. How has grantee impact evolved before and after receiving funding?
    2. How do impacts compare across different rounds?
    3. Predict future impact using historical data to identify high-potential grantees.
    4. Analyze trends across rounds to refine future funding strategies.
  • Collaborate on GTM value proposition and round success metrics

Milestones & Timeline

Phase Task Date
Phase I Alignment on ETL standards Month 1
Phase II Tighter integration and single (public) source of truth for grants data Month 2-3
Phase III Develop advanced analytics and GTM Month 4-6

Budget Breakdown

Total Request: $15K GTC ($2500/month for 6 months).

This effectively covers a portion of time spent by the OSO data & engineering teams. It does not cover any of the infrastructure costs, which will continue to be borne by each organization on its own. There is strong potential for a win-win here, so this GCP provides a springboard for additional work between Gitcoin and OSO in the future.

Note: There may be additional data requirements around metrics and reporting that come from partners and will be budgeted & scoped directly with those partners.

Success Measures

  1. Infrastructure
  • Source data is cleaned up and harmonized
  • All active OSS projects are indexed; relevant metrics available on Gitcoin
  • Ongoing data coverage and latency requirements are met
  1. Analytics implementation
  • Release of v1 of builder quality and momentum models
  • Builder metrics integrated at the application stage and on grants explorer
  • Longitudinal analysis of grant cohorts by round and type of project
  1. Adoption
  • Number of round operators using the analytics
  • User engagement with dashboards on Gitcoin website
  • Use of raw data in data warehouse and via the OSO API

Benefits

  1. Reduced data infra burden for Gitcoin
  2. Enhanced decision making for round operators and donors
  3. Improved transparency and accountability to funders
  4. High quality and up-and-coming projects receive more funding
  5. Ecosystem growth and better ROI

Drawbacks & Considerations

  1. Legacy data migration (eg, from cGrants, Allo v1)
  2. Integration complexity with existing systems
  3. Standardization / “hardening” of schemas
  4. Data quality maintenance and pipeline upkeep
  5. Finding robust metrics that are resistant to gamification

Out of Scope

The following items are not included in this proposal:

  • Impact metrics beyond open source developer activity
  • Custom visualizations for specific grant programs
  • Data entry for onboarding new ecosystems
  • Deep dives / additional data science work
8 Likes

Bullish. OSO has done amazing work pushing forward the grants and impact measurement space. I’m excited to have your expertise more available to us at Gitcoin and to work with familiar faces like @rohit and @ccerv1

3 Likes

I’m in favor of this proposal as I believe this investment will enhance our data infrastructure and metrics capabilities. The team at OSO are proven and longtime partners to Gitcoin.

LFG!

2 Likes

I have a COI so will be abstaining from this GCP, but obviously think there is a huge win-win here. Happy to help clarify anything from the original post too.

1 Like

I’m in favor of this proposal and am grateful for the collaboration with the OSO team!

2 Likes

I support this proposal. I can’t speak to the finer points of the proposed infrastructure changes, but in general I’m very excited to see what we can do with easier access to data about impact.

2 Likes

I support this proposal. Seems like a big value add!

2 Likes

In massive support of this proposal! Love seeing this work coming to life.

1 Like

And just as an FYI, GCP’s are now bucketed under the Citizens Grants program. You can find out more about the new process here: Citizen Grants Program Updated Strategy - #12 by MathildaDV

I will also be updating everyone on next steps once a decision is made.

1 Like

Support this proposal, thanks for thinking through the details. Excited to see this data come to life.

1 Like

This proposal has passed by a majority vote through our internal GCP council. I will be in touch with this team directly for next steps!

1 Like

Highly in favor. I’m seeing a strong need for the alignment of data standards for the ETL portion of this. We are even seeing this with attempts to do it using attestations. Their is budding fragmentation that Gitcoin could potentially head off for the betterment of the web 3 ecosystem as a whole.

3 Likes