Track metrics in the bounties platform (Postgres)

[ecurrencyhodler]

I'd like for us to start tracking key events. This will require more scope but here are a few to start:

Feature brief: Bounties are new way of working, so we want to learn as much as we can about the process of creating and completing bounties. Metrics provide a top down factual view of results. User interviews would provide more qualitative information.

Architecture: Redis vs. gocache?

Metrics v1

• [x] When a bounty is posted https://github.com/stakwork/sphinx-tribes/blob/master/db/structs.go#L345
• [x] When someone is assigned a bounty check if were using this currently? https://github.com/stakwork/sphinx-tribes/blob/master/db/structs.go#L360
• [x] When someone is paid I think a new field may need to be added, we might want to distinguish between paid through an org/the platform or just marked paid
• [x] When an org is created https://github.com/stakwork/sphinx-tribes/blob/master/db/structs.go#L406C2-L406C2
• [x] Amount in a bounty
• [x] Total amount paid over "x" period of time
• [x] Total bounties paid over "x" period of time
• [x] Total bounties assigned over "x" period of time
• [x] Total bounties posted over "x" period of time
• [x] % of bounties completed over "x" period of time
• [x] % of bounties paid over over "x" period of time

v.2 for super admin

• [ ] Time to value for bounty provider: From account creation to pay out. _make query to lookup from bounties table backwards for their ownerid=pubkey and paid=true and then take the paid date - profile creation date
• [ ] Time to value for bounty hunter: From account creation to getting paid. _make query to lookup from bounties table backwards for their assignepubkey=pubkey and paid=true and then take the paid date - profile creation date

[ecurrencyhodler]

@kevkevinpal Based on our convo today, is there a basic strategy around how we would want to implement this? Are we going to go with redis or gocash?

[kevkevinpal]

@kevkevinpal Based on our convo today, is there a basic strategy around how we would want to implement this? Are we going to go with redis or gocash?

with my convo with Gonza we can use the interface with gocache to either use redis if we provide the env vars or fall back to a local gocache if a redis instance is not defined in the env vars

[elraphty]

Figma design https://www.figma.com/file/jM4BZzPfN8K5tAUbl7gGoO/People.Sphinx-%5BDRAFTS%5D?type=design&node-id=6636-19632&mode=design&t=MnYGEQAd9Ae3jmJY-0

[ecurrencyhodler]

Edit: Sorry let's use the timestamp of date bounty is posted as our reference for the sorting of the "last 30 days" button on the top right @elraphty

[elraphty]

Yeah, using the bounty posted date timestamp works.

[ecurrencyhodler]

@elraphty sorry. Can we make sure to track Date bounty was assigned?