potmoC2 sign-ups-by-segment
Updated 2023-04-06Copy Reference Fork
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
›
⌄
-- forked from C2 Segment totals @ https://flipsidecrypto.xyz/edit/queries/26709f60-e068-4a3b-9ffb-ff72d3d6e52a
select count(*) as "Total cohort 2 signups"
from (
select
week,
count(*) as total
from
(
select
case
when tokenid = 0 then 'Segment 1'
when tokenid = 1 then 'Segment 2'
when tokenid = 2 then 'Segment 3'
when tokenid = 3 then 'Segment 4'
when tokenid = 5 then 'Segment 5'
when tokenid = 6 then 'Graduate'
end as week
from
polygon.core.ez_nft_transfers
where
nft_address = lower('0x74539714796C0FACc5EA32fB180F7cb04c71e97f')
and event_type = 'mint'
and erc1155_value = 1
and tokenid <= 6
and tokenid != 4
)
group by
1
order by
2 desc
Run a query to Download Data