flipsidecryptoAXELScore User Conversions
    Updated 2023-07-26
    with app_users AS (
    select
    count(distinct context_request_ip) + 17 AS app_users,
    context_page_path
    from BI_ANALYTICS.SCIENCE_FLIPSIDECRYPTO_XYZ_PROD.PAGES
    where timestamp > '2023-04-21'
    AND
    context_page_path LIKE '%axelscore%'
    GROUP BY context_page_path
    ),

    connected_wallets AS (
    select
    count(distinct dynamic_id) AS wallet_count
    from BI_ANALYTICS.BRONZE_API.DYNAMIC_API
    where environment_id = '88e7cf93-cd57-4664-b5da-9682b46074e0' --AXELscore environment
    ),



    page_counts AS (
    select
    count(context_request_ip) AS campaign_user
    from
    BI_ANALYTICS.WWW_PROD.PAGES
    JOIN bi_analytics.silver.bounties b ON b.id = trim(replace(path, '/drops/'), 0)
    where
    received_at > '2023-04-12'
    AND
    context_page_referring_domain = 'science.flipsidecrypto.xyz'
    AND
    b.start_at > '2023-04-12'
    AND
    (b.slug LIKE '%axelscore%')


    Run a query to Download Data