This is an SQL version of the Dashboard Report for Anonymous. This report shows the number of pageviews a site has received each day from anonymous users (users who are not logged into an account) over a specified date range. --[params] -- date :start_date = 2023-12-01 -- date :end_date = 2024-01-…

Should this one be req_type IN (8,10) to include the mobile numbers too?

I was originally considering that as well, but the admin dashboard report only includes page_view_anon, and not page_view_anon_mobile. With the way this query is now, it is a true mirror of the dashboard report, and you can verify this by running the query and comparing against the dashboard report…

[صورة] Sara Devlaeminck: should the dashboard report include anonymous mobile pageviews? I can’t think of a reason not to include them.

[صورة] Sara Devlaeminck: With the way this query is now, it is a true mirror of the dashboard report, and you can verify this by running the query and comparing against the dashboard report results. Ah, sorry. I should’ve been more specific in my comment. I did clock that this one was an exa…

Sorry, it’s morning here and I need more coffee, so I hit against language wall hard. Are you thinking now should tot include mobiles too in the meaning mobiles are excluded now? Or should it show two metrics, actual total views AND mobile views?

At the moment, the dashboard report currently only seems to include the one req_type (8) which means it’s only counting desktop anon views. We’re wondering why it’s not counting the mobile data as well (either just as a total, or as two numbers so you can see it in more detail).

It can’t be true or it counts bots too. By that I have around 1000 a day and that sounds right. But I know I have very small amount desktops. And situation where I would have 1000 deskstops and 9000 mobiles (yes, the ratio is that) it can’t be true.

Hmm. I’m not sure. I think the code is here: lib/middleware/request_tracker.rb main # Middleware::RequestTracker.register_ip_skipper do |ip| # ip == "1.2.3.4" # end # ``` def self.register_ip_skipper(&blk) ra…

[صورة] JammyDodger: elsif !SiteSetting.login_required ApplicationRequest.increment!(:page_view_anon) ApplicationRequest.increment!(:page_view_anon_mobile) if data[:is_mobile] end Huh. Yeah that logic would increment page_view_anon whe…

تقرير لوحة التحكم - مجهول

مجتمع البيانات والتقارير

JammyDodger 18 ديسمبر 2023، 11:29م 2

هل يجب أن يكون هذا req_type IN (8,10) لتضمين أرقام الهواتف المحمولة أيضًا؟

الموضوع		الردود	مرات العرض
Dashboard Report - Consolidated Pageviews Data & reporting sql-query , dashboard-reports , dashboard-sql	3	732	24 مارس 2025
Dashboard Report - Site Traffic Data & reporting sql-query , dashboard-reports , dashboard-sql	0	255	24 مارس 2025
Dashboard Report - Consolidated Pageviews with Browser Detection Data & reporting sql-query , dashboard-reports , dashboard-sql	5	441	21 يونيو 2024
Dashboard Report - Logged In Data & reporting sql-query , dashboard-reports , dashboard-sql	0	409	10 يناير 2024
Dashboard Report - Web Crawler Pageviews Data & reporting sql-query , dashboard-reports , dashboard-sql	0	393	8 فبراير 2024

تقرير لوحة التحكم - مجهول

الموضوعات ذات الصلة