TIME | WEEKS_ACTIVE | RONIN_RETENTION | BASE_RETENTION | ETH_RETENTION | |
|---|---|---|---|---|---|
1 | 2 month | 8 | 0.01047125 | 0.00112128 | 0.00310211 |
2 | 3 month | 12 | 0.00670886 | 0.00032315 | 0.00089379 |
3 | 1 week | 1 | 1 | 1 | 1 |
4 | 1 month | 4 | 0.0370939 | 0.00722736 | 0.02110274 |
Sandeshuser retention
Updated 2025-06-29
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 ronin_chain as
(
with temp as
(
select from_address, min(date_trunc('week',block_timestamp)) as joined, max(date_trunc('week',block_timestamp)) as exited, count(distinct date_trunc('week',block_timestamp)) as weeks_active
from ronin.core.fact_transactions
where 1=1
and from_address in ( select from_address from ronin.core.fact_transactions where block_timestamp>='2024-12-01' and nonce=0)
group by from_address
)
select weeks_active, count(from_address) as users, sum(users) over (order by weeks_active asc) as total_users, 100*users/total_users as retention_ratio
from temp
group by weeks_active
),
base_chain as
(
with temp as
(
select from_address, min(date_trunc('week',block_timestamp)) as joined, max(date_trunc('week',block_timestamp)) as exited, count(distinct date_trunc('week',block_timestamp)) as weeks_active
from base.core.fact_transactions
where 1=1
and from_address in ( select from_address from base.core.fact_transactions where block_timestamp>='2024-12-01' and nonce=0)
group by from_address
)
select weeks_active, count(from_address) as users, sum(users) over (order by weeks_active asc) as total_users, 100*users/total_users as retention_ratio
from temp
group by weeks_active
),
ethereum_chain as
(
with temp as
(
select from_address, min(date_trunc('week',block_timestamp)) as joined, max(date_trunc('week',block_timestamp)) as exited, count(distinct date_trunc('week',block_timestamp)) as weeks_active
from ethereum.core.fact_transactions
Last run: 3 months ago
4
161B
161s