Kalen
    discord@daftura
    @kal3n

    Flow user activity, retention and fees

    What each field mean
    Read this to understand the chart

    Here are what the fields mean

    first_activity_date:

    • The date when a user first interacted with the Flow blockchain.

    • Used to identify user cohorts and calculate retention.

    • activity_date:

      • The date of the recorded activity.

      • Used to track daily metrics and trends over time.

    • days_since_first_activity:

      • The number of days between a user's first activity and the current activity.

      • Crucial for analyzing user retention and engagement patterns over time.

    • active_users:

      • The count of unique users who performed any activity on a given day.

      • Helps track daily active user (DAU) metrics.

    • total_transactions:

      • The total number of transactions performed on a given day.

      • Indicates overall blockchain activity and usage.

    • total_gas_limit:

      • The sum of gas limits set for all transactions on a given day.

      • Useful for understanding network capacity utilization.

    • avg_active_addresses:

      • The average number of unique addresses that were active in a given day.

      • Provides a measure of network participation.

    • avg_transactions:

      • The average number of transactions per active address on a given day.

      • Indicates user engagement levels.

    • avg_fees_native:

      • The average transaction fee in the native blockchain currency.

      • Useful for tracking network costs in the native token.

    • avg_fees_usd:

      • The average transaction fee converted to USD.

      • Provides a standardized measure of transaction costs

    Summary of the boards
    TLDR - Flow not doing so well

    Flow user retention is decreasing and activities as a whole are stagnating.

    But overall the daily transaction is picking up slowly and steadily with the average fee remaining the lowest since last month.

    I didn't had enough time to add all of the graphs I wanted so below will explain the fields and what to do if you decide to fork this yourself

    Customization tips and explanation of code
    Some advice if you want to fork this

    Adjust the time range to suit your analysis needs if you want.

    Once again I have a particular preference and only did it monthly

    I wanted only successful transactions so I did some filtering for them using the (tx_succeeded = TRUE

    Disclaimer: Flipside AI is here to help but it can make mistakes. Always review outputs and use the upvote/downvote buttons to help us improve. This content is not financial advice.