# How to measure active users?

**URL:** <https://meta.discourse.org/t/how-to-measure-active-users/74574>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [November 22, 2017, 9:39am UTC](https://meta.discourse.org/t/how-to-measure-active-users/74574 "2017-11-22T09:39:55Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![robmc](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/robmc/32/125900_2.png) [@robmc](https://meta.discourse.org/u/robmc)\
**Post date:** [November 23, 2017, 10:05am UTC](https://meta.discourse.org/t/how-to-measure-active-users/74574/8 "2017-11-23T10:05:13Z")

</div>

you could also get in touch with @DiscourseMetrics.com and @Bas (about Community Analytics)

their tools can give you loads of extra stats so you don’t have to do the work … I’m looking at such tools at the moment myself

Up till now I’ve been doing this just in excel - you can export your user data and run a few queries to monitor this. I gave a value to each post read, to posts (replies) and to new threads, then categorised them accordingly

So far it shows 20% are ‘readers’, 25% are ‘participants’ and 15% are ‘creators’

I’ve found that most analysis tools are under-valuing the role of readers because of a focus just on the activity of posting. There is a big difference between inactive members and active readers!

Good luck!

---

_[View the full topic](https://meta.discourse.org/t/how-to-measure-active-users/74574)._