[Feature] Grants: Filter / Remove Non confirmed transactions from "Export All Earnings"
- Dominant language
- JavaScript
- Stars
- 1.8k
- Forks
- 776
- PR merge metrics
- No merged PRs in 30d
Description
### User Story
As a **Grant Administrator**, I want to be able to **filter non confirmed donations from the Export All Earnings .csv** to be able **to calculate real earnings (this might be needed legally) but also, if I decide so, to airdrop something to people who donated** (I've seen a lot of bot faking donations in a regular pattern, I guess this is for possible airdrops, like the last that happened after gr8)
### Why Is this Needed
Right now it is not possible to calculate real earnings with this tool because it returns all started transaction, even if those never went through.
Since there has been a lot of bots doing fake donations in gr9, this is not a matter of a few transactions / small amount to find anymore.
Earnings as donations might have to be taxed / declared legally, so it would be awesome to be able to filter those (or to not have them included in earnings at all).
*Summary*:
### Description
*Type*: Feature
### Current Behavior
When exporting all earnings, all "started transactions" are displayed, even those that didn't went through, making the earnings table not accurate
### Expected Behavior
In the best case, not exporting transaction that didn't went through
In the worst case, adding a {confirmed} column with value "confirmed/unconfirmed" or "yes/no" or "true/false" to be able to filter transaction that weren't
### Definition of Done
- when the exported CSV doesn't show the unconfirmed transactions OR has a {confirmed} column allowing the user to filter
### Data Requirements
### Additional Information
On my grant: https://gitcoin.co/grants/1530/beyondnft
This is the SUM of all donations shown in the CSV since starts og GR9: $11,302
This is the actual Amount shown on Gitcoin : $7,486
There is a difference of ~50% due to a lot of bots creating fake transactions of 0.1 eth
Contributor guide
Assessment
This issue has not been assessed yet.