flipside

    Specific-Project - Weekly New User on Near and New User for Project
    Yousefi_1994Specific-Project - Weekly New User on Near and New User for Project
    Updated 2024-01-29
    --The near_project table is forked from 'Zanyar_98' to fix the project name

    with near_project as (
    select
    address,
    case
    when project_name = 'sweat' or project_name = 'Sweat Economy' or project_name = 'SWEAT' then 'Sweat Еconomy'
    when project_name = 'PlayEmber' or project_name = 'playember' then 'PlayEmber'
    when project_name = 'Paras (PARAS)' or project_name = 'paras' then 'Paras'
    when project_name = 'Ref Finance' or project_name = 'ref finance' then 'Ref Finance'
    when project_name = 'Skyward' or project_name = 'skyward' or project_name ='SKYWARD' then 'Skyward'
    when project_name = 'AURORA' or project_name = 'Aurora (AURORA)' then 'Aurora'
    when project_name = 'jumbo' or project_name = 'Jumbo' or project_name ='jumbo exchange' then 'Jumbo'
    when project_name = 'Spin' or project_name = 'SPIN' or project_name = 'spin' then 'Spin'
    when project_name = 'cheddar' or project_name = 'Cheddar' then 'Cheddar'
    when project_name = 'burrow' or project_name = 'Burrow' then 'Burrow'
    when project_name = 'ZomLand' or project_name = 'zomland' then 'ZomLand'
    when project_name = 'PixelDapps' or project_name = 'pixeldapps' then 'PixelDapps'
    when project_name = 'open shards alliance' or project_name = 'Open Shards Alliance' then 'Open Shards Alliance'
    when project_name = 'HAPI' or project_name = 'HAPI (HAPI)' then 'HAPI'
    when project_name = 'Linear' or project_name = 'LINEAR' then 'LiNEAR'
    when project_name = 'neko' or project_name = 'NEKO(OLD)' or project_name ='Neko' then 'Neko'
    when project_name = 'mintbase' or project_name = 'Mintbase' then 'Mintbase'
    when project_name = 'Playible' or project_name = 'playible' then 'playible'
    when project_name = 'marmaj' or project_name = 'Marma J Foundation (MARMAJ)' then 'MARMAJ'
    when project_name = 'Enleap' or project_name = 'enleap' then 'Enleap'
    when project_name = 'Pembrock' or project_name = 'pembrock' then 'Pembrock'
    when project_name = 'Tonic' or project_name = 'tonic' then 'Tonic'
    when project_name = 'pem' or project_name = 'Pembrock' or project_name ='pembrock' then 'Pembrock'
    when project_name = 'Fusotao Protocol (TAO)' or project_name = 'Fusotao' then 'Fusotao Protocol (TAO)'
    when project_name = 'seat' or project_name = 'seatlab' then 'seat'
    when project_name = 'Stader (NEARX)' or project_name = 'stader' then 'Stader (NEARX)'
    when project_name = 'LazyFI' or project_name = 'LazyFi' then 'LazyFi'
    when project_name = 'DOJO' or project_name = 'DOJO Finance' then 'DOJO Finance'
    when project_name = 'PUMPOPOLY' or project_name = 'Pumpopoly' or project_name = 'pumpopoly' then 'Pumpopoly'
    when project_name = 'Secret Skellies Society' or project_name = 'Secret Skellies Society (UTO)' then 'Secret Skellies Society'
    Last run: over 1 year agoAuto-refreshes every 24 hours
    Type
    Date
    New User Count
    New User Growth Trends
    1
    		Total New Users2022-08-01 00:00:00.000612003347911
    2
    		New User for PlayEmber Project2023-08-01 00:00:00.000238412709301
    3
    		Total New Users2022-03-01 00:00:00.0008961883023456
    4
    		Total New Users2022-10-01 00:00:00.0005767624948932
    5
    		Total New Users2023-06-01 00:00:00.0002752097392685
    6
    		New User for PlayEmber Project2022-10-01 00:00:00.0001978419784
    7
    		Total New Users2021-03-01 00:00:00.0001234046557
    8
    		Total New Users2022-07-01 00:00:00.000839673286711
    9
    		Total New Users2021-09-01 00:00:00.000405104964726
    10
    		New User for PlayEmber Project2023-05-01 00:00:00.00018720211997
    11
    		Total New Users2021-02-01 00:00:00.0001157234217
    12
    		Total New Users2021-04-01 00:00:00.00084093130650
    13
    		New User for PlayEmber Project2023-12-01 00:00:00.00012899412539395
    14
    		Total New Users2020-10-01 00:00:00.00034236903
    15
    		Total New Users2023-08-01 00:00:00.0007234018526759
    16
    		New User for PlayEmber Project2023-01-01 00:00:00.00027321111720
    17
    		Total New Users2021-05-01 00:00:00.00055364186014
    18
    		Total New Users2021-12-01 00:00:00.0004315921966583
    19
    		New User for PlayEmber Project2023-03-01 00:00:00.00028884162080
    20
    		Total New Users2021-07-01 00:00:00.00061434370392
    59
    4KB
    645s