ACTIVITY_CATEGORY | USER_COUNT | |
|---|---|---|
1 | one-timer 1 day | 3711 |
2 | 🐌 2–3 days | 1248 |
3 | 🐇 3–4 days | 199 |
4 | 🐢 5–9 days | 16 |
5 | 🐌 10–14 days | 3 |
Afonso_DiazUsers Activity
Updated 2025-04-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with main as (
select
from_address as user,
block_timestamp::date as transaction_date
from
mezo.testnet.fact_transactions
where
tx_succeeded
),
user_active_days as (
select
user,
count(distinct transaction_date) as active_days
from
main
group by
user
)
select
case
WHEN active_days >= 180 THEN '🐘 180+ days'
WHEN active_days >= 90 THEN '🐅 90–179 days'
WHEN active_days >= 30 THEN '🦘 30–89 days'
WHEN active_days >= 15 THEN '🐿️ 15–29 days'
WHEN active_days >= 10 THEN '🐌 10–14 days'
WHEN active_days >= 5 THEN '🐢 5–9 days'
WHEN active_days >= 3 THEN '🐇 3–4 days'
WHEN active_days >= 2 THEN '🐌 2–3 days'
ELSE 'one-timer 1 day'
end as activity_category,
count(*) as user_count
from
user_active_days
group by
activity_category
order by
Last run: 15 days ago
5
122B
3s