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] -- date :start_date -- date :end_date SELECT ar.date::date AS "date", SUM(ar.…

@SaraDev when looking at our admin dashboard, it’s showing req_type = 13 (page_view_anon_browser) and 15 (page_view_logged_in_browser). Is this a bug? Is there any explanation of the sub request types? For example, I don’t see how any combination of the logged in types get to the 705 number. [imag…

[이미지] tyler.lamparter: Is there any explanation of the sub request types The req_type field in the application_requests corresponds to the follow types of application requests in Discourse: http_total http_2xx http_background http_3xx http_4xx http_5xx page_view_crawler page_view_logged_in p…

Thanks Sara, the query in the Dashboard Report - Site Traffic topic answers my question around using 13 and 15 and also why 13 + 14 != 8.

대시보드 보고서 - 통합 페이지뷰

커뮤니티 구축 데이터 및 보고

tyler.lamparter (Tyler Lamparter) 3월 24, 2025, 11:37오후 4

사라, 감사합니다. Dashboard Report - Site Traffic 주제에서 제시된 쿼리를 통해 13과 15를 사용하는 이유에 대한 제 질문에 답을 얻을 수 있었고, 왜 13 + 14가 8과 같지 않은지도 알게 되었습니다.

글		댓글	조회수
Dashboard Report - Consolidated Pageviews with Browser Detection Data & reporting sql-query , dashboard-reports , dashboard-sql	5	460	6월 21, 2024
Dashboard Report - Web Crawler Pageviews Data & reporting sql-query , dashboard-reports , dashboard-sql	0	398	2월 8, 2024
Dashboard Report - Site Traffic Data & reporting sql-query , dashboard-reports , dashboard-sql	0	263	3월 24, 2025
Dashboard Report - Anonymous Data & reporting sql-query , dashboard-reports , dashboard-sql	9	650	12월 21, 2023
Dashboard Report - Logged In Data & reporting sql-query , dashboard-reports , dashboard-sql	0	414	1월 10, 2024

대시보드 보고서 - 통합 페이지뷰

Related topics