SELECT

signer,

first_tx_date,

last_tx_date,

num_txs,

DATEDIFF(day, first_tx_date, last_tx_date) AS active_days

FROM

solana.core.ez_signers

),

activated_users AS (

SELECT

signer,

first_tx_date,

last_tx_date,

num_txs,

active_days

FROM

user_tx

WHERE

num_txs >= 2 -- At least 2 transactions

AND active_days <= 7 -- Within 7 days of activity

),

monthly_activity AS (

SELECT

DATE_TRUNC('month', first_tx_date) AS cohort_month,

COUNT(DISTINCT signer) AS monthly_new_users,

COUNT(

DISTINCT CASE

WHEN num_txs >= 2

AND active_days <= 7 THEN signer

END

) AS activated_users

FROM

user_tx

GROUP BY