# Is there an easy way to see which categories have the most views?

**URL:** <https://meta.discourse.org/t/is-there-an-easy-way-to-see-which-categories-have-the-most-views/262820>\
**Category:** Product Support\
**Created:** [April 25, 2023, 1:12pm UTC](https://meta.discourse.org/t/is-there-an-easy-way-to-see-which-categories-have-the-most-views/262820 "2023-04-25T13:12:38Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)\
**Post date:** [April 29, 2023, 10:49am UTC](https://meta.discourse.org/t/is-there-an-easy-way-to-see-which-categories-have-the-most-views/262820/2 "2023-04-29T10:49:00Z")

</div>

I think you could use the `topic_views` table to grab a count of the latest views for a topic, and group/sum that by category? The `topic_views` table counts one new view a day though, rather than ‘1-per-8-hours’ so it may give a smaller figure than you may be expecting when compared to the `topics.views` number.

---

_[View the full topic](https://meta.discourse.org/t/is-there-an-easy-way-to-see-which-categories-have-the-most-views/262820)._
