Tracking Blocto users

    Flow is known as a blockchain of NFTs, many users are interacting with this blockchain and its amazing NFTs like TopShot, Doodles or Barbie using Dapper wallet which is the official Flow NFT wallet from Dapper Labs, but how about Defi actions, what wallets ables users to interact Flow DEXs or stake $FLOW tokens plus NFT trading?! Well, there are some good options to choose from, and the the most popular one is Blocto!

    Blocto is an all-in-one cross-chain smart contract wallet with a seamless unified experience in one all-encompassing platform: Dev-friendly SDK, built-in DEX BloctoSwap, and non-custodial NFT marketplace BloctoBay. Users can be onboarded within 30 seconds, and enjoy a plethora of experiences. A cross-chain dApp ecosystem for dApps to scale exponentially and effortlessly from Web 2.0 to Web 3.0. (source)

    db_img

    In this dashboard, I will track Blocto users' activity usage on Flow blockchain. Here's how:

    On Flow, it's easy to find the wallet's real creation date. When a user installs a Flow wallet, the wallet will receive 0.001 $FLOW from a specified source (which depends on the wallet app the user is using) to be activated. This transaction is just an asset-receiving action, and no action is taken by the user. So the user's first action is when they sign something and confirm the transactions themselves (making a transaction).

    To find new address creation transactions, I used the EVENT_TYPE = 'AccountCreated' filter on the flow.core.fact_events table and separated each provider's related addresses with the 0.001 $FLOW sender address:

    Blocto new address sender: '0x55ad22f01ef568a1'

    Transactions on Flow are super cheap, but to provide a better experience of interacting with blockchains and the Web3 space, wallet providers on Flow pay transaction fees for users. To track daily active users of each app, I used each app's related payer address:

    Blocto fee payer: '0x55ad22f01ef568a1'

    Intro
    Methods

    Dashboard's realted twitter thread: https://twitter.com/h355i/status/1718252842434367916