SocioCryptoMonthly engaged users
    Updated 2025-04-14
    with activities as (
    SELECT
    signers[0] as user,
    date_trunc('day',block_timestamp) as date
    FROM solana.core.fact_events
    WHERE program_id = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA'
    AND date >= '2023-02-07'
    GROUP BY 1, 2
    ),
    active_wallets as (
    SELECT
    date_trunc('month',date) as month,
    user,
    count(date) as n_txn
    FROM activities
    GROUP BY 1 , 2
    HAVING n_txn >=4
    )
    ,
    mau_u as (
    SELECT
    date_trunc('month', block_timestamp) as month,
    count(DISTINCT signers[0]) as n_mau
    FROM solana.core.fact_events
    WHERE program_id = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA'
    AND block_timestamp::date >= '2023-02-07'
    GROUP BY 1
    )
    ,
    engaged as (
    SELECT
    month,
    count(DISTINCT user) as n_engaged_user
    FROM active_wallets
    GROUP BY 1
    )
    Last run: 3 months ago
    MONTH
    N_ENGAGED_USER
    N_MAU
    RATE_OF_ENGAGED_USER
    1
    2025-04-01 00:00:00.00034941218.468818
    2
    2025-03-01 00:00:00.00086298738.730882
    3
    2025-02-01 00:00:00.00014461403910.299879
    4
    2025-01-01 00:00:00.00020791862511.162416
    5
    2024-12-01 00:00:00.00030592446312.504599
    6
    2024-11-01 00:00:00.00036452575114.15479
    7
    2024-10-01 00:00:00.00033012301914.340328
    8
    2024-09-01 00:00:00.00032171991716.152031
    9
    2024-08-01 00:00:00.00041972757415.22086
    10
    2024-07-01 00:00:00.0003342334239.999102
    11
    2024-06-01 00:00:00.0003461376399.19525
    12
    2024-05-01 00:00:00.0005684624489.101973
    13
    2024-04-01 00:00:00.00089441357466.588776
    14
    2024-03-01 00:00:00.0001775013892112.777046
    15
    2024-02-01 00:00:00.0002086017413611.979143
    16
    2024-01-01 00:00:00.0002515514755717.047649
    17
    2023-12-01 00:00:00.0003754715755723.830741
    18
    2023-11-01 00:00:00.00042532600416.355176
    19
    2023-10-01 00:00:00.000777381320.377655
    20
    2023-09-01 00:00:00.000558223924.92184
    27
    1KB
    44s