Steemit New User Tracking feature - Proof of Concept - 2nd Update

Steemit New User Tracking

As I am currently working on Proof of Concept of the New User Tracking feature. I would like to share the updates on the same.

Tool Name

I am planning to give this tool name SUT - Steemit User Tracking because SCM will be maintained only for Steemit Contests.

^{Screenshot 1: New User's list page with post link and other information}

^{Screenshot 2: New User's list page with post link and other information}

Update 1: Steem blockchain & Justyy APIs

Thank you to Justyy for providing the API to pull the newly registered user's list (last 7 days)

• https://steemdata.justyy.workers.dev/?data=newaccounts
• condenser_api.get_blog - To pull the latest blog posted by user.
• condenser_api.get_accounts - To pull the user profile details

Some Code Snippet

^{Screenshot: Code Snippet to get the User profile details}

^{Screenshot: Code Snippet to pull the data and save it to SQL database}

Update 2: Getting the New Users list, their latest posts, and profile information

I am able to get the list of Newly Registered Steemit Users with help of APIs provided by Justyy and User's latest posts. I am still figuring out what sort of logic/algorithm I should write to remove the spam posts link.

The current list is big although I have excluded users who have not made any posts yet. There is a possibility that a few of them might publish their first post in few days so the program has to keep checking those users again if they make the first post even after 7 days of sign-up and display on this page.

Currently, I ran the program to pull the list and save all information to my development SQL database. The program ran for around 20 minutes to go through the list of all users, check their first blog, and to fetch their profile information. I need to run the program on daily basis as a background job in the production environment to keep the New User's list with their first blog link updated on #SUT.

I will keep enhancing this program but the current listing page will give details of new User accounts and their recent/latest post.

Update 3: SUT is using SQL Database

This program needs to store the information related to newly registered users, their first post, and profile details so the information is saved in the SQL database.

Next Steps:

• Deploy the currently developed #SUT on production (for testing) to take feedback from The Greeter Fairy Team and all team members.
• Write logic/algorithm to exclude the spam accounts/ posts from this list. I am still working on some logic which I will share once implemented and verified.
• Add pagination on Grid user interface as currently its loading huge data in the first load itself.
• Add Search parameters by account name and date to start with.
• Background Job to keep updating this New User's list on a daily basis.
• Add background job to keep checking New Users post in case they publish their first post after 7 days, maybe till 2 weeks.

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 feature. I would really appreciate any feedback/suggestions on this.

Thank you!

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

**Note: All the screenshots are taken from my development machine.

---

10% of the reward from this post will go to @bestofindia.

To know more about the Best of India community & its objective, visit this post