The 90-9-1 Rule in Reality

Hello Mark,

Thanks again for the discussion.

Yes that is true, some register users can still visit the community without login. Did you activate the auto-login option in your community. I have that activated and everytime I come back to the community, it just automatically log me in, so that the times when I have to visit the community from another computer, that require me to login manually is actually very small fraction of the time. Maybe I should look at how many registered user actually leave this option on or turn it off.

I totally agree. Certainly that both cumulative and the point-in-time summaries have their own merit. But the subject of academic debate is whether the 90-9-1 rule pertains to the cumulative or the point-in-time. And it seems that the point-in-time data fits the 90-9-1 rule better--at least in our data. The data I presented actually uses a 60 day running window every week, even though I also analyze data using cumulative data as well as other window length. Despite that, the precise proportion of the 9:1 is still quite far off, and if I presented the cumulative data, the proportion will be even further off.

So the debate is not that whether the cumulative view has any more or less merit. It just means that if you use cumulative data, you shouldn't be surprised that they are way off from the 90-9-1 rule. And it is because the delicate balance that is required to maintain the 90:9:1 proportion is very difficult to achieve, even if they were true at any point in time, they will not be true when looking over an large window cumulatively. And since this calculation is about the 90-9-1 rule, I just like to point that out as a potential pitfall as some may not be aware of it.