flipsidecryptoAXELScore App Visit Growth w/ L3
    Updated 2023-07-26
    -- forked from AXELScore App Visit Growth @ https://flipsidecrypto.xyz/edit/queries/fc012082-00d3-4f04-8f1c-bf9c8b7e9a87

    -- 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

    select
    date_trunc('day', timestamp) as day,
    count(context_request_ip) AS app_visits,
    count(distinct context_request_ip) AS unique_app_users,
    CASE WHEN initial_referrer LIKE '%layer3%' THEN 'Layer3'
    ELSE 'Other'
    END as Source
    from BI_ANALYTICS.SCIENCE_FLIPSIDECRYPTO_XYZ_PROD.PAGES
    where timestamp > '2023-04-21'
    AND
    context_page_path LIKE '%axelscore%'
    GROUP BY 1,initial_referrer
    ORDER BY 1




    Run a query to Download Data