nicholas 🧨
@nicholas
@kenny could we put do a @poidh to get a query that outputs all contributors to a given project on Gitcoin? There's currently no UI to learn who donated to my project, although i'm told it's on Gitcoin's roadmap https://explorer.publicgoods.network/address/0x98720dD1925d34a2453ebC1F91C9d48E7e89ec29?tab=contract
2 replies
0 recast
2 reactions
@
0 reply
0 recast
0 reaction
@
0 reply
0 recast
0 reaction
yesyes
@yesyes
Sure! i have played with gitcoin data before but it's been a while. @nicholas could you detail exactly what you are looking for? Enter a particular project's address and get a list of all the address that donated to the particular project(probably sorted by the amount donated) ?
1 reply
0 recast
0 reaction
nicholas 🧨
@nicholas
Yes! Enter project ID Get list of donors, how much they donated, and in which round. ENS labels a plus. ideally works on all chains where gitcoin accepts donations, but PGN is the priority. I’ll put in $50 too
2 replies
0 recast
0 reaction
yesyes
@yesyes
Okay so - There are currently three ways to get the PGN data - using the explorer api, using covalent and building a subgraph using goldsky. I used Covalent to get the list of all your donors plus how much they donated. Using other methods or building any further might be too complex for now because of lack of data.
2 replies
0 recast
2 reactions
yesyes
@yesyes
Covalent's increment is currently rather restrictive so i cant add the option to enter the project id or to select the donor round. There's a date aggregation filter that will allow a person to check all the donors in a particular date range but that's it. I don't believe there's any other option right now.
1 reply
0 recast
0 reaction
yesyes
@yesyes
Best that can be done is that i can provide the SQL code and you can manually enter the project id in increment.
1 reply
0 recast
0 reaction
