TIME | WEEKS_ACTIVE | RONIN_RETENTION | BASE_RETENTION | ETH_RETENTION | |
|---|---|---|---|---|---|
1 | 1 month | 4 | 0.05542123 | 0.00567585 | 0.01718783 |
2 | 2 month | 8 | 0.01201706 | 0.00061385 | 0.0016889 |
3 | 3 month | 12 | 0.00593823 | 0.00015353 | 0.00025241 |
4 | 1 week | 1 | 1 | 1 | 1 |
Sandeshuser retention
Updated 9 days ago
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: 9 days ago
4
161B
339s