flipside

    Try Quests to earn NEARTry Quests to earn NEAR
    Share

    NEAR Users per Project Challenge

    Loading...
    Introduction
    db_img

    Welcome to my comprehensive dashboard, offering a data-driven perspective on user adoption and activity within the NEAR ecosystem over a span of 2 years. This dashboard provides valuable insights into the growth trajectories and correlations among different user segments, including new users, repeat users, and the total user base, across various projects and protocols built on the NEAR blockchain.

    My analysis delves deep into usage patterns and trends spanning a wide range of verticals within the NEAR ecosystem. By examining the data over this extended timeframe, I aim to uncover key insights and valuable information about how users interact with and engage with NEAR-powered projects.

    I invite you to explore the rich data presented here, offering a holistic view of the NEAR blockchain's evolution, user engagement, and adoption trends. Whether you are a developer, investor, or enthusiast, this dashboard is designed to provide you with the insights you need to make informed decisions and gain a deeper understanding of the NEAR ecosystem.

    Methodology

    The analysis relied primarily on the near.core.fact_transactions and near.core.dim_address_labels tables to look at ecosystem project activity.

    Timeframes: Many of the queries focused on 1 month, 3 months, 6 months, 1 year, and 2 year timeframes to analyze growth over different periods. Some queries looked at weekly or monthly trends. The most common specific time period analyzed was July 2023 to September 2023.

    New User Identification:MIN and DATE_TRUNC functions identified first transactions and timed growth.

    Data Collection: Data for the dashboard is collected and presented by FlipsideCrypeo

    Overview

    In this report, I present an overview of projects within a specific time frame (BETWEEN '2023-07-01' AND '2023-09-01') you will find a comprehensive summary of various Project Names,Number of Transactions ,Total Active Users,New Users,New Transactions,New Users Percentage,New Transactions Percentage. To conveniently locate a specific project, you can utilize the search box located below the table.