3

How is total users given? If it is simply number of accounts that had ever been created, then it would be overestimate because there should be accounts that are inactive for a while, possibly abondoned. There are also users who log in each time with a different new account.

  • 5
    In what context? I guess you're asking about the top X% in the leagues? Then see Top 1% in profile page not useful, please don't count non users. – Arjan Apr 24 '11 at 7:36
  • @Arjan That is what I meant. I see the idea. But accounts that show no activity for certain period of time should also excluded. – sawa Apr 24 '11 at 16:00
  • 1
    for this we have "Top x% this month" and "Top x% this week" - the overall rank should take all accounts, even those who are not active for some time. – Shadow Apr 26 '11 at 13:52
  • @Shadow I see. That makes sense. Thanks. – sawa Apr 26 '11 at 14:05
1

The total users is the plain count of the number of rows found in the users table in SEDE. In Delete old, unloved, users you can find the rules that should be applied to remove users. Due to the backlog of deletions a lot of accounts that once where eligible for deletion are still around, at least on Stack Overflow and will be, forever: When will inactive accounts be deleted?. Lets only keep the established criteria then to decide on what an active user is.

So if we apply the deletion rules to the users table as found in the Stack Exchange Data Explorer we can can determine how many users from the total are to be considered active, by the Stack Exchange definition that is. Here is the query.

When run today you'll find:

# users                    # users if account deletion rules are applied 
---------                  --------------------------------------------- 
7,791,808                  3,151,339                                       

See how the 7 million figure is close to the current league numbers (also due to the fact SEDE just updated (on Sunday at 03:00 UTC)):

enter image description here

Notice that it can be important to leave out the inactive/ to be deleted accounts when doing statistics analysis: What is the median reputation level on Stack Overflow?

  • There is no more "to be deleted accounts": meta.stackexchange.com/a/48263/152859 – Shadow Oct 1 '17 at 13:17
  • @ShaWizDowArd thanks, I missed that memo. Edited it in. – rene Oct 1 '17 at 14:36
  • I tried your query for a few beta sites like Sustainability SE for example, but often I get a higher number for 'users if account deletion rules are applied' than for 'users'. Any idea why? – THelper Jan 24 '18 at 8:17
  • @THelper delete rules weren't applied for all the other sites. Fixed here – rene Jan 24 '18 at 8:58

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .