Methodology

Dashboard Objective

Show an Overview of Base Testnet, with a focus on tracking the health of the network and its daily performance. Also, highlight the top contracts/users by activity.

Dashboard Structure

Introduction
Base Testnet - Overview
- Explanation of Base Goerli.
- Transaction Activity
- User Activity
- Gas Usage
Base Testnet - Performance
- Daily Performance of Transactions and Gas Fees
- Stickiness Ratio (User Retention)
- Blocks Performance
- Performance by Timeframe
Base Testnet - Top Activity
- Top 100 Contracts by Transactions
- Top 10 Users
Conclusion
Methodology

Dashboard Method

Using the new Flipside Tables of Base I'll track the activity of Base, and searching some addresses using the Base Scanner.

--Table Used to get all the Activity

base.goerli.fact_transactions

--To get the contracts I used this table

base.goerli.fact_event_logs --And then joining it with the fact_transactions using tx_hash.

--To get Block Information

base.goerli.fact_blocks

--To get the $USD price for the fees

FROM base.goerli.fact_transactions left join (
    select
      date_trunc('day', hour) as day1,
      avg(price) as price
    from ethereum.core.fact_hourly_token_prices 
    where symbol LIKE 'WETH'
    group by 1 
  ) on day1 = date_trunc('day', block_timestamp)

Dashboard Sources

Coinbase by Wikipedia

Introducing Base by Coinbase

What is Goerli? by Alchemy

Coinbase Logo

Base Icon

Bridge Image from the Base Bridge App

MetricsDAO Bounty Question

Submit a deep dive dashboard that explores a specific topic in detail using Base data.

Popex404