flipsidecryptoAXELScore User Conversions
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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