SUT - Steemit New User Tracking Hosting Cost and Usage

in Steemit Dev Group4 years ago

Steemit New User Tracking (#SUT)

As I am working and maintaining the Steemit New User Tracking application on Microsoft Azure, It uses Steem Blockchain Condensor API to pull the data and process/display as per #SUT user interface. I would like to share an update on it's hosting cost and usage for the last 2 months i.e. November and December 2020.

#SUT application URL: https://steemut.azurewebsites.net

Hosting Details & Cost till December 31st, 2020.

Steemit New User Tracking is hosted on Microsoft Azure, below is the Azure resources list which is used to run the application.

  • SteemitNewUserJob (background job runs daily)
  • SteemUserTracking SQL Database
  • SteemSQL - SQLServer
  • SteemUT - App Service
  • Steem - Resource group

image.png
Azure Resources Screenshot

image.png
Azure Resources Cost till December 31st, 2020

So actual hosting cost till date is 811 INR (appx. USD 11) and the forecast till December end is 922 INR (appx. USD 12.8). I am also regularly monitoring the application and background job to make sure the application is up and running and also fixing bugs from time to time.

Application Usage: Google Analytics Report

image.png
SUT: Page Views

image.png
SUT: User Stats New Vs Returning

image.png
SUT: Visitors Country-Wise


I am continuously working on enhancing the features of #SUT and trying to make it useful for the Steem Greeter Team, I have added active/dormant users list of India and Sri Lanka already here.

I will update this list with the remaining countries Newcomers soon.

That was all the updates related to the Steemit New User Tracking application hosting and usage.

Thank you!

Cc:-
@steemitblog
@steemcurator01
@steemcurator02

Thank you Steemit team for providing me the opportunity to work on this application and for your continuous support.

**Note: All the screenshots are taken from Steemit New User Tracking application and Azure hosting account which is managed by me.

Sort:  

May I ask if STEEMSQL still works? I tried to connect but failed.

Hi @neerajkr03.
So, lately, I was looking at one of the APIs provided by justyy that tracks new user accounts. There seems to be some data mismatch between the two.

Screenshot 2020-12-22 at 12.39.32 PM.png
The API provided by justyy | The total count for today is 60 so far on 22-12-2020

Screenshot 2020-12-22 at 12.40.06 PM.png
The new accounts as listed on the SUT web page for 22-12-2020

So, I think the design is to run a background job once every day to update the database of new users. This would mean that the correct number would be updated tonight correct?

However, the count of new users for the date 21-12-2020 also seems to be incorrect.

Screenshot 2020-12-22 at 12.39.47 PM.png
Raw XML response from justyy's API for 21-12-2020 shows 257 new accounts

Screenshot 2020-12-22 at 12.40.24 PM.png
Count on the SUT webapp is only 44

Is there some logic that's filtering out some accounts? Or is this a bug? Please have a look at this once.

#onepercent #india #affable

Yes, there is a filter added in #SUT to show only accounts that has published at least 1 blog/post so that on genuine account Steem Greeter team could comment/reply or guide with instructions so that new users could follow the right path from the beginning.

Thank you for your query.

Great to know. :-)

Great work, hope this vote will help cover the costs.

Thank you

Thank you, Steemit team.

Yes, this vote is very helpful.

Thank you for your continuous work on this project.

Thank you so much!

I am going bit slow but will certainly cover more features, countries in #SUT one by one.

Thank you for your work on steem greeters project.

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 , Better Life, etc. Also keep engaging with others to win #onepercent & #twopercent votes

Coin Marketplace

STEEM 0.19
TRX 0.14
JST 0.030
BTC 62740.92
ETH 3354.24
USDT 1.00
SBD 2.46