flipsidecryptoAXELScore App Visits - Galxe
Updated 2023-05-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- 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