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

Dashboard	Creator	Published
Trisolaris DEX Aug 16, 2023	Popex404	Aug 16, 2023
Aurora Health 💗🩺 Jul 19, 2023	Popex404	Jul 19, 2023
NEAR Monthly Active Users in 2023 Jul 30, 2023	Popex404	Jul 30, 2023

Popex404