What is the problem? & Why are we solving it?

DAO ran scripts dependent on outdated stuff

we want a transparent set of dashboards that is semi or fully automated and use onchain as the source of truth.

How does it help Shapeshift users or DAO?

These Dashboards will allow for ShapeShift’s TMDC to better make decisions about the fox discounts program and other DAO related strategies moving forward. This should benefit the DAO by having a more complete picture of its finances and address strategy around this information.

How are we solving it?

Currently,

What are the requirements (engineering, marketing, grants etc.)?

TMDC shall spearhead the requirements and help with queries and costs. The goal is to keep this away from engineering resources.

• Analytics—Fees
  • number of active traders by types
    • free_traders (trades <$1k)
    • fox_whales (fox holdings >$1MM)
  • trading volumes by pairs
  • average trade size per user type
  • average fee size per user type
• Revenues
  • swappers (thor, 0x, COW, lifi)
  • Swap size
  • Swap pairs
  • Trading Fees
  • FOX token holdings at time of trade
  • FOX token holdings now
  • Total affiliate fees
    • matched to address (events in specific smartcontracts, example swappers, TOKE)
  • Reverts (TC only)
  • top refund reason (TC only)

• Analytics—Liquidity

smaple query .sqkl

sample query flipside

What are the risks and how will we mitigate them?

Risks of data being corrupted, incomplete, or not correct if checks are not happening.