I’m a SQL newbie as well and was a bit intimidated by Data Explorer 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 
And it’s read only, so no matter how stupid your query is, you can’t really hurt anything.
I’d love to see stats on replies made by email - count, trend, and as a percentage of total posts.
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.
Yup, coming soon to admin dashboard 2.0
Or to have it as a checkbox to display one or not.
I like the way Grytics lays it out…
Basically, everything they show is very helpful and informative for someone focusing on growing a community
I think a good metric would be the number of unique contributors.
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:
created_at and last_seen_at
created_at to timestamplast_seen_at to timestampcreated_at from last_seen_at
So far it is only an overall “snapshot” and isn’t intervals, but nonetheless gives interesting results.
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.
Any news or prototype of the dashboard?
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.
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
Yup, that’s the plan. And thanks.
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? 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.
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.
Is it possible to add a hook which identifies if the plugin is installed (for self-hosted) and loads it on the dashboard? In addition those preloaded queries would be great to include the queries for those graphs
Important to note that I considered doing that while writing it, but couldn’t come up with a good list of what to pre-load.
Nice!
What I am realy missing for my self hosted instance are some hardware information, like memory, diskspace and cpu usage. That would be awesome.
