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?
- Would it consider anonymous views?
- Also, is there a way to convert this into a report?
-- [params] -- string :date = '2020-01-01' WITH t AS ( SELECT date(:date) AS START ), f AS ( SELECT id as user_id FROM users u WHERE u.moderator = 'True' or u.admin = 'True' ) SELECT date_part('year', viewed_at) as year, date_part('week', viewed_at) as week, COUNT(topic_id) AS topics_viewed FROM topic_views, t WHERE viewed_at > t.START AND user_id not in (select f.user_id from f) GROUP BY year, week ORDER BY year, week