[📊 DATA] Existence + Time Since NEAR Social Profile Before Potlock Registration + Social Activity 🟠

[codingshot]

Description

• see existing social.near stats like date created, NEAR social profile, followers at time of registration and over time for project that has registered

Objective / Business Insight

• understand if profiles are already in ecosystem
• profiles that are prefilled out streamlined project creation
• see if reason to target profiles that are public goods account that already have near social profile
• later link activity of near social into frquency of donations

Acceptance Criterion

• data near social profile was created
• frequency and number of posts per account and date of project registration and date of social.near account
• see how many followers a project has had
• date between near social profile
• percentage of project reigstrations that already had near social profile

Data Sources

• social.near
• registry.potlock.near

Similar Queries

• [📊 DATA] Account Age When Project Registered 🟠 #4
• see if donors already have near social profile
• whether project has been making near social posts, whether those near social posts were through a twitter intergration like wormhol3

Challenges

Resources

How to Present

[Melissa-Zhou]

https://flipsidecrypto.xyz/melissa06029/2024-03-21-potlock-jidbDd
3/21 updated two graphs (Date vs New Accounts, Date vs Posts) and one table (User vs Date vs Posts)

[codingshot]

distinguish projects on registry from donors, distinguish donor types, will need to reapply this for detecting bots for nada bot. Also if you cna add account created
filter by users
date is associated to a post not all posts