Hey guys, I don’t see this data in the reports. I’m using the Data Explorer plugin, what query would give me the Pageview counts for only our users per week, excluding the crawler activity and the staff members of our forum, but including the anonymous pageviews. Would something like this work? W…

[Bild] mrjn: So, essentially excluding staff users is not possible to get accurate PV numbers. I am not seeing any way to exclude staff from the data that is provided by the application_requests table. It is also not possible to filter the results of that table by category. If you are trying …

The query looks like it should work. [Bild] mrjn: Would it consider anonymous views? Yes, as it is written it is counting anonymous views. For anonymous topic views, the user_id will be NULL and the ip_address will be NOT NULL. You could exclude anonymous views by adding the following condi…

So, something like this? So, would the IP address be null for crawlers? I want to include: anonymous viewers logged in users I want to exclude: crawlers staff users -- [params] -- string :date = '2020-01-01' -- boolean :staff = false WITH t AS ( SELECT date(:date) AS START ), f AS ( …

The above is wrong. It is undercounting anonymous users when compared to the Discourse report’s consolidated pageviews. Looks like I might need to consider some other tables too?

The Page Views report queries the application_requests table. That table doesn’t give any data for filtering out staff views though. What it returns is a sum of the number of requests of each type per day. The req_type is returned as an integer. The integers are mapped to the type of request with th…

I see. So, essentially excluding staff users is not possible to get accurate PV numbers. Taking a long shot here, is it possible to exclude certain categories (I’m guessing not)? We have some private categories which are team internal only – and don’t want those polluting our user PV numbers.

Seitenaufrufe für Benutzer zählen (nicht-Mitarbeiter, nicht-Crawler)

Gemeinschaft Daten & Berichterstattung

simon 7. Juli 2020 um 21:23 5

Der Bericht „Seitenaufrufe

Thema		Antworten	Aufrufe
Dashboard Report - Consolidated Pageviews Data & reporting sql-query , dashboard-reports , dashboard-sql	3	740	24. März 2025
Number of anonymous users per week Data & reporting sql-query	1	656	28. April 2021
Tracking of Pageviews and Unique Users at Category and Tag Level Data & reporting	20	2755	2. Februar 2024
Understanding pageviews and the site traffic report Site Management explanation , dashboard-reports	1	1645	5. Mai 2026
Can we create the Consolidated Page View Chart without Admins? Data & reporting	1	238	23. April 2024

Seitenaufrufe für Benutzer zählen (nicht-Mitarbeiter, nicht-Crawler)

Verwandte Themen