flipsidecryptoAXELScore App Visits - Galxe
    Updated 2023-05-30
    -- forked from AXELScore App Visits - Layer3 @ https://flipsidecrypto.xyz/edit/queries/0fdc0337-f8a5-42df-8356-777246925a11

    -- forked from AXELScore App Visits @ https://flipsidecrypto.xyz/edit/queries/452649ff-1ce5-489a-a37d-58dc43b059dc
    -- forked from flowscored app visits @ https://flipsidecrypto.xyz/edit/queries/4a9f326b-fb5a-4c8f-b7a4-89f5e7cde2da
    -- 17 app visitors before 4/21
    select
    count(context_request_ip) AS galxe_app_visits,
    count(distinct context_request_ip) + 17 AS galxe_unique_app_users
    from
    BI_ANALYTICS.SCIENCE_FLIPSIDECRYPTO_XYZ_PROD.PAGES
    where
    timestamp > '2023-04-21'
    AND context_page_path LIKE '%axelscore%'
    AND initial_referrer LIKE '%galxe%'


    Run a query to Download Data