Methodology

Dashboard Objective

Show User Activity and User Retention in Flow

Dashboard Structure

Welcome to Flow
Important Info & Definitions
- How to Track Correctly Users?
- Key Definitions
User Activity in Flow
- New Users in Flow
- Active Users in Flow - All Time
- User Retention in Flow
- Users by Total Days Active
Type of User Activity in Flow
- Monthly User Activity by Type of Activity - Since 2022
- Monthly Retention of Users by Activity - Since 2022
- Weekly User Activity by Type of Activity - 2023
- Weekly Retention of Users by Activity - 2023
What is behind the User Spikes?
- $FLOW transfers during user spikes
- Top Activity of $FLOW transfers in 2023
Conclusion
Methodology

Dashboard Method

Using Flipside Tables of Flow I'll track the user activity and retention

Table Used to track all users in FLOW:

flow.core.fact_transactions

Table Used for the Bridge Users in FLOW:

flow.core.ez_bridge_transactions

Table Used for the NFT Users in FLOW:

flow.core.ez_nft_sales

Table Used for the Stakers in FLOW:

flow.core.ez_staking_actions

Table Used for the Swappers in FLOW:

flow.core.ez_swaps

Table Used for the Senders (Transfers) in FLOW:

flow.core.ez_token_transfers

Dashboard Sources

Flow Logo

Flow Icon from Flow Website

MetricsDAO Bounty Question

Track how the Flow blockchains daily active users have evolved over time. What about monthly? All-time wallets?

Recently, we’ve identified some interesting spikes (in both directions) in daily active users. Chart this activity, and try to uncover any reasonable explanations for the results.

User Activity in Flow