[PT]
A HiveBR e a SkateHive marcaram presença em peso na Blockchain Rio para prestigiar o stand da Hive e ajudar nossos amigos, e claro, não poderíamos deixar de nos perguntar: quantos novos usuários conseguimos trazer para a Hive durante o evento?
Com essa curiosidade em mente, decidimos utilizar o HiveSQL para monitorar o impacto do evento em termos de onboardings. Para quem não conhece, HiveSQL é um banco de dados disponível de forma pública que contém todos os dados da Hive, podendo assim, ser utilizado para os mais diversos fins por meio de consultas SQL.
Com o apoio dos membros @shiftrox e @vaipraonde, extraímos os dados e, junto com a colaboração de todos que estiveram no evento, conseguimos filtrar e identificar as contas criadas durante os dias do evento.
Resultados do Onboarding
O evento ocorreu entre os dias 24 e 25 de julho de 2024, e os dados do HiveSQL mostram um aumento considerável na criação de contas durante esse período:
- 2024-07-24: 136 novas contas
- 2024-07-25: 143 novas contas
Comparando com os dias anteriores e posteriores, esses números destacam claramente o impacto da nossa participação na Blockchain Rio.
Após filtrar as contas criadas nesse período, conseguimos identificar um total de 55 contas criadas por pessoas que estavam no evento realizando assim o onboarding delas.
Além disso, tivemos usuários que fizeram o download do Hive Keychain (@keychain), mas que provavelmente ainda não criaram suas contas, estamos sempre tentando entrar em contato e prover todo o apoio necessário para chamar a atenção deles e mostrar todos os benefícios que a Hive têm.
O Desafio Agora é Reter Esses Usuários
O resultado foi positivo, mas agora vem a parte mais desafiadora: reter esses novos usuários na plataforma.
Precisamos garantir que eles se sintam bem-vindos e engajados, ajudando-os a explorar o vasto ecossistema da Hive e descobrir como podem se beneficiar dele.
Estamos abertos a sugestões de toda a comunidade! Como podemos melhor apoiar esses novos membros e garantir que eles continuem ativos e contribuintes na Hive?
O que podemos oferecer para facilitar essa jornada inicial?
A #hivebr já preparou alguns tutoriais e posts para ajudar os novos usuários a iniciar sua jornada pela Hive. Esses tutoriais se encontram em nossa Comunidade, aqui na Hive e no canal #Tutoriais em nosso Discord.
Caso você não seja familiarizado com o Discord, temos também um grupo de Whatsapp, com muitos membros, onde podemos conversar, interagir e tirar dúvidas.
Vamos aproveitar essa oportunidade e transformar esses números em membros duradouros e ativos na nossa comunidade.
Afinal, a força da Hive está no seu coletivo, e juntos podemos alcançar ainda mais!
Dados do HiveSQL
| Date | Account Created | Event Day |
|---|---|---|
| 2024-07-01 | 130 | |
| 2024-07-02 | 136 | |
| 2024-07-03 | 139 | |
| 2024-07-04 | 103 | |
| 2024-07-05 | 105 | |
| 2024-07-06 | 90 | |
| 2024-07-07 | 62 | |
| 2024-07-08 | 108 | |
| 2024-07-09 | 102 | |
| 2024-07-10 | 111 | |
| 2024-07-11 | 153 | |
| 2024-07-12 | 97 | |
| 2024-07-13 | 317 | |
| 2024-07-14 | 74 | |
| 2024-07-15 | 108 | |
| 2024-07-16 | 114 | |
| 2024-07-17 | 119 | |
| 2024-07-18 | 97 | |
| 2024-07-19 | 109 | |
| 2024-07-20 | 112 | |
| 2024-07-21 | 65 | |
| 2024-07-22 | 123 | |
| 2024-07-23 | 83 | |
| 2024-07-24 | 136 | * |
| 2024-07-25 | 143 | * |
| 2024-07-26 | 126 | |
| 2024-07-27 | 97 | |
| 2024-07-28 | 111 | |
| 2024-07-29 | 126 | |
| 2024-07-30 | 135 | |
| 2024-07-31 | 138 |
| id | name | last_account_update | created |
|---|---|---|---|
| 2511127 | vanessabarrostec | 2024-07-25 14:41:21 | 2024-07-25 14:35:15 |
| 2511036 | ddrika | 1970-01-01 0:00:00 | 2024-07-24 20:25:57 |
| 2511162 | matheusluciano | 2024-07-25 19:02:39 | 2024-07-25 18:57:48 |
| 2511020 | ee21 | 1970-01-01 0:00:00 | 2024-07-24 18:33:21 |
| 2511118 | lulandim | 2024-07-25 14:02:45 | 2024-07-25 13:52:30 |
| 2510973 | starkerztesttt | 1970-01-01 0:00:00 | 2024-07-24 11:50:12 |
| 2511124 | victorestevao | 2024-07-25 14:45:21 | 2024-07-25 14:13:51 |
| 2510959 | kafi-19 | 2024-07-30 15:26:30 | 2024-07-24 9:53:42 |
| 2511052 | becopro | 2024-07-29 3:21:21 | 2024-07-25 0:36:09 |
| 2511053 | klarakopi | 2024-08-07 21:48:27 | 2024-07-25 0:41:24 |
| 2511002 | rafaelpcoelho | 2024-07-27 0:59:21 | 2024-07-24 15:11:15 |
| 2511189 | ambersinoh96 | 1970-01-01 0:00:00 | 2024-07-25 21:18:51 |
| 2511181 | beatrixcris | 2024-07-26 14:26:27 | 2024-07-25 20:50:18 |
| 2511174 | caguinhas | 1970-01-01 0:00:00 | 2024-07-25 20:24:30 |
| 2510991 | danielpatriota | 1970-01-01 0:00:00 | 2024-07-24 13:45:03 |
| 2511037 | caiosantosdev | 1970-01-01 0:00:00 | 2024-07-24 20:26:12 |
| 2510978 | edmundotesttt | 1970-01-01 0:00:00 | 2024-07-24 12:00:06 |
| 2511038 | jorgel | 1970-01-01 0:00:00 | 2024-07-24 20:31:18 |
| 2511054 | katiasuzue | 1970-01-01 0:00:00 | 2024-07-25 0:59:39 |
| 2511179 | mariachaves04 | 2024-07-26 17:12:45 | 2024-07-25 20:46:36 |
| 2511035 | mathamen | 1970-01-01 0:00:00 | 2024-07-24 20:25:18 |
| 2511171 | rafaellalondri | 1970-01-01 0:00:00 | 2024-07-25 20:15:39 |
| 2510917 | starkerztesty | 1970-01-01 0:00:00 | 2024-07-24 1:18:09 |
| 2511021 | stevemad | 1970-01-01 0:00:00 | 2024-07-24 18:43:09 |
| 2511033 | michellydepra | 1970-01-01 0:00:00 | 2024-07-24 20:15:12 |
| 2511015 | alexandregpf | 1970-01-01 0:00:00 | 2024-07-24 17:34:30 |
| 2511030 | aluren | 1970-01-01 0:00:00 | 2024-07-24 19:34:03 |
| 2511125 | dieguito9000 | 1970-01-01 0:00:00 | 2024-07-25 14:28:57 |
| 2510999 | giovannamatos | 1970-01-01 0:00:00 | 2024-07-24 14:38:27 |
| 2510988 | hernandesn | 1970-01-01 0:00:00 | 2024-07-24 13:11:21 |
| 2511135 | inessmaciel | 1970-01-01 0:00:00 | 2024-07-25 15:32:51 |
| 2510993 | katrinafrozen | 1970-01-01 0:00:00 | 2024-07-24 14:13:21 |
| 2511008 | klebersjunior | 1970-01-01 0:00:00 | 2024-07-24 16:25:36 |
| 2511121 | larissaperc | 1970-01-01 0:00:00 | 2024-07-25 14:04:12 |
| 2511201 | marlus | 1970-01-01 0:00:00 | 2024-07-26 1:45:39 |
| 2511009 | mateuaxia | 1970-01-01 0:00:00 | 2024-07-24 16:27:36 |
| 2511143 | nameless97 | 1970-01-01 0:00:00 | 2024-07-25 16:37:33 |
| 2511152 | rocelo | 1970-01-01 0:00:00 | 2024-07-25 17:22:30 |
| 2511167 | tatilika | 1970-01-01 0:00:00 | 2024-07-25 19:30:39 |
| 2511166 | wallace790 | 1970-01-01 0:00:00 | 2024-07-25 19:29:57 |
| 2511187 | amnia | 1970-01-01 0:00:00 | 2024-07-25 21:08:24 |
| 2511005 | dcm1999 | 1970-01-01 0:00:00 | 2024-07-24 15:38:45 |
| 2511001 | dorabertoni | 1970-01-01 0:00:00 | 2024-07-24 15:10:45 |
| 2511130 | ivanova93 | 1970-01-01 0:00:00 | 2024-07-25 15:01:54 |
| 2510909 | jonsnowtest3 | 1970-01-01 0:00:00 | 2024-07-23 22:13:39 |
| 2511032 | vasylltr | 1970-01-01 0:00:00 | 2024-07-24 19:58:54 |
| 2511050 | xvlad666 | 1970-01-01 0:00:00 | 2024-07-24 23:49:06 |
| 2511188 | betacrissouza | 1970-01-01 0:00:00 | 2024-07-25 21:18:03 |
| 2511170 | luksousaw | 1970-01-01 0:00:00 | 2024-07-25 20:07:09 |
| 2511160 | vncsvr | 2024-07-27 23:57:48 | 2024-07-25 18:45:06 |
| 2511204 | fradomnt | 1970-01-01 0:00:00 | 2024-07-26 1:57:33 |
| 2511024 | laribf | 2024-07-31 21:30:24 | 2024-07-24 19:04:33 |
| 2511057 | dieguin | 1970-01-01 0:00:00 | 2024-07-25 1:41:36 |
| 2511205 | byronmendes | 1970-01-01 0:00:00 | 2024-07-26 2:02:30 |
| 2510916 | aister88 | 2024-08-08 14:08:12 | 2024-07-24 1:11:12 |
Confira algumas foto tiradas no evento da Blockchain Rio!
 |  |  |
|---|---|---|
 |  |  |
 |  |  |
 |  |  |
Capa: criada com Copilot.
[EN]
HiveBR and SkateHive were in full attendance at Blockchain Rio to honor Hive's Strand and help our friends, and of course, we couldn't help but wonder: how many new users did we manage to bring to Hive during the event?
With this curiosity in mind, we decided to use HiveSQL to monitor the impact of the event in terms of onboardings. For those who don't know, HiveSQL is a publicly available database that contains all of Hive's data, and can therefore be used for a variety of purposes through SQL queries.
With the support of members @shiftrox and @vaipraonde, we extracted the data and, together with the collaboration of everyone who was at the event, we were able to filter and identify the accounts created during the days of the event.
Onboarding Results
The event took place between July 24th and 25th, 2024, and HiveSQL data shows a considerable increase in account creation during this period:
- 2024-07-24: 136 new accounts
- 2024-07-25: 143 new accounts
Compared to the days before and after, these numbers clearly highlight the impact of our participation in Blockchain Rio.
After filtering the accounts created during this period, we were able to identify a total of 55 accounts created by people who were at the event and were onboarding them.
In addition, we had users who downloaded Hive Keychain (@keychain), but who probably haven't created their accounts yet. We are always trying to get in touch and provide all the support necessary to get their attention and show them all the benefits that Hive has to offer.
The Challenge Now Is Retaining These Users
The results have been positive, but now comes the most challenging part: retaining these new users on the platform.
We need to make sure they feel welcome and engaged, helping them explore the vast Hive ecosystem and discover how they can benefit from it.
We welcome suggestions from the entire community! How can we best support these new members and ensure they remain active and contributing to Hive?
What can we offer to make this initial journey easier?
#hivebr has already prepared some tutorials and posts to help new users start their journey through Hive. These tutorials can be found in our Community, here on Hive and in the #Tutoriais channel on our Discord.
In case you are not familiar with Discord, we also have a WhatsApp group, with many members, where we can chat, share curiosities and ask questions.
Let's take advantage of this opportunity and turn these numbers into lasting and active members of our community.
After all, Hive's strength lies in its collective, and together we can achieve even more!
Raw data from HiveSQL
| Data | Contas Criadas | Dias do Evento |
|---|---|---|
| 2024-07-01 | 130 | |
| 2024-07-02 | 136 | |
| 2024-07-03 | 139 | |
| 2024-07-04 | 103 | |
| 2024-07-05 | 105 | |
| 2024-07-06 | 90 | |
| 2024-07-07 | 62 | |
| 2024-07-08 | 108 | |
| 2024-07-09 | 102 | |
| 2024-07-10 | 111 | |
| 2024-07-11 | 153 | |
| 2024-07-12 | 97 | |
| 2024-07-13 | 317 | |
| 2024-07-14 | 74 | |
| 2024-07-15 | 108 | |
| 2024-07-16 | 114 | |
| 2024-07-17 | 119 | |
| 2024-07-18 | 97 | |
| 2024-07-19 | 109 | |
| 2024-07-20 | 112 | |
| 2024-07-21 | 65 | |
| 2024-07-22 | 123 | |
| 2024-07-23 | 83 | |
| 2024-07-24 | 136 | * |
| 2024-07-25 | 143 | * |
| 2024-07-26 | 126 | |
| 2024-07-27 | 97 | |
| 2024-07-28 | 111 | |
| 2024-07-29 | 126 | |
| 2024-07-30 | 135 | |
| 2024-07-31 | 138 |
| id | name | last_account_update | created |
|---|---|---|---|
| 2511127 | vanessabarrostec | 2024-07-25 14:41:21 | 2024-07-25 14:35:15 |
| 2511036 | ddrika | 1970-01-01 0:00:00 | 2024-07-24 20:25:57 |
| 2511162 | matheusluciano | 2024-07-25 19:02:39 | 2024-07-25 18:57:48 |
| 2511020 | ee21 | 1970-01-01 0:00:00 | 2024-07-24 18:33:21 |
| 2511118 | lulandim | 2024-07-25 14:02:45 | 2024-07-25 13:52:30 |
| 2510973 | starkerztesttt | 1970-01-01 0:00:00 | 2024-07-24 11:50:12 |
| 2511124 | victorestevao | 2024-07-25 14:45:21 | 2024-07-25 14:13:51 |
| 2510959 | kafi-19 | 2024-07-30 15:26:30 | 2024-07-24 9:53:42 |
| 2511052 | becopro | 2024-07-29 3:21:21 | 2024-07-25 0:36:09 |
| 2511053 | klarakopi | 2024-08-07 21:48:27 | 2024-07-25 0:41:24 |
| 2511002 | rafaelpcoelho | 2024-07-27 0:59:21 | 2024-07-24 15:11:15 |
| 2511189 | ambersinoh96 | 1970-01-01 0:00:00 | 2024-07-25 21:18:51 |
| 2511181 | beatrixcris | 2024-07-26 14:26:27 | 2024-07-25 20:50:18 |
| 2511174 | caguinhas | 1970-01-01 0:00:00 | 2024-07-25 20:24:30 |
| 2510991 | danielpatriota | 1970-01-01 0:00:00 | 2024-07-24 13:45:03 |
| 2511037 | caiosantosdev | 1970-01-01 0:00:00 | 2024-07-24 20:26:12 |
| 2510978 | edmundotesttt | 1970-01-01 0:00:00 | 2024-07-24 12:00:06 |
| 2511038 | jorgel | 1970-01-01 0:00:00 | 2024-07-24 20:31:18 |
| 2511054 | katiasuzue | 1970-01-01 0:00:00 | 2024-07-25 0:59:39 |
| 2511179 | mariachaves04 | 2024-07-26 17:12:45 | 2024-07-25 20:46:36 |
| 2511035 | mathamen | 1970-01-01 0:00:00 | 2024-07-24 20:25:18 |
| 2511171 | rafaellalondri | 1970-01-01 0:00:00 | 2024-07-25 20:15:39 |
| 2510917 | starkerztesty | 1970-01-01 0:00:00 | 2024-07-24 1:18:09 |
| 2511021 | stevemad | 1970-01-01 0:00:00 | 2024-07-24 18:43:09 |
| 2511033 | michellydepra | 1970-01-01 0:00:00 | 2024-07-24 20:15:12 |
| 2511015 | alexandregpf | 1970-01-01 0:00:00 | 2024-07-24 17:34:30 |
| 2511030 | aluren | 1970-01-01 0:00:00 | 2024-07-24 19:34:03 |
| 2511125 | dieguito9000 | 1970-01-01 0:00:00 | 2024-07-25 14:28:57 |
| 2510999 | giovannamatos | 1970-01-01 0:00:00 | 2024-07-24 14:38:27 |
| 2510988 | hernandesn | 1970-01-01 0:00:00 | 2024-07-24 13:11:21 |
| 2511135 | inessmaciel | 1970-01-01 0:00:00 | 2024-07-25 15:32:51 |
| 2510993 | katrinafrozen | 1970-01-01 0:00:00 | 2024-07-24 14:13:21 |
| 2511008 | klebersjunior | 1970-01-01 0:00:00 | 2024-07-24 16:25:36 |
| 2511121 | larissaperc | 1970-01-01 0:00:00 | 2024-07-25 14:04:12 |
| 2511201 | marlus | 1970-01-01 0:00:00 | 2024-07-26 1:45:39 |
| 2511009 | mateuaxia | 1970-01-01 0:00:00 | 2024-07-24 16:27:36 |
| 2511143 | nameless97 | 1970-01-01 0:00:00 | 2024-07-25 16:37:33 |
| 2511152 | rocelo | 1970-01-01 0:00:00 | 2024-07-25 17:22:30 |
| 2511167 | tatilika | 1970-01-01 0:00:00 | 2024-07-25 19:30:39 |
| 2511166 | wallace790 | 1970-01-01 0:00:00 | 2024-07-25 19:29:57 |
| 2511187 | amnia | 1970-01-01 0:00:00 | 2024-07-25 21:08:24 |
| 2511005 | dcm1999 | 1970-01-01 0:00:00 | 2024-07-24 15:38:45 |
| 2511001 | dorabertoni | 1970-01-01 0:00:00 | 2024-07-24 15:10:45 |
| 2511130 | ivanova93 | 1970-01-01 0:00:00 | 2024-07-25 15:01:54 |
| 2510909 | jonsnowtest3 | 1970-01-01 0:00:00 | 2024-07-23 22:13:39 |
| 2511032 | vasylltr | 1970-01-01 0:00:00 | 2024-07-24 19:58:54 |
| 2511050 | xvlad666 | 1970-01-01 0:00:00 | 2024-07-24 23:49:06 |
| 2511188 | betacrissouza | 1970-01-01 0:00:00 | 2024-07-25 21:18:03 |
| 2511170 | luksousaw | 1970-01-01 0:00:00 | 2024-07-25 20:07:09 |
| 2511160 | vncsvr | 2024-07-27 23:57:48 | 2024-07-25 18:45:06 |
| 2511204 | fradomnt | 1970-01-01 0:00:00 | 2024-07-26 1:57:33 |
| 2511024 | laribf | 2024-07-31 21:30:24 | 2024-07-24 19:04:33 |
| 2511057 | dieguin | 1970-01-01 0:00:00 | 2024-07-25 1:41:36 |
| 2511205 | byronmendes | 1970-01-01 0:00:00 | 2024-07-26 2:02:30 |
| 2510916 | aister88 | 2024-08-08 14:08:12 | 2024-07-24 1:11:12 |
Cover: created with Copilot