flipsidecryptoMonthly Acquired Users
    Updated 2023-09-26
    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