aureasarsanedesbattle 4
Updated 2025-01-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT
PLATFORM_NAME,
COUNT(DISTINCT CASE WHEN BUYER_ADDRESS IN (
SELECT BUYER_ADDRESS
FROM aptos.nft.ez_nft_sales
WHERE BLOCK_TIMESTAMP < DATEADD(day, -{{days}}, CURRENT_DATE)
) THEN BUYER_ADDRESS END) AS repeat_buyers,
COUNT(DISTINCT BUYER_ADDRESS) AS total_buyers,
(COUNT(DISTINCT CASE WHEN BUYER_ADDRESS IN (
SELECT BUYER_ADDRESS
FROM aptos.nft.ez_nft_sales
WHERE BLOCK_TIMESTAMP < DATEADD(day, -{{days}}, CURRENT_DATE)
) THEN BUYER_ADDRESS END) * 1.0 /
COUNT(DISTINCT BUYER_ADDRESS)) * 100 AS retention_rate
FROM
aptos.nft.ez_nft_sales
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
GROUP BY
PLATFORM_NAME
ORDER BY
retention_rate DESC
QueryRunArchived: QueryRun has been archived