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

Reach Icon Image, Retention Icon Image, Revenue Icon Image
Aurora Logo, Aurora Rainbow Bridge Image, Aurora Image from Aurora Docs, Aurora Dao Image
Helth Meme, Aurora Logo Used in the Meme

Documents

Aurora Health 💗🩺