Dune analytics GA dashboard

[ramirotw]

Current dashboard that supports stats for individual auctions: https://duneanalytics.com/gnosis.protocol/Gnosis-Auction-Boson-Sale?DECIMALS_DIFF=12 https://duneanalytics.com/audieleon/VitaDAO-Auction

I would like to have a general dashboard to show overall stats for Gnosis Auction. The existing dashboard is a good reference for the relevant tables and queries.

Some interesting information to have on the dashboard:

All time unique users

• Graph of unique users over time
• Number of auctions - all time
• Graph, number of live auctions over time
• Graph, number of ended auctions over time
• List of auctions with stats:
  • Auction ID
  • No of unique bidders
  • No of unique users added to GA
  • Start date
  • Duration
  • Amount sold
  • Amount bought
  • Clearing price

[cmagan]

https://duneanalytics.com/audieleon/VitaDAO-Auction

[stackseeder]

https://duneanalytics.com/ivicajuras/Gnosis-Auction-Sales This is the dashboard which I built now. It's missing some fields and charts yet.

[josojo]

Good start!

I would love to additionally see:

• Trading volumes for each auction
• Token symbols of the tokens bought and sold
• Trading volume overall

Is it possible to include xdai auctions?

[stackseeder]

Okay, I will add new columns. And I think we can include xdai auction. Which kind of info and view do I need to display in dashboard for xdai?

[josojo]

xdai auction should just appear as usual auctions. I think we should just introduce a new column with the name network and then display the network in there. That should be the only difference

[stackseeder]

• [x] Graph of unique users over time
• [x] Number of auctions - all time
• [x] Graph, number of live auctions over time
• [x] Graph, number of ended auctions over time
• [x] List of auctions with stats:
  • [x] Auction ID
  • [x] No of unique bidders
  • [x] No of unique users added to GA
  • [x] Start date
  • [x] Duration
  • [x] Amount sold
  • [x] Amount bought
  • [x] Network
  • [x] Token symbol bought
  • [x] Token symbol sold
  • [x] Auction volume
  • [x] Clearing price

I created Auction volume table separately. Because it take so long time to calculate all auctions transaction data to get volume.

• [x] Auction Volume with USD This also take 18 minutes to get all data from the blockchain.

[josojo]

Hey,

I just looked at the dune dashboard, and I was a little bit disappointed that the USD query was not yet working. You can make your life much easier by just using the indexed gnosis_auction:

there is also the sell_token_address available and in this "Auctions USD Volume" query, you don't need to depend on all indexed erc20's

[stackseeder]

Ok, let me check it. Thanks.

[stackseeder]

That makes much easier. I am recreating all dashboard charts and tables based on the gnosis auction indices in dune. It will be done soon.

[stackseeder]

@cmalfesi @josojo Please check this dashboard: https://duneanalytics.com/ivicajuras/Gnosis-Auction-Sales I completed the dune dashboard for Gnosis auctions

[josojo]

Hey could you please check the usd trading volumes? it shows only 700k, though just the viita auction alone was 5M

[stackseeder]

@josojo Ok, I found the issue here.

I got the USD price in prices."usd" table in Dune. Anyway, some price has the value, but others doesn't have the price value. For the empty price value, what value should I use as USD price?

[josojo]

For the empty price value, what value should I use as USD price? If the auction is not important, we cacan usee just a price of 0, otherwise, wee need o get it from somewhere

[stackseeder]

@josojo Yes, that's it. Current volume is the value which I calculated the empty prices as 0. In the dune platform, how can I get more exact usd price value instead of empty?

[josojo]

An easy improvement of the price can be archived, if you use the price of the bidding token instead of auctioning token. The bidding tokens are usually stablecoins, whose prices should be available

[stackseeder]

@josojo Yes, I already used bidding token to get the USD price. But the most token prices are empty.

[josojo]

If you are taking the biddingToken, then you can't calculate with the sellamount, which is in the auctioningToken. I think there is the error

[stackseeder]

@josojo I tried, but I can't get the prices properly. Would you please help me to get correct usd prices by updating sql query?

[stackseeder]

@josojo I updated the usd volume. Please check it.

[ramirotw]

@josojo was going to take care of the USD volume query. The rest of the dashboard queries were ok.