COHORT_DATE | MONTHS | RETENTION_RATE | |
|---|---|---|---|
1 | 2025-01 | 1 | 10.34 |
2 | 2024-12 | 1 | 4.69 |
3 | 2024-12 | 2 | 1.56 |
4 | 2024-11 | 1 | 5.66 |
5 | 2024-11 | 2 | 1.89 |
6 | 2024-10 | 1 | 7.14 |
7 | 2024-10 | 2 | 7.14 |
8 | 2024-10 | 3 | 7.14 |
9 | 2024-10 | 4 | 2.38 |
10 | 2024-09 | 1 | 26.32 |
11 | 2024-09 | 2 | 21.05 |
12 | 2024-09 | 3 | 10.53 |
13 | 2024-09 | 4 | 13.16 |
14 | 2024-09 | 5 | 5.26 |
15 | 2024-08 | 1 | 7.55 |
16 | 2024-08 | 2 | 7.55 |
17 | 2024-08 | 3 | 7.55 |
18 | 2024-08 | 4 | 3.77 |
19 | 2024-08 | 5 | 1.89 |
20 | 2024-08 | 6 | 1.89 |
Flipside Axelar AnalystsITS RETENTION
Updated 2025-02-18
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: about 2 months ago
53
1013B
60s