This is generally done through third party analytics such as Google Analytics – be sure you have set that up by entering your analytics ID in your site settings.
I do have GA on my instance.
To me, the discourse dashboard is a succinct window into my community. I really like it. Just a tiny bit more filtering would be nice.
The data in the dashboard is excellent for reviewing key metrics at a glance, but if you are porting the data into excel/sheets for custom weekly or monthly summaries to distribute it can be clunky. If I want to pull daily data for each stat category I need to enter each one and either export or copy/paste. Would love it if I could select a date range and export a set number of days from all (or a group of select) stats and get one CSV with several columns of data.
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?
Not certain - but I’d check out What cool data explorer queries have you come up with? to get some ideas where to start.
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.
See what categories new users (& other trust levels) post in most
Yup, coming soon to admin dashboard 2.0
Be good to add an optional trend line to all existing graphs where it makes sense.
Can we have an aggregate View of the statistical numbers?
Or to have it as a checkbox to display one or not.
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
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:
- tests for the existence of
- 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.
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?
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.
What's the difference between "User Visits" and "Active Users"