MONTH_COHORT | MONTHLY_NEW_USERS | |
|---|---|---|
1 | 2024-09-01 00:00:00.000 | 623024 |
2 | 2024-10-01 00:00:00.000 | 794426 |
3 | 2024-11-01 00:00:00.000 | 1307600 |
4 | 2024-12-01 00:00:00.000 | 1457076 |
5 | 2025-01-01 00:00:00.000 | 2222027 |
6 | 2025-02-01 00:00:00.000 | 7214337 |
7 | 2025-03-01 00:00:00.000 | 5954920 |
developer_violaMonthly New user
Updated 2025-03-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH new_users AS (
SELECT
from_address AS user,
MIN(DATE_TRUNC('month', block_timestamp)) AS month_cohort
FROM kaia.core.fact_transactions
WHERE tx_succeeded = TRUE
GROUP BY from_address
)
SELECT
month_cohort,
COUNT(*) AS monthly_new_users
FROM new_users
WHERE month_cohort >= DATE '2024-08-29'
GROUP BY month_cohort
ORDER BY month_cohort;
Last run: 3 months ago
7
251B
41s