gitcoinco / gitcoinco/web

[Feature] Grants: Filter / Remove Non confirmed transactions from "Export All Earnings"

Open
#8,678 0 comments 0 reactions 0 assignees View on GitHub
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

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.