mrwildcatawful cohort retention
Updated 2024-05-24
999
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
34
35
36
›
⌄
⌄
/*select
origin_from_address as address,
min(date_trunc('month', block_timestamp)) as cohortMonth,
(decoded_log:weight :: int) / pow(10, 18) as voting_power_used
FROM
arbitrum.core.ez_decoded_event_logs
WHERE
contract_address IN(
'0xf07ded9dc292157749b6fd268e37df6ea38395b9',
'0x789fc99093b09ad01c34dc7251d0c89ce743e5a4'
) -- Core Governor, Treasury Governor
and tx_status = 'SUCCESS'
and event_name = 'VoteCast'
and block_timestamp >= '2024-01-01'
group by 1*/
/*
with user_cohort as (
SELECT
origin_from_address AS address,
MIN(date_trunc('month', block_timestamp)) AS cohortMonth,
SUM((decoded_log:weight :: int) / POW(10, 18)) AS voting_power_used
FROM
arbitrum.core.ez_decoded_event_logs
WHERE
contract_address IN (
'0xf07ded9dc292157749b6fd268e37df6ea38395b9',
'0x789fc99093b09ad01c34dc7251d0c89ce743e5a4'
) -- Core Governor, Treasury Governor
AND tx_status = 'SUCCESS'
AND event_name = 'VoteCast'
AND block_timestamp >= '2024-01-01'
GROUP BY
origin_from_address
--HAVING voting_power_used > 1
QueryRunArchived: QueryRun has been archived