gitcoinco / gitcoinco/web

Determining relation between Bounties & Grants v2

Open
#10,222 1 comment 0 reactions 1 assignee Claimed by @gdixon View on GitHub
Dominant language
JavaScript
Stars
1.8k
Forks
776
PR merge metrics
No merged PRs in 30d

Description

**User Story:**
As a PM at Gitcoin
I want to see if there is a flywheel effect for bounties and grants
So that i can make better product decisions

**Acceptance Criteria**

**Bounty Builder --> Grant Funder:**
GIVEN I have access to Metabase
WHEN I looked at queries in Metabase
THEN I expect to see a query that has the following:
- Profiles with 1+ bounty completed AND funded 1+ grant
- Count of bounties completed + dollars earned through bounties
- Count of Grants + Dollars funded through Grants
- Parsing of which came first - bounty or grant

**Bounty Funder --> Grant Owner:**
GIVEN I have access to Metabase
WHEN I looked at queries in Metabase
THEN I expect to see a query that has the following:
- Profiles with 1+ bounty funded AND has received funds in 1+ grant
- Count of bounties funded + dollars funded through bounties
- Count of Grants + Dollars earned through Grants
- Parsing of which came first - bounty or grant

**Bounty Funder --> Grant Funder:**
GIVEN I have access to Metabase
WHEN I looked at queries in Metabase
THEN I expect to see a query that has the following:
- Profiles with 1+ bounty funded AND has received funds in 1+ grant
- Count of bounties funded + dollars funded through bounties
- Count of Grants + Dollars funded through Grants
- Parsing of which came first - bounty or grant

**Notes:**
![image](https://user-images.githubusercontent.com/95642312/156260770-e1a1d5d5-9df4-4960-9b8d-bf96f86f8a55.png)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.