New and Returning Users

0xHaM-dNew and Returning Users

Updated 6 days ago

WITH eventTb AS (

SELECT

BLOCK_TIMESTAMP,

TX_HASH,

FROM_ADDRESS as user,

CASE

when TO_ADDRESS in ('0xd887014121ddbad4494093689997125dde30612a'

,'0x3825ff6b6ad0f460660547e5890425ee821bd02c') then 'Fableborne'

when TO_ADDRESS in ('0x02790f32ad7e7eaaecfb0ad21950829932f1a2ee'

,'0x7eae20d11ef8c779433eb24503def900b9d28ad7') then 'Pixel'

when TO_ADDRESS in ('0x0e268edc8750d50c440d715c935eba2e7c6ae775') then 'Wild Forest'

when TO_ADDRESS in ('0x1136dac182ab639632a38540c6f33c01e02e51a6') then 'Pixel HeroZ'

when TO_ADDRESS in ('0x58ad3594758b0f74478dbc07168812ddf460a07f') then 'Apeiron'

when TO_ADDRESS in ('0xd97c9707528141b3b505eec03ee90aebf055a901') then 'Kaidro'

when TO_ADDRESS in ('0x0a9e7795ab1d691986b8f944f99560a7ed9e0708') then 'Kongz'

when TO_ADDRESS in ('0x9eb8857d07a833b47cc95a1f5c8331d627622511') then 'Kongz'

when TO_ADDRESS in ('0x59cfa86b6820901ebeddd60f131c473c15eae130') then 'Ragnarok: Monster World'

when TO_ADDRESS in ('0xda1c8c1d7df35ecf91186e3cb410ecdb4fb29a3a') then 'Ragnarok: Monster World'

when TO_ADDRESS in ('0xa62bbfe37d5fd209a83e17c385b0d1034ac41ade') then 'The Machines Arena'

when TO_ADDRESS in ('0x19f70ecd63f40f11716c3ce2b50a6d07491c12fe') then 'Lumiterra'

when TO_ADDRESS in ('0x9d3936dbd9a794ee31ef9f13814233d435bd806c'

,'0x32950db2a7164ae833121501c797d79e7b79d74c'

,'0x05b0bb3c1c320b280501b86706c3551995bc8571'

,'0x3e0674b1ddc84b0cfd9d773bb2ce23fe8f445de3') then 'Axie Infinity'

end as first_game,

FROM ronin.core.fact_transactions

WHERE TO_ADDRESS in (

'0xd887014121ddbad4494093689997125dde30612a'

,'0x3825ff6b6ad0f460660547e5890425ee821bd02c'

,'0x02790f32ad7e7eaaecfb0ad21950829932f1a2ee'

,'0x7eae20d11ef8c779433eb24503def900b9d28ad7'

,'0x0e268edc8750d50c440d715c935eba2e7c6ae775'

,'0x1136dac182ab639632a38540c6f33c01e02e51a6'

,'0x58ad3594758b0f74478dbc07168812ddf460a07f'

,'0xd97c9707528141b3b505eec03ee90aebf055a901'

Last run: 6 days ago

	DATE	ACTIVE_USERS	N_NEW_USER	CUM_USERS	RECURRING_USER	NEW_USER_PERCENT	RECURRING_USER_PERCENT	Avg Active Users	AVARAGE_7_ACTIVE_USERS	Avg New User	AVARAGE_7_NEW_USER
1	2025-03-28 00:00:00.000	308397	1048	6238292	307349	0.339822	99.660178	722607.122905	374430	34850.793296	4457.285
2	2025-03-27 00:00:00.000	445003	6026	6237244	438977	1.354148	98.645852	724934.146067	377677.285	35040.696629	5167.142
3	2025-03-26 00:00:00.000	386734	4648	6231218	382086	1.20186	98.79814	726515.677966	367189.571	35204.621469	4867.571
4	2025-03-25 00:00:00.000	408546	3142	6226570	405404	0.769069	99.230931	728446.255682	360628.571	35378.238636	5091.285
5	2025-03-24 00:00:00.000	402325	5110	6223428	397215	1.270117	98.729883	730274.257143	350876.857	35562.445714	5806.428
6	2025-03-23 00:00:00.000	338363	6099	6218318	332264	1.802502	98.197498	732159.022989	357844.714	35737.45977	5513.142
7	2025-03-22 00:00:00.000	331642	5128	6212219	326514	1.546246	98.453754	734435.300578	377916.428	35908.780347	6003.428
8	2025-03-21 00:00:00.000	331128	6017	6207091	325111	1.817122	98.182878	736777.122093	399195.714	36087.738372	5962.571
9	2025-03-20 00:00:00.000	371589	3929	6201074	367660	1.057351	98.942649	739149.339181	420646	36263.590643	5605.142
10	2025-03-19 00:00:00.000	340807	6214	6197145	334593	1.823319	98.176681	741311.458824	438553.142	36453.794118	5588.714
11	2025-03-18 00:00:00.000	340284	8148	6190931	332136	2.394471	97.605529	743681.307692	461983.428	36632.727811	5054.285
12	2025-03-17 00:00:00.000	451100	3057	6182783	448043	0.677677	99.322323	746082.482143	484629.142	36802.279762	4468
13	2025-03-16 00:00:00.000	478865	9531	6179726	469334	1.990331	98.009669	747848.844311	493093.714	37004.347305	4817.714
14	2025-03-15 00:00:00.000	480597	4842	6170195	475755	1.007497	98.992503	749469.228916	498601.428	37169.849398	4196.142
15	2025-03-14 00:00:00.000	481280	3515	6165353	477765	0.730344	99.269656	751098.757576	503251.285	37365.775758	4454
16	2025-03-13 00:00:00.000	496939	3814	6161838	493125	0.767499	99.232501	752743.993902	474388.857	37572.182927	4663.142
17	2025-03-12 00:00:00.000	504819	2473	6158024	502346	0.489879	99.510121	754313.349693	479894.428	37779.288344	4823.857
18	2025-03-11 00:00:00.000	498804	4044	6155551	494760	0.810739	99.189261	755853.438272	487207.428	37997.228395	6204.428
19	2025-03-10 00:00:00.000	510352	5505	6151507	504847	1.078667	98.921333	757450.018634	460219.714	38208.118012	6204.428
20	2025-03-09 00:00:00.000	517419	5180	6146002	512239	1.001123	98.998877	758994.38125	463842.571	38412.5125	6644

...

179

21KB

44s

flipside

flipside