flipsidecryptoMonthly Acquired Users
Updated 2023-09-26
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
34
35
36
›
⌄
with all_submissions AS (
select
wallet_address AS wallet,
slug AS first_flow_bounty,
min(s.created_at) AS submission_date
FROM bi_analytics.silver.bounties b
LEFT JOIN bi_analytics.silver.claims cl
ON b.id = cl.bounty_id
LEFT JOIN bi_analytics.silver.submissions s
ON cl.id = s.claim_id
WHERE s.id IS NOT NULL
AND project_name = 'Flow'
AND bounty_type <> 'education'
group by wallet, first_flow_bounty
),
first_submissions AS (
select
wallet_address AS wallet,
min(s.created_at) AS first_submission_date
FROM bi_analytics.silver.bounties b
LEFT JOIN bi_analytics.silver.claims cl
ON b.id = cl.bounty_id
LEFT JOIN bi_analytics.silver.submissions s
ON cl.id = s.claim_id
WHERE s.id IS NOT NULL
AND project_name = 'Flow'
AND bounty_type <> 'education'
group by wallet
),
counts AS (
SELECT
first_submission_date,
date_trunc('month', first_submission_date) AS wallet_join_month,
first_flow_bounty,
Run a query to Download Data