SUT - Steemit New User Tracking - Newcomers Active/Dormant Stats on Single ClicksteemCreated with Sketch.

Steemit New User Tracking(#SUT)

As I am currently working on the New User Tracking related features. I would like to share an update on Newcomers' active/dormant list feature and details display on a single click.

Steemit New User Tracking Url - https://steemut.azurewebsites.net

Background and Uses Case

Steem Greeter team/country representatives could quickly check the list of newcomers along with total users, active, and dormant users count on a single click. This feature will avoid manual checks which are currently performed by CRs to prepare the active/dormant users weekly/monthly reports. It would also help in quickly analyze and in taking corrective action with help of these stats.


Development Update

Newcomers' active/dormant list feature currently in the development phase, I am working on it part-time from past few days. I have designed the solution and approach and very close to make this feature live so that the Steem Greeter team/country representatives could start using it.

Currently, I am implementing this for India and after that, this feature will be available for all countries to check active/dormant users with details on a single click.

Below is the current User Interface, I will improve the UI once other countries newcomers stats will be added.

image.png

Newcomers list with total, active and dormant users list - India

Newcomers data import to #SUT SQL database

Newcomers account name with their country details will be imported only first time and after that background job will keep updating the user record by checking their latest blog post or replies with the timestamp. New user we can keep adding to the system through a user interface (to be developed). I have referred the Steem Greeter sheet to pull the Indian Steemit users account and imported it into #SUT.

image.png

Newcomers list in CSV format | Initial data import

Updating Users Last Post and Root Post timestamp in SQL database

image.png

Background job to keep updating the user account last post timestamp based on their activity on Steemit

Displaying Newcomers stats and list sorted by last post date time on UI.

image.png

Next Steps:

  • Deploy this feature on production/live #SUT application.
  • Import other countries Steem user accounts and display active/dormant stats.
  • UI to add new users in the future to track active/dormant stats with updated users list.

The next set of activities will be defined later once the above is accomplished.


That was all the updates related to the Steemit New User Tracking application active/dormant users feature. I would really appreciate any feedback/suggestions on this.

Thank you!

Cc:-
@steemitblog
@steemcurator01
@steemcurator02
@stephenkendal
@shortsegments
@cryptokannon
@rishabh99946
@sapwood

**Note: All the screenshots are taken from the Steemit New User Tracking application (development environment) which is managed by me.


The post payout is set to "Power Up 100%".

Sort:  

Newcomers account name with their country details will be imported only first time and after that background job will keep updating the user record by checking their latest blog post or replies with the timestamp. New user we can keep adding to the system through a user interface (to be developed). I have referred the Steem Greeter sheet to pull the Indian Steemit users account and imported it into #SUT.

Hi @neerajkr03 thank you for taking the time aside to develop this useful tool.
From your statement above, at first, we will have to pull out the data from the steem greeter spreadsheet that we have now into this #SUT system right? Then after you finish with the UI newcomers feature, we greeters can key in their data directly into the system? Steemit team mentions the country information, we will have to find out that from their introduction post tag? as some newcomers forgot to put their country tag on their achievement 1/introduction post sometimes, or will this system pull that info automatically? (not sure how the system will do this as it sounds impossible, maybe through their IP address?)

Can we transfer the data from this system into HTML/markdown format so we can present it to our biweekly/monthly report? or can we transfer out to a google spreadsheet/excel for making statistic data? or will this system will have that statistic data feature too(maybe this is too much to ask,haha)? 😄

Hi @cryptokannon,

at first, we will have to pull out the data from the steem greeter spreadsheet that we have now into this #SUT system right?

I will take care of this initial/first time users account import from the steem greeter spreadsheet (accounts mentioned till date). After that, the new user account who completes the achievement task 1 can be added from #SUT user interface to this tool.

Then after you finish with the UI newcomers feature, we greeters can key in their data directly into the system?

Yes, that's the goal. Newcomers records can be edited and added by the steem greeter team on this #SUT tool.

Steemit team mentions the country information, we will have to find out that from their introduction post tag? as some newcomers forgot to put their country tag on their achievement 1/introduction post sometimes, or will this system pull that info automatically?

I think yes, we need to find out from the users introduction post. Fetching the country name using IP address can be done only by the Steemit engineering team as that type of data is not available for me I think. Also, nowadays many users are using proxy which routes the IP from different countries so I think fetching user's country names using their IP address may not be always correct.

I will you updated on the development.

Thank you.

Looking forward to seeing the new system in action.

How will you pick up the Country - just from the Profile?

Will it be editable as more information becomes available?

Thank you

The Steemit Team

Thank you Steemit team for reviewing this.

Currently, I am taking/importing the country name from the Steem Greeter team's newcomers spreadsheet. This feature is mainly to track newcomers (active/dormant) who have completed at least achievement task 1 of the newcomers achievement program.

The other tab in the #SUT application is for all new users (valid and spam) who are signing up on Steemit. For these accounts, I think there is only option to pick the country using Steem Profile API. I have observed that many newly signed up users don't add country information in their profile section. Please let me know if there is another way to pick up the country details for newly signed up users.

Yes, these records are editable and we can add more information and save it.

Thank you.

Manual addition of country when known will be the main option maybe.

Yes, we will add manually when known. I will publish a how to use post also once this feature is deployed on production.

You have been upvoted by @sapwood A Country Representative from INDIA I am voting with the Steemit Community Curator @steemcurator07 account to support the newcomers coming into steemit.


Follow @steemitblog for the latest update on Steem Community and other writing challenges and contest such as The diary game Season 3, Spotlight on Poloniex Contest, Better Life, etc. Also keep engaging with others to win #onepercent & #twopercent votes.

Thanks for the update.It has been very helpful

wow it is great update to know about Steemit New User Tracking, best of luck dear @neerajkr03 i think in first process using country tag will be helpful to find country detail then manual check profile area,, i think at the time of sign up , for new commer , country name should be appear auto on profile , at the sign up ,, best of luck dear for @neerajkr03

Your post is manually rewarded by the
World of Xpilar Community Curation Trail

join the World of Xpilar Curation Trail, info can be found here