COHORT_DATE | MONTHS | RETENTION_RATE | |
|---|---|---|---|
1 | 2025-03 | 1 | 10 |
2 | 2025-02 | 1 | 11.76 |
3 | 2025-02 | 2 | 5.88 |
4 | 2025-01 | 1 | 10.34 |
5 | 2025-01 | 2 | 6.9 |
6 | 2025-01 | 3 | 13.79 |
7 | 2024-12 | 1 | 4.69 |
8 | 2024-12 | 2 | 1.56 |
9 | 2024-12 | 3 | 3.13 |
10 | 2024-12 | 4 | 6.25 |
11 | 2024-11 | 1 | 5.66 |
12 | 2024-11 | 2 | 1.89 |
13 | 2024-11 | 4 | 3.77 |
14 | 2024-11 | 5 | 3.77 |
15 | 2024-10 | 1 | 7.14 |
16 | 2024-10 | 2 | 7.14 |
17 | 2024-10 | 3 | 7.14 |
18 | 2024-10 | 4 | 2.38 |
19 | 2024-10 | 5 | 4.76 |
20 | 2024-10 | 6 | 7.14 |
Flipside Axelar AnalystsITS RETENTION
Updated 6 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 base as (
select
call:transaction:from as TX_SIGNER,
min(date_trunc('month', created_at)) over (partition by TX_SIGNER) as signup_date,
date_trunc('month', created_at) as activity_date,
datediff('month', signup_date, activity_date) as difference
from axelar.axelscan.fact_gmp
where call ilike '%0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c%' -- ITS Contract
and (data:executed:receipt:logs[1]:address=lower('0x4e78011Ce80ee02d2c3e649Fb657E45898257815')
or data:executed:receipt:logs[1]:address=lower('0xDCEFd8C8fCc492630B943ABcaB3429F12Ea9Fea2'))),
unp as (
select
TO_VARCHAR(signup_date, 'yyyy-MM') as cohort_date,
difference as months,
count (distinct TX_SIGNER) as users
from
base
where
datediff('month', signup_date, current_date()) <= 12
group by
1,2
order by
1
),
fine as (
select
u.*,
p.USERS as user0
from
unp u
left join unp p on u.COHORT_DATE = p.COHORT_DATE
where
p.MONTHS = 0
)
select
COHORT_DATE,
Last run: 6 days ago
54
1KB
140s