Can you do one of these on activity by sign up date?
It amazes me that sooo many people sign up and then do nothing with the account.
I wonder if that percentage has remained constant over the 5 years.
Arcange is showing that inactives are growing as a share of signups.
!PIZZA
Posted Using LeoFinance Beta
@antisocialist! I sent you a slice of $PIZZA on behalf of @cooperclub.
Learn more about $PIZZA Token at hive.pizza (3/20)
Not sure what you mean, something like share of new active account by time?
This will be dynimic...
More, signed up by month still active.
How many are still here from the initial wave and any subsequent waves?
Which signup months are most/least active?
I guess you could do since the hf to hive, but I'm curious how many of the first 100k accounts still interact.
I think we will show a hardcore from 2016 still here and active, but any months that stand out since will give them something to be proud of, if they signed up during that month.
Or, if they signed up in a least active month but persevere as a stand out.
If a user signed up in July 2020, was active till March 2021, but not active in June 2021, will this be inactive user? If we use the last month to determain activity. Then in August 2021 the user might become active again. This is what I mean by dinamic ...
The other aproach will be, did the sign ups made any activity since the account was crrated.
Oh, ok, I see what you mean.
I think I would use 90 days to be inactive.
I guess numbers of accounts that take a 90 day break and return to be active later can be known?
My bet is most 90 day inactive accounts rarely return, but maybe you can show those numbers, too.
Perhaps the type of transactions have an effect, too.
Of those that made a post (since the fork to hive?), and were active for XX days, XX are currently active.
Those that only made jsons for XX days and are still currently active.
Maybe show the average number of days it takes for formerly active accounts to become inactive?
How many were active for at least XX days and went on to be active XX days later.
Does that help?
If an account was active for 30/60/90 days, then took a minimum 30/60/90 day break, how many are currently active in the last 90 days?
What is the longest inactive streak to come back and be active in the last 30 days?
What are the accounts with the least inactive days?
Which accounts are the most active across the various columns?
Json, transfers, posts, comments, etc.