# Admin dashboard report reference guide **URL:** https://meta.discourse.org/t/admin-dashboard-report-reference-guide/240233 **Category:** Site Management **Tags:** reference, sql-query, dashboard-reports, reporting **Created:** [September 27, 2022, 8:25pm UTC](https://meta.discourse.org/t/admin-dashboard-report-reference-guide/240233 "2022-09-27T20:25:16Z") **Posts on this page:** 1 **Showing post:** 1
### Author: ![Discourse](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/discourse/32/148734_2.png) [@Discourse](https://meta.discourse.org/u/Discourse) #### Post date: [September 27, 2022, 8:25pm UTC](https://meta.discourse.org/t/admin-dashboard-report-reference-guide/240233/1 "2022-09-27T20:25:16Z")
> 🔖 This is a reference guide for describing how the Admin Dashboard Reports function, the data they’re displaying, the corresponding [Data Explorer](https://meta.discourse.org/t/32566?silent=true) SQL queries, and where to find the Ruby code for each report. > > 🙋 Required user level: Staff Discourse contains several built-in admin dashboard Reports that can be useful for exploring stats about a community. To access these reports, you can visit `discourse.example.com/admin/dashboard/reports` on your site ( or click the **Reports** link in the sidebar). Note that only staff users will have access to these reports. ![Screenshot 2026-09-02 at 12.11.17 PM](https://global.discourse-cdn.com/meta/original/4X/a/3/3/a33721f8ed7bbed4ab4357cd0630514eec5874bc.png) Data from all users on a site is included in these reports (including staff activity like visiting admin pages). The only condition that is put on users in the reports is that they are ‘real’ users, which is used to exclude the `system` user from the reports. Plugins can also add reports to the dashboard with `add_report(name, &block)`. > 💎 Ruby models for most reports are located at: [discourse/app/models/concerns/reports/](https://github.com/discourse/discourse/tree/main/app/models/concerns/reports). Some reports also reference: [discourse/app/models/report.rb](https://github.com/discourse/discourse/blob/4c085873e5c4174e876304d8300462fb96a7fd6e/app/models/report.rb) > 💡 The #dashboard-sql topics contain all of the corresponding SQL queries that can be used to generate reports identical to the Admin Dashboard Reports. These queries can be used within the [Data Explorer](https://meta.discourse.org/t/discourse-data-explorer/32566) plugin and for [Running Data Explorer queries with the Discourse API](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063) > 🔧 To hide specific reports from the dashboard, use the `dashboard_hidden_reports` site setting. ## Accepted solutions Displays daily tally of posts marked as solutions. Ruby code: [discourse-solved/plugin.rb at main · discourse/discourse-solved · GitHub](https://github.com/discourse/discourse-solved/blob/main/plugin.rb#L368) SQL Query: [Dashboard Report - Accepted Solutions](https://meta.discourse.org/t/dashboard-report-accepted-solutions/288863) ## Admin Logins List of admin login times with locations. Ruby Code: [discourse/app/models/concerns/reports/staff\_logins.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/staff_logins.rb) SQL Query: [Dashboard Report - Admin Logins](https://meta.discourse.org/t/dashboard-report-admin-logins/288873) ## Anonymous Number of new pageviews by visitors not logged in to an account. Ruby Code: [discourse/app/models/concerns/reports/consolidated\_page\_views.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/consolidated_page_views.rb) SQL Query: [Dashboard Report - Anonymous](https://meta.discourse.org/t/dashboard-report-anonymous/289114) ## Bookmarks Number of new topics and posts bookmarked. Ruby Code: [discourse/app/models/concerns/reports/bookmarks.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/bookmarks.rb) SQL Query: [Dashboard Report - Bookmarks](https://meta.discourse.org/t/dashboard-report-bookmarks/289129) ## Consolidated API Requests API usage statistics by date, tracking both regular API requests and user API requests. Ruby Code: [discourse/app/models/concerns/reports/consolidated\_api\_requests.rb at main · discourse/discourse · GitHub](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/consolidated_api_requests.rb) SQL Query: [Dashboard Report - Consolidated API Requests](https://meta.discourse.org/t/dashboard-report-consolidated-api-requests/383778) ## Consolidated Pageviews Pageviews for logged in users, anonymous users and crawlers. This is a legacy report superseded by the **Site Traffic** report. Ruby Code: [discourse/app/models/concerns/reports/consolidated\_page\_views.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/consolidated_page_views.rb) SQL Query: [Dashboard Report - Consolidated Pageviews](https://meta.discourse.org/t/dashboard-report-consolidated-pageviews/289263) ## Consolidated Pageviews with Browser Detection (Deprecated) Pageviews for logged in users, anonymous users, known crawlers and other. This report is deprecated and now delegates to the **Site Traffic** report. Ruby Code: [discourse/app/models/concerns/reports/consolidated\_page\_views\_browser\_detection.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/consolidated_page_views_browser_detection.rb) SQL Query: [Dashboard Report - Consolidated Pageviews with Browser Detection](https://meta.discourse.org/t/dashboard-report-consolidated-pageviews-with-browser-detection/312968) ## DAU/MAU Number of members that logged in in the last day divided by number of members that logged in in the last month – returns a % which indicates community ‘stickiness’. Aim for \>20%. Ruby Code: [discourse/app/models/concerns/reports/dau\_by\_mau.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/dau_by_mau.rb) SQL Query: [Dashboard Report - DAU/MAU](https://meta.discourse.org/t/dashboard-report-dau-mau/289383) ## Daily Engaged Users Number of users that have liked or posted in the last day. Ruby Code: [discourse/app/models/concerns/reports/daily\_engaged\_users.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/daily_engaged_users.rb) SQL Query: [Dashboard Report - Daily Engaged Users](https://meta.discourse.org/t/dashboard-report-daily-engaged-users/288033) ## Emails Sent Number of new emails sent. Ruby Code: [discourse/app/models/concerns/reports/emails.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/emails.rb) SQL Query: [Dashboard Report - Emails Sent](https://meta.discourse.org/t/dashboard-report-emails-sent/289401) ## Flags Number of new flags. Ruby Code: [discourse/app/models/concerns/reports/flags.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/flags.rb) SQL Query: [Dashboard Report - Flags](https://meta.discourse.org/t/dashboard-report-flags/289412) ## Flags Status List of flags’ statuses including type of flag, poster, flagger, and time to resolution. Ruby Code: [discourse/app/models/concerns/reports/flags\_status.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/flags_status.rb) SQL Query: [Dashboard Report - Flags Status](https://meta.discourse.org/t/dashboard-report-flags-status/289501) ## Likes Number of new likes. Ruby Code: [discourse/app/models/concerns/reports/likes.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/likes.rb) SQL Query: [Dashboard Report - Likes](https://meta.discourse.org/t/dashboard-report-likes/291092) ## Logged In Number of new pageviews from logged in users. Ruby Code: [discourse/app/controllers/admin/reports\_controller.rb#L5](https://github.com/discourse/discourse/blob/main/app/controllers/admin/reports_controller.rb#L5) SQL Query: [Dashboard Report - Logged In](https://meta.discourse.org/t/dashboard-report-logged-in/291102) ## Moderator Activity List of moderator activity including flags reviewed, reading time, topics created, posts created, personal messages created, and revisions. SQL Query: [Dashboard Report - Moderator Activity](https://meta.discourse.org/t/dashboard-report-moderator-activity/291244) ## Moderator Warning Number of warnings sent by personal messages from moderators. Ruby Code: [discourse/app/models/concerns/reports/moderator\_warning\_private\_messages.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/moderator_warning_private_messages.rb) SQL Query: [Dashboard Report - Moderator Warnings](https://meta.discourse.org/t/dashboard-report-moderator-warnings/291876) ## New Contributors Number of users who made their first post during this period. Ruby Code: [discourse/app/models/concerns/reports/new\_contributors.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/new_contributors.rb) SQL Query: [Dashboard Report - New Contributors](https://meta.discourse.org/t/dashboard-report-new-contributors/291879) ## Notify Moderators Number of times moderators have been privately notified by a flag. Ruby Code: [discourse/app/models/concerns/reports/notify\_moderators\_private\_messages.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/notify_moderators_private_messages.rb) SQL Query: [Dashboard Report - Notify Moderators](https://meta.discourse.org/t/dashboard-report-notify-moderators/291887) ## Notify User Number of times users have been privately notified by a flag. Ruby Code: [discourse/app/models/concerns/reports/notify\_user\_private\_messages.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/notify_user_private_messages.rb) SQL Query: [Dashboard Report - Notify User](https://meta.discourse.org/t/dashboard-report-notify-user/292004) ## Overall Sentiment Number of posts classified either positive or negative with the “Sentiment” AI, over a specified period. Ruby Code: [https://github.com/discourse/discourse-ai/blob/main/lib/sentiment/entry\_point.rb](https://github.com/discourse/discourse-ai/blob/main/lib/sentiment/entry_point.rb) SQL Query: [Dashboard Report - Overall Sentiment](https://meta.discourse.org/t/dashboard-report-overall-sentiment/295428) ## Pageviews Number of new pageviews from all visitors. Same as the total for Consolidated Pageviews. Discourse uses the follow query to determine total pageviews: SQL Query: [Dashboard Report - Consolidated Pageviews](https://meta.discourse.org/t/dashboard-report-consolidated-pageviews/289263) ## Post Edits Number of new post edits. Ruby Code: [discourse/app/models/concerns/reports/post\_edits.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/post_edits.rb) SQL Query: [Dashboard Report - Post Edits](https://meta.discourse.org/t/dashboard-report-post-edits/292019) ## Posts New posts created during the selected time period Ruby Code: [discourse/app/models/concerns/reports/posts.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/posts.rb) SQL Query: [Dashboard Report - Posts](https://meta.discourse.org/t/dashboard-report-posts/288579) ## Post Emotion Number of posts classified by AI with one of following emotions: Sadness, Surprise, Fear, Anger, Joy, Disgust - group by poster trust level, over a specified period. Ruby Code: [https://github.com/discourse/discourse-ai/blob/main/lib/sentiment/entry\_point.rb](https://github.com/discourse/discourse-ai/blob/main/lib/sentiment/entry_point.rb) SQL Query: [Dashboard Report - Post Emotion](https://meta.discourse.org/t/dashboard-report-post-emotion/295553) ## Reactions List most recent reactions. Ruby code: [discourse-reactions/plugin.rb at main · discourse/discourse-reactions · GitHub](https://github.com/discourse/discourse-reactions/blob/main/plugin.rb#L194) SQL Query: [Dashboard Report - Reactions](https://meta.discourse.org/t/dashboard-report-reactions/292024) ## Signups New account registrations for this period. Ruby Code: [discourse/app/models/concerns/reports/signups.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/signups.rb) SQL Query: [Dashboard Report - Signups](https://meta.discourse.org/t/dashboard-report-signups/288037) ## Site Traffic Pageviews for logged in browsers, anonymous browsers, crawlers, and other traffic. This is the primary traffic report, replacing the legacy Consolidated Pageviews reports. Ruby Code: [discourse/app/models/concerns/reports/site\_traffic.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/site_traffic.rb) SQL Query: [Dashboard Report - Site Traffic](https://meta.discourse.org/t/dashboard-report-site-traffic/358667) ## Suspicious Logins Details of new logins that differ suspiciously from previous logins. Ruby Code: [discourse/app/models/concerns/reports/suspicious\_logins.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/suspicious_logins.rb) SQL Query: [Dashboard Report - Suspicious Logins](https://meta.discourse.org/t/dashboard-report-suspicious-logins/294773) ## System Number of personal messages sent automatically by the System. Ruby Code: [discourse/app/models/concerns/reports/system\_private\_messages.rb](https://github.com/discourse/discourse/blob/main/app/models/report.rb#L369) SQL Query: [Dashboard Report - System](https://meta.discourse.org/t/dashboard-report-system/293546) ## Time to first response Average time (in hours) of the first response to new topics. Ruby Code: [discourse/app/models/concerns/reports/time\_to\_first\_response.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/time_to_first_response.rb) + [discourse/discourse/blob/main/app/models/topic.rb#L1799-L1844](https://github.com/discourse/discourse/blob/main/app/models/topic.rb#L1799-L1844) SQL Query: [Dashboard Report - Time to First Response](https://meta.discourse.org/t/dashboard-report-time-to-first-response/288597) ## Top Ignored / Muted Users Users who have been muted and/or ignored by many other users. Ruby Code: [discourse/app/models/concerns/reports/top\_ignored\_users.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/top_ignored_users.rb) SQL Query: [Dashboard Report - Top Ignored / Muted Users](https://meta.discourse.org/t/dashboard-report-top-ignored-muted-users/293582) ## Top Referred Topics Topics that have received the most clicks from external sources. Ruby Code: [discourse/app/models/concerns/reports/top\_referred\_topics.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/top_referred_topics.rb) SQL Query: [Dashboard Report - Top Referred Topics](https://meta.discourse.org/t/dashboard-report-top-referred-topics/288433) ## Top Referrers Users listed by number of clicks on links they have shared. Ruby Code: [discourse/app/models/concerns/reports/top\_referrers.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/top_referrers.rb) SQL Query: [Dashboard Report - Top Referrers](https://meta.discourse.org/t/dashboard-report-top-referrers/288437) ## Top Traffic Sources External sources that have linked to this site the most. Ruby Code: [discourse/app/models/concerns/reports/top\_traffic\_sources.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/top_traffic_sources.rb) SQL Query: [Dashboard Report - Top Traffic Sources](https://meta.discourse.org/t/dashboard-report-top-traffic-sources/288745) ## Top Uploads List all uploads by extension, filesize and author. Ruby Code: [discourse/app/models/concerns/reports/top\_uploads.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/top_uploads.rb) SQL Query: [Dashboard Report - Top Uploads](https://meta.discourse.org/t/dashboard-report-top-uploads/288440) ## Top Users by likes received Top 10 users who have received likes. Ruby Code: [discourse/app/models/concerns/reports/top\_users\_by\_likes\_received.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/top_users_by_likes_received.rb) SQL Query: [Dashboard Report - Top Users by Likes Received](https://meta.discourse.org/t/dashboard-report-top-users-by-likes-received/293714) ## Top Users by likes received from a user with a lower trust level Top 10 users in a higher trust level being liked by people in a lower trust level. Ruby Code: [discourse/app/models/concerns/reports/top\_users\_by\_likes\_received\_from\_inferior\_trust\_level.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/top_users_by_likes_received_from_inferior_trust_level.rb) SQL Query: [Dashboard Report - Top Users by Likes Received from a User with a Lower Trust Level](https://meta.discourse.org/t/dashboard-report-top-users-by-likes-received-from-a-user-with-a-lower-trust-level/293717) ## Top Users by likes received from a variety of people Top 10 users who have had likes from a wide range of people. Ruby Code: [discourse/app/models/concerns/reports/top\_users\_by\_likes\_received\_from\_a\_variety\_of\_people.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/top_users_by_likes_received_from_a_variety_of_people.rb) SQL Query: [Dashboard Report - Top Users by Likes Received From a Variety of People](https://meta.discourse.org/t/dashboard-report-top-users-by-likes-received-from-a-variety-of-people/293723) ## Topics New topics created during this period. Ruby Code: [discourse/app/models/concerns/reports/topics.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/topics.rb) SQL Query: [Dashboard Report - Topics](https://meta.discourse.org/t/dashboard-report-topics/288446) ## Topics with no response Number of new topics created that did not receive a response. Ruby Code: [discourse/app/models/concerns/reports/topics\_with\_no\_response.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/topics_with_no_response.rb) SQL Query: [Dashboard Report - Topics with No Response](https://meta.discourse.org/t/dashboard-report-topics-with-no-response/294002) ## Topic View Stats Top 100 topics by views with anonymous and logged-in breakdowns, filterable by category. Ruby Code: [discourse/app/models/concerns/reports/topic\_view\_stats.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/topic_view_stats.rb) SQL Query: [Dashboard Report - Topic View Stats](https://meta.discourse.org/t/dashboard-report-topic-view-stats/349452) ## Trending Search Terms Most popular search terms with their click-through rates. Ruby Code: [discourse/app/models/concerns/reports/trending\_search.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/trending_search.rb) SQL Query: [Dashboard Report - Trending Search Terms](https://meta.discourse.org/t/dashboard-report-trending-search-terms/288562) ## Trust Level growth Number of users who increased their Trust Level during this period. The Trust Level Growth report is pulling data from the `user_histories` table in the Discourse database. Specifically, this report is counting the number of times a `user_histories.action` is recorded for an increase in a user trust level. Ruby Code: [discourse/app/models/concerns/reports/trust\_level\_growth.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/trust_level_growth.rb) SQL Query: [Dashboard Report - Trust Level Growth](https://meta.discourse.org/t/dashboard-report-trust-level-growth/294418) ## Unaccepted policies This dashboard report identifies topics with policies that have not been accepted by certain users. Ruby code: [discourse-policy/plugin.rb at main · discourse/discourse-policy · GitHub](https://github.com/discourse/discourse-policy/blob/main/plugin.rb#L159) SQL Query: [Dashboard Report - Unaccepted Policies](https://meta.discourse.org/t/dashboard-report-unaccepted-policies/294432) ## User Flagging Ratio List of users ordered by ratio of staff response to their flags (disagreed to agreed). Ruby Code: [discourse/app/models/concerns/reports/user\_flagging\_ratio.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/user_flagging_ratio.rb) SQL Query: [Dashboard Report - User Flagging Ratio](https://meta.discourse.org/t/dashboard-report-user-flagging-ratio/294442) ## User notes List most recent user notes. Ruby code: [discourse-user-notes/plugin.rb at main · discourse/discourse-user-notes · GitHub](https://github.com/discourse/discourse-user-notes/blob/main/plugin.rb#L153) SQL Query: [Dashboard Report - User Notes](https://meta.discourse.org/t/dashboard-report-user-notes/294785) ## User Profile Views Total new views of user profiles. Ruby Code: [discourse/app/models/concerns/reports/profile\_views.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/profile_views.rb) SQL Query: [Dashboard Report - User Profile Views](https://meta.discourse.org/t/dashboard-report-user-profile-views/294477) ## User Visits The total number of logged-in user visits in the forum for the selected time period (today, yesterday, last 7 days, etc). A User Visit is counted anytime a unique logged in user visits the site, up to once per day. For example, if a user visited a site every day within a week, Discourse would count that as 7 user visits. Ruby Code: [discourse/app/models/concerns/reports/visits.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/visits.rb) SQL Query: [Dashboard Report - User Visits](https://meta.discourse.org/t/dashboard-report-user-visits/294620) ## User Visits (mobile) Number of unique logged-in users who visited using a mobile device. Ruby Code: [discourse/app/models/concerns/reports/mobile\_visits.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/mobile_visits.rb) SQL Query: [Dashboard Report - User Visits](https://meta.discourse.org/t/dashboard-report-user-visits/294620) ## User-to-User (excluding replies) Number of newly initiated personal messages. Ruby Code: [discourse/app/models/concerns/reports/user\_to\_user\_private\_messages.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/user_to_user_private_messages.rb) SQL Query: [Dashboard Report - User-to-User](https://meta.discourse.org/t/dashboard-report-user-to-user/288459) ## User-to-User (with replies) Number of all new personal messages and responses. Ruby Code: [discourse/app/models/concerns/reports/user\_to\_user\_private\_messages\_with\_replies.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/user_to_user_private_messages_with_replies.rb) SQL Query: [Dashboard Report - User-to-User](https://meta.discourse.org/t/dashboard-report-user-to-user/288459) ## Users per Trust Level Number of users grouped by trust level. Ruby Code: [discourse/app/models/concerns/reports/users\_by\_trust\_level.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/users_by_trust_level.rb) SQL Query: [Dashboard Report - Users Per Trust Level](https://meta.discourse.org/t/dashboard-report-users-per-trust-level/288565) ## Users per Type Number of users grouped by admin, moderator, suspended, and silenced. Ruby Code: [discourse/app/models/concerns/reports/users\_by\_type.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/users_by_type.rb) SQL Query: [Dashboard Report - Users Per Type](https://meta.discourse.org/t/dashboard-report-users-per-type/288569) ## Web Crawler Pageviews Total pageviews from web crawlers over time. Ruby Code: [discourse/app/models/report.rb](https://github.com/discourse/discourse/blob/main/app/models/report.rb#L209-L214) SQL Query: [Dashboard Report - Web Crawler Pageviews](https://meta.discourse.org/t/dashboard-report-web-crawler-pageviews/294745) ## Web Crawler User Agents List of web crawler user agents, sorted by pageviews. Ruby Code: [discourse/app/models/concerns/reports/web\_crawlers.rb](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/web_crawlers.rb) SQL Query: [Dashboard Report - Web Crawler User Agents](https://meta.discourse.org/t/dashboard-report-web-crawler-user-agents/294762) > Last edited by @meghna 2026-09-02T06:44:34Z > > Last checked by @JonathanG 2026-04-14T03:52:32Z > > > **Check document** > > > > Perform check on document: --- _[View the full topic](https://meta.discourse.org/t/admin-dashboard-report-reference-guide/240233)._