# Data & reporting **URL:** https://meta.discourse.org/c/community-building/data-reporting/148.md?page=2 [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) **Page:** 3 --- ## [How do you track activity (clicks) from activity summary emails](https://meta.discourse.org/t/how-do-you-track-activity-clicks-from-activity-summary-emails/359202)
**Author:** [@Jacob\_Peebles](https://meta.discourse.org/u/Jacob_Peebles)\ **Replies:** 3\ **Last updated:** [March 28, 2025, 5:42am UTC](https://meta.discourse.org/t/how-do-you-track-activity-clicks-from-activity-summary-emails/359202 "2025-03-28T05:42:45Z")
Hello, Does anyone know if there is a way to track activity summary, for example the clicks generated back to the forum from a summary? If not is there another method for judging the effectiveness of the activity summa… --- ## [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… --- ## [Top traffic sources by topic](https://meta.discourse.org/t/top-traffic-sources-by-topic/237436)
**Author:** [@balboah](https://meta.discourse.org/u/balboah)\ **Replies:** 5\ **Last updated:** [March 21, 2025, 7:09pm UTC](https://meta.discourse.org/t/top-traffic-sources-by-topic/237436 "2025-03-21T19:09:09Z")
I tried to find stats for which are the top traffic source a.k.a. referral traffic for a particular topic which got more attention than other topics. I could only find generic top source for all topics as a whole. Is th… --- ## [Looking for help posting automating data explorer reports to my forum](https://meta.discourse.org/t/looking-for-help-posting-automating-data-explorer-reports-to-my-forum/355265)
**Author:** [@hmmmnotsure](https://meta.discourse.org/u/hmmmnotsure)\ **Replies:** 3\ **Last updated:** [March 20, 2025, 6:09pm UTC](https://meta.discourse.org/t/looking-for-help-posting-automating-data-explorer-reports-to-my-forum/355265 "2025-03-20T18:09:42Z")
I am looking for a way to schedule some of the existing reports i.e. pageviews, posts, signups, visits etc, so the data gets PM’d to a group as a csv every week. But I’m not sure how to do that. Besides, when i tried to… --- ## [Category stats](https://meta.discourse.org/t/category-stats/357945)
**Author:** [@jackierenee](https://meta.discourse.org/u/jackierenee)\ **Replies:** 1\ **Last updated:** [March 20, 2025, 10:16am UTC](https://meta.discourse.org/t/category-stats/357945 "2025-03-20T10:16:38Z")
Hi, I’ve read through the posts in this category and didn’t find what I was looking for, so I hope someone can help me. I was hoping to create a data explorer query that sums the stats by a category or sub-category over… --- ## [Issue with the Current "Time to First Response" Metric](https://meta.discourse.org/t/issue-with-the-current-time-to-first-response-metric/358074)
**Author:** [@tyler.lamparter](https://meta.discourse.org/u/tyler.lamparter)\ **Replies:** 0\ **Last updated:** [March 20, 2025, 1:23am UTC](https://meta.discourse.org/t/issue-with-the-current-time-to-first-response-metric/358074 "2025-03-20T01:23:10Z")
I’ve been replicating Discourse metrics into our BI tool, ThoughtSpot, and when I got to the “Time to First Response” metric, I noticed a flaw in how it’s being reported when viewed on a weekly or monthly basis. Current… --- ## [How can I count monthly active users?](https://meta.discourse.org/t/how-can-i-count-monthly-active-users/357574)
**Author:** [@alefattorini](https://meta.discourse.org/u/alefattorini)\ **Replies:** 2\ **Last updated:** [March 18, 2025, 11:17am UTC](https://meta.discourse.org/t/how-can-i-count-monthly-active-users/357574 "2025-03-18T11:17:38Z")
How can I have this number into Data Explorer or customize my about section? Now I have this but 7 days are not enough for me. For active members I mean people who have just logged in, no posts, no like. User vi… --- ## [Getting All Posts for a Given Category ID Matching Certain Parameters](https://meta.discourse.org/t/getting-all-posts-for-a-given-category-id-matching-certain-parameters/357475)
**Author:** [@JohnMcDonald](https://meta.discourse.org/u/JohnMcDonald)\ **Replies:** 2\ **Last updated:** [March 17, 2025, 5:22pm UTC](https://meta.discourse.org/t/getting-all-posts-for-a-given-category-id-matching-certain-parameters/357475 "2025-03-17T17:22:13Z")
I have developed an SQL query that obtains all posts in my site that contain certain keywords, but I’d like to restrict the posts to a specific category id. Does anyone know how to do that given that (it appears) catego… --- ## [How to measure active users?](https://meta.discourse.org/t/how-to-measure-active-users/74574)
**Author:** [@sianwhite](https://meta.discourse.org/u/sianwhite)\ **Replies:** 15\ **Last updated:** [March 6, 2025, 1:23pm UTC](https://meta.discourse.org/t/how-to-measure-active-users/74574 "2025-03-06T13:23:53Z")
How does everyone measure active/super active users? ie people who have logged in or commented in the past month, for example. The dashboard tells me the number of visits and comments etc, but I don’t know how to chunk … --- ## [User Page Metrics](https://meta.discourse.org/t/user-page-metrics/354906)
**Author:** [@srinivas.chilukuri](https://meta.discourse.org/u/srinivas.chilukuri)\ **Replies:** 6\ **Last updated:** [February 27, 2025, 11:14pm UTC](https://meta.discourse.org/t/user-page-metrics/354906 "2025-02-27T23:14:40Z")
@SaraDev can u provide the sql query for metrics available at https://meta.discourse.org/u?cards=no&order=post\_count refer image below metrics like received like given topics viewed posts read days visited solu… --- ## [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… --- ## [Dynamic params to use with Data Explorer](https://meta.discourse.org/t/dynamic-params-to-use-with-data-explorer/346502)
**Author:** [@gormus](https://meta.discourse.org/u/gormus)\ **Replies:** 4\ **Last updated:** [February 6, 2025, 9:25pm UTC](https://meta.discourse.org/t/dynamic-params-to-use-with-data-explorer/346502 "2025-02-06T21:25:40Z")
I have a Data Explorer report using 2 date parameters with hard-coded default values. -- \[params\] -- date :start\_date = 2024-12-01 -- date :end\_date = 2025-01-01 The hard-coded default values work for most of the p… --- ## [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… --- ## [Content Audit : Report to pull Categories, Topics and Replies](https://meta.discourse.org/t/content-audit-report-to-pull-categories-topics-and-replies/349354)
**Author:** [@RachFeverBee](https://meta.discourse.org/u/RachFeverBee)\ **Replies:** 2\ **Last updated:** [January 31, 2025, 10:13am UTC](https://meta.discourse.org/t/content-audit-report-to-pull-categories-topics-and-replies/349354 "2025-01-31T10:13:39Z")
I’m working with a client to complete a Content Audit. I’d like to run a query to pull all categories, topics and replies from 2023 to now. Ideally, I’d like the report to include dates, poster, titles, links and full te… --- ## [Does Discourse track consecutive days active?](https://meta.discourse.org/t/does-discourse-track-consecutive-days-active/349671)
**Author:** [@MikeNolan](https://meta.discourse.org/u/MikeNolan)\ **Replies:** 3\ **Last updated:** [January 30, 2025, 4:29am UTC](https://meta.discourse.org/t/does-discourse-track-consecutive-days-active/349671 "2025-01-30T04:29:31Z")
A member of our Discourse forum has asked if Discourse has a way to show/recognize consecutive days visiting in or posting in a Discourse forum. I don’t see that information anywhere in the admin’s user information, is … --- ## [Error displaying Top Referred Topics](https://meta.discourse.org/t/error-displaying-top-referred-topics/349603)
**Author:** [@serkhelesheyi](https://meta.discourse.org/u/serkhelesheyi)\ **Replies:** 2\ **Last updated:** [January 29, 2025, 10:39pm UTC](https://meta.discourse.org/t/error-displaying-top-referred-topics/349603 "2025-01-29T22:39:19Z")
After updating Discourse, the following error appears in the dashboard in Top Referred Topics section: Sorry, an error occurred while executing the query The error is also explained in the log as follows: Error while … --- ## [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… --- ## [Search for keywords across posts](https://meta.discourse.org/t/search-for-keywords-across-posts/134553)
**Author:** [@david](https://meta.discourse.org/u/david)\ **Replies:** 1\ **Last updated:** [January 27, 2025, 3:08am UTC](https://meta.discourse.org/t/search-for-keywords-across-posts/134553 "2025-01-27T03:08:57Z")
This query will let you efficiently search for a keyword across all posts. It will be significantly faster than a posts.raw LIKE query, because it uses the postgres full text search structured data -- \[params\] -- string… --- ## [PHP - Data Explorer API Example](https://meta.discourse.org/t/php-data-explorer-api-example/348668)
**Author:** [@LotusJeff](https://meta.discourse.org/u/LotusJeff)\ **Replies:** 2\ **Last updated:** [January 23, 2025, 8:09pm UTC](https://meta.discourse.org/t/php-data-explorer-api-example/348668 "2025-01-23T20:09:03Z")
I am working on pulling data out of Discourse using PHP and the Data Explorer API. Here is the skeleton of my PHP code for others as a starting point. PHP Code \'; // … --- ## [How to get all topics from a specific category using offset/page param in the API query?](https://meta.discourse.org/t/how-to-get-all-topics-from-a-specific-category-using-offset-page-param-in-the-api-query/348554)
**Author:** [@Shubham\_G](https://meta.discourse.org/u/Shubham_G)\ **Replies:** 4\ **Last updated:** [January 23, 2025, 4:37pm UTC](https://meta.discourse.org/t/how-to-get-all-topics-from-a-specific-category-using-offset-page-param-in-the-api-query/348554 "2025-01-23T16:37:42Z")
I have found an API which can list all the topics from a specific subject (whose slug is “mlt-kb”) from between a certain date range. Here is the endpoint: https://{default\_host}/search.json?q=%23courses%3Amlt-kb%20afte… --- ## [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… --- ## [Discrepancy in API data vs WebUI data](https://meta.discourse.org/t/discrepancy-in-api-data-vs-webui-data/347920)
**Author:** [@Shubham\_G](https://meta.discourse.org/u/Shubham_G)\ **Replies:** 5\ **Last updated:** [January 20, 2025, 11:32am UTC](https://meta.discourse.org/t/discrepancy-in-api-data-vs-webui-data/347920 "2025-01-20T11:32:04Z")
I want to get the data of a specific user via API. Basically, I want to know how many replies the user gave since he joined the forum. I used the following code (basically I fetched all the user\_actions where the action\_… --- ## [Custom reports link in dashboard or reports list](https://meta.discourse.org/t/custom-reports-link-in-dashboard-or-reports-list/347026)
**Author:** [@StefanoCecere](https://meta.discourse.org/u/StefanoCecere)\ **Replies:** 0\ **Last updated:** [January 14, 2025, 9:49am UTC](https://meta.discourse.org/t/custom-reports-link-in-dashboard-or-reports-list/347026 "2025-01-14T09:49:15Z")
we have developed many custom reports. but to access them we have to go to plugin → Data Explorer → select or go the groups page → reports → select why can’t we have the list of our custom reports in the /admin/report… --- ## [How to Create a Custom Report for Daily User Sign-Ups?](https://meta.discourse.org/t/how-to-create-a-custom-report-for-daily-user-sign-ups/346666)
**Author:** [@RoyJack](https://meta.discourse.org/u/RoyJack)\ **Replies:** 1\ **Last updated:** [January 11, 2025, 6:58pm UTC](https://meta.discourse.org/t/how-to-create-a-custom-report-for-daily-user-sign-ups/346666 "2025-01-11T18:58:33Z")
Hi all, I want to generate a custom report that shows daily user sign-ups over time. I noticed the built-in reports don’t provide exactly what I need. Would using the Data Explorer plugin be the best option for this? If… --- ## [How to count clicks to internal files (topic\_links.clicks)](https://meta.discourse.org/t/how-to-count-clicks-to-internal-files-topic-links-clicks/346007)
**Author:** [@StefanoCecere](https://meta.discourse.org/u/StefanoCecere)\ **Replies:** 0\ **Last updated:** [January 7, 2025, 2:44pm UTC](https://meta.discourse.org/t/how-to-count-clicks-to-internal-files-topic-links-clicks/346007 "2025-01-07T14:44:01Z")
I uploaded a PDF in a post, but I can’t get the number of clicks it had. the link is like https://mydiscourse.com/uploads/short-url/8jqrvCPN6SEMi6llemEOWtONtT4.pdf the odd thing is that Discourse counts all clicks to e… --- ## [Session Timeout](https://meta.discourse.org/t/session-timeout/34686)
**Author:** [@ATPJD](https://meta.discourse.org/u/ATPJD)\ **Replies:** 66\ **Last updated:** [January 4, 2025, 11:45am UTC](https://meta.discourse.org/t/session-timeout/34686 "2025-01-04T11:45:18Z")
Is there a secret configuration option to allow me to limit how long a user remains signed-in? I would like users to be signed-out automatically after 30 minutes of inactivity. Thanks for any pointers. --- ## [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… --- ## [Data Explorer Query CSV Export reports user\_id while results display user name](https://meta.discourse.org/t/data-explorer-query-csv-export-reports-user-id-while-results-display-user-name/341019)
**Author:** [@cogdog](https://meta.discourse.org/u/cogdog)\ **Replies:** 2\ **Last updated:** [December 8, 2024, 11:13pm UTC](https://meta.discourse.org/t/data-explorer-query-csv-export-reports-user-id-while-results-display-user-name/341019 "2024-12-08T23:13:55Z")
This is likely an inexperienced query writer (me). I run Data Explorer query to report all users who have entered some text in a custom field (we ask for their Fediverse username): SELECT ucf.user\_id, ucf.value, … --- ## [Page Views vs. Top Views](https://meta.discourse.org/t/page-views-vs-top-views/340721)
**Author:** [@AaronW](https://meta.discourse.org/u/AaronW)\ **Replies:** 2\ **Last updated:** [December 5, 2024, 10:34pm UTC](https://meta.discourse.org/t/page-views-vs-top-views/340721 "2024-12-05T22:34:29Z")
We are a small community. When I look at the number of page views for say a month of logged in users, it says that there were about 1300. But when I click on “Top” on our main page, there are only a couple of topics an… [Previous page](https://meta.discourse.org/c/community-building/data-reporting/148.md?page=1) [Next page](https://meta.discourse.org/c/community-building/data-reporting/148.md?page=3)