Methodology

Dashboard Objective

Show the Health of the Aurora Blockchain through the Reach, Retention, and Revenue Business Model

Dashboard Structure

Aurora
- Aurora Blockchain, Taking Ethereum beyond the stratosphere
- Tracking Aurora Health
Reach
- Transactions
- Users
- Blocks
Retention
- New Users vs Existing Users
- Number of Active Users
- Stickiness Ratio (DAU/MAU)
- Days Active per Week (Users)
- MoM Cohort Retention
Revenue
- ETH Gas Fees
- Top 10 Contracts by ETH Fees
Key Takeaways
Methodology

Dashboard Method

Using the New Flipside Tables of Aurora I'll track the activity Using:

Transaction, User, and Fees Activity from: 
aurora.core.fact_transactions

Activity from Blocks from: 
aurora.core.fact_blocks

Smart Contracts Activity from: 
aurora.core.fact_logs

Labels for Contracts from:
crosschain.core.address_labels + Some I added manually (Refer to Dashboard Sources)

Heartchart from Antonidas Query:
https://flipsidecrypto.xyz/Antonidas/q/Y8r1Jxz3uwYj/heart-chart-3

Table for New Users Retention Cohort from Madi Query:
https://flipsidecrypto.xyz/Madi/q/e8PiGckOs7t_/new-users-monthly-retention

Rest of the SQL Recipes and RRR Model from My Experience at CovalentHQ Alchemist Data Boot Camp

Dashboard Sources

Images

Documents

Aurora Health 💗🩺