# Visual forum statistics

**URL:** https://meta.discourse.org/t/visual-forum-statistics/34744
**Category:** Feature
**Tags:** completed
**Created:** [October 21, 2015, 3:49am UTC](https://meta.discourse.org/t/visual-forum-statistics/34744 "2015-10-21T03:49:48Z")
**Posts on this page:** 16
**Page:** 1

<div class="post-metadata">

### Author: ![dandv](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/dandv/32/169779_2.png) [@dandv](https://meta.discourse.org/u/dandv)
#### Post date: [October 21, 2015, 3:49am UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/1 "2015-10-21T03:49:49Z")

</div>

My old MyBB forum had a simple charting feature that showed the userbase size over time. It came in handy in this presentation I gave about the growth of the forum, where I overlaid certain events on the chart.

 ![](https://global.discourse-cdn.com/meta/original/3X/1/5/15d70a92264b01be150be448df5cd692a5c6870e.png)

`/admin/reports/signups` is a start, but less visually compelling.

Haven’t found [any plugins](https://meta.discourse.org/c/extensibility/plugin) that display charts, but they would be a nice visual addition to the Discourse dashboard:

- users over time
- posts and topics over time
- attachments over time
- [top posters](https://meta.discourse.org/t/first-post-badge/276674/2) / most active users (bar chart) - that kind of exists at [`/users`](http://meta.discourse.org/users)

[Daily/Monthly Active Users can be generated with Google Analytics](https://meta.discourse.org/t/daily-active-users-monthly-active-users-statistics-need/11957), but the process isn’t easy, and won’t cover any data retroactively (i.e. before installing GA), or from imported posts.

---

<div class="post-metadata">

### Author: ![Mytee](https://avatars.discourse-cdn.com/v4/letter/m/ee7513/32.png) [@Mytee](https://meta.discourse.org/u/Mytee)
#### Post date: [October 21, 2015, 7:09am UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/2 "2015-10-21T07:09:03Z")

</div>

This would be very handy! As a Community Manager, it matters a lot to have visual analytics.

---

<div class="post-metadata">

### Author: ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [October 21, 2015, 7:36am UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/3 "2015-10-21T07:36:55Z")

</div>

I’m a community manager too, and have such visual chart could be really handy,

---

<div class="post-metadata">

### Author: ![LeoMcA](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/leomca/32/87233_2.png) [@LeoMcA](https://meta.discourse.org/u/LeoMcA)
#### Post date: [October 28, 2015, 5:49pm UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/4 "2015-10-28T17:49:00Z")

</div>

A while back I started a plugin a bit like this for use on Mozilla’s Discourse instance called “Are we Discoursing yet?” (to fit in with a bit of a trend: [Areweyet - MozillaWiki](https://wiki.mozilla.org/Areweyet)), the result of which can be seen at [http://arewediscoursingyet.com/](http://arewediscoursingyet.com/)

 ![](https://global.discourse-cdn.com/meta/original/3X/6/7/676e9687da9a60ccce48ffea0b60e7617a687020.png)

I haven’t really found the time to do any more work on it recently, but the source is at: [GitHub - mozilla-cit/arewediscoursingyet: Are we Discoursing yet? · GitHub](https://github.com/Mozilla-cIT/arewediscoursingyet) (plugin is in `plugin` branch, frontend is in `gh-pages` branch).

At the moment it’s rather tailor made for Mozilla (and also rather badly made, it was only after I’d created it that I realised that Discourse was already creating exactly the stats I wanted…), and I doubt I’ll get round to improving it, let alone creating a general purpose plugin, anytime soon.

Of course, if somebody wants to jingle a bag of coins in front of my face that might change things.

---

<div class="post-metadata">

### Author: ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [December 6, 2015, 7:00pm UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/5 "2015-12-06T19:00:52Z")

</div>

I need these kind of statistics and graph:

- How many new users last months?
- How many posts? Against previous months!?
- How many logged in users?  
We have already such data, build up handy graphs should be pretty easy.

Smf and other forum tool have this charts and they’re pretty cool and useful, I’d like to use them with my stakeholders

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [December 6, 2015, 11:02pm UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/6 "2015-12-06T23:02:09Z")

</div>

These graphs mostly already exist, click through on the dashboard.

---

<div class="post-metadata">

### Author: ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [December 10, 2015, 8:53am UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/7 "2015-12-10T08:53:35Z")

</div>

Yes, but I can’t have a grpah as in the example given above!  
Discourse data and graph are good but not very useful because there aren’t aggregated data, for example new users/posts/topics/loggeduser by month or quarter could be enough. That data are very interesting and useful from the community perspective since I can use them as ROI 😄  
Export such data from reports and sum them after it’s not very handy.

Check also:  
[https://meta.discourse.org/t/show-total-amounts-on-reports-by-range/3502](https://meta.discourse.org/t/show-total-amounts-on-reports-by-range/3502)

---

<div class="post-metadata">

### Author: ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [December 14, 2015, 3:09pm UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/8 "2015-12-14T15:09:48Z")

</div>

Check something like this, IMHO I miss this data and a graph based on them

 ![](https://global.discourse-cdn.com/meta/original/3X/2/4/240fa20e2e9c48ed71ad4883851d695ca6df92f7.png)

---

<div class="post-metadata">

### Author: ![erlend\_sh](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/erlend_sh/32/119475_2.png) [@erlend\_sh](https://meta.discourse.org/u/erlend_sh)
#### Post date: [December 14, 2015, 4:16pm UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/9 "2015-12-14T16:16:53Z")

</div>

I would love something fairly close to the GitHub Contributors stats:

 ![](https://global.discourse-cdn.com/meta/original/3X/b/f/bfaa319957f36d0be3db4e85643ea7c1db1a8e63.png)

Imagine that with options for “Topics, posts, likes” etc., which could be shown all-at-once (with differently color-coded graphs) or individually. The simple date-range selector is also a wonderful feature.

I love checking out the GD Contributors tab, it tells stories. Look at these three for instance:

 ![](https://global.discourse-cdn.com/meta/original/3X/a/d/ad5bc33260203771c94badbce2a04f32ed461f9a.png)

What happened here? Did they just happily scratch their itch and that’s all there is to it, or did we do something wrong that deterred them from continuing to contribute?

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [December 15, 2015, 12:03am UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/10 "2015-12-15T00:03:43Z")

</div>

Not sure, you could email them to find out. Might be a good idea. (I think they just moved on to other stuff, which is usually the case.)

---

<div class="post-metadata">

### Author: ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [December 22, 2015, 7:07am UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/11 "2015-12-22T07:07:21Z")

</div>

> [@erlend\_sh](#):
>
> Did they just happily scratch their itch and that’s all there is to it, or did we do something wrong that deterred them from continuing to contribute?

Like this approach, as cmgr working hard on retention and keeping existing member active such informations are extremely useful!

---

<div class="post-metadata">

### Author: ![Mittineague](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mittineague/32/114259_2.png) [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [December 22, 2015, 8:32am UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/12 "2015-12-22T08:32:26Z")

</div>

I think any stats would need to be “broad trends”

A person might leave a forum for any of countless reasons. Health, family obligations, new employment etc. Real Life has a way of getting in the way and making one change course from time to time.

True, it may not always be a “lack of time” reason, one may leave because they are no longer interested in what is being discussed, maybe there is to much “noise” for their liking, maybe they found someplace they like better. (cough, Facebook)

And I’m not so sure contacting members for an “exit interview” would provide the true reasons or even be a good thing to do.

On the other hand, I do think that seeing an increase or decrease over time would _suggest_ how well a forum is doing. As long as it is remembered that - to steal from SEOers - correlation does not equal causation

---

<div class="post-metadata">

### Author: ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [December 23, 2015, 12:07am UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/13 "2015-12-23T00:07:30Z")

</div>

From my experience people leave just because they’re not interested so much in your community or only distracted by something else, so they forget to visit, join or be active.  
Mentioning them, sending a PM or asking their thoughts about a topic works pretty well in my case: retention is my primary goal currently.  
Have those data, graph or statistics help me to know who ping or how/where move forward.

---

<div class="post-metadata">

### Author: ![DavidGNavas](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/davidgnavas/32/68313_2.png) [@DavidGNavas](https://meta.discourse.org/u/DavidGNavas)
#### Post date: [January 4, 2016, 4:59pm UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/14 "2016-01-04T16:59:46Z")

</div>

> [@alefattorini](#):
>
> Check also:[https://meta.discourse.org/t/show-total-amounts-on-reports-by-range/3502](https://meta.discourse.org/t/show-total-amounts-on-reports-by-range/3502)

Perhaps that topic is restricted to tl3, i don’t have access to view it 😕

* * *

Btw, thanks to the [Data Explorer Plugin](https://meta.discourse.org/t/data-explorer-plugin/32566) and the query that @riking created, we have a great visualization of the interaction in our :discourse: instance.

[![](https://global.discourse-cdn.com/meta/original/3X/3/9/39b31332ba376814335437f8ca011aad6ecc4995.png)](https://meta.discourse.org/t/network-chart-of-your-forum-data-visualization/37426)

The way to do it:

> [@Create a Network chart of your forum - data visualization](https://meta.discourse.org/t/network-chart-of-your-forum-data-visualization/37426):
>
> Thanks to the [Data Explorer Plugin](https://meta.discourse.org/t/data-explorer-plugin/32566) and the query that @riking created, we have a great visualization of the interaction in our discourse instance. [[image]](http://bit.ly/1O6vDyv) You can also [play with it](http://bit.ly/1O6vDyv). It’s easy to do it: 1 - Install [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin 2 - Run the riking query or an modified version of it.play_button We use a version that only extracts from a specific groupplay_button You could do it another modified version of the SQL query that filter by period 3 - Download the .csv 4 - Create a [Fusion Table](https://www.google.com/fusiontables/data?dsrcid=implicit)5 - Upload the .…

---

<div class="post-metadata">

### Author: ![erlend\_sh](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/erlend_sh/32/119475_2.png) [@erlend\_sh](https://meta.discourse.org/u/erlend_sh)
#### Post date: [May 16, 2016, 10:27am UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/15 "2016-05-16T10:27:49Z")

</div>

We’ve started to support visual forum analytics now:

> [@Visualised traffic statistics](https://meta.discourse.org/t/visualised-traffic-statistics/44298):
>
> We now have fancy visual graphs to help community managers better track activity trends in their Discourse forum. This feature was quietly released by @sam some weeks ago; now we’d like some feedback. You can see the graph for any traffic stat in your dashboard by clicking on it, like these ones: Example stats from Meta Identify peaks at a glance: Set custom date ranges: Filter data for specific groups:

---

<div class="post-metadata">

### Author: ![erlend\_sh](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/erlend_sh/32/119475_2.png) [@erlend\_sh](https://meta.discourse.org/u/erlend_sh)
#### Post date: [May 16, 2016, 10:27am UTC](https://meta.discourse.org/t/visual-forum-statistics/34744/16 "2016-05-16T10:27:53Z")

</div>


