# What would you like to see on your Discourse 2.0 Admin Dashboard?
**URL:** https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134
**Category:** Community Building
**Tags:** feedback
**Created:** [7월 31, 2017, 1:33오전 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134 "2017-07-31T01:33:28Z")
**Posts on this page:** 20
**Page:** 4
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [2월 9, 2018, 11:22오후 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/64 "2018-02-09T23:22:42Z")
What you need is the [Discourse Data Explorer](https://meta.discourse.org/t/data-explorer-plugin/32566).
---
### Author:  [@RyanK](https://meta.discourse.org/u/RyanK)
#### Post date: [2월 10, 2018, 12:35오전 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/65 "2018-02-10T00:35:27Z")
Looks like I had it but didn’t even realize it was there. I’m not very good writing SQL. Has anyone posted a simple query to pull daily details for the 25ish stat categories that are displayed on the admin dashboard?
---
### Author:  [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [2월 10, 2018, 12:37오전 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/66 "2018-02-10T00:37:40Z")
Not certain - but I’d check out [(Superseded) What cool data explorer queries have you come up with?](https://meta.discourse.org/t/what-cool-data-explorer-queries-have-you-come-up-with/43516) to get some ideas where to start.
---
### Author:  [@bts](https://meta.discourse.org/u/bts)
#### Post date: [2월 10, 2018, 1:02오전 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/67 "2018-02-10T01:02:51Z")
I’m a SQL newbie as well and was a bit intimidated by [Data Explorer](https://meta.discourse.org/t/32566?silent=true) at first but it’s super cool, there’s a side panel reference where you can browse all the data tables / column names, and one click export.
Also that thread @jomaxro linked has a ton of great examples. Someone (I forget who but I think it’s in that thread somewhere) even made a github repo collecting all the queries in one place, super easy to copy paste and test them all to play around w/ it 🙂
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [2월 10, 2018, 1:46오전 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/68 "2018-02-10T01:46:41Z")
And it’s read only, so no matter how stupid your query is, you can’t really hurt anything.
---
### Author:  [@omarfilip](https://meta.discourse.org/u/omarfilip)
#### Post date: [2월 11, 2018, 3:45오전 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/69 "2018-02-11T03:45:02Z")
I’d love to see stats on replies made by email - count, trend, and as a percentage of total posts.
---
### Author:  [@gabrieltonon](https://meta.discourse.org/u/gabrieltonon)
#### Post date: [2월 12, 2018, 6:35오후 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/70 "2018-02-12T18:35:29Z")
I recently created a thread on this actually 🤣
I’d love to have more out-of-the-box metrics about our users (# interactions, replies, messages, reply times, etc).
These are super helpful in customer-centric organizations.
> [@Create report for amount of interactions per user](https://meta.discourse.org/t/create-report-for-amount-of-interactions-per-user/80264):
>
> Hey everybody, Would it be possible to create a breakdown for the amount of interactions (replies on threads) per user in a Discourse instance? I couldn’t find anything in the /admin dashboard and it’d surely be awesome to have such metrics and figure out what are our most empowering users. grin Thanks again! grinning
---
### Author:  [@HAWK](https://meta.discourse.org/u/HAWK)
#### Post date: [2월 12, 2018, 7:51오후 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/71 "2018-02-12T19:51:52Z")
> [@gabrieltonon](#):
>
> I’d love to have more out-of-the-box metrics about our users (# interactions, replies, messages, reply times, etc).
Yup, coming soon to admin dashboard 2.0
---
### Author:  [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [2월 14, 2018, 9:55오후 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/72 "2018-02-14T21:55:25Z")
Be good to add an optional [trend line](https://support.office.com/en-ie/article/add-a-trend-or-moving-average-line-to-a-chart-fa59f86c-5852-4b68-a6d4-901a745842ad) to all existing graphs where it makes sense.
---
### Author:  [@jerdog](https://meta.discourse.org/u/jerdog)
#### Post date: [2월 14, 2018, 11:09오후 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/73 "2018-02-14T23:09:34Z")
> [@merefield](#):
>
> Be good to add an optional [trend line](https://support.office.com/en-ie/article/add-a-trend-or-moving-average-line-to-a-chart-fa59f86c-5852-4b68-a6d4-901a745842ad) to all existing graphs where it makes sense.
Or to have it as a checkbox to display one or not.
---
### Author:  [@Martin\_Cash](https://meta.discourse.org/u/Martin_Cash)
#### Post date: [2월 17, 2018, 1:52오전 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/74 "2018-02-17T01:52:44Z")
I like the way Grytics lays it out…
- the ability to export everything in csv to generate reports or nice pdf to bring to a quick meeting.
- I really like the way they show the top performers so you know who your most valuable contributors are at a glance.
- I like to see the top conversations in a specific time period so you know what content really connects with your audience
- The number of “active members”
- I like how they lay it out pretty simple, but allow you to click-through each metric to dive deeper.
Basically, everything they show is very helpful and informative for someone focusing on growing a community
---
### Author:  [@outofthebox](https://meta.discourse.org/u/outofthebox)
#### Post date: [2월 24, 2018, 2:38오후 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/75 "2018-02-24T14:38:49Z")
I think a good metric would be the number of unique contributors.
---
### Author:  [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [2월 24, 2018, 7:22오후 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/76 "2018-02-24T19:22:57Z")
I’ve been working up a localhost PHP script that works with the Users CSV export file.
One thing that I think has potential wide spread usefulness is what I’m calling “longevity” or “retention”. So far it:
- tests for the existence of `created_at` and `last_seen_at`
- converts `created_at` to timestamp
- converts `last_seen_at` to timestamp
- subtracts `created_at` from `last_seen_at`
- switch-case increments year+, year, month, week, day, hour betweens and less than hour counts
So far it is only an overall “snapshot” and isn’t intervals, but nonetheless gives interesting results.
---
### Author:  [@10ColorsTenkara](https://meta.discourse.org/u/10ColorsTenkara)
#### Post date: [4월 10, 2018, 5:29오후 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/77 "2018-04-10T17:29:29Z")
I may have missed a comment about this, but here goes. While I realize I can get some similar data from my analytics, the following would be great to be able to access from the admin dashboard.
Under the “Top Traffic Sources” and “Top Referrers” section, it would be great if you could click to see what topics are having the highest traffic for that given point or month. It would also be great to be able to see a longitudinal history (longer than 30 days) for those two sections as well.
---
### Author:  [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [4월 11, 2018, 7:33오후 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/78 "2018-04-11T19:33:06Z")
Any news or prototype of the dashboard? 🙂
---
### Author:  [@HAWK](https://meta.discourse.org/u/HAWK)
#### Post date: [4월 11, 2018, 10:11오후 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/79 "2018-04-11T22:11:07Z")
Sure. Here is a hifi prototype that @awesomerobot did of my initial design.
@joffreyjaffeux is currently working on a v1 which will be shipped with the 2.0 release.
That may mean that not everything you see here will be included in the first instance but we’ll iterate.
Also note that there will be a separate moderation dashboard in the future.
---
### Author:  [@jerdog](https://meta.discourse.org/u/jerdog)
#### Post date: [4월 11, 2018, 11:28오후 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/80 "2018-04-11T23:28:04Z")
This is a fantastic start @awesomerobot / @HAWK / @joffreyjaffeux I am assuming most of the above metrics will be available for non-hosted, except for obvious ones of course
---
### Author:  [@HAWK](https://meta.discourse.org/u/HAWK)
#### Post date: [4월 11, 2018, 11:41오후 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/81 "2018-04-11T23:41:46Z")
Yup, that’s the plan. And thanks.
---
### Author:  [@BenLeong](https://meta.discourse.org/u/BenLeong)
#### Post date: [4월 12, 2018, 12:13오전 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/82 "2018-04-12T00:13:32Z")
New dashboard looks great - I like the format for the community health metrics, as those charts show a lot more detail than just “up” or “down” from a previous period.
Including a section for data queries is also great. Does Discourse ship with any pre-loaded queries in [Data Explorer](https://meta.discourse.org/t/32566?silent=true)? It looks like it should be a great way of helping CMs to start exploring their forum data, as I’m guessing that many people don’t venture into the plugins area very often.
---
### Author:  [@HAWK](https://meta.discourse.org/u/HAWK)
#### Post date: [4월 12, 2018, 12:22오전 UTC](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134/83 "2018-04-12T00:22:41Z")
> [@BenLeong](#):
>
> Does Discourse ship with any pre-loaded queries in [Data Explorer](https://meta.discourse.org/t/32566?silent=true)?
Not at the moment but I like this idea.
Impt to note that DE isn’t available on Standard hosted plans we we need to figure out how that looks.
[이전 페이지](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134.md?page=3)
[다음 페이지](https://meta.discourse.org/t/what-would-you-like-to-see-on-your-discourse-2-0-admin-dashboard/67134.md?page=5)