✨Introduction

Social networking on NEAR wasn't developed from the ground up. The original version of the platform was hosted on Mastodon, an open-source platform for managing one's own social networking site. To communicate and interact with those around them, people could use their near wallets. As a result of its single point of failure and inability to withstand censorship, Evgeny and the NEAR social team quickly realized that this was not a viable long-term solution.

The project began as an attempt to create a database to host social interactions (SocialDB), but it has since grown into a platform where members of the NEAR ecosystem can experiment with a decentralized, open-source alternative to Twitter.

🛠️ Methodology

I have created a multi-page dashboard to analyze the activities of NEAR Social's users, such as creating and editing profiles, sharing posts and comments, and reacting to them with likes, dislikes, and pokes.

To extract this information, I parsed the NODE_DATA column in the social table of the NEAR database on FS. For instance, to identify profile creations, I counted the first transactions of users in the near.social.fact_decoded_actions table. To find profile edits, I counted the second and subsequent transactions of users in the same table.

I used different methods to discover other types of activities. For example, I looked for the 'post' node in the main and comments states to differentiate between main posts and regular comments. I also used the pattern 'Node ilike '%widget%'' to detect widget creation transactions. Finally, I searched for the 'index' node in the main and comments states to find user interactions such as liking, disliking, and poking other users' posts and comments.

In the dashboard, I presented the top users based on the number of comments, likes, and widgets they created. I also included insights on profile creations and edits, post creations and responses, follows and unfollows, and widget creation, usage, and reusability.

I hope this methodology helps you better understand the procedure of creating this dashboard and allows you to know the activities happening on NEAR Social.

Data set to refresh once every 24h

✍🏻 Conclusion

From the all pages findings, it can be concluded that both NEAR and the social platform analyzed have high levels of activity and engagement. The NEAR network has seen a smooth increase in profile updating, with users showing interest in creating visually appealing profiles and customizing the look and feel of their profiles. This trend can be leveraged by NEAR to encourage further adoption and engagement on the network.

The social platform analyzed has also experienced growth, with an increasing number of shared posts over time. The sudden increase in main posts on March 3rd suggests a possible change in user behavior or introduction of new incentives by the platform. Main posts have received more engagement than comments, with a significant number of likes and few dislikes.

Furthermore, the charts and data highlight that users of the social platform are interested in providing more information about themselves and their projects on their profiles, and are using Linktree to share additional links and resources with their audience. This insight can be used by the platform to develop new features that cater to user needs.

Overall, these findings suggest that both NEAR and the social platform analyzed are growing and attracting active users who are interested in engaging with the platforms and creating content. Understanding user behavior and preferences can be valuable for these platforms to introduce new features and incentives that drive engagement and growth.

Hey there 👋!

Firstly, I appreciate you sticking with it until the conclusion.

I'm Hamed, a civil engineering Ph.D.

student interested in data analysis.

I've made many similar dashboards and visualizations since I started at Flipside in January.

Please take a look at my various contact details and let me know what you think.

About:

• Author: HaM☰d

• Discord: 0xHaM☰d#8391

• Twitter: @arjmandi_hamed

• Email: h_arjmandi2012@yahoo.com

🔎 Findings:

Based on the visuals presented on this page, we can see that NEAR Social has over 3.5K unique profiles created to date, out of which 961 have been edited. The users of NEAR Social have shared over 3.71K posts and 2.38K comments, and have also created about 2K widgets to date.

The charts also provide insights into the daily count of profile creations and the distribution of assessed metrics over time. We can observe that the dominance of profile creations was the highest until the third week of December last year, after which the users started sharing more posts and putting more comments on others' posts.

Interestingly, the highest point for both profile creations and sharing posts was on March 5th, making it the busiest day for NEAR Social network.

These findings provide us with a comprehensive understanding of the activities happening on NEAR Social and how they have evolved over time. It also indicates that the platform is growing steadily and users are becoming more engaged with the content being shared on the network.

What are we looking at?

Activities happening on NEAR.Social in total and over time such as:

• Profile creations, edits
• Post creations, responses
• Follows and unfollows
• Widget creation, usage and reusability

To acheive an valuable insight and find meaningful actions being recorded on-chain and to help map growth and adoption of NEAR social.