retention plots

TheLaughingManretention plots

Updated 2025-04-11

-- forked from new vs old traffic @ https://flipsidecrypto.xyz/studio/queries/32c825b6-9c3d-467a-811e-23cbd25bb896

-- forked from new users by instance @ https://flipsidecrypto.xyz/studio/queries/c8ac5c1a-c63d-4c2f-bb3c-8bf718b0822c

-- forked from new users @ https://flipsidecrypto.xyz/studio/queries/1a856392-7af8-4ad9-96ee-909b0154fe62

with merge_all_time as (

---arbitrum

SELECT * EXCLUDE version, 'arbitrum' as label from arbitrum.vertex.ez_perp_trades

WHERE 1=1

--AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---base

SELECT *, 'base' as label from base.vertex.ez_perp_trades

WHERE 1=1

--AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---blitz

SELECT * , 'blitz' as label from blast.blitz.ez_perp_trades

WHERE 1=1

--AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---mantle

SELECT * , 'mantle' as label from mantle.vertex.ez_perp_trades

WHERE 1=1

--AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'

AND trader != '0x0000000000000000000000000000000000000000'

Last run: 16 days ago

	BATCH	WEEKS_SINCE	RETENTION_PCT	NEW_USERS	EXISTING_USERS
1	01-06	8	0.01	67	1
2	01-06	2	0.03	67	2
3	01-06	11	0.01	67	1
4	01-06	3	0.1	67	7
5	01-06	4	0.03	67	2
6	01-06	1	0.15	67	10
7	01-06	6	0.03	67	2
8	01-06	7	0.06	67	4
9	01-06	5	0.03	67	2
10	01-06	9	0.04	67	3
11	01-06	10	0.04	67	3
12	01-13	3	0.13	61	8
13	01-13	6	0.08	61	5
14	01-13	11	0.02	61	1
15	01-13	10	0.08	61	5
16	01-13	9	0.08	61	5
17	01-13	5	0.1	61	6
18	01-13	2	0.11	61	7
19	01-13	4	0.11	61	7
20	01-13	8	0.07	61	4

2KB

46s