Welcome to the NEAR social user segmentation dashboard! This dashboard is designed to help you understand the behavior of new users on NEAR.social.

The first step in this dashboard is to segment users based on the date they created their profile. We extract the date of profile creation from the "near.social.fact_profile_changes" table and categorize users based on the month and year of creation. This information is presented in the next page.

Next, we analyze users' staking activities using data from the "near.core.dim_staking_actions" table. By aggregating the "amount" column and counting the "tx_hash" column for each user, we calculate the average amount staked and the average number of times staked. This information is presented on the thierd page.

The fourth page is dedicated to DEX swaps activities. We extract data from the "near.core.ez_dex_swaps" table and join it with the social users table using the "trader" and "signer_id" columns. To calculate the swap volume in $USD, we also use the "near.social.fact_profile_changes" table.

The sixth page analyzes bridging activities. We use queries on this dashboard to assess the most popular destination of transfer transactions, which we categorize by label type and project name. We extract this information from the "near.core.fact_transactions" and "near.core.dim_address_labels" tables.

Finally, we use queries on this dashboard to track the social activities of users who created their profile in a selected month. This information is presented on the last page.

Note: The dashboard has been set for March by default, but you can change it for your desired month's newcomers.

Data set to refresh once every 24 hours.

The Near Social was launched in October 2022, so the data are available since this month, but because of live queries and a 24-hour refresh rate, we consider other months for future viewers.

We hope you find this research useful and would appreciate your feedback.

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.

Date of profile creation: This refers to the date and time when a user created their profile on NEAR.social.

Staking history: This refers to the record of a user's staking activities on the NEAR blockchain. It includes information on the amount staked, the number of times staked, and the duration of each staking period.

Average amount staked: This is the average amount of tokens that a user has staked on the NEAR blockchain over a certain period of time.

Average number of times staking: This is the average number of times that a user has staked tokens on the NEAR blockchain over a certain period of time.

DEX swaps: This refers to the process of exchanging one token for another on a decentralized exchange (DEX) on the NEAR blockchain.

Swap volume: This is the total amount of tokens swapped on the NEAR blockchain, expressed in $USD.

Bridging activities: This refers to the process of transferring tokens from one blockchain to another, typically via a bridge. It includes information on the destination of the transfer, the type of bridge used, and the project name.

Social activities: This refers to the activities that users perform on NEAR.social, such as creating posts, commenting, liking, and following other users.