flipsidecryptoAXELScore App Visit Growth w/ L3
Updated 2023-07-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
-- 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