TOTAL_INVITATIONS | INVITED_10_FRIENDS | INVITED_5_FRIENDS | UNIQUE_SENDERS | |
|---|---|---|---|---|
1 | 154444 | 13367 | 140285 | 148585 |
datavortexReferalls
Updated 2025-02-27
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
›
⌄
WITH event_data AS (
SELECT
tx_hash,
origin_from_address,
CASE
WHEN contract_address = '0xd37f28c6c51420054b1fb1362288d07ba40440e8' THEN 'invited 10 friends'
WHEN contract_address = '0xb06cef4ff184f218c5318a2f2319d8a77a3b7dc2' THEN 'invited 5 friends'
END AS invitation_status
FROM kaia.core.fact_event_logs
WHERE
contract_address IN ('0xd37f28c6c51420054b1fb1362288d07ba40440e8', '0xb06cef4ff184f218c5318a2f2319d8a77a3b7dc2')
AND tx_succeeded = TRUE
)
SELECT
COUNT(DISTINCT tx_hash) AS total_invitations,
COUNT(DISTINCT CASE WHEN invitation_status = 'invited 10 friends' THEN origin_from_address END) AS invited_10_friends,
COUNT(DISTINCT CASE WHEN invitation_status = 'invited 5 friends' THEN origin_from_address END) AS invited_5_friends,
COUNT(DISTINCT origin_from_address) AS unique_senders
FROM event_data;
Last run: 2 months ago
1
30B
2s