Methodology

Dashboard Objective

Show the Monthly Activity of Users in Near & Aurora and compare them.
Dig into the Activity of Users in Near with a Project Approach, identify trends, and create an Hypothesis to explain User Activity.

Dashboard Structure

Near in Q2, 2023
- Near Foundation Publishes the Second Quarterly Report of the Year!
- The Transparency Report Q2, 2023 in a Nutshell
- Active Projects in Near Blockchain and Near Horizon Q2, 2023
What is an Active User?
- Near North Star Metric, Monthly Active Accounts (MAA)
- Test Results, What is an Active User?
Near 2023 MAUs
- Overview
- Monthly Active Users by Project
- Monthly Projects by MAU
- Monthly Users by Number of Projects Used
Pairing Projects
- Monthly Active Users Using More than 1 Project
- Activity of Users Using 2 Projects
- Activity of Users Using More than 3 Projects
Near MAUs Hypothesis
- Users Using Sweat vs Users Not Using Sweat
Near vs Aurora
- Monthly Active Users in 2023
- MAU Growth Rates
- Monthly New Users
- Retention of MAU
Key Takeaways
Methodology

Dashboard Method

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

Table To get Near Projects:
near.core.dim_address_labels

Tables to get Activity:
near.core.fact_actions_events
To track activity of users using projects as a single transaction hash can involve multiples projects.

near.core.fact_transactions
To get Near Active Users in charts without Projects.

aurora.core.fact_transactions
To get Aurora Active Users

Table for New Users Retention Cohort from Madi Query:
https://flipsidecrypto.xyz/Madi/q/e8PiGckOs7t_/new-users-monthly-retention
But I Improve it to make it more clear.

Dashboard Sources

NEAR Monthly Active Users in 2023