# Data & reporting **URL:** https://meta.discourse.org/c/community-building/data-reporting/148.md [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) --- ## [About the Data & reporting category](https://meta.discourse.org/t/about-the-data-reporting-category/274664)
**Author:** [@Discourse](https://meta.discourse.org/u/Discourse)\ **Replies:** 0\ **Last updated:** [August 10, 2023, 3:00pm UTC](https://meta.discourse.org/t/about-the-data-reporting-category/274664 "2023-08-10T15:00:18Z")
This is the category for everything related to Discourse data and reporting. Here, you can discuss dashboard reports, custom badge queries, data-explorer queries and any other analytic add-ons. --- ## [Is it possible to export Admin User Notes?](https://meta.discourse.org/t/is-it-possible-to-export-admin-user-notes/413008)
**Author:** [@Mark07](https://meta.discourse.org/u/Mark07)\ **Replies:** 2\ **Last updated:** [September 22, 2026, 3:06pm UTC](https://meta.discourse.org/t/is-it-possible-to-export-admin-user-notes/413008 "2026-09-22T15:06:32Z")
When a Community member requests a Subject Access Request (SAR) we would provide a copy of their User Notes left by mods etc. Can these be exported into a csv (or similar)? --- ## [How to list emails for users in a group?](https://meta.discourse.org/t/how-to-list-emails-for-users-in-a-group/173323)
**Author:** [@satonotdead](https://meta.discourse.org/u/satonotdead)\ **Replies:** 4\ **Last updated:** [September 10, 2026, 10:42pm UTC](https://meta.discourse.org/t/how-to-list-emails-for-users-in-a-group/173323 "2026-09-10T22:42:09Z")
Just that. There is a way to e-mail all the group or list the email of entire custom group? Thanks! --- ## [DSA Content Moderation Reporting + Statements of Reasons Requirements](https://meta.discourse.org/t/dsa-content-moderation-reporting-statements-of-reasons-requirements/409681)
**Author:** [@Jay-C](https://meta.discourse.org/u/Jay-C)\ **Replies:** 8\ **Last updated:** [August 17, 2026, 8:26am UTC](https://meta.discourse.org/t/dsa-content-moderation-reporting-statements-of-reasons-requirements/409681 "2026-08-17T08:26:07Z")
Hello, We’re currently in the trenches of DSA compliance. Part of this involves looking at our use of Discourse, as our discussion board qualifies as an “online platform” under the DSA. As you may know, there is now a … --- ## [Users who haven't voted in a poll](https://meta.discourse.org/t/users-who-havent-voted-in-a-poll/408953)
**Author:** [@nathank](https://meta.discourse.org/u/nathank)\ **Replies:** 0\ **Last updated:** [July 31, 2026, 2:00am UTC](https://meta.discourse.org/t/users-who-havent-voted-in-a-poll/408953 "2026-07-31T02:00:45Z")
It can be very challenging to get your users to vote on a poll - especially if you want to catch your more casual visitors who only drop by once in a while. To this end, I find that it is very useful to know who hasn’t … --- ## [AI Translation Progress Graph](https://meta.discourse.org/t/ai-translation-progress-graph/405915)
**Author:** [@LotusJeff](https://meta.discourse.org/u/LotusJeff)\ **Replies:** 7\ **Last updated:** [July 27, 2026, 10:02am UTC](https://meta.discourse.org/t/ai-translation-progress-graph/405915 "2026-07-27T10:02:10Z")
I activated ai translations on my self-hosted Discourse server yesterday. Everything is going well… sort of. The translation progress graph is either not refreshing or inaccurate. Here is what I am seeing: This woul… --- ## [Tracking LLM Crawler Activity: Can we identify which topics are being indexed/crawled most frequently?](https://meta.discourse.org/t/tracking-llm-crawler-activity-can-we-identify-which-topics-are-being-indexed-crawled-most-frequently/401083)
**Author:** [@noahl](https://meta.discourse.org/u/noahl)\ **Replies:** 3\ **Last updated:** [April 21, 2026, 5:26am UTC](https://meta.discourse.org/t/tracking-llm-crawler-activity-can-we-identify-which-topics-are-being-indexed-crawled-most-frequently/401083 "2026-04-21T05:26:30Z")
We’re looking to identify which specific topics are being indexed/crawled most frequently by AI crawlers to ensure our most “cited” content isn’t feeding LLM hallucinations. Is there a way with Data Explorer to attribute… --- ## [How can I post links to live reports or embed site activity?](https://meta.discourse.org/t/how-can-i-post-links-to-live-reports-or-embed-site-activity/399678)
**Author:** [@alanr](https://meta.discourse.org/u/alanr)\ **Replies:** 3\ **Last updated:** [April 1, 2026, 2:06pm UTC](https://meta.discourse.org/t/how-can-i-post-links-to-live-reports-or-embed-site-activity/399678 "2026-04-01T14:06:04Z")
I am trying to display some site activity metrics on the front page of my website. My forum is hosted on a subdomain. I would like to either post the Site Activity from the About page or post one or more graph reports. I… --- ## [Listing event invitees with email addresses](https://meta.discourse.org/t/listing-event-invitees-with-email-addresses/399106)
**Author:** [@nathank](https://meta.discourse.org/u/nathank)\ **Replies:** 0\ **Last updated:** [March 23, 2026, 9:59pm UTC](https://meta.discourse.org/t/listing-event-invitees-with-email-addresses/399106 "2026-03-23T21:59:35Z")
:bookmark: This is a Data Explorer SQL query that retrieves a list of all users who have RSVP’d to a specific event, along with their primary email addresses. It’s useful for event coordinators who need attendee contact… --- ## [Data Processing and Contact Usage Inquiry](https://meta.discourse.org/t/data-processing-and-contact-usage-inquiry/398913)
**Author:** [@lucy.sierracircuits](https://meta.discourse.org/u/lucy.sierracircuits)\ **Replies:** 1\ **Last updated:** [March 20, 2026, 8:55pm UTC](https://meta.discourse.org/t/data-processing-and-contact-usage-inquiry/398913 "2026-03-20T20:55:36Z")
I wanted to inquire about your data handling practices. Could someone please share the Data Processing Agreement (DPA) and outline how Discourse manages and uses contact data? Specifically, I’d like to understand: Ho… --- ## [What's your workflow for the annual EU DSA compliance?](https://meta.discourse.org/t/whats-your-workflow-for-the-annual-eu-dsa-compliance/396390)
**Author:** [@sps](https://meta.discourse.org/u/sps)\ **Replies:** 4\ **Last updated:** [February 18, 2026, 9:01pm UTC](https://meta.discourse.org/t/whats-your-workflow-for-the-annual-eu-dsa-compliance/396390 "2026-02-18T21:01:23Z")
Hi everyone, I’ve recently been working with a client on preparing their annual reporting for EU DSA compliance, and it struck me that this is likely a recurring task for many moderators and admins running Discourse com… --- ## [Find the users which are more likely to become TL3](https://meta.discourse.org/t/find-the-users-which-are-more-likely-to-become-tl3/91495)
**Author:** [@barreeeiroo](https://meta.discourse.org/u/barreeeiroo)\ **Replies:** 21\ **Last updated:** [February 12, 2026, 3:50pm UTC](https://meta.discourse.org/t/find-the-users-which-are-more-likely-to-become-tl3/91495 "2026-02-12T15:50:29Z")
Is there a method to get a sorted list of users who might become Trust Level 3? Maybe using the Data Explorer plugin and a query (?) --- ## [Badge SQL triggered on post content](https://meta.discourse.org/t/badge-sql-triggered-on-post-content/394444)
**Author:** [@Alexander\_Wright](https://meta.discourse.org/u/Alexander_Wright)\ **Replies:** 1\ **Last updated:** [February 10, 2026, 2:32pm UTC](https://meta.discourse.org/t/badge-sql-triggered-on-post-content/394444 "2026-02-10T14:32:17Z")
I’m trying to award a badge depending on the content of a post. For example, If I type ‘Give Me A Badge’ i’m awarded the ‘Demanding’ badge. My SQL is as follows: SELECT p.user\_id, p.id post\_id, p.updated\_at granted\_at… --- ## [Using Parameters in Data Explorer Queries](https://meta.discourse.org/t/using-parameters-in-data-explorer-queries/277934)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 6\ **Last updated:** [February 10, 2026, 2:20pm UTC](https://meta.discourse.org/t/using-parameters-in-data-explorer-queries/277934 "2026-02-10T14:20:25Z")
Parameters are a powerful tool that can be used in Data Explorer queries on Discourse. Parameters allow for more dynamic and customizable queries, and instead of hard-coding values in your queries, you can declare vari… --- ## [Requirements for Trust Level 3](https://meta.discourse.org/t/requirements-for-trust-level-3/391400)
**Author:** [@Moin](https://meta.discourse.org/u/Moin)\ **Replies:** 0\ **Last updated:** [December 15, 2025, 10:58pm UTC](https://meta.discourse.org/t/requirements-for-trust-level-3/391400 "2025-12-15T22:58:57Z")
I tried to recreate the “requirements for Trust Level 3” report that staff can see on a user’s admin profile page as a Data Explorer query. The motivation for this is that, with the new feature allowing a query to be li… --- ## [Event registration/interested time for waiting list and event management](https://meta.discourse.org/t/event-registration-interested-time-for-waiting-list-and-event-management/380451)
**Author:** [@opcourdis](https://meta.discourse.org/u/opcourdis)\ **Replies:** 3\ **Last updated:** [December 14, 2025, 7:17pm UTC](https://meta.discourse.org/t/event-registration-interested-time-for-waiting-list-and-event-management/380451 "2025-12-14T19:17:03Z")
Hi, One of the main upcoming feature for the event plugin should be a max participant limit for event. I thought of using the Interested status to act as a waiting list : like once the event is full, people can still cl… --- ## [Anonymous views suddenly very high](https://meta.discourse.org/t/anonymous-views-suddenly-very-high/251826)
**Author:** [@agemo](https://meta.discourse.org/u/agemo)\ **Replies:** 48\ **Last updated:** [December 10, 2025, 12:20pm UTC](https://meta.discourse.org/t/anonymous-views-suddenly-very-high/251826 "2025-12-10T12:20:55Z")
I never know what to think of the anonymous views numbers but it never seems to corresponds to Google analytics data in any meaningful way. The last four or so days has brought this into focus because there has been a h… --- ## [Query to return topic actions done by a certain user?](https://meta.discourse.org/t/query-to-return-topic-actions-done-by-a-certain-user/385057)
**Author:** [@Canapin](https://meta.discourse.org/u/Canapin)\ **Replies:** 2\ **Last updated:** [November 6, 2025, 8:59am UTC](https://meta.discourse.org/t/query-to-return-topic-actions-done-by-a-certain-user/385057 "2025-11-06T08:59:30Z")
Hi, A user unnecessarily renamed and recategorized some topics. I noticed some, but I think there are others. I’d like to have the list using a data explorer query. ask.discourse.org was of no help for this request, so… --- ## [Anonymous user visits](https://meta.discourse.org/t/anonymous-user-visits/387658)
**Author:** [@Mark07](https://meta.discourse.org/u/Mark07)\ **Replies:** 2\ **Last updated:** [November 5, 2025, 12:38pm UTC](https://meta.discourse.org/t/anonymous-user-visits/387658 "2025-11-05T12:38:13Z")
Hi there, I’m hoping someone can help. :folded\_hands: I’m looking to better track and understand traffic coming onto my community. I know that I can track user visits from members who log in. However, am i correct in … --- ## [Themes and Associated Theme Components Report](https://meta.discourse.org/t/themes-and-associated-theme-components-report/386372)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [October 21, 2025, 9:17pm UTC](https://meta.discourse.org/t/themes-and-associated-theme-components-report/386372 "2025-10-21T21:17:32Z")
This query provides a comprehensive view of all themes in your Discourse instance along with their installed components, and can be helpful for admins who manage multiple themes and need to quickly identify which compone… --- ## [Data explorer challenge: Generate list of members by location](https://meta.discourse.org/t/data-explorer-challenge-generate-list-of-members-by-location/55648)
**Author:** [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)\ **Replies:** 6\ **Last updated:** [October 10, 2025, 7:53pm UTC](https://meta.discourse.org/t/data-explorer-challenge-generate-list-of-members-by-location/55648 "2025-10-10T19:53:37Z")
On our site, we populate the location field via SSO with the country where the member is based. I had a request this week from a moderator who wanted to alert members in Pakistan about a new resource published specific t… --- ## [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… --- ## [Private topics not showing up in Posts created report](https://meta.discourse.org/t/private-topics-not-showing-up-in-posts-created-report/382079)
**Author:** [@tknospdr](https://meta.discourse.org/u/tknospdr)\ **Replies:** 8\ **Last updated:** [September 22, 2025, 2:20pm UTC](https://meta.discourse.org/t/private-topics-not-showing-up-in-posts-created-report/382079 "2025-09-22T14:20:15Z")
I’m trying to figure out why some reports that should have data points on them are blank. If you look at this screenshot, you can see that I just created a new topic and there is a post under it: And if you look at … --- ## [Solved and Unsolved Topic Stats with Date and Tag Parameters](https://meta.discourse.org/t/solved-and-unsolved-topic-stats-with-date-and-tag-parameters/301425)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 4\ **Last updated:** [September 19, 2025, 8:22pm UTC](https://meta.discourse.org/t/solved-and-unsolved-topic-stats-with-date-and-tag-parameters/301425 "2025-09-19T20:22:12Z")
This Data Explorer report provides a comprehensive analysis of solved and unsolved topics on a site, within a specified date range, and optionally filtered by a specific tag. :discourse: This report requires the Discou… --- ## [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… --- ## [Relevant reports for Discourse as a ticket system?](https://meta.discourse.org/t/relevant-reports-for-discourse-as-a-ticket-system/381752)
**Author:** [@tknospdr](https://meta.discourse.org/u/tknospdr)\ **Replies:** 3\ **Last updated:** [September 9, 2025, 3:43pm UTC](https://meta.discourse.org/t/relevant-reports-for-discourse-as-a-ticket-system/381752 "2025-09-09T15:43:37Z")
I’ve been working on a replacement for our company’s ticketing system using Discourse. I know it has a lot of built in reports, but I’m not sure what is germane. Is anyone here using the software in that way already abl… --- ## [Badge for poll vote + topic post with min post likes?](https://meta.discourse.org/t/badge-for-poll-vote-topic-post-with-min-post-likes/281547)
**Author:** [@Tom\_Beckett](https://meta.discourse.org/u/Tom_Beckett)\ **Replies:** 0\ **Last updated:** [August 13, 2019, 10:14am UTC](https://meta.discourse.org/t/badge-for-poll-vote-topic-post-with-min-post-likes/281547 "2019-08-13T10:14:26Z")
Has anyone come up with a SQL statement or could give me an idea of whether the following is possible in awarding a badge? Responded to a poll with a specific number of answers (e.g. What things have you done to reduce… --- ## [Sum up of topics and posts](https://meta.discourse.org/t/sum-up-of-topics-and-posts/380192)
**Author:** [@Alfi](https://meta.discourse.org/u/Alfi)\ **Replies:** 2\ **Last updated:** [August 25, 2025, 3:41pm UTC](https://meta.discourse.org/t/sum-up-of-topics-and-posts/380192 "2025-08-25T15:41:29Z")
Hi, After one year of running our self-hosted travel forum on Discourse, I would like to create an annual report based on the main parameters taken from the Admin Report facility. During the year, the reports show appr… --- ## [Statistics on most-liked posts of all time?](https://meta.discourse.org/t/statistics-on-most-liked-posts-of-all-time/292882)
**Author:** [@Viktor09](https://meta.discourse.org/u/Viktor09)\ **Replies:** 4\ **Last updated:** [August 25, 2025, 1:18pm UTC](https://meta.discourse.org/t/statistics-on-most-liked-posts-of-all-time/292882 "2025-08-25T13:18:17Z")
I’d like to know which posts on my forum have received the most likes since we first started running on Discourse (nearly 4 years ago). I searched on here and found this, which appears to be the same question, but the t… --- ## [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… [Next page](https://meta.discourse.org/c/community-building/data-reporting/148.md?page=1)