I’m using data explorer to count the number of views on a category using the topic_views table, but when I count the number of views for that category vs the number of views on the topic (topic.views) the number of views in the topic_views table is much less. Any idea why this is?
The topic_views table only records the first view of a topic for each user (or IP Address for anyone not logged in), whereas topics.views from the topics table records one new view every 8 hours (default, but configurable using the topic view duration hours admin setting).
We do have a new table to collect topic view data that can be reported on over a timeframe, which may also be of interest (quite new still, so the data won’t go back too far). That’s in the topic_view_stats table, and can give an aggregate amount of views per topic (for both anon and logged in users) per day.
hi @JammyDodger , i noticed that some topic Views are 0 but there are comments inside, do you know why?
Hi there, I hope you are doing well.
The difference in view counts is likely because the topic views table tracks individual view records (like per user or IP), while the views count in the topic table is a total that includes all views. This total might also account for repeated or guest views that aren’t always in topic views. So, the topic table usually shows a higher, more complete view count.
Thank You,
Mike Taku.