# \#dashboard-sql **URL:** https://meta.discourse.org/tag/dashboard-sql/725.md [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) --- ## [Dashboard Report - Consolidated API Requests](https://meta.discourse.org/t/dashboard-report-consolidated-api-requests/383778)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [September 23, 2025, 7:12pm UTC](https://meta.discourse.org/t/dashboard-report-consolidated-api-requests/383778 "2025-09-23T19:12:10Z")
This is an SQL version of the Dashboard Report for Consolidated API Requests. This report shows API usage statistics by date, tracking both regular API requests and user API requests. This report helps you monitor the A… --- ## [Dashboard Report - Posts](https://meta.discourse.org/t/dashboard-report-posts/288579)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 3\ **Last updated:** [September 9, 2025, 8:03pm UTC](https://meta.discourse.org/t/dashboard-report-posts/288579 "2025-09-09T20:03:47Z")
This is an SQL version of the Dashboard Report for Posts. This report provides a daily count of posts created within a specified date range. It is designed to track the activity in regular topics, excluding posts from p… --- ## [Dashboard Report - Web Crawler User Agents](https://meta.discourse.org/t/dashboard-report-web-crawler-user-agents/294762)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 1\ **Last updated:** [August 22, 2025, 5:10pm UTC](https://meta.discourse.org/t/dashboard-report-web-crawler-user-agents/294762 "2025-08-22T17:10:08Z")
This is an SQL version of the Dashboard Report for Web Crawler User Agents. This Dashboard Report lists the top web crawler user agents, sorted by pageviews, providing insight into which crawlers are most active on a s… --- ## [Dashboard Report - Post Emotion](https://meta.discourse.org/t/dashboard-report-post-emotion/295553)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [February 16, 2024, 1:04am UTC](https://meta.discourse.org/t/dashboard-report-post-emotion/295553 "2024-02-16T01:04:05Z")
This is an SQL version of the Dashboard Report for Post Emotion. :discourse: This report requires the Discourse AI plugin and Sentiment Analysis to be enabled. This dashboard report shows the number of posts classif… --- ## [Dashboard Report - Overall Sentiment](https://meta.discourse.org/t/dashboard-report-overall-sentiment/295428)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 2\ **Last updated:** [July 3, 2025, 8:19pm UTC](https://meta.discourse.org/t/dashboard-report-overall-sentiment/295428 "2025-07-03T20:19:14Z")
This is an SQL version of the Dashboard Report for Overall Sentiment. :discourse: This report requires the Discourse AI plugin and Sentiment Analysis to be enabled. This dashboard report compares the number of posts … --- ## [Dashboard Report - Accepted Solutions](https://meta.discourse.org/t/dashboard-report-accepted-solutions/288863)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [December 15, 2023, 9:15pm UTC](https://meta.discourse.org/t/dashboard-report-accepted-solutions/288863 "2023-12-15T21:15:51Z")
This is an SQL version of the Dashboard Report for Accepted Solutions. This report provides a count of posts that have been marked as solutions on a daily basis within a specified date range. It is useful for understand… --- ## [Dashboard Report - Consolidated Pageviews](https://meta.discourse.org/t/dashboard-report-consolidated-pageviews/289263)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 3\ **Last updated:** [March 24, 2025, 11:37pm UTC](https://meta.discourse.org/t/dashboard-report-consolidated-pageviews/289263 "2025-03-24T23:37:49Z")
This is an SQL version of the Dashboard Report for Consolidated Pageviews. This SQL report provides a daily count of pageviews from logged in users, anonymous users, and crawlers on a Discourse site. -- \[params\] -- dat… --- ## [Dashboard Report - Site Traffic](https://meta.discourse.org/t/dashboard-report-site-traffic/358667)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [March 24, 2025, 8:18pm UTC](https://meta.discourse.org/t/dashboard-report-site-traffic/358667 "2025-03-24T20:18:02Z")
This is an SQL version of the Dashboard Report for Site Traffic. This report provides an overview of site traffic metrics grouped by date. It breaks down page views into several categories, including logged-in browser v… --- ## [Dashboard Report - Moderator Activity](https://meta.discourse.org/t/dashboard-report-moderator-activity/291244)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 5\ **Last updated:** [October 30, 2024, 8:46pm UTC](https://meta.discourse.org/t/dashboard-report-moderator-activity/291244 "2024-10-30T20:46:19Z")
This is an SQL version of the Dashboard Report for Moderator Activity. This report provides a comprehensive overview of the activities performed by moderators within a specified time frame on a Discourse site. The repor… --- ## [Dashboard Report - DAU/MAU](https://meta.discourse.org/t/dashboard-report-dau-mau/289383)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 2\ **Last updated:** [February 2, 2025, 8:44pm UTC](https://meta.discourse.org/t/dashboard-report-dau-mau/289383 "2025-02-02T20:44:32Z")
This is an SQL version of the Dashboard Report for DAU/MAU. This report provides a detailed analysis of the Daily Active Users (DAU) to Monthly Active Users (MAU) ratio over a specific date range. The DAU/MAU ratio is a… --- ## [Dashboard Report - Topic View Stats](https://meta.discourse.org/t/dashboard-report-topic-view-stats/349452)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [January 28, 2025, 9:40pm UTC](https://meta.discourse.org/t/dashboard-report-topic-view-stats/349452 "2025-01-28T21:40:30Z")
This is an SQL version of the Dashboard Report for Topic View Stats. This report collects and aggregates topic view statistics, including anonymous and logged-in views, within a given date range. It also allows filterin… --- ## [Dashboard Report - Likes](https://meta.discourse.org/t/dashboard-report-likes/291092)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 3\ **Last updated:** [January 22, 2025, 10:03pm UTC](https://meta.discourse.org/t/dashboard-report-likes/291092 "2025-01-22T22:03:34Z")
This is an SQL version of the Dashboard Report for Likes. This query provides a report of the total number of likes given to all posts on a site, on a day-to-day basis, within a specified date range. -- \[params\] -- dat… --- ## [Dashboard Report - Signups](https://meta.discourse.org/t/dashboard-report-signups/288037)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 1\ **Last updated:** [December 24, 2024, 6:18pm UTC](https://meta.discourse.org/t/dashboard-report-signups/288037 "2024-12-24T18:18:54Z")
This is an SQL version of the Admin Dashboard Report for Signups. The SQL report will count the number of users who have joined a forum each day between two dates, :start\_date and :end\_date, which are parameters that ca… --- ## [Dashboard Report - Topics with No Response](https://meta.discourse.org/t/dashboard-report-topics-with-no-response/294002)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 8\ **Last updated:** [September 5, 2024, 1:44pm UTC](https://meta.discourse.org/t/dashboard-report-topics-with-no-response/294002 "2024-09-05T13:44:53Z")
This is an SQL version of the Dashboard Report for Topics with No Response. The dashboard report is designed to count the number of topics created within a specified date range that have not received any responses from … --- ## [Dashboard Report - Consolidated Pageviews with Browser Detection](https://meta.discourse.org/t/dashboard-report-consolidated-pageviews-with-browser-detection/312968)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 5\ **Last updated:** [June 21, 2024, 7:49pm UTC](https://meta.discourse.org/t/dashboard-report-consolidated-pageviews-with-browser-detection/312968 "2024-06-21T19:49:57Z")
This is an SQL version of the Dashboard Report for Consolidated Pageviews with Browser Detection. This Data Explorer report provides a view of daily site pageviews with browser detection over a specified date range. The… --- ## [Dashboard Report - User Visits](https://meta.discourse.org/t/dashboard-report-user-visits/294620)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [February 8, 2024, 12:44am UTC](https://meta.discourse.org/t/dashboard-report-user-visits/294620 "2024-02-08T00:44:12Z")
This is an SQL version of the Dashboard Report for User Visits and User Visits (Mobile). This dashboard report provides insights into user engagement by tracking daily user visits. Admins can filter the data based on da… --- ## [Dashboard Report - System](https://meta.discourse.org/t/dashboard-report-system/293546)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 3\ **Last updated:** [March 20, 2024, 12:56am UTC](https://meta.discourse.org/t/dashboard-report-system/293546 "2024-03-20T00:56:00Z")
This is an SQL version of the Dashboard Report for System. This dashboard report provides a daily count of the number of personal messages sent automatically by the system. -- \[params\] -- date :start\_date = 2024-01-01 … --- ## [Dashboard Report - User Notes](https://meta.discourse.org/t/dashboard-report-user-notes/294785)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [February 9, 2024, 1:36am UTC](https://meta.discourse.org/t/dashboard-report-user-notes/294785 "2024-02-09T01:36:13Z")
This is an SQL version of the Dashboard Report for User Notes. :discourse: This report requires the Discourse User Notes plugin to be enabled. This dashboard report lists user notes created by staff users within a sp… --- ## [Dashboard Report - Suspicious Logins](https://meta.discourse.org/t/dashboard-report-suspicious-logins/294773)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [February 9, 2024, 12:15am UTC](https://meta.discourse.org/t/dashboard-report-suspicious-logins/294773 "2024-02-09T00:15:29Z")
This is an SQL version of the Dashboard Report for Suspicious Logins. This dashboard report provides details of new logins from users that differ suspiciously from previous logins, over a specified date range. By identi… --- ## [Dashboard Report - Web Crawler Pageviews](https://meta.discourse.org/t/dashboard-report-web-crawler-pageviews/294745)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [February 8, 2024, 9:02pm UTC](https://meta.discourse.org/t/dashboard-report-web-crawler-pageviews/294745 "2024-02-08T21:02:18Z")
This is an SQL version of the Dashboard Report for Web Crawler Pageviews. This dashboard report shows the total pageviews a site receives from web crawlers per day, over a specific date range. Understanding web crawler … --- ## [Dashboard Report - User-to-User](https://meta.discourse.org/t/dashboard-report-user-to-user/288459)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [December 13, 2023, 12:26am UTC](https://meta.discourse.org/t/dashboard-report-user-to-user/288459 "2023-12-13T00:26:26Z")
This is an SQL version of the Dashboard Report for User-to-User (with replies) and User-to-User (excluding replies). This report counts the number of personal messages sent by users each day, within a specified date ran… --- ## [Dashboard Report - User Profile Views](https://meta.discourse.org/t/dashboard-report-user-profile-views/294477)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [February 7, 2024, 1:07am UTC](https://meta.discourse.org/t/dashboard-report-user-profile-views/294477 "2024-02-07T01:07:57Z")
This is an SQL version of the Dashboard Report for User Profile Views. This dashboard report is generates statistics about the total number of user profile views per day within a specified date range. -- \[params\] -- da… --- ## [Dashboard Report - User Flagging Ratio](https://meta.discourse.org/t/dashboard-report-user-flagging-ratio/294442)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [February 6, 2024, 11:17pm UTC](https://meta.discourse.org/t/dashboard-report-user-flagging-ratio/294442 "2024-02-06T23:17:32Z")
This is an SQL version of the Dashboard Report for User Flagging Ratio. This dashboard report generates a list of users ordered by the ratio of staff responses to their flags (agreed and disagreed). The report includes … --- ## [Dashboard Report - Unaccepted Policies](https://meta.discourse.org/t/dashboard-report-unaccepted-policies/294432)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [February 6, 2024, 10:30pm UTC](https://meta.discourse.org/t/dashboard-report-unaccepted-policies/294432 "2024-02-06T22:30:24Z")
This is an SQL version of the Dashboard Report for Unaccepted Policies. :discourse: This report requires the Discourse Policy plugin to be enabled. This dashboard report identifies topics with policies that have not… --- ## [Dashboard Report - Trust Level Growth](https://meta.discourse.org/t/dashboard-report-trust-level-growth/294418)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [February 6, 2024, 9:36pm UTC](https://meta.discourse.org/t/dashboard-report-trust-level-growth/294418 "2024-02-06T21:36:54Z")
This is an SQL version of the Dashboard Report for Trust Level Growth. This dashboard report counts the number of users reaching trust levels 1, 2, 3, and 4 each day within the specified date range, and helps admins to … --- ## [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)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [February 1, 2024, 12:41am UTC](https://meta.discourse.org/t/dashboard-report-top-users-by-likes-received-from-a-variety-of-people/293723 "2024-02-01T00:41:02Z")
This is an SQL version of the Dashboard Report for Top Users by Likes Received From a Variety of People. This dashboard report shows the top users who have received likes from a wide range of users of a site, over a spe… --- ## [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)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [February 1, 2024, 12:30am UTC](https://meta.discourse.org/t/dashboard-report-top-users-by-likes-received-from-a-user-with-a-lower-trust-level/293717 "2024-02-01T00:30:10Z")
This is an SQL version of the Dashboard Report for Top Users by Likes Received from a User with a Lower Trust Level. This dashboard report aims to identify which users have received the most likes from members of lower … --- ## [Dashboard Report - Top Users by Likes Received](https://meta.discourse.org/t/dashboard-report-top-users-by-likes-received/293714)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [February 1, 2024, 12:21am UTC](https://meta.discourse.org/t/dashboard-report-top-users-by-likes-received/293714 "2024-02-01T00:21:49Z")
This is an SQL version of the Dashboard Report for Top Users by Likes Received. This dashboard report shows the top users on a site by the number of likes received across all posts. The report helps admins identify high… --- ## [Dashboard Report - Top Ignored / Muted Users](https://meta.discourse.org/t/dashboard-report-top-ignored-muted-users/293582)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [January 31, 2024, 2:04am UTC](https://meta.discourse.org/t/dashboard-report-top-ignored-muted-users/293582 "2024-01-31T02:04:46Z")
This is an SQL version of the Dashboard Report for Top Ignored / Muted Users. This dashboard report provides administrators with insights into which users on the platform have been ignored or muted by other members betw… --- ## [Dashboard Report - Reactions](https://meta.discourse.org/t/dashboard-report-reactions/292024)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 2\ **Last updated:** [January 19, 2024, 10:36pm UTC](https://meta.discourse.org/t/dashboard-report-reactions/292024 "2024-01-19T22:36:04Z")
This is an SQL version of the Dashboard Report for Reactions. This report provides a daily count of all likes and reactions to posts across a site over a specified date range. This report helps provide a snapshot of us… [Next page](https://meta.discourse.org/tag/dashboard-sql/725.md?match_all_tags=true&page=1&tags%5B%5D=dashboard-sql)